派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -81,6 +81,11 @@ public const Int16 HShowDateCol = 60; public const Int16 HInnerBillNoCol = 61; public const Int16 HMakerCol = 62; public const Int16 HProduceDateCol = 63; public const Int16 HExpiryDateCol = 64; public const Int16 HISKFPERIODCol = 65; public const Int16 HEXPUNITCol = 66; public const Int16 HEXPPERIODCol = 67; public Int16 HSelectCol = 0; public Int16 HSno2Col = 1; @@ -142,6 +147,11 @@ public Int16 HInnerBillNo2Col = 57; public Int16 HMaker2Col = 58; public Int16 HEntryID2Col = 59; public Int16 HProduceDate2Col = 60; public Int16 HExpiryDate2Col = 61; public Int16 HISKFPERIOD2Col = 62; public Int16 HEXPUNIT2Col = 63; public Int16 HEXPPERIOD2Col = 64; // public string ModName = "85"; public string ModCaption = "æ¡ç çæ"; @@ -211,6 +221,8 @@ cmbSourceBillType.Items.Add("éè´è®¢å"); cmbSourceBillType.Items.Add("æ¶æéç¥å"); cmbSourceBillType.Items.Add("å§å¤è®¢å"); cmbSourceBillType.Items.Add("å·¥åºæ±æ¥å"); cmbSourceBillType.Items.Add("å·¥åºæµè½¬å¡"); cmbSourceBillType.Items.Add("éè´§éç¥å"); cmbSourceBillType.Items.Add("å ¶ä»å ¥åºå"); cmbSourceBillType.Items.Add("ç´æ¥è°æ¨å"); @@ -624,6 +636,45 @@ { sHRemark= sHRemark+DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HRemark"]); } else { if (DBUtility.ClsPub.isBool(oDsCheck.Tables[0].Rows[0]["HISKFPERIOD"])) { DateTime HProduceDate; //ç产æ¥æ string HEXPUNIT; //ä¿è´¨æåä½ int HEXPPERIOD; //ä¿è´¨æ HProduceDate = dtpHDate.Value; HEXPUNIT = DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HEXPUNIT"]); HEXPPERIOD = DBUtility.ClsPub.isInt(oDsCheck.Tables[0].Rows[0]["HEXPPERIOD"]); grdMain.Rows[j].Cells[HISKFPERIODCol].Value = 1; grdMain.Rows[j].Cells[HEXPUNITCol].Value = HEXPUNIT; grdMain.Rows[j].Cells[HEXPPERIODCol].Value = HEXPPERIOD.ToString(); grdMain.Rows[j].Cells[HProduceDateCol].Value = HProduceDate.ToShortDateString(); if (HEXPUNIT == "Y") { grdMain.Rows[j].Cells[HExpiryDateCol].Value = HProduceDate.AddYears(HEXPPERIOD).ToShortDateString(); } else if (HEXPUNIT == "M") { grdMain.Rows[j].Cells[HExpiryDateCol].Value = HProduceDate.AddMonths(HEXPPERIOD).ToShortDateString(); } else { grdMain.Rows[j].Cells[HExpiryDateCol].Value = HProduceDate.AddDays(HEXPPERIOD).ToShortDateString(); } } else { grdMain.Rows[j].Cells[HISKFPERIODCol].Value = 0; grdMain.Rows[j].Cells[HEXPUNITCol].Value = ""; grdMain.Rows[j].Cells[HEXPPERIODCol].Value = 0; grdMain.Rows[j].Cells[HProduceDateCol].Value = ""; grdMain.Rows[j].Cells[HExpiryDateCol].Value = ""; } } } } if(sHRemark!="") @@ -789,6 +840,15 @@ { TM = HOrgNumber + HNumber + HBatchNo; }//åæ¥ç¹æ®å¤ç else if (cmbHBarCodeType.Text == "åºåç ") { //æ¡ç è§åï¼ GX+ç©æå ç +å¹´å¹´æææ¥æ¥+5ä½æµæ°´å· LSHlen = 5; //æ¡ç åç¼ = GX+ç©æå ç +å¹´å¹´æææ¥æ¥ sTMNumber = "GX" + HNumber + sYear + sPeriod + sDay; Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæ大æµæ°´å· LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } else if(cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç æ®éè§å" || cmbHBarCodeType.Text == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") { //ç©æç¼ç +åæ®æ¥æï¼YYMMDDï¼+æµæ°´4ä½ @@ -824,9 +884,9 @@ //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 4; if (sTMNumber.Length != 16) if (sTMNumber.Length != 16 && sTMNumber.Length != 15) { MessageBox.Show("æ¡ç é¿åº¦ä¸å¤16ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼å¶é æ¬é¨1ä½:[0] + æºå代ç 5ä½:[" + HModelName + "] + å¹´ææ¥5ä½:["+ HBarCodeDate + "] + æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "]+ å缩æº1ä½:["+ HYasuoji + "]+00 ; "); MessageBox.Show("æ¡ç é¿åº¦ä¸å¤15æ16ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼å¶é æ¬é¨1ä½:[0] + æºå代ç 5ä½:[" + HModelName + "] + å¹´ææ¥4æ5ä½:["+ HBarCodeDate + "] + æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "]+ å缩æº1ä½:["+ HYasuoji + "]+00 ; "); return; } } @@ -839,9 +899,9 @@ //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); LSHlen = 4; if (sTMNumber.Length != 18) if (sTMNumber.Length != 18 && sTMNumber.Length != 17) { MessageBox.Show("æ¡ç é¿åº¦ä¸å¤18ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼ç©æ代ç 11ä½:["+ HMaterNumber.Replace(".", "") + "]+å¹´ææ¥5ä½:["+ HBarCodeDate + "]+æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "];"); MessageBox.Show("æ¡ç é¿åº¦ä¸å¤17æ18ä½ï¼æ¯å¦æ°æ®ä¸å ¨ï¼ç©æ代ç 11ä½:["+ HMaterNumber.Replace(".", "") + "]+å¹´ææ¥4æ5ä½:["+ HBarCodeDate + "]+æ¹æ¬¡å·2ä½:[" + HBarCodeBatchNo + "];"); return; } } @@ -896,6 +956,11 @@ LSH2 = "0" + LSH2; } if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") { //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· TM = sTMNumber + LSH2; } else if (cmbHBarCodeType.Text == "åºåç ") { //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· TM = sTMNumber + LSH2; @@ -977,12 +1042,24 @@ 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; grdSub.Rows[i].Cells[HProduceDate2Col].Value = grdMain.Rows[j].Cells[HProduceDateCol].Value; grdSub.Rows[i].Cells[HExpiryDate2Col].Value = grdMain.Rows[j].Cells[HExpiryDateCol].Value; grdSub.Rows[i].Cells[HISKFPERIOD2Col].Value = grdMain.Rows[j].Cells[HISKFPERIODCol].Value; grdSub.Rows[i].Cells[HEXPUNIT2Col].Value = grdMain.Rows[j].Cells[HEXPUNITCol].Value; grdSub.Rows[i].Cells[HEXPPERIOD2Col].Value = grdMain.Rows[j].Cells[HEXPPERIODCol].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; //æ¯å¦å¯ç¨ä¿è´¨æ DataGridViewCheckBoxCell oCell2 = new DataGridViewCheckBoxCell(); oCell2.ThreeState = false; oCell2.Value = grdSub.Rows[i].Cells[HISKFPERIOD2Col].Value; oCell2.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdSub.Rows[i].Cells[HISKFPERIOD2Col] = oCell2; k = k + 1; n = n + 1; //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); @@ -1026,6 +1103,11 @@ string HInnerBillNo = ""; bool HGiveAwayFlag = false; Int64 HEntryID = 0; string HProduceDate; string HExpiryDate; bool HISKFPERIOD = false; string HEXPUNIT = ""; double HEXPPERIOD = 0; try { oCn.BeginTran(); @@ -1071,6 +1153,25 @@ HSeOrderSEQ = ClsPub.isLong(grdSub.Rows[i].Cells[HSeOrderSEQ2Col].Value); HInnerBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HInnerBillNo2Col].Value); HGiveAwayFlag = ClsPub.isBool(grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value); if (ClsPub.isDate(grdSub.Rows[i].Cells[HProduceDate2Col].Value) < Convert.ToDateTime("1950-01-01")) { HProduceDate = ""; } else { HProduceDate = ClsPub.isStrNull(grdSub.Rows[i].Cells[HProduceDate2Col].Value); } if (ClsPub.isDate(grdSub.Rows[i].Cells[HExpiryDate2Col].Value) < Convert.ToDateTime("1950-01-01")) { HExpiryDate = ""; } else { HExpiryDate = ClsPub.isStrNull(grdSub.Rows[i].Cells[HExpiryDate2Col].Value); } HISKFPERIOD = ClsPub.isBool(grdSub.Rows[i].Cells[HISKFPERIOD2Col].Value); HEXPUNIT = ClsPub.isStrNull(grdSub.Rows[i].Cells[HEXPUNIT2Col].Value); HEXPPERIOD = ClsPub.isDoule(grdSub.Rows[i].Cells[HEXPPERIOD2Col].Value); oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + @@ -1078,6 +1179,8 @@ ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + ",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " + ",HProduceDate,HExpiryDate " + ",HISKFPERIOD,HEXPUNIT,HEXPPERIOD " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() @@ -1085,8 +1188,10 @@ + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'" + ", " + 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() + "" + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + HSeOrderSEQ.ToString() + "," + HSourceEntryID.ToString() + ", " + (HProduceDate == "" ? "NULL" : "'" + HProduceDate + "'") + "," + (HExpiryDate == "" ? "NULL" : "'" + HExpiryDate + "'") + ", " + DBUtility.ClsPub.BoolToString(HISKFPERIOD) + ",'" + HEXPUNIT + "'," + HEXPPERIOD.ToString() + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')"); @@ -1493,7 +1598,7 @@ // grdMain.RowCount = 0; grdSub.RowCount = 0; grdMain.ColumnCount = 63; //æ»åæ° grdMain.ColumnCount = 68; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); grdMain.Columns[HSnoCol].HeaderText = "åºå·"; grdMain.Columns[HMainIDCol].HeaderText = "æºå主ID"; @@ -1550,6 +1655,11 @@ grdMain.Columns[HShowDateCol].HeaderText = "æ¥æ"; grdMain.Columns[HInnerBillNoCol].HeaderText = "å é¨éè´è®¢åå·"; grdMain.Columns[HMakerCol].HeaderText = "å¶å人"; grdMain.Columns[HProduceDateCol].HeaderText = "ç产æ¥æ"; grdMain.Columns[HExpiryDateCol].HeaderText = "æææè³"; grdMain.Columns[HISKFPERIODCol].HeaderText = "æ¯å¦å¯ç¨ä¿è´¨æ"; grdMain.Columns[HEXPUNITCol].HeaderText = "ä¿è´¨æåä½"; grdMain.Columns[HEXPPERIODCol].HeaderText = "ä¿è´¨æ"; //// //æ ¼å¼å grdMain.Columns[HTagCol].Visible = false; //éèå @@ -1597,7 +1707,12 @@ grdMain.Columns[HSourceIDCol].Visible = false; grdMain.Columns[HSourceNumberCol].Visible = false; grdMain.Columns[HSourceNameCol].Visible = false; grdMain.Columns[HProduceDateCol].Visible = false; grdMain.Columns[HExpiryDateCol].Visible = false; grdMain.Columns[HISKFPERIODCol].Visible = false; grdMain.Columns[HEXPUNITCol].Visible = false; grdMain.Columns[HEXPPERIODCol].Visible = false; //设置å¯ç¼è¾å string sAllowCol = HQtyCol.ToString()+ "," + HMinQtyCol.ToString() + @@ -1627,7 +1742,7 @@ DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol,oSumGrid); //---------------------------- grdSub.ColumnCount = 60; //æ»åæ° grdSub.ColumnCount = 65; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdSub, this.Name); grdSub.Columns[HSelectCol].HeaderText = "éæ©"; grdSub.Columns[HTMCol].HeaderText = "æ¡ç ç¼å·"; @@ -1687,6 +1802,11 @@ grdSub.Columns[HInnerBillNo2Col].HeaderText = "å é¨éè´è®¢åå·"; grdSub.Columns[HMaker2Col].HeaderText = "å¶å人"; grdSub.Columns[HEntryID2Col].HeaderText = "è¡å·"; grdSub.Columns[HProduceDate2Col].HeaderText = "ç产æ¥æ"; grdSub.Columns[HExpiryDate2Col].HeaderText = "æææè³"; grdSub.Columns[HISKFPERIOD2Col].HeaderText = "æ¯å¦å¯ç¨ä¿è´¨æ"; grdSub.Columns[HEXPUNIT2Col].HeaderText = "ä¿è´¨æåä½"; grdSub.Columns[HEXPPERIOD2Col].HeaderText = "ä¿è´¨æ"; //æ ¼å¼å grdSub.Columns[HMaterID2Col].Visible = false; grdSub.Columns[HModel2Col].Visible = false; @@ -1735,11 +1855,18 @@ 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; //æ¯å¦å¯ç¨ä¿è´¨æ DataGridViewCheckBoxCell oCell2 = new DataGridViewCheckBoxCell(); oCell2.ThreeState = false; oCell2.Value = 0; oCell2.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grdSub.Rows[i].Cells[HISKFPERIOD2Col] = oCell2; } DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); @@ -2177,6 +2304,24 @@ FillSelectData(oIF_PackageDismantleBillList.oBillSelectColl); } } else if (cmbSourceBillType.Text.Trim() == "å·¥åºæµè½¬å¡") { string sWhere = " and HOrgID =" + HOrgID.ToString(); DAL.Cls_S_IF_ProcessExchangeBillList oIF_ProcessExchangeBillList = new DAL.Cls_S_IF_ProcessExchangeBillList(); if (oIF_ProcessExchangeBillList.Refresh(sWhere)) //éæ©åå { FillSelectData(oIF_ProcessExchangeBillList.oBillSelectColl); } } else if (cmbSourceBillType.Text.Trim() == "å·¥åºæ±æ¥å") { string sWhere = " and HOrgID =" + HOrgID.ToString(); DAL.Cls_S_IF_ProcessReportBillList oIF_ProcessReportBillList = new DAL.Cls_S_IF_ProcessReportBillList(); if (oIF_ProcessReportBillList.Refresh(sWhere)) //éæ©åå { FillSelectData(oIF_ProcessReportBillList.oBillSelectColl); } } else { @@ -2319,6 +2464,26 @@ grdMain.Rows[i].Cells[HTagCol].Value = "*"; //å¾å°ä¿¡æ¯ Ds = oCn.RunProcReturn("select * from h_v_IF_PackageDismantleList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_PackageDismantleList"); //åå ¥ä¿¡æ¯ Sub_WriteInForm1(Ds.Tables[0], i); } //å·¥åºæµè½¬å¡ if (oSelectRow.BillType == "3772") { grdMain.Rows.Add(); grdMain.Rows[i].Cells[HTagCol].Value = "*"; //å¾å°ä¿¡æ¯ Ds = oCn.RunProcReturn("select * from h_v_IF_ProcessExchangeList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_ProcessExchangeList"); //åå ¥ä¿¡æ¯ Sub_WriteInForm1(Ds.Tables[0], i); } //ç产æ±æ¥å if (oSelectRow.BillType == "3714") { grdMain.Rows.Add(); grdMain.Rows[i].Cells[HTagCol].Value = "*"; //å¾å°ä¿¡æ¯ Ds = oCn.RunProcReturn("select * from h_v_IF_ProcessReportList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_ProcessReportList"); //åå ¥ä¿¡æ¯ Sub_WriteInForm1(Ds.Tables[0], i); } @@ -3432,5 +3597,23 @@ MessageBox.Show("çæç®±ç 失败ï¼" + e1.Message ); } } private void cmbSourceBillType_TextChanged(object sender, EventArgs e) { if (cmbSourceBillType.Text == "å·¥åºæµè½¬å¡") { cmbHBarCodeType.Items.Clear(); cmbHBarCodeType.Items.Add("åºåç "); this.cmbHBarCodeType.SelectedIndex = 0; } else { cmbHBarCodeType.Items.Clear(); cmbHBarCodeType.Items.Add("å¯ä¸æ¡ç "); cmbHBarCodeType.Items.Add("åç§æ¡ç "); cmbHBarCodeType.Items.Add("æ¹æ¬¡æ¡ç "); this.cmbHBarCodeType.SelectedIndex = 0; } } } }
