Дипломная работа: Автоматизация обработки заявок ООО «Пилснаб»

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
106
searchLookUpEditGmil.ReadOnly = _readonly;
OrdersearchLookUpEdit.ReadOnly = _readonly;
OrdersearchLookUpEdit.Properties.Buttons[1].Enabled =
false;
lookUpEditProjects.ReadOnly = _readonly;
lookUpEditProjects.Properties.Buttons[1].Enabled =
false;
}
}
bool ValidateForm()
{
bool res = true;
if (!UIUtil.Validate(dateEditDelivery))
{
res = false;
}
if (!UIUtil.Validate(OrdersearchLookUpEdit))
{
res = false;
}
return res;
}
void UpdateData()
{
using (var scope = new TransactionScope())
{
try
{
rEFUNITSBindingSource.EndEdit();
rEF_UNITSTableAdapter.Update(proposalDataSet.REF_UNITS);
pSWSMaterialItemBindingSource.EndEdit();
pS_WS_MaterialItemTableAdapter.Update(proposalDataSet.PS_WS_MaterialIt
em);
pSWSREFProjectsBindingSource.EndEdit();
pS_WS_REF_ProjectsTableAdapter.Update(proposalDataSet.PS_WS_REF_Projec
ts);
pSWSMaterialsBindingSource.EndEdit();
pS_WS_MaterialsTableAdapter.Update(proposalDataSet.PS_WS_Materials);
pS_WS_MaterialsItemsBindingSource.EndEdit();
pS_WS_MaterialsItemsTableAdapter.Update(proposalDataSet.PS_WS_Material
sItems);
scope.Complete();
}
catch (Exception e)
{
UIUtil.ShowErrorBox(e.Message);
}
}
}
107
private void
gridControlMaterials_EmbeddedNavigator_ButtonClick(object sender,
NavigatorButtonClickEventArgs e)
{
if (e.Button.ButtonType == NavigatorButtonType.Append)
{
e.Handled = true;
using (var wFormM = new WSMaterialItemsForm(currUser,
propID, specificationID, this.proposalDataSet))
{
if (wFormM.ShowDialog() == DialogResult.OK) { }
else
{
pS_WS_MaterialsItemsBindingSource.CancelEdit();
}
}
}
else if (e.Button.ButtonType ==
NavigatorButtonType.Remove)
{
e.Handled = true;
pS_WS_MaterialsItemsBindingSource.RemoveCurrent();
}
else if (e.Button.ButtonType == NavigatorButtonType.Edit)
{
e.Handled = true;
var row =
(ProposalDataSet.PS_WS_MaterialsItemsRow)((DataRowView)pS_WS_Materials
ItemsBindingSource.Current).Row;
using (var wFormM = new WSMaterialItemsForm(currUser,
propID, row.ID, specificationID, proposalDataSet))
{
if (wFormM.ShowDialog() == DialogResult.OK) { }
else
{
pS_WS_MaterialsItemsBindingSource.CancelEdit();
}
}
}
}
#endregion
#region ComponentsEvents
private void simpleButtonConfirm_Click(object sender,
EventArgs e)
{
try
{
if (ValidateForm())
{
UpdateData();
DialogResult = DialogResult.OK;
Close();
}
}
catch (Exception ex)
{
108
UIUtil.ShowErrorBox(UtilDictionary.DataSaveFailedFormat(ex.Message));
}
}
private void gridView2_CellValueChanged(object sender,
DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
var row =
(ProposalDataSet.PS_WS_MaterialsItemsRow)((DataRowView)pS_WS_Materials
ItemsBindingSource.Current).Row;
if (e.Column.FieldName != "DeliveredCount") return;
var newCount = e.Value is int i ? i : -1;
if (newCount < 0)
row.DeliveredCount = 0;
if (newCount > row.Count)
{
row.DeliveredCount = row.Count;
UIUtil.ShowErrorBox(WSMaterialsMessageBoxRes.ValueGreaterThanZeroOrBig
gerThenCount);
}
}
private void simpleButtonImportInfo_Click(object sender,
EventArgs e)
{
var oFile = new OpenFileDialog { Filter = "Excel file |
*.xls; *xlsx" };
if (oFile.ShowDialog() != DialogResult.OK) return;
var FirmsDataList =
this.fIRMMANUFACTURERBindingSource.List;
var GostsDataList = this.gOSTSBindingSource.List;
var ProductsDataList =
this.pRODUCTSTYPESBindingSource.List;
var sDataList = this.rEFUNITSBindingSource.List;
var mDataList = this.pSWSMaterialItemBindingSource.List;
var missing = Missing.Value;
var excelApp = new
Microsoft.Office.Interop.Excel.Application { Visible = false };
var cnt = 0;
var objBook = excelApp.Workbooks.Open(oFile.FileName,
missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing,
missing, missing, missing);
try
{
if (!File.Exists(oFile.FileName)) return;
var objSheet = (Worksheet)objBook.Sheets[1];
var i = 2;
while (!String.IsNullOrEmpty(objSheet.Range["A" + i,
missing].Text))
{
if (String.IsNullOrEmpty(objSheet.Range["A" + i,
missing].Text) || String.IsNullOrEmpty(objSheet.Range["B" + i,
missing].Text)
|| String.IsNullOrEmpty(objSheet.Range["C" +
i, missing].Text))
109
{
XtraMessageBox.Show(WSMaterialsMessageBoxRes.ExcelTrouble);
pS_WS_MaterialsItemsBindingSource.CancelEdit();
return;
}
var row =
(ProposalDataSet.PS_WS_MaterialsItemsRow)((DataRowView)pS_WS_Materials
ItemsBindingSource.AddNew()).Row;
row.ID =
currUser.GetNewID("PS_WS_MaterialsItems");
row.ProposalID = propID;
row.DeliveredCount = 0;
row.MaterialItemID = 0;
foreach (DataRowView refRow in mDataList)
{
var rowR =
(ProposalDataSet.PS_WS_MaterialItemRow)(refRow).Row;
if (rowR.SpecificationID == specificationID)
if ((objSheet.Range["A" + i,
missing].Text).ToLower() == rowR.Name.ToLower())
{
row.MaterialItemID = rowR.ID;
rowR.UsingCount++;
break;
}
}
if (row.MaterialItemID == 0)
{
var rowR =
(ProposalDataSet.PS_WS_MaterialItemRow)((DataRowView)pSWSMaterialItemB
indingSource.AddNew()).Row;
rowR.ID =
currUser.GetNewID("PS_WS_MaterialItems");
rowR.Name = objSheet.Range["A" + i,
missing].Text;
rowR.UsingCount = 1;
rowR.SpecificationID = specificationID;
row.MaterialItemID = rowR.ID;
}
row.Count = Convert.ToInt32(objSheet.Range["B" +
i, missing].Text);
row.UnitID = 0;
row.FirmID = 0;
row.GostID = 0;
row.ProductTypeId = 0;
foreach (DataRowView refRow in sDataList)
{//adding umit
var rowR =
(ProposalDataSet.REF_UNITSRow)(refRow).Row;
string enterName = (objSheet.Range["C" + i,
missing].Text).ToLower();
string dataBaseName = rowR.NAME.ToLower();
enterName = enterName.Trim();
dataBaseName = dataBaseName.Trim();
if (enterName == dataBaseName)
110
{
row.UnitID = rowR.ID;
break;
}
}
foreach (DataRowView refRow in FirmsDataList)
{///adding firm
var rowR =
(ProposalDataSet.FIRM_MANUFACTURERRow)(refRow).Row;
string enterName = (objSheet.Range["D" + i,
missing].Text).ToLower();
string dataBaseName = rowR.NAME.ToLower();
enterName = enterName.Trim();
dataBaseName = dataBaseName.Trim();
if (enterName == dataBaseName)
{
row.FirmID = rowR.ID;
break;
}
}
foreach (DataRowView refRow in GostsDataList)
{///adding gost
var rowR =
(ProposalDataSet.GOSTSRow)(refRow).Row;
string enterName = (objSheet.Range["E" + i,
missing].Text).ToLower();
string dataBaseName = rowR.NAME.ToLower();
enterName = enterName.Trim();
dataBaseName = dataBaseName.Trim();
if (enterName == dataBaseName)
{
row.GostID = rowR.ID;
break;
}
}
foreach (DataRowView refRow in ProductsDataList)
{///adding sortment
var rowR =
(ProposalDataSet.PRODUCTS_TYPESRow)(refRow).Row;
string enterName = (objSheet.Range["F" + i,
missing].Text).ToLower();
string dataBaseName = rowR.NAME.ToLower();
enterName = enterName.Trim();
dataBaseName = dataBaseName.Trim();
if (enterName == dataBaseName)
{
row.ProductTypeId = rowR.ID;
break;
}
}
///////////////////////////////////////////////////////
Источник: https://baza.diplomsite.ru/previewfile/1897

Смотрите также:

Изложение содержания дела, по которому приняты судебные постановления
_-___-~1
_1-тема-СтрМетал
_10_Эмиль Золя для эл версии