派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -688,6 +688,7 @@ string HModelName = ""; //æºå string HICMOBillNo = ""; //æºåå· string HBarCodeBatchNo = ""; //æ¡ç æ¹æ¬¡å· string HBarCodeDate = ""; //æ¡ç æ¥æ int k = 0; int n = 0; //åä¸æ¹çææ¡ç ä¸ç第å æ¡ string sTMNumber = ""; //æ¡ç èªå®ä¹åç¼ @@ -704,7 +705,7 @@ //æ¥æè·åæ¹å¼ sDate = dtpHDate.Value.ToShortDateString(); // if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å") //åæ®æ¥æ(æ¶æéç¥å) if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") //åæ®æ¥æ(æ¶æéç¥å) { sDate = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HDateCol].Value); } @@ -712,14 +713,15 @@ { sDate = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HEndDateCol].Value); } else if (CompanyName=="å¤å®çµå¨")// æ¥æï¼ç产订å æ¡ç æ¥æ else if (CampanyName == "å¤å®çµå¨")// æ¥æï¼ç产订å æ¡ç æ¥æ { sDate = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HDateCol].Value); } HYasuoji= DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HPinfanCol].Value); //å缩æºä»£ç ï¼å¤å®çµå¨ï¼ HModelName= DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value); //æºåï¼å¤å®çµå¨ï¼ HModelName= DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusTypeCol].Value); //æºåï¼å¤å®çµå¨ï¼ HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HSourceBillNoCol].Value); //ç产订åå·ï¼å¤å®çµå¨ï¼ HBarCodeBatchNo= DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HPinfanBarCodeCol].Value); //æ¡ç æ¹æ¬¡å·ï¼å¤å®çµå¨ï¼ HBarCodeDate= DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HSupNumberCol].Value); //æ¡ç æ¥æï¼å¤å®çµå¨ï¼ // sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); @@ -776,7 +778,7 @@ { TM = HOrgNumber + HNumber + HBatchNo; }//åæ¥ç¹æ®å¤ç else if(cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å") else if(cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { //ç©æç¼ç +åæ®æ¥æï¼YYMMDDï¼+æµæ°´4ä½ sTMNumber = HMaterNumber + sYear + sPeriod + sDay; @@ -785,7 +787,7 @@ LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 4; } else if (cmbHBarCodeType.Text == "仪å¨æåæ¡ç è§å") else if (cmbHBarCodeType.Text == "仪å¨æåæ¡ç è§å") //å¦å¤å¤çäº { //ç©æç¼ç +åºåå·+ç产æ¥æ //sTMNumber = HMaterNumber + sYear + sPeriod + sDay; @@ -806,20 +808,31 @@ { //å¶é æ¬é¨1ä½ï¼é»è®¤1ï¼+æºå代ç 5ä½ï¼ï¼+å¹´2ä½+æ1ä½ï¼AãBãC代æ¿10æä»½ï¼ //+æ¥2ä½+æ¡ç æ¹æ¬¡ç 2ä½+å缩æºä»£ç 1ä½+00+æµæ°´å·4ä½+æ ¡éªç ï¼é»è®¤0ï¼ sTMNumber = "1" + HModelName + sYear + Sub_PeriodChange(sPeriod) + sDay + HBarCodeBatchNo + HYasuoji; sTMNumber = "1" + HModelName + HBarCodeDate + HBarCodeBatchNo + HYasuoji + "00" ; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 4; if (sTMNumber.Length != 16) { MessageBox.Show("æ¡ç é¿åº¦ä¸å¤16ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼å¶é æ¬é¨1ä½:[0] + æºå代ç 5ä½:[" + HModelName + "] + å¹´ææ¥5ä½:["+ HBarCodeDate + "] + æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "]+ å缩æº1ä½:["+ HYasuoji + "]+00 ; "); return; } } else if (cmbHBarCodeType.Text == "å¤éæºæ¡ç ") { //ç©æ代ç 11ä½+å¹´2ä½+æ1ä½ï¼AãBãC代æ¿10æ份ï¼+æ¥2ä½+æ¹æ¬¡2ä½+æµæ°´å·4ä½ sTMNumber = HMaterNumber + sYear + Sub_PeriodChange(sPeriod) + sDay + HBarCodeBatchNo ; //sTMNumber = HMaterNumber.Replace(Convert.ToChar("."),Convert.ToChar("")) + HBarCodeDate + HBarCodeBatchNo; sTMNumber = HMaterNumber.Replace( "." , "" ) + HBarCodeDate + HBarCodeBatchNo; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); LSHlen = 4; if (sTMNumber.Length != 18) { MessageBox.Show("æ¡ç é¿åº¦ä¸å¤18ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼ç©æ代ç 11ä½:["+ HMaterNumber.Replace(".", "") + "]+å¹´ææ¥5ä½:["+ HBarCodeDate + "]+æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "];"); return; } } else if (cmbHBarCodeType.Text == "åæåæ¡ç ") { @@ -875,7 +888,17 @@ //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· TM = sTMNumber + LSH2; } else if(cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å" || cmbHBarCodeType.Text == "è¯åæåæ¡ç è§å" || cmbHBarCodeType.Text == "åæåæ¡ç " || cmbHBarCodeType.Text == "å¤éæºæ¡ç ") { TM = sTMNumber + LSH2; } else if (cmbHBarCodeType.Text == "å éæºæ¡ç ") { TM = sTMNumber + LSH2 + "0"; } // if (i + 1 > grdSub.Rows.Count) { grdSub.RowCount = grdSub.RowCount + 1; @@ -1091,29 +1114,30 @@ } } //æ份转å private string Sub_PeriodChange(string sPeriod) { if(sPeriod=="10") { return "A"; } else if (sPeriod == "11") { return "B"; } else if (sPeriod == "12") { return "C"; } else { return sPeriod.Substring(2, 1); } } ////æ份转å //private string Sub_PeriodChange(string sPeriod) //{ // if(sPeriod=="10") // { // return "A"; // } // else if (sPeriod == "11") // { // return "B"; // } // else if (sPeriod == "12") // { // return "C"; // } // else // { // return sPeriod.Substring(1, 1); // } //} //çææ¡ç åæ¥ //ç©æç¼ç +åºåå·+ç产æ¥æ //çææ¡ç åæ¥ //ç©æç¼ç +åºåå·+ç产æ¥æ private void SaveBarCode_bori() { grdSub.Rows.Clear(); @@ -1127,7 +1151,7 @@ int HBQty = 0; //ç®±æ° double HQty = 0; //æ°é string WeiShu = ""; //å°¾æ° int LSH = 0; //æµæ°´å· //int LSH = 0; //æµæ°´å· string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 string sDate = ""; //æ¥æ string sYear = ""; //å¹´ @@ -1161,25 +1185,36 @@ sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); sDay = sDay.Substring(sDay.Length - 2, 2); //================================== if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") { //æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); } else { MessageBox.Show("é误çæ¡ç ç±»åï¼ä¸è½çææ¡ç ï¼"); return; } //if (cmbHBarCodeType.Text == "è¯åæåæ¡ç è§å") //{ // //æ¡ç åç¼ = ç»ç»ä»£ç + ç©æ代ç + å¹´ + æ + æ¥ //sTMNumber = HMaterNumber + HNumber + sYear + sPeriod + sDay; // Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· // //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); // LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); //} //else //{ // MessageBox.Show("é误çæ¡ç ç±»åï¼ä¸è½çææ¡ç ï¼"); // return; //} HBQty = HBQty + ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); HMinQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); HSumQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HQtyCol].Value); n = 0; for (int i = k; i < HBQty; i++) //ä»éè¶åºåå·è¡¨è·ååºåå· DataSet DSet = oCn.RunProcReturn("exec h_p_CLD_GetBarCodeSno "+ ClsPub.isStrNull(grdMain.Rows[j].Cells[HMainIDCol].Value) + "," + ClsPub.isStrNull(grdMain.Rows[j].Cells[HSubIDCol].Value) + " ", "h_p_CLD_GetBarCodeSno", ref DBUtility.ClsPub.sExeReturnInfo); //çæé¦è¡æ é¢ if (DSet == null) { MessageBox.Show("没æè¿åä»»ä½ç»æ,éè¶äºåºåå·ä¸åå¨ï¼" + DBUtility.ClsPub.sExeReturnInfo); continue; } // for (int i = k; i < DSet.Tables[0].Rows.Count; i++) //for (int i = k; i < HBQty; i++) { if (HSumQty - HMinQty > 0) { @@ -1199,17 +1234,18 @@ HMinQty = HSumQty; } // LSH = LSH + 1; LSH2 = LSH.ToString(); while (LSH2.Length < LSHlen) //å¦ææµæ°´å·å°äº6ä½æ°åé¢è¡¥0 { LSH2 = "0" + LSH2; } if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") { //LSH = LSH + 1; LSH2 =DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[n]["SHNO"]); //while (LSH2.Length < LSHlen) //å¦ææµæ°´å·å°äº6ä½æ°åé¢è¡¥0 //{ // LSH2 = "0" + LSH2; //} //if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") //{ //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· TM = sTMNumber + LSH2; } //T/*M*/ = HMaterNumber + LSH2 + sYear + sPeriod + sDay; TM = LSH2 + sYear + sPeriod + sDay; //} if (i + 1 > grdSub.Rows.Count) { @@ -1283,7 +1319,7 @@ grdSub.Rows[i].Cells[HGiveAwayFlag2Col] = oCell; k = k + 1; n = n + 1; oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); } } } @@ -2289,6 +2325,7 @@ grdMain.Rows[i].Cells[HMainIDCol].Value = oTable.Rows[0]["hmainid"].ToString(); grdMain.Rows[i].Cells[HSubIDCol].Value = oTable.Rows[0]["hsubid"].ToString(); grdMain.Rows[i].Cells[HBillNoCol].Value = oTable.Rows[0]["åæ®å·"].ToString(); grdMain.Rows[i].Cells[HSourceBillNoCol].Value = oTable.Rows[0]["åæ®å·"].ToString(); grdMain.Rows[i].Cells[HBillTypeCol].Value = oTable.Rows[0]["HBillType"].ToString(); grdMain.Rows[i].Cells[HDateCol].Value = oTable.Rows[0]["æ¥æ"].ToString(); //åæ¥ æ¶æåæ®æ¥æ grdMain.Rows[i].Cells[HShowDateCol].Value = dtpHDate.Value.ToShortDateString(); @@ -2313,15 +2350,19 @@ grdMain.Rows[i].Cells[HCusNumberCol].Value = oTable.Rows[0]["客æ·ä»£ç "].ToString(); grdMain.Rows[i].Cells[HCusNameCol].Value = oTable.Rows[0]["客æ·"].ToString(); grdMain.Rows[i].Cells[HCusTypeCol].Value = oTable.Rows[0]["客æ·åå·"].ToString(); grdMain.Rows[i].Cells[HPinfanBarCodeCol].Value = oTable.Rows[0]["HPinfanBarCode"].ToString(); grdMain.Rows[i].Cells[HPinfanCol].Value = oTable.Rows[0]["HPinfan"].ToString(); //grdMain.Rows[i].Cells[HSourceIDCol].Value = oTable.Rows[0]["HSourceID"].ToString(); //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();//åæ¥ ç产订å 失ææ¥æ if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å" && CampanyName == "åæ¥ç§æ") if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å" ) { grdMain.Rows[i].Cells[HMinQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æªçææ¡ç æ°é"]); } else if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" && CampanyName == "åæ¥ç§æ") else if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || cmbHBarCodeType.Text == "仪å¨æåæ¡ç è§å" || cmbHBarCodeType.Text == "è¯åæåæ¡ç è§å") { grdMain.Rows[i].Cells[HMinQtyCol].Value = "1"; } @@ -2378,10 +2419,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(); if (cmbHBarCodeType.Text == "æ¹æ¬¡æ¡ç " && CampanyName == "åæ¥ç§æ") if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { grdMain.Rows[i].Cells[HMinQtyCol].Value = ClsPub.isDoule(oTable.Rows[0]["æªçææ¡ç æ°é"]); } else if (cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å") { grdMain.Rows[i].Cells[HMinQtyCol].Value = "1"; } else { grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å è£ æ°"].ToString();
