private void button1_Click(object sender, EventArgs e) { if (tbCustVenName.Text.Length == 0) { MessageBox.Show("Please input the Customer/Vendor Name"); } var publicCustVen = new publiccustven { custVenName = tbCustVenName.Text.Trim(), custVendorType = (sbyte)(isOffer?1:0), contact = tbContact.Text.Trim(), tel = tbTel.Text.Trim(), email = tbEmail.Text.Trim(), userID = (short)UserInfo.UserId, enterDay = DateTime.Now }; using (BomOfferEntities entity = new BomOfferEntities()) { entity.publiccustven.AddObject(publicCustVen); entity.SaveChanges(); } this.DialogResult = DialogResult.OK; this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (tbCustVenName.Text.Length == 0) { MessageBox.Show("Please input the Customer/Vendor Name"); } var publicCustVen = new publiccustven { custVenName=tbCustVenName.Text.Trim(), custVendorType=(sbyte)(bomOfferType), contact=tbContact.Text.Trim(), tel=tbTel.Text.Trim(), email=tbEmail.Text.Trim(), userID=(short)UserInfo.UserId, enterDay=DateTime.Now }; using (BomOfferEntities entity = new BomOfferEntities()) { entity.publiccustven.AddObject(publicCustVen); entity.SaveChanges(); } this.DialogResult = DialogResult.OK; this.Close(); }
private void tsbDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } if (MessageBox.Show("Delete the selected customer/vendor will also delete its related BOM/Offer", "Warning", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenIdSelected = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferList = entity.publicbomoffer.Where(bomOffer => bomOffer.BomCustVendId == custVenIdSelected); foreach (var bomOffer in bomOfferList) { entity.DeleteObject(bomOffer); } entity.DeleteObject(entity.publiccustven.Where(cv => cv.custVenId == custVenIdSelected).First()); entity.SaveChanges(); } BomOfferCustVendor_Load(this, null); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewSelectedRowCollection dgvrrc = dataGridView1.SelectedRows; int bomOfferId; using (BomOfferEntities entity = new BomOfferEntities()) { foreach (DataGridViewRow dgvr in dgvrrc) { bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); var bomOfferItem = entity.publicbomoffer.First(item => item.bomOfferId == bomOfferId); entity.publicbomoffer.DeleteObject(bomOfferItem); } entity.SaveChanges(); } if (listAll) { tsbListAll_Click(this, null); } else { tsbSearch_Click(this, null); } }
private void button1_Click(object sender, EventArgs e) { if (!ItemsCheck.CheckTextBoxEmpty(tbMfg)) { MessageBox.Show("Please input the MFG"); return; } if (!ItemsCheck.CheckTextBoxEmpty(tbMpn)) { MessageBox.Show("Please input the MPN"); return; } if (!ItemsCheck.CheckIntNumber(tbQty)) { MessageBox.Show("The QTY should be an integer value"); tbQty.Focus(); return; } if (!ItemsCheck.CheckTextBoxEmpty(tbPrice)) { MessageBox.Show("Please input the Price"); return; } else { if (!ItemsCheck.CheckFloatNumber(tbPrice)) { MessageBox.Show("The Price should be a float number"); tbPrice.Focus(); return; } } var publicBomOff = new publicbomoffer { mfg = tbMfg.Text.Trim(), mpn = tbMpn.Text.Trim(), qty = int.Parse(tbQty.Text.Trim()), price = float.Parse(tbPrice.Text.Trim()), cpn = tbCpn.Text.Trim(), userID = (short)UserInfo.UserId, BomCustVendId = this.custVenId, enerDay = DateTime.Now }; using (BomOfferEntities entity = new BomOfferEntities()) { entity.publicbomoffer.AddObject(publicBomOff); entity.SaveChanges(); } this.DialogResult = DialogResult.OK; this.Close(); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferItem = entity.publicbomoffer.First(item => item.BomCustVendId == bomOfferId); entity.DeleteObject(bomOfferItem); entity.SaveChanges(); } BomOfferList_Load(this, null); }
private void button1_Click(object sender, EventArgs e) { if (!ItemsCheck.CheckTextBoxEmpty(tbMfg)) { MessageBox.Show("Please input the MFG"); return; } if (!ItemsCheck.CheckTextBoxEmpty(tbMpn)) { MessageBox.Show("Please input the MPN"); return; } if (!ItemsCheck.CheckIntNumber(tbQty)) { MessageBox.Show("The QTY should be an integer value"); tbQty.Focus(); return; } if (!ItemsCheck.CheckTextBoxEmpty(tbPrice)) { MessageBox.Show("Please input the Price"); return; } else { if (!ItemsCheck.CheckFloatNumber(tbPrice)) { MessageBox.Show("The Price should be a float number"); tbPrice.Focus(); return; } } var publicBomOff = new publicbomoffer { mfg = tbMfg.Text.Trim().ToUpper(), mpn = tbMpn.Text.Trim().ToUpper(), //upper qty = int.Parse(tbQty.Text.Trim()), price = float.Parse(tbPrice.Text.Trim()), cpn = tbCpn.Text.Trim().ToUpper(), userID = (short)UserInfo.UserId, BomCustVendId=this.custVenId, enerDay = DateTime.Now }; using (BomOfferEntities entity = new BomOfferEntities()) { entity.publicbomoffer.AddObject(publicBomOff); entity.SaveChanges(); } this.DialogResult = DialogResult.OK; this.Close(); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferItem = entity.publicbomoffer.First(item => item.BomCustVendId == bomOfferId); entity.DeleteObject(bomOfferItem); entity.SaveChanges(); } BomOfferList_Load(this,null); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewSelectedRowCollection dgvrrc = dataGridView1.SelectedRows; int bomOfferId; using (BomOfferEntities entity = new BomOfferEntities()) { foreach (DataGridViewRow dgvr in dgvrrc) { bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); var bomOfferItem = entity.publicbomoffer.First(item => item.bomOfferId == bomOfferId); entity.publicbomoffer.DeleteObject(bomOfferItem); } entity.SaveChanges(); } if (listAll) { tsbListAll_Click(this, null); } else { tsbSearch_Click(this, null); } }
private void tsbDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; if (MessageBox.Show("Delete the selected customer/vendor will also delete its related BOM/Offer", "Warning", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenIdSelected = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferList = entity.publicbomoffer.Where(bomOffer => bomOffer.BomCustVendId == custVenIdSelected); foreach (var bomOffer in bomOfferList) { entity.DeleteObject(bomOffer); } entity.DeleteObject(entity.publiccustven.Where(cv => cv.custVenId == custVenIdSelected).First()); entity.SaveChanges(); } BomOfferCustVendor_Load(this, null); }
private void tsbExportFromExcel_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenId = Convert.ToInt32(dgvr.Cells["Id"].Value); OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Excel文件(*.xls)|*.xls"; ofd.RestoreDirectory = true; ofd.Multiselect = false; if (DialogResult.OK == ofd.ShowDialog()) { DataTable dt = ExcelHelper.ExcelHelper.Import(ofd.FileName); if (dt.Rows.Count == 0) return; bool hasCpn=false,hasMpn=false,hasMfg=false,hasQty=false,hasPrice=false; int cpnColumn = -1, mpnColumn = -1, mfgColumn = -1, qtyColumn = -1, priceColumn = -1; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Trim().ToUpper() == "MPN") { hasMpn = true; mpnColumn=dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "CPN") { hasCpn = true; cpnColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "MFG") { hasMfg = true; mfgColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "QTY") { hasQty = true; qtyColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "PRICE") { hasPrice = true; priceColumn = dt.Columns.IndexOf(dc); } } if (false == (hasPrice && hasMpn && hasCpn && hasMfg && hasQty)) { MessageBox.Show("Please check the xls File Column.(CPN,MPN,MFG,QTY,PRICE)"); return; } // List<publicbomoffer> publicbomOfferList = new List<publicbomoffer>(); using (BomOfferEntities entity = new BomOfferEntities()) { int i=1; foreach (DataRow dr in dt.Rows) { //Qty omit the "," string qtyString = dr[qtyColumn].ToString(); qtyString = qtyString.Replace(",",string.Empty); if (!string.IsNullOrWhiteSpace(qtyString) && (!ItemsCheck.CheckIntNumber(qtyString))) { MessageBox.Show("The Qty value is not correct in row " + i.ToString()); return; } if (!string.IsNullOrWhiteSpace(dr[priceColumn].ToString()) && (!ItemsCheck.CheckFloatNumber(dr[priceColumn]))) { MessageBox.Show("The Price value is not correct in row " + i.ToString()); return; } int? qtyLocal; float? priceLocal; if (string.IsNullOrWhiteSpace(qtyString)) { qtyLocal = null; } else { qtyLocal = Convert.ToInt32(qtyString); } if (string.IsNullOrWhiteSpace(dr[priceColumn].ToString())) { priceLocal = null; } else { priceLocal = Convert.ToSingle(dr[priceColumn]); } entity.publicbomoffer.AddObject( new publicbomoffer { mfg = dr[mfgColumn].ToString(), mpn = dr[mpnColumn].ToString(), qty =qtyLocal, price = priceLocal, cpn = dr[cpnColumn].ToString(), userID = (short)UserInfo.UserId, BomCustVendId = custVenId, enerDay = DateTime.Now } ); i++; } entity.SaveChanges(); } MessageBox.Show("Import file " + ofd.FileName + " successfully."); } }
private void tsbExportFromExcel_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenId = Convert.ToInt32(dgvr.Cells["Id"].Value); OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Excel文件(*.xls)|*.xls"; ofd.RestoreDirectory = true; ofd.Multiselect = false; if (DialogResult.OK == ofd.ShowDialog()) { DataTable dt = ExcelHelper.ExcelHelper.Import(ofd.FileName); if (dt.Rows.Count == 0) { return; } bool hasCpn = false, hasMpn = false, hasMfg = false, hasQty = false, hasPrice = false; int cpnColumn = -1, mpnColumn = -1, mfgColumn = -1, qtyColumn = -1, priceColumn = -1; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Trim().ToUpper() == "MPN") { hasMpn = true; mpnColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "CPN") { hasCpn = true; cpnColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "MFG") { hasMfg = true; mfgColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "QTY") { hasQty = true; qtyColumn = dt.Columns.IndexOf(dc); } if (dc.ColumnName.Trim().ToUpper() == "PRICE") { hasPrice = true; priceColumn = dt.Columns.IndexOf(dc); } } if (false == (hasPrice && hasMpn && hasCpn && hasMfg && hasQty)) { MessageBox.Show("Please check the xls File Column.(CPN,MPN,MFG,QTY,PRICE)"); return; } // List<publicbomoffer> publicbomOfferList = new List<publicbomoffer>(); using (BomOfferEntities entity = new BomOfferEntities()) { int i = 1; foreach (DataRow dr in dt.Rows) { //Qty omit the "," string qtyString = dr[qtyColumn].ToString(); qtyString = qtyString.Replace(",", string.Empty); if (!string.IsNullOrWhiteSpace(qtyString) && (!ItemsCheck.CheckIntNumber(qtyString))) { MessageBox.Show("The Qty value is not correct in row " + i.ToString()); return; } if (!string.IsNullOrWhiteSpace(dr[priceColumn].ToString()) && (!ItemsCheck.CheckFloatNumber(dr[priceColumn]))) { MessageBox.Show("The Price value is not correct in row " + i.ToString()); return; } int? qtyLocal; float?priceLocal; if (string.IsNullOrWhiteSpace(qtyString)) { qtyLocal = null; } else { qtyLocal = Convert.ToInt32(qtyString); } if (string.IsNullOrWhiteSpace(dr[priceColumn].ToString())) { priceLocal = null; } else { priceLocal = Convert.ToSingle(dr[priceColumn]); } entity.publicbomoffer.AddObject( new publicbomoffer { mfg = dr[mfgColumn].ToString(), mpn = dr[mpnColumn].ToString(), qty = qtyLocal, price = priceLocal, cpn = dr[cpnColumn].ToString(), userID = (short)UserInfo.UserId, BomCustVendId = custVenId, enerDay = DateTime.Now } ); i++; } entity.SaveChanges(); } MessageBox.Show("Import file " + ofd.FileName + " successfully."); } }