From 9ae6aa786445d49dc3e93ead5a8ee4b92006304e Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 07 八月 2023 08:08:15 +0800
Subject: [PATCH] 1
---
DAL/车间管理/ClsWW_EntrustWorkOrderBill.cs | 114 ++++++++++++++++++++++++++++----------------------------
1 files changed, 57 insertions(+), 57 deletions(-)
diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsWW_EntrustWorkOrderBill.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsWW_EntrustWorkOrderBill.cs"
index 06c1015..041ee53 100644
--- "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsWW_EntrustWorkOrderBill.cs"
+++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsWW_EntrustWorkOrderBill.cs"
@@ -18,8 +18,8 @@
base.MvarItemKeySub4 = "";
base.MvarItemKey = "WW_EntrustWorkOrderBillMain";
base.MvarReportTitle = "濮斿鍔犲伐鍗�";
- base.BillType = "1602";
- base.HBillSubType = "1602";
+ base.BillType = "3740";
+ base.HBillSubType = "3740";
}
@@ -41,7 +41,7 @@
oCn.BeginTran();
//鍒犻櫎鍏宠仈
DeleteRelation(ref sReturn, lngBillKey);
- oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch_Del " + lngBillKey.ToString());
+ //oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch_Del " + lngBillKey.ToString());
//鍒犻櫎鏄庣粏琛�
DeleteBillSub(lngBillKey);
DeleteBillSub2(lngBillKey);
@@ -82,9 +82,9 @@
",HSupID=" + omodel.HSupID.ToString() +
",HOrderProcNO='" + omodel.HOrderProcNO + "'" +
" where HInterID=" + lngBillKey.ToString());
- //鍒犻櫎鍏宠仈
- DeleteRelation(ref sReturn, lngBillKey);
- oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch_Del " + lngBillKey.ToString());
+ ////鍒犻櫎鍏宠仈
+ //DeleteRelation(ref sReturn, lngBillKey);
+ //oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch_Del " + lngBillKey.ToString());
//鍒犻櫎瀛愯〃
DeleteBillSub(lngBillKey);
@@ -97,39 +97,39 @@
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HOrderBillNo,HMaterLenModel,HMaterQty,HMaterID,HQty" +
",HEntrustType,HNextProcName,HPrice,HOutQty,HInQty" +
- ",HBackSupDate,HInDate,HWorkProcFlow,HProcID,HLeftMater" +
+ ",HInDate,HWorkProcFlow,HProcID,HLeftMater" +
") values("
+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
",'" + oSub.HOrderBillNo + "','" + oSub.HMaterLenModel + "'," + oSub.HMaterQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HQty.ToString() +
",'" + oSub.HEntrustType + "','" + oSub.HNextProcName + "'," + oSub.HPrice.ToString() + "," + oSub.HOutQty.ToString() + "," + oSub.HInQty.ToString() +
- ",'" + oSub.HBackSupDate.ToShortDateString() + "','" + oSub.HInDate.ToShortDateString() + "','" + oSub.HWorkProcFlow + "'," + oSub.HProcID.ToString() +",'" + oSub.HLeftMater + "'" +
+ ",'" + oSub.HInDate.ToShortDateString() + "','" + oSub.HWorkProcFlow + "'," + oSub.HProcID.ToString() +",'" + oSub.HLeftMater + "'" +
") ");
}
- //鏍规嵁鍐呯爜 濮斿宸ュ崟琛ㄥご渚涘簲鍟� 鍥炲～瀵瑰簲娴佽浆鍗� 渚涘簲鍟嗭紝鏈夊澶栨爣璁版墠鍥炲～
- oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch " + omodel.HInterID.ToString());
- //
- //
- DataSet Ds;
- Ds = oCn.RunProcReturn("exec h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl " + omodel.HInterID.ToString() + "", "h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl");
- if (Ds == null)
- {
- sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
- oCn.RollBack();
- return false;
- }
- if (Ds.Tables[0].Rows.Count == 0)
- {
- sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
- oCn.RollBack();
- return false;
- }
- if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2")
- {
- sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]);
- oCn.RollBack();
- return false;
- }
+ ////鏍规嵁鍐呯爜 濮斿宸ュ崟琛ㄥご渚涘簲鍟� 鍥炲～瀵瑰簲娴佽浆鍗� 渚涘簲鍟嗭紝鏈夊澶栨爣璁版墠鍥炲～
+ //oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch " + omodel.HInterID.ToString());
+ ////
+ ////
+ //DataSet Ds;
+ //Ds = oCn.RunProcReturn("exec h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl " + omodel.HInterID.ToString() + "", "h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl");
+ //if (Ds == null)
+ //{
+ // sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
+ // oCn.RollBack();
+ // return false;
+ //}
+ //if (Ds.Tables[0].Rows.Count == 0)
+ //{
+ // sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
+ // oCn.RollBack();
+ // return false;
+ //}
+ //if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2")
+ //{
+ // sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]);
+ // oCn.RollBack();
+ // return false;
+ //}
//
sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
@@ -169,8 +169,8 @@
",HDeptID,HSupID,HOrderProcNO" +
") " +
" values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
- ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
- ", " + omodel.HDeptID.ToString() + "," + omodel.HSupID.ToString() + ",'" + omodel.HOrderProcNO + "'" +
+ ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "','" + omodel.HDate+
+ "', " + omodel.HDeptID.ToString() + "," + omodel.HSupID.ToString() + ",'" + omodel.HOrderProcNO + "'" +
") ");
//鎻掑叆瀛愯〃
foreach (Model.ClsWW_EntrustWorkOrderBillSub oSub in DetailColl)
@@ -180,39 +180,39 @@
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HOrderBillNo,HMaterLenModel,HMaterQty,HMaterID,HQty" +
",HEntrustType,HNextProcName,HPrice,HOutQty,HInQty" +
- ",HBackSupDate,HInDate,HWorkProcFlow,HProcID,HLeftMater" +
+ ",HInDate,HWorkProcFlow,HProcID,HLeftMater" +
") values("
+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
",'" + oSub.HOrderBillNo + "','" + oSub.HMaterLenModel + "'," + oSub.HMaterQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HQty.ToString() +
",'" + oSub.HEntrustType + "','" + oSub.HNextProcName + "'," + oSub.HPrice.ToString() + "," + oSub.HOutQty.ToString() + "," + oSub.HInQty.ToString() +
- ",'" + oSub.HBackSupDate.ToShortDateString() + "','" + oSub.HInDate.ToShortDateString() + "','" + oSub.HWorkProcFlow + "'," + oSub.HProcID.ToString() + ",'" + oSub.HLeftMater + "'" +
+ ",'" + oSub.HInDate.ToShortDateString() + "','" + oSub.HWorkProcFlow + "'," + oSub.HProcID.ToString() + ",'" + oSub.HLeftMater + "'" +
") ");
}
//鏍规嵁鍐呯爜 濮斿宸ュ崟琛ㄥご渚涘簲鍟� 鍥炲～瀵瑰簲娴佽浆鍗� 渚涘簲鍟嗭紝鏈夊澶栨爣璁版墠鍥炲～..骞朵笖鍥炲～ 鍏宠仈鏁伴噺
- oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch " + omodel.HInterID.ToString());
+ //oCn.RunProc("exec h_p_WW_EntrustWorkOrderToProcExch " + omodel.HInterID.ToString());
//
- DataSet Ds;
- Ds = oCn.RunProcReturn("exec h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl " + omodel.HInterID.ToString() + "", "h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl");
- if (Ds == null)
- {
- sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
- oCn.RollBack();
- return false;
- }
- if (Ds.Tables[0].Rows.Count == 0)
- {
- sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
- oCn.RollBack();
- return false;
- }
- if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2")
- {
- sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]);
- oCn.RollBack();
- return false;
- }
+ //DataSet Ds;
+ //Ds = oCn.RunProcReturn("exec h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl " + omodel.HInterID.ToString() + "", "h_p_WW_EntrustWorkOrderToProcExch_QtyCtrl");
+ //if (Ds == null)
+ //{
+ // sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
+ // oCn.RollBack();
+ // return false;
+ //}
+ //if (Ds.Tables[0].Rows.Count == 0)
+ //{
+ // sReturn = "鍒ゆ柇鏁伴噺澶辫触锛�";
+ // oCn.RollBack();
+ // return false;
+ //}
+ //if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBack"]) == "2")
+ //{
+ // sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackRemark"]);
+ // oCn.RollBack();
+ // return false;
+ //}
//
sReturn = "鏂板鍗曟嵁鎴愬姛锛�";
oCn.Commit();
--
Gitblit v1.9.1