派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -39,45 +39,46 @@ public const Int16 HBarCodeTypeCol = 18; public const Int16 HBatchManagerCol = 19; public const Int16 HBatchNoCol = 20; public const Int16 HQtyCol = 21; public const Int16 HMinQtyCol = 22; public const Int16 HBQtyCol = 23; public const Int16 HDeptIDCol = 24; public const Int16 HDeptNumberCol = 25; public const Int16 HDeptNameCol = 26; public const Int16 HSourceIDCol = 27; public const Int16 HSourceNumberCol = 28; public const Int16 HSourceNameCol = 29; public const Int16 HDateCol = 30; public const Int16 HEndDateCol = 31; public const Int16 HSupIDCol = 32; public const Int16 HSupNumberCol = 33; public const Int16 HSupNameCol = 34; public const Int16 HCusIDCol = 35; public const Int16 HCusNumberCol = 36; public const Int16 HCusNameCol = 37; public const Int16 HCusTypeCol = 38; public const Int16 HSourceInterIDCol = 39; public const Int16 HSourceEntryIDCol = 40; public const Int16 HSourceBillNoCol = 41; public const Int16 HSourceBillTypeCol = 42; public const Int16 HInstructIDCol = 43; public const Int16 HInstructNoCol = 44; public const Int16 HSeOrderBillIDCol = 45; public const Int16 HSeOrderBillNoCol = 46; public const Int16 HWhIDCol = 47; public const Int16 HWhNumberCol = 48; public const Int16 HWhNameCol = 49; public const Int16 HSPIDCol = 50; public const Int16 HSPNumberCol = 51; public const Int16 HSPNameCol = 52; public const Int16 HinitQtyCol = 53; public const Int16 HRemarkCol = 54; public const Int16 HPinfanBarCodeCol = 55; public const Int16 HMTONoCol = 56; public const Int16 HShowDateCol = 57; public const Int16 HInnerBillNoCol = 58; public const Int16 HMakerCol = 59; public const Int16 HGiveAwayFlagCol = 21; public const Int16 HQtyCol = 22; public const Int16 HMinQtyCol = 23; public const Int16 HBQtyCol = 24; public const Int16 HDeptIDCol = 25; public const Int16 HDeptNumberCol = 26; public const Int16 HDeptNameCol = 27; public const Int16 HSourceIDCol = 28; public const Int16 HSourceNumberCol = 29; public const Int16 HSourceNameCol = 30; public const Int16 HDateCol = 31; public const Int16 HEndDateCol = 32; public const Int16 HSupIDCol = 33; public const Int16 HSupNumberCol = 34; public const Int16 HSupNameCol = 35; public const Int16 HCusIDCol = 36; public const Int16 HCusNumberCol = 37; public const Int16 HCusNameCol = 38; public const Int16 HCusTypeCol = 39; public const Int16 HSourceInterIDCol = 40; public const Int16 HSourceEntryIDCol = 41; public const Int16 HSourceBillNoCol = 42; public const Int16 HSourceBillTypeCol = 43; public const Int16 HInstructIDCol = 44; public const Int16 HInstructNoCol = 45; public const Int16 HSeOrderBillIDCol = 46; public const Int16 HSeOrderBillNoCol = 47; public const Int16 HWhIDCol = 48; public const Int16 HWhNumberCol = 49; public const Int16 HWhNameCol = 50; public const Int16 HSPIDCol = 51; public const Int16 HSPNumberCol = 52; public const Int16 HSPNameCol = 53; public const Int16 HinitQtyCol = 54; public const Int16 HRemarkCol = 55; public const Int16 HPinfanBarCodeCol = 56; public const Int16 HMTONoCol = 57; public const Int16 HShowDateCol = 58; public const Int16 HInnerBillNoCol = 59; public const Int16 HMakerCol = 60; public Int16 HSelectCol = 0; public Int16 HSno2Col = 1; @@ -93,49 +94,50 @@ public Int16 HAuxPropNumber2Col = 11; public Int16 HAuxPropName2Col = 12; public Int16 HBatchNo2Col = 13; public Int16 HUnitID2Col = 14; public Int16 HUnitNumber2Col = 15; public Int16 HUnitName2Col = 16; public Int16 HQty2Col = 17; public Int16 HWeiCol = 18; public Int16 HPrintCol = 19; public Int16 HDeptID2Col = 20; public Int16 HDeptNumber2Col = 21; public Int16 HDeptName2Col = 22; public Int16 HSourceID2Col = 23; public Int16 HSourceNumber2Col = 24; public Int16 HSourceName2Col = 25; public Int16 HDate2Col = 26; public Int16 HEndDate2Col = 27; public Int16 HBarcodeNoCol = 28; public Int16 HBarcodeQtysCol = 29; public Int16 HSupID2Col = 30; public Int16 HSupNumber2Col = 31; public Int16 HSupName2Col = 32; public Int16 HCusID2Col = 33; public Int16 HCusNumber2Col = 34; public Int16 HCusName2Col = 35; public Int16 HCusType2Col = 36; public Int16 HSourceInterID2Col = 37; public Int16 HSourceEntryID2Col = 38; public Int16 HSourceBillNo2Col = 39; public Int16 HSourceBillType2Col = 40; public Int16 HInstructID2Col = 41; public Int16 HInstructNo2Col = 42; public Int16 HSeOrderBillID2Col = 43; public Int16 HSeOrderBillNo2Col = 44; public Int16 HWhID2Col = 45; public Int16 HWhNumber2Col = 46; public Int16 HWhName2Col = 47; public Int16 HSPID2Col = 48; public Int16 HSPNumber2Col = 49; public Int16 HSPName2Col = 50; public Int16 HRemark2Col = 51; public Int16 HPinfanBarCode2Col = 52; public Int16 HMTONo2Col = 53; public Int16 HShowDate2Col = 54; public Int16 HInnerBillNo2Col = 55; public Int16 HMaker2Col = 56; public Int16 HGiveAwayFlag2Col = 14; public Int16 HUnitID2Col = 15; public Int16 HUnitNumber2Col = 16; public Int16 HUnitName2Col = 17; public Int16 HQty2Col = 18; public Int16 HWeiCol = 19; public Int16 HPrintCol = 20; public Int16 HDeptID2Col = 21; public Int16 HDeptNumber2Col = 22; public Int16 HDeptName2Col = 23; public Int16 HSourceID2Col = 24; public Int16 HSourceNumber2Col = 25; public Int16 HSourceName2Col = 26; public Int16 HDate2Col = 27; public Int16 HEndDate2Col = 28; public Int16 HBarcodeNoCol = 29; public Int16 HBarcodeQtysCol = 30; public Int16 HSupID2Col = 31; public Int16 HSupNumber2Col = 32; public Int16 HSupName2Col = 33; public Int16 HCusID2Col = 34; public Int16 HCusNumber2Col = 35; public Int16 HCusName2Col = 36; public Int16 HCusType2Col = 37; public Int16 HSourceInterID2Col = 38; public Int16 HSourceEntryID2Col = 39; public Int16 HSourceBillNo2Col = 40; public Int16 HSourceBillType2Col = 41; public Int16 HInstructID2Col = 42; public Int16 HInstructNo2Col = 43; public Int16 HSeOrderBillID2Col = 44; public Int16 HSeOrderBillNo2Col = 45; public Int16 HWhID2Col = 46; public Int16 HWhNumber2Col = 47; public Int16 HWhName2Col = 48; public Int16 HSPID2Col = 49; public Int16 HSPNumber2Col = 50; public Int16 HSPName2Col = 51; public Int16 HRemark2Col = 52; public Int16 HPinfanBarCode2Col = 53; public Int16 HMTONo2Col = 54; public Int16 HShowDate2Col = 55; public Int16 HInnerBillNo2Col = 56; public Int16 HMaker2Col = 57; // public string ModName = "85"; public string ModCaption = "æ¡ç çæ"; @@ -830,6 +832,13 @@ grdSub.Rows[i].Cells[HSeOrderBillNo2Col].Value = grdMain.Rows[j].Cells[HSeOrderBillNoCol].Value; grdSub.Rows[i].Cells[HInnerBillNo2Col].Value = grdMain.Rows[j].Cells[HInnerBillNoCol].Value; grdSub.Rows[i].Cells[HMaker2Col].Value = grdMain.Rows[j].Cells[HMakerCol].Value; grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value = grdMain.Rows[j].Cells[HGiveAwayFlagCol].Value; //ç½æ ¼æå¾ DataGridViewCheckBoxCell oCell = new DataGridViewCheckBoxCell(); oCell.ThreeState = false; oCell.Value = grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value; oCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdSub.Rows[i].Cells[HGiveAwayFlag2Col] = oCell; k = k + 1; n = n + 1; oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); @@ -867,6 +876,7 @@ string HWorkLineName = ""; string HSeOrderBillNo = ""; string HInnerBillNo = ""; bool HGiveAwayFlag = false; try { oCn.BeginTran(); @@ -903,12 +913,14 @@ HWorkLineName = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSourceName2Col].Value); HSeOrderBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSeOrderBillNo2Col].Value); HInnerBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HInnerBillNo2Col].Value); HGiveAwayFlag = ClsPub.isBool(grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value); oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID " + ",HGiveAwayFlag " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() @@ -917,6 +929,7 @@ + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')"); @@ -975,7 +988,7 @@ // grdMain.RowCount = 0; grdSub.RowCount = 0; grdMain.ColumnCount = 60; //æ»åæ° grdMain.ColumnCount = 61; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); grdMain.Columns[HSnoCol].HeaderText = "åºå·"; grdMain.Columns[HMainIDCol].HeaderText = "æºå主ID"; @@ -998,6 +1011,7 @@ grdMain.Columns[HBarCodeTypeCol].HeaderText = "æ¡ç ç±»å"; grdMain.Columns[HBatchManagerCol].HeaderText = "æ¯å¦å¯ç¨æ¹æ¬¡"; grdMain.Columns[HBatchNoCol].HeaderText = "æ¹å·"; grdMain.Columns[HGiveAwayFlagCol].HeaderText = "æ¯å¦èµ å"; grdMain.Columns[HQtyCol].HeaderText = "æ°é"; grdMain.Columns[HMinQtyCol].HeaderText = "æå°å è£ æ°"; grdMain.Columns[HBQtyCol].HeaderText = "ç®±æ°"; @@ -1089,12 +1103,23 @@ "," + HRemarkCol.ToString(); //设置å计å string sTotalCol = HQtyCol.ToString(); //设置ç¹æ®å for (int i = 0; i < grdMain.Rows.Count; i++) { //ç½æ ¼æå¾ DataGridViewCheckBoxCell oCell = new DataGridViewCheckBoxCell(); oCell.ThreeState = false; oCell.Value = 0; oCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdMain.Rows[i].Cells[HGiveAwayFlagCol] = oCell; } // DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol,oSumGrid); //---------------------------- grdSub.ColumnCount = 57; //æ»åæ° grdSub.ColumnCount = 58; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdSub, this.Name); grdSub.Columns[HSelectCol].HeaderText = "éæ©"; grdSub.Columns[HTMCol].HeaderText = "æ¡ç ç¼å·"; @@ -1111,6 +1136,7 @@ grdSub.Columns[HPinfan2Col].HeaderText = "åçª"; grdSub.Columns[HPinfanBarCode2Col].HeaderText = "HPinfanBarCode"; grdSub.Columns[HBatchNo2Col].HeaderText = "æ¹å·"; grdSub.Columns[HGiveAwayFlag2Col].HeaderText = "æ¯å¦èµ å"; grdSub.Columns[HUnitID2Col].HeaderText = "计éåä½ID"; grdSub.Columns[HUnitNumber2Col].HeaderText = "计éåä½ä»£ç "; grdSub.Columns[HUnitName2Col].HeaderText = "计éåä½"; @@ -1194,6 +1220,17 @@ grdSub.Columns[HSourceID2Col].Visible = false; grdSub.Columns[HSourceNumber2Col].Visible = false; grdSub.Columns[HSourceName2Col].Visible = false; //设置ç¹æ®å for (int i = 0; i < grdSub.Rows.Count; i++) { //ç½æ ¼æå¾ DataGridViewCheckBoxCell oCell = new DataGridViewCheckBoxCell(); oCell.ThreeState = false; oCell.Value = 0; oCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdSub.Rows[i].Cells[HGiveAwayFlag2Col] = oCell; } DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); DBUtility.Xt_BaseBillFun.GetGrid(grdSub, this.Name + "grdSub"); @@ -1832,7 +1869,14 @@ //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() + @@ -1882,7 +1926,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() == "éè´å ¥åºå") @@ -1891,6 +1942,18 @@ grdMain.Rows[i].Cells[HSupIDCol].Value = oTable.Rows[0]["hsupid"].ToString(); grdMain.Rows[i].Cells[HSupNumberCol].Value = oTable.Rows[0]["ä¾åºå代ç "].ToString(); grdMain.Rows[i].Cells[HSupNameCol].Value = oTable.Rows[0]["ä¾åºå"].ToString(); if (cmbSourceBillType.Text.Trim() == "æ¶æéç¥å") { if (oTable.Rows[0]["æ¯å¦èµ å"].ToString() == "æ¯") { grdMain.Rows[i].Cells[HGiveAwayFlagCol].Value = 1; } else { grdMain.Rows[i].Cells[HGiveAwayFlagCol].Value = 0; } } } if (cmbSourceBillType.Text.Trim() == "éè´§éç¥å") { @@ -2471,6 +2534,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; } } }
