/// <summary> /// 物料BOM编辑加载窗口 /// </summary> /// <param name="MaterialFatherGuid"></param> public void EditBom(string MaterialFatherGuid) { //选择的品名填充 if (MaterialFatherGuid != "") { //得到料件的信息 Material material = new Material(); material = MaterialManage.GetMaterialByGuid(MaterialFatherGuid); //填充数据 txtMaterialID.Tag = material.MaterialGuID; txtMaterialID.Text = material.MaterialID; txtMaterialName.Text = material.MaterialName; txtUnit.Text = base.GetBasicDataNameByID(material.Unit); txtSpec.Text = base.GetBasicDataNameByID(material.Spec); //得到bom主表的备注信息 txtRemark.Text = MaterialBOMManage.GetBOMRemarkByMaterialGuid(MaterialFatherGuid); } //载入子件列表 LoadMaterialChildData(); //母件子件按树型显示 LoadBomTree(); treeView1.ExpandAll(); this.ShowDialog(); }
private void btnAddDetail_Click(object sender, EventArgs e) { frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(); frmSelectMaterial.ShowDialog(); if (frmSelectMaterial.Tag != null) { //取出选择的料件Guid List <string> lstGuid = frmSelectMaterial.Tag as List <string>; //选择的品名填充 if (lstGuid.Count > 0) { //得到料件的信息 for (int i = 0; i < lstGuid.Count; i++) { Material material = new Material(); material = MaterialManage.GetMaterialByGuid(lstGuid[i]); //填充数据 gridView1.AddNewRow(); gridView1.SetFocusedRowCellValue(gridMaterialGuID, material.MaterialGuID); gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialID); gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName); gridView1.SetFocusedRowCellValue(gridUnit, base.GetBasicDataNameByID(material.Unit)); gridView1.SetFocusedRowCellValue(gridSpec, base.GetBasicDataNameByID(material.Spec)); gridView1.SetFocusedRowCellValue(gridPrice, material.Price.ToString("g0")); } } } }
private void btnSelectMaterialGuid_Click(object sender, EventArgs e) { frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(1); frmSelectMaterial.ShowDialog(); if (frmSelectMaterial.Tag != null) { //取出选择的料件Guid List <string> lstGuid = frmSelectMaterial.Tag as List <string>; //选择的品名填充 if (lstGuid.Count > 0) { //得到料件的信息 Material material = new Material(); material = MaterialManage.GetMaterialByGuid(lstGuid[0]); //填充数据 txtMaterialGuid.Text = material.MaterialID; txtMaterialGuid.Tag = material.MaterialGuID; txtMaterialName.Text = material.MaterialName; } } }
private void btnAddDetail_Click(object sender, EventArgs e) { frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(); frmSelectMaterial.Tag = ""; frmSelectMaterial.ShowDialog(); //选择的料件填充 if (frmSelectMaterial.Tag.ToString() != "") { //得到选择的料件guid,然后得到 Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString()); //填充数据 gridView1.AddNewRow(); gridView1.SetFocusedRowCellValue(gridMaterialGuid, material.MaterialGuid); gridView1.SetFocusedRowCellValue(gridMaterialId, material.MaterialId); gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName); gridView1.SetFocusedRowCellValue(gridClassName, material.ClassId); gridView1.SetFocusedRowCellValue(gridBarNo, material.BarNo); gridView1.SetFocusedRowCellValue(gridSpec, material.Spec); gridView1.SetFocusedRowCellValue(gridUnit, material.Unit); gridView1.SetFocusedRowCellValue(gridRemark, material.Remark); } }
public void LoadData(string strMaterialGuid) { MaterialManage MaterialManage = new MaterialManage(); Material material = new Material(); material = MaterialManage.GetMaterialByGuid(strMaterialGuid); txtMaterialID.Text = material.MaterialID; txtMaterialName.Text = material.MaterialName; txtSpec.Text = base.GetBasicDataNameByID(material.Spec); txtUnit.Text = base.GetBasicDataNameByID(material.Unit); DataTable dtl = MaterialManage.sp_GetStorageSumData(strMaterialGuid); gridControl1.DataSource = dtl; }
//选择料件 private void btnSelectMaterial_Click(object sender, EventArgs e) { frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(); frmSelectMaterial.Tag = ""; frmSelectMaterial.ShowDialog(); //选择的料件填充 if (frmSelectMaterial.Tag.ToString() != "") { //得到选择的料件guid,然后得到 Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString()); //填充数据 txtMaterialGuid.Text = material.MaterialGuid; txtBarNo.Text = material.BarNo; txtMaterialName.Text = material.MaterialName; txtMaterialId.Text = material.MaterialId; txtSpec.Text = material.Spec; } }
private void btnAddDetail_Click(object sender, EventArgs e) { frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(); frmSelectMaterial.Tag = ""; frmSelectMaterial.ShowDialog(); //选择的料件填充 if (frmSelectMaterial.Tag.ToString() != "") { //得到选择的料件guid,然后得到 Material material = MaterialManage.GetMaterialByGuid(frmSelectMaterial.Tag.ToString()); //填充数据 gridView1.AddNewRow(); gridView1.SetFocusedRowCellValue(gridMaterialGuid, material.MaterialGuid); gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialId); gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName); gridView1.SetFocusedRowCellValue(gridClassName, material.ClassId); gridView1.SetFocusedRowCellValue(gridBarNo, material.BarNo); gridView1.SetFocusedRowCellValue(gridSpec, material.Spec); gridView1.SetFocusedRowCellValue(gridUnit, material.Unit); gridView1.SetFocusedRowCellValue(gridRemark, material.Remark); //出库单货品是否自动计算平均单价 if (this.Text == "出库单新增" || this.Text == "出库单编辑") { string AutoFillBillOutPrice = System.Configuration.ConfigurationSettings.AppSettings["IsAutoFillBillOutPrice"].ToString();; if (AutoFillBillOutPrice == "true") { decimal priceAVG = 0; string guid = ((DataRowView)(gridView1.GetFocusedRow())).Row[0].ToString(); //得到此料件在某个仓库中的平均价,写入单价列中 priceAVG = bm.sp_GetMaterialPrice(guid, cboDepot.Text); gridView1.SetFocusedRowCellValue(gridPrice, priceAVG); } } } }
//增加明细 private void btnAddMaterial_Click(object sender, EventArgs e) { MaterialManage MaterialManage = new MaterialManage(); frmSelectMaterial frmSelectMaterial = new frmSelectMaterial(); frmSelectMaterial.ShowDialog(); if (frmSelectMaterial.Tag != null) { //取出选择的料件Guid List <string> lstGuid = frmSelectMaterial.Tag as List <string>; //选择的品名填充 if (lstGuid.Count > 0) { //得到料件的信息 for (int i = 0; i < lstGuid.Count; i++) { Material material = new Material(); material = MaterialManage.GetMaterialByGuid(lstGuid[i]); //填充数据 gridView2.AddNewRow(); gridView2.SetFocusedRowCellValue(gridMaterialGuidDetail, material.MaterialGuID); gridView2.SetFocusedRowCellValue(gridMaterialIDDetail, material.MaterialID); gridView2.SetFocusedRowCellValue(gridMaterialNameDetail, material.MaterialName); gridView2.SetFocusedRowCellValue(gridUnitDetail, base.GetBasicDataNameByID(material.Unit)); gridView2.SetFocusedRowCellValue(gridSpecDetail, base.GetBasicDataNameByID(material.Spec)); gridView2.SetFocusedRowCellValue(gridMaterialSumDetail, 0); gridView2.SetFocusedRowCellValue(gridStorageSum, 0); gridView2.SetFocusedRowCellValue(gridStorageMaterialSum, 0); gridView2.SetFocusedRowCellValue(gridOnlySum, 0); } } } }
private void btnAddDetail_Click(object sender, EventArgs e) { MaterialBOMManage MaterialBOMManage = new MaterialBOMManage(); frmSelectMaterial2 frmSelectMaterial2 = new frmSelectMaterial2(); frmSelectMaterial2.ShowDialog(); if (frmSelectMaterial2.Tag != null) { //取出选择的料件Guid List <string> lstGuid = frmSelectMaterial2.Tag as List <string>; //选择的品名填充 if (lstGuid.Count > 0) { //组建物料sql string strsql = " where 1<>1 "; for (int i = 0; i < lstGuid.Count; i++) { strsql = strsql + " or MaterialGuid='" + lstGuid[i] + "'"; } //加载单耗 DataSet dsetConsume = new DataSet(); if (frmSelectMaterial2.txtQryValue.Text.Trim() != "") { if (frmSelectMaterial2.txtQryValue.Tag != null) { //确认是点击了BOM查询 dsetConsume = MaterialBOMManage.sp_GetMaterialBomConsumeByDrawOrder(strsql, frmSelectMaterial2.txtQryValue.Tag.ToString()); } } //得到料件的信息 for (int i = 0; i < lstGuid.Count; i++) { Material material = new Material(); material = MaterialManage.GetMaterialByGuid(lstGuid[i]); //填充数据 gridView1.AddNewRow(); gridView1.SetFocusedRowCellValue(gridMaterialGuID, material.MaterialGuID); gridView1.SetFocusedRowCellValue(gridMaterialID, material.MaterialID); gridView1.SetFocusedRowCellValue(gridMaterialName, material.MaterialName); gridView1.SetFocusedRowCellValue(gridUnit, base.GetBasicDataNameByID(material.Unit)); gridView1.SetFocusedRowCellValue(gridSpec, base.GetBasicDataNameByID(material.Spec)); //加载单耗 if (frmSelectMaterial2.txtQryValue.Text.Trim() != "") { if (frmSelectMaterial2.txtQryValue.Tag != null) { decimal decConsumeSum = GetConsumeSum(material.MaterialGuID, dsetConsume); gridView1.SetFocusedRowCellValue(gridConsumeSum, decConsumeSum.ToString("g0")); } } } } } }