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