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.");
}
}