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;
}
}
///////////////////////////////////////////////////////
111
if (row.UnitID == 0)
{
var rowR =
(ProposalDataSet.REF_UNITSRow)((DataRowView)rEFUNITSBindingSource.AddN
ew()).Row;
rowR.ID = currUser.GetNewID("REF_UNITS");
string name = (objSheet.Range["C" + i,
missing].Text);
name = name.Trim();
rowR.NAME = name;
row.UnitID = rowR.ID;
rEFUNITSBindingSource.EndEdit();
rEF_UNITSTableAdapter.Update(proposalDataSet.REF_UNITS);
}
if (row.FirmID == 0)
{
var rowR =
(ProposalDataSet.FIRM_MANUFACTURERRow)((DataRowView)fIRMMANUFACTURERBi
ndingSource.AddNew()).Row;
string name = (objSheet.Range["D" + i,
missing].Text);
name = name.Trim();
rowR.NAME = name;
row.FirmID = rowR.ID;
fIRMMANUFACTURERBindingSource.EndEdit();
fIRM_MANUFACTURERTableAdapter.Update(proposalDataSet.FIRM_MANUFACTURER
);
}
if (row.GostID == 0)
{
var rowR =
(ProposalDataSet.GOSTSRow)((DataRowView)gOSTSBindingSource.AddNew()).R
ow;
string name = (objSheet.Range["E" + i,
missing].Text);
name = name.Trim();
rowR.NAME = name;
row.GostID = rowR.ID;
gOSTSBindingSource.EndEdit();
gOSTSTableAdapter.Update(proposalDataSet.GOSTS);
}
if (row.ProductTypeId == 0)
{
var rowR =
(ProposalDataSet.PRODUCTS_TYPESRow)((DataRowView)pRODUCTSTYPESBindingS
ource.AddNew()).Row;
var identer = gOSTSTableAdapter.ScalarQuery();
string name = (objSheet.Range["F" + i,
missing].Text);
name = name.Trim();
112
rowR.NAME = name;
row.ProductTypeId = rowR.ID;
pRODUCTSTYPESBindingSource.EndEdit();
pRODUCTS_TYPESTableAdapter.Update(proposalDataSet.PRODUCTS_TYPES);
}
//////////////////////////
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)
{
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;
}
113
}
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;
}
}
row.Description = objSheet.Range["G" + i,
missing].Text;
cnt++;
i++;
}
pSWSMaterialItemBindingSource.EndEdit();
pS_WS_MaterialsItemsBindingSource.EndEdit();
XtraMessageBox.Show(string.Format(WSMaterialsMessageBoxRes.ExcelImport
Success, cnt, 0),
WSMaterialsMessageBoxRes.Success,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
pSWSMaterialItemBindingSource.CancelEdit();
rEFUNITSBindingSource.CancelEdit();
pS_WS_MaterialsItemsBindingSource.CancelEdit();
UIUtil.ShowErrorBox(ex.Message);
}
finally
{
objBook.Close();
excelApp.Quit();
}
}
private void simpleButtonExport_Click(object sender, EventArgs
e)
{
var sfd = new SaveFileDialog() { Filter = "Excel file |
*xlsx;" };
if (sfd.ShowDialog() != DialogResult.OK) return;
gridViewMaterials.ExportToXlsx(sfd.FileName + ".xlsx");
}
#endregion
114
private void simpleButtonClone_Click(object sender, EventArgs
e)
{
using (var wForm = new WSCloneMaterialItemsForm(currUser,
proposalDataSet, specificationID))
{
if (wForm.ShowDialog() == DialogResult.OK)
{
GetCloneMaterialItems(wForm.PropID);
}
wForm.Close();
}
}
private void lookUpEditProjects_ButtonClick(object sender,
DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Kind == ButtonPredefines.Plus)
{
var uForm = new WSProjectForm(currUser,
pSWSREFProjectsBindingSource);
if (uForm.ShowDialog() != DialogResult.OK)
pSWSREFProjectsBindingSource.CancelEdit();
else
{
pSWSREFProjectsBindingSource.MoveLast();
var rowI =
(ProposalDataSet.PS_WS_REF_ProjectsRow)((DataRowView)pSWSREFProjectsBi
ndingSource.Current).Row;
lookUpEditProjects.EditValue = rowI.ID;
}
}
}
private void SetRegexOnGMIL()
{
//textEditGmil.Properties.Mask.MaskType =
DevExpress.XtraEditors.Mask.MaskType.RegEx;
//textEditGmil.Properties.Mask.EditMask =
"\\S\\S\\S\\S\\S\\S([.])\\S\\S\\S([-])\\S\\S\\S\\S";
}
private void WSMaterialsForm_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the
'proposalDataSet.PS_GMIL_Item' table. You can move, or remove it, as
needed.
this.pS_GMIL_ItemTableAdapter.Fill(this.proposalDataSet.PS_GMIL_Item);
}
private void OrdersearchLookUpEdit_ButtonClick(object sender,
ButtonPressedEventArgs e)
{
if (e.Button.Kind == ButtonPredefines.Plus)
{
var uForm = new WSOrderXForm(currUser);
if (uForm.ShowDialog() != DialogResult.OK)
115
{
}
else
{
pS_TM_OrderTableAdapter.Fill(this.proposalDataSet.PS_TM_Order);
pSTMOrderBindingSource.MoveLast();
var rowI =
(ProposalDataSet.PS_TM_OrderRow)((DataRowView)pSTMOrderBindingSource.C
urrent).Row;
OrdersearchLookUpEdit.EditValue = rowI.ID;
}
}
pS_TM_OrderTableAdapter.Fill(this.proposalDataSet.PS_TM_Order);
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void labelControl4_Click(object sender, EventArgs e)
{
}
private void textEdit1_EditValueChanged(object sender,
EventArgs e)
{
SetRegexOnGMIL();
}
private void searchLookUpEdit1_Properties_ButtonClick(object
sender, ButtonPressedEventArgs e)
{
if (e.Button.Kind == ButtonPredefines.Plus)
{
using (var uForm = new WSGMILForm())
{
if (uForm.ShowDialog() == DialogResult.OK)
{
pS_GMIL_ItemTableAdapter.Fill(proposalDataSet.PS_GMIL_Item);
var lastAdded =
proposalDataSet.PS_GMIL_Item.LastOrDefault();
if (lastAdded != null)
searchLookUpEditGmil.EditValue =
lastAdded.ID;
}
}
}
}
}
}