From 8e82aa3bf721908fdb44d9fb06eb4772e4f126d7 Mon Sep 17 00:00:00 2001
From: jhz <jinghz@oceic.com>
Date: 星期二, 26 七月 2022 09:59:30 +0800
Subject: [PATCH] 1
---
WarM/条码打印/Sc_ICMOToBarCode.cs | 252 +++++++++++++++----------------------------------
1 files changed, 79 insertions(+), 173 deletions(-)
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
index 07f7c53..225d43b 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
@@ -807,7 +807,9 @@
//00 鍏堢敓鎴� 鍞竴鐨� 鎵樻潯鐮�
//鐢熸垚涓�涓绠辩爜
- string sPackStr = "ZXM" + HYear + HPeriod + HDay; //澶栫鐮� 鍓嶇紑
+ long HTMaterID = 0;
+ HTMaterID = ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HMaterID")].Value);
+ string sPackStr = "ZXM" + HYear + HPeriod + HDay + HTMaterID; //澶栫鐮� 鍓嶇紑
DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //鑾峰彇鏈�澶ф祦姘村彿 //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1;
string sPackBarCode = sPackStr + TTM_LSH.ToString();
@@ -995,191 +997,95 @@
private void button4_Click(object sender, EventArgs e)
{
-
- //鏍规嵁鏈鏁伴噺 鏉� 鍒嗛厤鍒� 姣忎釜鐢熶骇璁㈠崟涓婏紙鍒嗛厤鏃� 瑕佽�冭檻 璁㈠崟鍓╀綑鏁伴噺宸茬粡鏄� 璐熸暟鐨勬儏鍐碉級
- //濡傛灉鏈夋爣鍑嗚绠辨暟閲� 鍏堥粯璁ゅ彇鏍囧噯瑁呯鏁伴噺 娌℃湁鍐嶅彇鎵嬭緭鐨勬湰绠辨暟閲�
- //1.鍒ゆ柇鏈鏁伴噺 蹇呴』澶т簬0
- double HZXQty = 0;//鏁寸鏁伴噺
- if (txtHZXQty.Text.Trim() != "")
- {
- HZXQty = ClsPub.isDoule(txtHZXQty.Text);
- }
- else
- {
- HZXQty = ClsPub.isDoule(txtHMiniQty.Text);
- }
- if (HZXQty <= 0)
- {
- MessageBox.Show("璇疯緭鍏ユ暣绠辨暟閲忥紒");
- return;
- }
- //2.鍒锋柊缃戞牸
- //Display();
- //3.鎶婃暣绠辨暟閲� 鍒嗛厤鍒� 缃戞牸涓嬮潰鐨勬瘡涓�涓� 鐢熶骇璁㈠崟涓婂幓銆� 寰幆缃戞牸
- for(int i =0;i<grdMain.Rows.Count;i++)
- {
- if (HZXQty > 0)
- {
- if (HZXQty > DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value))
- {
- HZXQty = HZXQty - DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
- grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
- //MessageBox.Show("璇风偣鍑昏秴棰濈敓浜ф寜閽敓鎴愭潯鐮侊紒");
- //return;
- }
- else
- {
- grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = HZXQty;
- //
-
- //HZXQty = HZXQty - DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
- //grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
- }
- }
- else
- {
- break;
- }
- }
- Sub_SaveBarCode();
- //
-
-
-
-
-
- ////1.鑾峰彇鐣岄潰涓婇潰鏁寸鏁伴噺妗嗚緭鍏ョ殑鏁伴噺 璧嬪�肩粰鍙橀噺 骞跺埛鏂扮綉鏍�
- //double HBarCodeQty = 0;
- //double HZXQty = 0;
- //HZXQty = ClsPub.isDoule(txtHZXQty.Text);
- //if (HZXQty ==0)
+ ////鏍规嵁鏈鏁伴噺 鏉� 鍒嗛厤鍒� 姣忎釜鐢熶骇璁㈠崟涓婏紙鍒嗛厤鏃� 瑕佽�冭檻 璁㈠崟鍓╀綑鏁伴噺宸茬粡鏄� 璐熸暟鐨勬儏鍐碉級
+ ////濡傛灉鏈夋爣鍑嗚绠辨暟閲� 鍏堥粯璁ゅ彇鏍囧噯瑁呯鏁伴噺 娌℃湁鍐嶅彇鎵嬭緭鐨勬湰绠辨暟閲�
+ ////1.鍒ゆ柇鏈鏁伴噺 蹇呴』澶т簬0
+ //double HZXQty = 0;//鏁寸鏁伴噺
+ //if (txtHZXQty.Text.Trim() != "")
+ //{
+ // HZXQty = ClsPub.isDoule(txtHZXQty.Text);
+ //}
+ //else
+ //{
+ // HZXQty = ClsPub.isDoule(txtHMiniQty.Text);
+ //}
+ //if (HZXQty <= 0)
//{
// MessageBox.Show("璇疯緭鍏ユ暣绠辨暟閲忥紒");
// return;
//}
- //Display();
- ////2.鑾峰彇缃戞牸閫変腑琛岀墿鏂橧D
- ////int a = grdMain.CurrentRow.Index;
- ////long HMaterID = 0;
- //////HMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[a].Cells[Fun_GetCol("HMaterID")].Value);
- //// if (HMaterID == 0)
- //// {
- //// MessageBox.Show("娌℃湁閫変腑浠讳綍璁板綍锛�");
- //// return;
- //// }
- ////3.瀹氫箟鏄惁缁勬墭鐨勫彉閲�
- //int Mul = 0;
- ////4.鏍规嵁鍗曟嵁绫诲瀷鑾峰彇鏈鏉＄爜涓诲唴鐮丠InterID
- //HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
-
-
- //for (int i = 0; i < grdMain.Rows.Count; i++)
+ ////2.鍒锋柊缃戞牸
+ ////Display();
+ ////3.鎶婃暣绠辨暟閲� 鍒嗛厤鍒� 缃戞牸涓嬮潰鐨勬瘡涓�涓� 鐢熶骇璁㈠崟涓婂幓銆� 寰幆缃戞牸
+ //for(int i =0;i<grdMain.Rows.Count;i++)
//{
-
- // //鑾峰彇缃戞牸閲岄潰姣忎竴琛岃鍗曞搴旂殑璁㈠崟鏁伴噺
- // double HDDQty = 0;
- // HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
-
-
- // //鑾峰彇褰撳墠绯荤粺鐧婚檰缁勭粐浠ｇ爜
- // HOrgNumber = ClsPub.HOrgNumber;
-
-
-
-
- // //鑷姩鍖归厤閫昏緫 鍒ゆ柇璁㈠崟鏁伴噺鏄惁澶т簬鏁寸鏁伴噺 濡傛灉璁㈠崟鏁伴噺澶т簬鏁寸鏁伴噺 鐩存帴鐢熸垚鍞竴鐮�
- // //濡傛灉璁㈠崟鏁伴噺灏忎簬鏁寸鏁伴噺 鍒欏惊鐜敓鎴愬敮涓�鐮� 鐢熸垚瀵瑰簲鐨勬墭鏉＄爜
- // if (HDDQty >= HZXQty)
+ // if (HZXQty > 0)
+ // {
+ // if (HZXQty > DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value))
// {
- // HBarCodeQty = HZXQty;
- // this.Sub_SaveBill_TTM();
- // Display();
- // Mul = Mul + 1;
- // break;
+ // HZXQty = HZXQty - DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ // grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+
+ // //MessageBox.Show("璇风偣鍑昏秴棰濈敓浜ф寜閽敓鎴愭潯鐮侊紒");
+ // //return;
// }
- // else if(HDDQty < HZXQty)
+ // else if (HZXQty == 0)
// {
- // HBarCodeQty = HDDQty;
- // HZXQty = HZXQty - HDDQty;
- // this.Sub_SaveBill_TTM();
- // Mul = Mul + 1;
- // continue;
+ // return;
// }
+ // else
+ // {
+ // grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = HZXQty;
+ // //
- // //濡傛灉Mul>1 鏂板缁勬墭鍗曚富琛�
-
+ // //HZXQty = HZXQty - DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ // //grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ // }
+ // }
+ // else
+ // {
+ // break;
+ // }
//}
+ //Sub_SaveBarCode();
+ ////
- //if (Mul > 1)
- //{
- // //HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("鐢熶骇璁㈠崟鍙�")].Value);
- // DataSet DS1;
- // HTTMNumber = HOrgNumber + HICMOBillNo;
- // DS1 = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTTMNumber + "'", "h_p_WMS_GetMaxNo"); //鑾峰彇鏈�澶ф祦姘村彿
- // TLSH = ClsPub.isInt(DS1.Tables[0].Rows[0][0]);
- // TLSH2 = TLSH.ToString();
- // TTM = HTTMNumber + TLSH2;
- // HInterID_TTM = DBUtility.ClsPub.CreateBillID_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo);
- // HBillNo_TTM = DBUtility.ClsPub.CreateBillCode_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo, true);//寰楀埌鏂板崟鍙�
-
- // string HDate = "";
- // string HYear = "";
- // string HPeriod = "";
- // string HDay = "";
- // HDate = DateTime.Now.ToShortDateString();
- // HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2);
- // HPeriod = "0" + ClsPub.isDate(HDate).Month.ToString();
- // HPeriod = HPeriod.Substring(HPeriod.Length - 2, 2);
- // HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
- // HDay = HDay.Substring(HDay.Length - 2, 2);
-
- // oCn.RunProc("insert into Sc_PackUnionBillMain (HYear,HPeriod,HBillType,HInterID,HDate" +
- // ",HBillNo,HBillStatus,HICMOBillNo,HBarCode_Pack,HMaterID,HUnitID,HWeight" +
- // ",HPWeight,HProdOrgID,HDeptID,HEmpID,HSNum,HPackNum,HBarCode_Cus,HBatchNo " +
- // ") values ("
- // + HYear + "," + HPeriod + ",'3783'," + HInterID_TTM + ",'" + HDate + "'"
- // + ", " + HBillNo_TTM.ToString() + ",1,''," + TTM.ToString() + ",0,0,0"
- // + ",0,1,0,0,0,0,'','')");
- //}
-
-
- ////3.鍏堝垽鏂墿鏂欐槸鍚︿竴鑷� 濡傛灉涓�鑷村紑濮嬪惊鐜綉鏍�
- //for (int i = 0; i < grdMain.Rows.Count; i++)
- //{
- // //long HGrdMaterID = 0;
- // //HGrdMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("HMaterID")].Value);
- // //if (HGrdMaterID == HMaterID)
- // //{
- // // double HDDQty = 0;
- // // HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
- // // //濡傛灉寰幆鐨勮琛岃褰曠殑璁㈠崟鏁伴噺宸茬粡澶т簬绛変簬鏈瑁呯鏁伴噺 鍒欑洿鎺ョ敓鎴愬敮涓�鐮� 骞朵笖鍒锋柊缃戞牸 鍒锋柊鏉＄爜淇℃伅椤�
- // // if (HDDQty >= HZXQty)
- // // {
- // // double HBarCodeQty = 0;
- // // HBarCodeQty = HZXQty;
- // // this.Sub_SaveBill();
- // // Display();
- // // }
- // // //濡傛灉鏀硅璁板綍璁㈠崟鏁伴噺灏忎簬鏈瑁呯鏁伴噺 鍒欑户缁惊鐜� 璧扮敓鎴愭墭鏉＄爜鏂规硶
- // // else
- // // {
- // // //鏌ュ嚭绗﹀悎鏉′欢鐨勯�変腑杩欐潯鏁伴噺璺熻绠辨暟閲忕殑宸紓鍊�
- // // double HCYQty = 0;
- // // HCYQty = HZXQty - DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
-
- // // }
-
- // //}
- // //else
- // //{
-
- // //}
- //}
-
-
-
-
+ bool flag = this.txtHZXQty.Text.Trim() != "";
+ double num;
+ if (flag)
+ {
+ num = Pub_Class.ClsPub.isDoule(this.txtHZXQty.Text);
+ }
+ else
+ {
+ num = Pub_Class.ClsPub.isDoule(this.txtHMiniQty.Text);
+ }
+ bool flag2 = num <= 0.0;
+ if (flag2)
+ {
+ MessageBox.Show("璇疯緭鍏ユ暣绠辨暟閲忥紒");
+ }
+ else
+ {
+ for (int i = 0; i < this.grdMain.Rows.Count; i++)
+ {
+ bool flag3 = num > 0.0;
+ if (!flag3)
+ {
+ break;
+ }
+ bool flag4 = num > Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ if (!flag4)
+ {
+ this.grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = num;
+ break;
+ }
+ num -= Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ this.grdMain.Rows[i].Cells["鏈鏁伴噺"].Value = Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["鐢熶骇璁㈠崟鏁伴噺"].Value);
+ }
+ this.Sub_SaveBarCode();
+ }
}
private void Sub_SaveBill()
--
Gitblit v1.9.1