派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -156,6 +156,7 @@ public Int64 HInterID = 0; //å ç public Int64 HOrgID = -1; public string HOrgNumber = ""; public string ERPMode = ""; //ERP模å¼ï¼WISEãCLOUDï¼ public string CampanyName = ""; //客æ·å®å¶åå称 public string SourceQtyCtl = ""; //è¶ æºåæ°éæ§å¶ //------------------------------------------------------------------------- @@ -373,6 +374,7 @@ } else { ERPMode = oSystemParameter.omodel.WMS_WMSStockCtl_ERPMode; CampanyName = oSystemParameter.omodel.WMS_CampanyName; SourceQtyCtl = oSystemParameter.omodel.BarCode_SourceQtyCtl; } @@ -975,6 +977,7 @@ grdSub.RowCount = 0; grdMain.ColumnCount = 60; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); grdMain.Columns[HSnoCol].HeaderText = "åºå·"; grdMain.Columns[HMainIDCol].HeaderText = "æºå主ID"; grdMain.Columns[HSubIDCol].HeaderText = "æºååID"; grdMain.Columns[HBillNoCol].HeaderText = "æºååå·"; @@ -1027,7 +1030,6 @@ grdMain.Columns[HInnerBillNoCol].HeaderText = "å é¨éè´è®¢åå·"; grdMain.Columns[HMakerCol].HeaderText = "å¶å人"; //// grdMain.Columns[HSnoCol].HeaderText = "åºå·"; //æ ¼å¼å grdMain.Columns[HTagCol].Visible = false; //éèå grdMain.Columns[HMainIDCol].Visible = false; @@ -1037,8 +1039,8 @@ grdMain.Columns[HModelCol].Visible = false; //grdMain.Columns[HBatchNoCol].Visible = false; grdMain.Columns[HAuxPropIDCol].Visible = false; grdMain.Columns[HAuxPropNumberCol].Visible = false; grdMain.Columns[HAuxPropNameCol].Visible = false; //grdMain.Columns[HAuxPropNumberCol].Visible = false; //grdMain.Columns[HAuxPropNameCol].Visible = false; grdMain.Columns[HUnitIDCol].Visible = false; grdMain.Columns[HinitQtyCol].Visible = false; grdMain.Columns[HSupIDCol].Visible = false; @@ -1153,8 +1155,8 @@ grdSub.Columns[HMaterID2Col].Visible = false; grdSub.Columns[HModel2Col].Visible = false; grdSub.Columns[HAuxPropID2Col].Visible = false; grdSub.Columns[HAuxPropNumber2Col].Visible = false; grdSub.Columns[HAuxPropName2Col].Visible = false; //grdSub.Columns[HAuxPropNumber2Col].Visible = false; //grdSub.Columns[HAuxPropName2Col].Visible = false; grdSub.Columns[HUnitID2Col].Visible = false; grdSub.Columns[HPrintCol].Visible = false; grdSub.Columns[HSourceInterID2Col].Visible = false; @@ -1336,6 +1338,7 @@ } DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();//ç©æ DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();//计éåä½ DAL.ClsIF_Property_View oProperty = new DAL.ClsIF_Property_View();//è¾ å©å±æ§ if (!grdStatus) { return; @@ -1368,6 +1371,9 @@ grdMain.Rows[sRow].Cells[HMinQtyCol].Value = oMater.omodel.HQtyMin; grdMain.Rows[sRow].Cells[HDateCol].Value = dtpHDate.Value.ToShortDateString(); grdMain.Rows[sRow].Cells[HShowDateCol].Value = dtpHDate.Value.ToShortDateString(); grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; if (oUnit.GetInfoByID(oMater.omodel.HUnitID)) { grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString(); @@ -1392,6 +1398,9 @@ grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; } } else @@ -1402,6 +1411,11 @@ grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; grdMain.Rows[sRow].Cells[HMinQtyCol].Value = 0; grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; } break; @@ -1435,6 +1449,31 @@ case HDateCol: BLL.ClsPub_BLL.Sub_SelectDate(grdMain, sRow, HDateCol); oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HDateCol].Value); break; case HAuxPropNumberCol: oProperty.WherePart = ""; if (ERPMode == "CLOUD") { sWhere = " and HMaterNumber = '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[HMaterNumberCol].Value) + "'"; } else { sWhere = ""; } if (oProperty.RefreshView(sWhere)) { grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = oProperty.oModel.HItemID.ToString(); grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = oProperty.oModel.HNumber; grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = oProperty.oModel.HName; oEdit.Text = oProperty.oModel.HNumber; } else { grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; } break; @@ -1742,7 +1781,7 @@ grdMain.Rows.Add(); Application.DoEvents(); //å¾å°ä¿¡æ¯ Ds = oCn.RunProcReturn("select * from h_v_KF_ICInventoryList_IF where hmaterid=" + oSelectRow.BillMainID + " and hwhid=" + oSelectRow.BillSubID + " and hspid=" + oSelectRow.SPID + " and æ¹æ¬¡='" + oSelectRow.BatchNo + "' and 计åè·è¸ªå·='" + oSelectRow.BillNo + "'", "h_v_KF_ICInventoryList_IF"); Ds = oCn.RunProcReturn("select * from h_v_KF_ICInventoryList_IF where hmaterid=" + oSelectRow.BillMainID + " and hwhid=" + oSelectRow.BillSubID + " and hspid=" + oSelectRow.SPID + " and HAuxPropID=" + oSelectRow.HAuxPropID + " and æ¹æ¬¡='" + oSelectRow.BatchNo + "' and 计åè·è¸ªå·='" + oSelectRow.BillNo + "'", "h_v_KF_ICInventoryList_IF"); //åå ¥ä¿¡æ¯ Sub_WriteInForm2(Ds.Tables[0], i); } @@ -1793,13 +1832,21 @@ //grdMain.Rows[i].Cells[HSourceNumberCol].Value = oTable.Rows[0]["ç产线代ç "].ToString(); grdMain.Rows[i].Cells[HSourceNameCol].Value = oTable.Rows[0]["ç产线"].ToString(); grdMain.Rows[i].Cells[HEndDateCol].Value = oTable.Rows[0]["计åå®å·¥æ¥æ"].ToString(); grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å è£ æ°"].ToString(); if (cmbHBarCodeType.Text == "æ¹æ¬¡æ¡ç " && CampanyName == "åæ¥ç§æ") { grdMain.Rows[i].Cells[HMinQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æªçææ¡ç æ°é"]); } else { grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å è£ æ°"].ToString(); } //-- //设置å¯ç¼è¾å string sAllowCol = HQtyCol.ToString() + "," + HMinQtyCol.ToString() + "," + HAuxPropNumberCol.ToString() + "," + HBatchNoCol.ToString() + "," + HRemarkCol.ToString() + "," + HMinQtyCol.ToString(); "," + HRemarkCol.ToString(); grdMain.Columns[HBillNoCol].ReadOnly = true; //设置å计å string sTotalCol = HQtyCol.ToString(); @@ -1842,7 +1889,14 @@ grdMain.Rows[i].Cells[HUnitNameCol].Value = oTable.Rows[0]["计éåä½"].ToString(); grdMain.Rows[i].Cells[HRemarkCol].Value = oTable.Rows[0]["å¤æ³¨"].ToString(); grdMain.Rows[i].Cells[HMTONoCol].Value = oTable.Rows[0]["计åè·è¸ªå·"].ToString(); grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å è£ æ°"].ToString(); if (cmbHBarCodeType.Text == "æ¹æ¬¡æ¡ç " && CampanyName == "åæ¥ç§æ") { grdMain.Rows[i].Cells[HMinQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æªçææ¡ç æ°é"]); } else { grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å è£ æ°"].ToString(); } grdMain.Rows[i].Cells[HMakerCol].Value = ClsPub.CurUserName; if (cmbSourceBillType.Text.Trim() == "æ¶æéç¥å"|| cmbSourceBillType.Text.Trim() == "éè´è®¢å" || cmbSourceBillType.Text.Trim() == "å§å¤è®¢å" || cmbSourceBillType.Text.Trim() == "éè´å ¥åºå") @@ -1870,9 +1924,10 @@ //-- //设置å¯ç¼è¾å string sAllowCol = HQtyCol.ToString() + "," + HMinQtyCol.ToString() + "," + HAuxPropNumberCol.ToString() + "," + HBatchNoCol.ToString() + "," + HRemarkCol.ToString() + "," + HMinQtyCol.ToString(); "," + HRemarkCol.ToString(); grdMain.Columns[HBillNoCol].ReadOnly = true; //设置å计å string sTotalCol = HQtyCol.ToString(); @@ -2430,6 +2485,138 @@ } } //æ¹æ¬¡æé® private void BatchNo_Click(object sender, EventArgs e) { lblCaption.Focus(); bool b = false; for (int i = 0; i < grdMain.RowCount; i++) { long HMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value); // ç©æå ç string HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HBatchNoCol].Value); // æ¹å· if (HMaterID != 0) { DataSet oDs = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_GetBatchNo " + HMaterID.ToString() + ",'" + HBatchNo + "','" + dtpHDate.Value.ToShortDateString() + "','" + CampanyName + "'", "h_p_Gy_BarCodeBill_GetBatchNo"); // if (oDs == null && oDs.Tables[0].Rows.Count == 0) { MessageBox.Show("çææ¹æ¬¡å¤±è´¥ï¼"); return; } else if (DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][0]) == "1") { grdMain.Rows[i].Cells[HBatchNoCol].Value = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]); b = true; } } } //æç»è¡¨æ¯å¦ä¸ºé¶è¡ if (b == false) { MessageBox.Show("没æéè¦çææ¹æ¬¡çæç»è¡ï¼", "æ示"); return; } } private void txtHSourceBillNo_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Return)//å车带åºæºåä¿¡æ¯ { long sHOrgID = -1; DAL.ClsGy_ORGANIZATIONS_View oClsGy_ORGANIZATIONS_View = new DAL.ClsGy_ORGANIZATIONS_View(); if (oClsGy_ORGANIZATIONS_View.GetInfoByName(cmbHOrgID.Text)) { sHOrgID = oClsGy_ORGANIZATIONS_View.omodel.HItemID; } if (txtHSourceBillNo.Text.Length < 4) { MessageBox.Show("请è¾å ¥4ä½ä»¥ä¸æ°æ®ï¼"); return; } //æ ¹æ®æºåç±»å åæºåå· è·åä¿¡æ¯ if (cmbSourceBillType.Text.Trim() == "ç产订å") { DAL.Cls_S_IFCLD_ICMOList oIFCLD_ICMOList = new DAL.Cls_S_IFCLD_ICMOList(); if (oIFCLD_ICMOList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' and HOrgID =" + sHOrgID.ToString())) //éæ©åå { FillSelectData(oIFCLD_ICMOList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»åä¸æºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else if (cmbSourceBillType.Text.Trim() == "ç产æ±æ¥å") { DAL.Cls_S_IF_ICMOReportBillList oIF_ICMOReportBillList = new DAL.Cls_S_IF_ICMOReportBillList(); if (oIF_ICMOReportBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' ")) //éæ©åå { FillSelectData(oIF_ICMOReportBillList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»åä¸æºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else if (cmbSourceBillType.Text.Trim() == "æ¶æéç¥å") { DAL.Cls_S_IF_POInStockBillList oIF_POInStockBillList = new DAL.Cls_S_IF_POInStockBillList(); if (oIF_POInStockBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' ")) //éæ©åå { FillSelectData(oIF_POInStockBillList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»åä¸æºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else if (cmbSourceBillType.Text.Trim() == "éè´è®¢å") { DAL.Cls_S_IF_POOrderBillList oIF_POOrderBillList = new DAL.Cls_S_IF_POOrderBillList(); if (oIF_POOrderBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' ")) //éæ©åå { FillSelectData(oIF_POOrderBillList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»åä¸æºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else if (cmbSourceBillType.Text.Trim() == "å§å¤è®¢å") { DAL.Cls_S_IF_EntrustOrderBillList oIF_EntrustOrderBillList = new DAL.Cls_S_IF_EntrustOrderBillList(); if (oIF_EntrustOrderBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' ")) //éæ©åå { FillSelectData(oIF_EntrustOrderBillList.oBillSelectColl); txtHSourceBillNo.Text = ""; } else { MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»åä¸æºååå·æ¯å¦æ£ç¡®ï¼"); return; } } else { MessageBox.Show("æéæºåç±»åï¼ä¸æ¯ææ¤åè½ï¼"); return; } } }
