From 45c1541ca7d2ac7cdfebae0d08fdbc771ca37a41 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期一, 05 八月 2024 17:14:26 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
DAL/采购管理/ClsCg_POOrderBill.cs | 88 --------------------------------------------
1 files changed, 0 insertions(+), 88 deletions(-)
diff --git "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POOrderBill.cs" "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POOrderBill.cs"
index d361402..98631ae 100644
--- "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POOrderBill.cs"
+++ "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POOrderBill.cs"
@@ -310,94 +310,6 @@
}
}
- //鍙戣捣瀹℃壒
- public bool startCheckFlow(Int64 lngBillKey, Int64 HCheckFlowID_select, ref string sReturn)
- {
- try
- {
- string HBillNo = ""; //鍗曟嵁鍙�
- string HCheckFlowID = ""; //瀹℃壒娴両D
- string HCheckItemNowID = ""; //褰撳墠瀹℃牳椤圭洰ID
- string HCheckItemNextID = ""; //寰呭鏍搁」鐩甀D
-
- //鍒ゆ柇鏄惁宸茬粡鍙戣捣瀹℃壒
- string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "'";
- DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus");
- if (ds0 != null && ds0.Tables[0].Rows.Count > 0)
- {
- sReturn = "鍗曟嵁宸插彂璧峰鎵癸紝涓嶅彲閲嶅瀹℃壒锛�";
- return false;
- }
-
- //鑾峰彇鍗曟嵁鏁版嵁
- string sql = "select * from " + this.MvarItemKey + " where HInterID = " + lngBillKey;
- DataSet ds = oCn.RunProcReturn(sql, this.MvarItemKey);
- if (ds == null || ds.Tables[0].Rows.Count == 0)
- {
- sReturn = "鍗曟嵁涓嶅瓨鍦紒";
- return false;
- }
- HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();
-
- //鑾峰彇鍗曟嵁绫诲瀷瀵瑰簲鐨勯粯璁ゅ鎵规祦
- string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " +
- "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " +
- "where a.HBillTypeID = '" + this.BillType + "' " +
- "and a.HInterID = " + HCheckFlowID_select + " " +
- "order by b.HFlowNo asc";
- DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain");
- if (ds1 == null || ds1.Tables[0].Rows.Count == 0)
- {
- sReturn = "榛樿瀹℃壒娴佷笉瀛樺湪锛�";
- return false;
- }
-
- HCheckFlowID = ds1.Tables[0].Rows[0]["HInterID"].ToString();
- HCheckItemNowID = ds1.Tables[0].Rows[0]["HCheckItemID"].ToString();
- if (ds1.Tables[0].Rows.Count >= 2)
- {
- HCheckItemNextID = ds1.Tables[0].Rows[1]["HCheckItemID"].ToString();
- }
- else
- {
- HCheckItemNextID = "0";
- }
-
- oCn.BeginTran();
- //澧炲姞 鍗曟嵁瀹℃壒鐘舵�佽〃 鏁版嵁
- for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
- {
- string sql2 = "insert into Xt_BillCheckFlowStatus" +
- "(HBillTypeID,HBillInterID,HBillNo,HCheckFlowID,HCheckItemID,HChecker,HCheckDate,HCheckNote) " +
- "values(" +
- "'" + this.BillType + "'," +
- "" + lngBillKey + "," +
- "'" + HBillNo + "'," +
- "" + ds1.Tables[0].Rows[i]["HInterID"].ToString() + "," +
- "" + ds1.Tables[0].Rows[i]["HCheckItemID"].ToString() + "," +
- "" + "''" + "," +
- "" + "''" + "," +
- "" + "''" + "" +
- ")";
-
- oCn.RunProc(sql2);
- }
-
- //鏇存柊涓昏〃 瀹℃壒娴� 鏁版嵁
- string sql3 = "update " + this.MvarItemKey + " set HCheckFlowID = " + HCheckFlowID + ",HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey;
- oCn.RunProc(sql3);
-
-
- oCn.Commit();
-
- return true;
- }
- catch (Exception e)
- {
- sReturn += e.Message;
- return false;
- }
- }
}
}
--
Gitblit v1.9.1