派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -685,10 +685,10 @@ string HMaterNumber = ""; //ç©æ代ç double HSumQty = 0; //产åæ°é double HMinQty = 0; //æå°å è£ æ° int HBQty = 0; //ç®±æ° Int64 HBQty = 0; //ç®±æ° double HQty = 0; //æ°é string WeiShu = ""; //å°¾æ° int LSH = 0; //æµæ°´å· Int64 LSH = 0; //æµæ°´å· string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 string sDate = ""; //æ¥æ string sYear = ""; //å¹´ @@ -701,7 +701,7 @@ string HBarCodeBatchNo = ""; //æ¡ç æ¹æ¬¡å· string HBarCodeDate = ""; //æ¡ç æ¥æ int k = 0; int n = 0; //åä¸æ¹çææ¡ç ä¸ç第å æ¡ Int64 n = 0; //åä¸æ¹çææ¡ç ä¸ç第å æ¡ string sTMNumber = ""; //æ¡ç èªå®ä¹åç¼ DataSet Ds; //Ds = oCn.RunProcReturn("exec GetLSH '" + ClsPub.GetServerDate(0) + "'", "GetLSH"); @@ -748,7 +748,7 @@ sTMNumber = 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } else if (CampanyName == "é£é¾") { @@ -763,7 +763,7 @@ sTMNumber = HWorksNumber + 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } else //éç¨æ¹æ³ { @@ -771,7 +771,7 @@ 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } } else if (cmbHBarCodeType.Text == "åç§æ¡ç ") @@ -795,7 +795,7 @@ sTMNumber = HMaterNumber + 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 4; } else if (cmbHBarCodeType.Text == "仪å¨æåæ¡ç è§å") //å¦å¤å¤çäº @@ -804,7 +804,7 @@ //sTMNumber = HMaterNumber + 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]); //LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } else if (cmbHBarCodeType.Text == "è¯åæåæ¡ç è§å") { @@ -812,7 +812,7 @@ sTMNumber = HMaterNumber + HBatchNo ; 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 6; } else if (cmbHBarCodeType.Text == "å éæºæ¡ç ") @@ -822,7 +822,7 @@ 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 5; if (sTMNumber.Length != 16) { @@ -837,7 +837,7 @@ 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 5; if (sTMNumber.Length != 18) { @@ -851,7 +851,7 @@ sTMNumber = HICMOBillNo; 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]); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 5; } //else if (cmbHBarCodeType.Text == "æçæ¡ç ") @@ -864,7 +864,7 @@ return; } HBQty = HBQty + ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); HBQty = HBQty + ClsPub.isLong(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; @@ -1073,7 +1073,7 @@ ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + ",HGiveAwayFlag,HSeOrderSEQ " + ",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() @@ -1082,7 +1082,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() + "," + HEntryID.ToString() + "" + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + HSeOrderSEQ.ToString() + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + HSeOrderSEQ.ToString() + "," + HSourceEntryID.ToString() + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')"); @@ -1165,7 +1165,7 @@ string HMaterNumber = ""; //ç©æ代ç double HSumQty = 0; //产åæ°é double HMinQty = 0; //æå°å è£ æ° int HBQty = 0; //ç®±æ° Int64 HBQty = 0; //ç®±æ° double HQty = 0; //æ°é string WeiShu = ""; //å°¾æ° //int LSH = 0; //æµæ°´å· @@ -1216,7 +1216,7 @@ // return; //} HBQty = HBQty + ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); HBQty = HBQty + ClsPub.isLong(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; @@ -3113,6 +3113,12 @@ grdMain.Rows[row + r].Cells[HMTONoCol].Value = grdMain.Rows[row].Cells[HMTONoCol].Value; grdMain.Rows[row + r].Cells[HInnerBillNoCol].Value = grdMain.Rows[row].Cells[HInnerBillNoCol].Value; grdMain.Rows[row + r].Cells[HMakerCol].Value = grdMain.Rows[row].Cells[HMakerCol].Value; //ç½æ ¼æå¾ DataGridViewCheckBoxCell oCell = new DataGridViewCheckBoxCell(); oCell.ThreeState = false; oCell.Value = grdMain.Rows[row].Cells[HGiveAwayFlagCol].Value; oCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdMain.Rows[row + r].Cells[HGiveAwayFlagCol] = oCell; } DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
