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

Скачать

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

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
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;
}
}
}
}
}
}
Источник: https://baza.diplomsite.ru/previewfile/1897

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

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