From 7f8ed8cdc49b33178f34c91edf862f831cd30c9c Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 08 二月 2023 09:18:04 +0800 Subject: [PATCH] 供应商物料;根据登录用户获取默认值 --- WarM/条码打印/Gy_BarCodeBill.cs | 90 +++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 83 insertions(+), 7 deletions(-) diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" index b70b19d..92c9009 100644 --- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" +++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill.cs" @@ -211,6 +211,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("鐩存帴璋冩嫧鍗�"); @@ -789,6 +791,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 == "浠櫒澶栬喘浠舵潯鐮佸鍣ㄨ鍒�") { //鐗╂枡缂栫爜+鍗曟嵁鏃ユ湡锛圷YMMDD锛�+娴佹按4浣� @@ -823,10 +834,10 @@ Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //鑾峰彇鏈�澶ф祦姘村彿 //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); - LSHlen = 5; - if (sTMNumber.Length != 16) + LSHlen = 4; + if (sTMNumber.Length != 16 && sTMNumber.Length != 15) { - MessageBox.Show("鏉$爜闀垮害涓嶅16浣嶏紝鏄惁鏁版嵁涓嶅叏锛佸埗閫犳湰閮�1浣�:[0] + 鏈哄瀷浠g爜5浣�:[" + HModelName + "] + 骞存湀鏃�5浣�:["+ HBarCodeDate + "] + 鎵规鍙�2浣�:[" + HBarCodeBatchNo + "]+ 鍘嬬缉鏈�1浣�:["+ HYasuoji + "]+00 ; "); + MessageBox.Show("鏉$爜闀垮害涓嶅15鎴�16浣嶏紝鏄惁鏁版嵁涓嶅叏锛佸埗閫犳湰閮�1浣�:[0] + 鏈哄瀷浠g爜5浣�:[" + HModelName + "] + 骞存湀鏃�4鎴�5浣�:["+ HBarCodeDate + "] + 鎵规鍙�2浣�:[" + HBarCodeBatchNo + "]+ 鍘嬬缉鏈�1浣�:["+ HYasuoji + "]+00 ; "); return; } } @@ -838,10 +849,10 @@ Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //鑾峰彇鏈�澶ф祦姘村彿 //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); - LSHlen = 5; - if (sTMNumber.Length != 18) + LSHlen = 4; + 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; } } @@ -868,6 +879,7 @@ HMinQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); HSumQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HQtyCol].Value); n = 0; + int nn = 0; for (int i = k; i < HBQty; i++) { if (HSumQty - HMinQty > 0) @@ -895,6 +907,11 @@ LSH2 = "0" + LSH2; } if (cmbHBarCodeType.Text == "鍞竴鏉$爜") + { + //鏉$爜缂栧彿 = 鏉$爜鍓嶇紑 + 娴佹按鍙� + TM = sTMNumber + LSH2; + } + else if (cmbHBarCodeType.Text == "搴忓垪鐮�") { //鏉$爜缂栧彿 = 鏉$爜鍓嶇紑 + 娴佹按鍙� TM = sTMNumber + LSH2; @@ -984,8 +1001,11 @@ 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 + "'"); + nn = nn + 1; } + //鍚庡彴鎵归噺鎵ц璇彞 + oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + nn.ToString() + " "); } } string HWei = ""; //灏炬暟 @@ -2173,6 +2193,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 { @@ -2315,6 +2353,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); } @@ -3428,5 +3486,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; + } + } } } \ No newline at end of file -- Gitblit v1.9.1