private void btn_Query_Click(object sender, EventArgs e)
{
//product info query
if (this.txt_ProductNo.Text.Trim().Length > 0)
{
clearBOMText();
List <MaterialInfo> materialsList = new List <MaterialInfo>();
ProductBOMs _productBOMs = new ProductBOMs();
if (this.txt_ProductNo.Text.Trim().Length > 0)
{
materialsList = _productBOMs.GetProductBOMList(this.txt_ProductNo.Text.Trim());
materialsList = materialsList.OrderBy(o => o.MaterialSeq).ToList();//升序
if (materialsList.Count > 0)
{
fillMaterialsInfo(materialsList);
this.txt_ProductName.Text = ProductBOMBLL.GetProductName(this.txt_ProductNo.Text.Trim());
}
else
{
SpMessageBox.Show("没有查找到对应产品BOM信息, 请重新输入正确的产品号.", "产品信息维护");
}
}
}
else
{
}
}
private void btn_Add_Click(object sender, EventArgs e)
{
//product info add
if (this.txt_ProductNo.Text.Trim().Length > 0 && this.txt_ProductName.Text.Trim().Length > 0)
{
try
{
if (ProductBOMBLL.InsertProductBOMInfo(this.txt_ProductNo.Text.Trim(), this.txt_ProductName.Text.Trim(),
this.textBox1.Text.Trim().Length > 0 ? this.textBox1.Text.Trim() : null, (this.comboBox1.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox1.Text.Trim())) ? byte.Parse(this.comboBox1.Text.Trim()) : (byte)0,
this.textBox2.Text.Trim().Length > 0 ? this.textBox2.Text.Trim() : null, (this.comboBox2.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox2.Text.Trim())) ? byte.Parse(this.comboBox2.Text.Trim()) : (byte)0,
this.textBox3.Text.Trim().Length > 0 ? this.textBox3.Text.Trim() : null, (this.comboBox3.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox3.Text.Trim())) ? byte.Parse(this.comboBox3.Text.Trim()) : (byte)0,
this.textBox4.Text.Trim().Length > 0 ? this.textBox4.Text.Trim() : null, (this.comboBox4.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox4.Text.Trim())) ? byte.Parse(this.comboBox4.Text.Trim()) : (byte)0,
this.textBox5.Text.Trim().Length > 0 ? this.textBox5.Text.Trim() : null, (this.comboBox5.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox5.Text.Trim())) ? byte.Parse(this.comboBox5.Text.Trim()) : (byte)0,
this.textBox6.Text.Trim().Length > 0 ? this.textBox6.Text.Trim() : null, (this.comboBox6.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox6.Text.Trim())) ? byte.Parse(this.comboBox6.Text.Trim()) : (byte)0,
this.textBox7.Text.Trim().Length > 0 ? this.textBox7.Text.Trim() : null, (this.comboBox7.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox7.Text.Trim())) ? byte.Parse(this.comboBox7.Text.Trim()) : (byte)0,
this.textBox8.Text.Trim().Length > 0 ? this.textBox8.Text.Trim() : null, (this.comboBox8.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox8.Text.Trim())) ? byte.Parse(this.comboBox8.Text.Trim()) : (byte)0,
this.textBox9.Text.Trim().Length > 0 ? this.textBox9.Text.Trim() : null, (this.comboBox9.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox9.Text.Trim())) ? byte.Parse(this.comboBox9.Text.Trim()) : (byte)0,
this.textBox10.Text.Trim().Length > 0 ? this.textBox10.Text.Trim() : null, (this.comboBox10.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox10.Text.Trim())) ? byte.Parse(this.comboBox10.Text.Trim()) : (byte)0,
this.textBox11.Text.Trim().Length > 0 ? this.textBox11.Text.Trim() : null, (this.comboBox11.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox11.Text.Trim())) ? byte.Parse(this.comboBox11.Text.Trim()) : (byte)0,
this.textBox12.Text.Trim().Length > 0 ? this.textBox12.Text.Trim() : null, (this.comboBox12.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox12.Text.Trim())) ? byte.Parse(this.comboBox12.Text.Trim()) : (byte)0,
this.textBox13.Text.Trim().Length > 0 ? this.textBox13.Text.Trim() : null, (this.comboBox13.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox13.Text.Trim())) ? byte.Parse(this.comboBox13.Text.Trim()) : (byte)0,
this.textBox14.Text.Trim().Length > 0 ? this.textBox14.Text.Trim() : null, (this.comboBox14.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox14.Text.Trim())) ? byte.Parse(this.comboBox14.Text.Trim()) : (byte)0,
this.textBox15.Text.Trim().Length > 0 ? this.textBox15.Text.Trim() : null, (this.comboBox15.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox15.Text.Trim())) ? byte.Parse(this.comboBox15.Text.Trim()) : (byte)0,
this.textBox16.Text.Trim().Length > 0 ? this.textBox16.Text.Trim() : null, (this.comboBox16.Text.Trim().Length > 0 && RegularHelper.isNumericString(this.comboBox16.Text.Trim())) ? byte.Parse(this.comboBox16.Text.Trim()) : (byte)0
))
{
ShowLoginTip("产品信息添加成功.");
}
else
{
SpMessageBox.Show(this.txt_ProductName.Text.Trim() + "信息添加失败.", "产品信息维护");
}
}
catch
{
}
}
}
/// <summary>
/// List GetSampleQryResult, get 4 COLUMNs from samplemain and patien to a list to show in listview
/// </summary>
/// <returns></returns>
public List <MaterialInfo> GetProductBOMList(string _productNo)
{
List <MaterialInfo> productMaterialsList = new List <MaterialInfo>();
if (productMaterialsList.Count > 0)
{
productMaterialsList.Clear();
}
foreach (var val in ProductBOMBLL.GetProductBOMList(_productNo))
{
if (val.ProductNo != "" && val.ProductNo != null)
{
if (!val.IsMaterial1NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material1No;
materialTemp.MaterialPcs = val.Material1Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial2NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material2No;
materialTemp.MaterialPcs = val.Material2Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial3NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material3No;
materialTemp.MaterialPcs = val.Material3Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial4NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material4No;
materialTemp.MaterialPcs = val.Material4Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial5NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material5No;
materialTemp.MaterialPcs = val.Material5Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial6NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material6No;
materialTemp.MaterialPcs = val.Material6Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial7NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material7No;
materialTemp.MaterialPcs = val.Material7Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial8NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material8No;
materialTemp.MaterialPcs = val.Material8Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial9NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material9No;
materialTemp.MaterialPcs = val.Material9Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial10NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material10No;
materialTemp.MaterialPcs = val.Material10Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial11NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material11No;
materialTemp.MaterialPcs = val.Material11Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial12NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material12No;
materialTemp.MaterialPcs = val.Material12Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial13NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material13No;
materialTemp.MaterialPcs = val.Material13Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial14NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material14No;
materialTemp.MaterialPcs = val.Material14Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial15NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material15No;
materialTemp.MaterialPcs = val.Material15Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial16NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material16No;
materialTemp.MaterialPcs = val.Material16Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial17NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material17No;
materialTemp.MaterialPcs = val.Material17Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial18NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material18No;
materialTemp.MaterialPcs = val.Material18Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial19NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material19No;
materialTemp.MaterialPcs = val.Material19Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial20NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material20No;
materialTemp.MaterialPcs = val.Material20Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
}
}
return(productMaterialsList);
}
