From 5402ccf6d9f8bb3d75e837d457d74cbfc2243c3a Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 25 三月 2025 08:44:35 +0800
Subject: [PATCH] 注释一个工序负荷分析汇总报表 没有权限的查询
---
DAL/车间管理/ClsSc_StationEntrustInBill.cs | 22 +++++++++++++++++++++-
1 files changed, 21 insertions(+), 1 deletions(-)
diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_StationEntrustInBill.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_StationEntrustInBill.cs"
index 1ebff10..c6e696c 100644
--- "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_StationEntrustInBill.cs"
+++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_StationEntrustInBill.cs"
@@ -812,11 +812,13 @@
return true;
}
- public bool DeleteBill(long HInterID, long HProcExchInterID, long HProcExchEntryID, ref string sReturn)
+ public bool DeleteBill(long HInterID, long HProcExchInterID, long HProcExchEntryID, string HBillNo, string procName, string user, ref string sReturn)
{
try
{
oCn.BeginTran();
+
+
//鍐欏叆鍒犻櫎鏃ュ織
//oCn.RunProc("exec h_p_Sc_StationInBillMain_DropLog " + HInterID+",'"+DBUtility.ClsPub.CurUserName+"'");
@@ -836,6 +838,24 @@
//鍥炲～娴佽浆鍗¤繘绔欐椂闂�
//oCn.RunProc("update Sc_ProcessExchangeBillsub set HRelBeginDate=null where HInterID=" + HProcExchInterID + " and HEntryID=" + HProcExchEntryID);
+ //鍒犻櫎鍚庢帶鍒�==================================================================================
+ string sql2 = "exec " + procName + " " + HInterID + ",'" + HBillNo + "','" + user + "'";
+ DataSet ds = oCn.RunProcReturn(sql2, procName);
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+
+ sReturn = "鍒犻櫎澶辫触!鍘熷洜:鍒犻櫎鍚庡垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ oCn.RollBack();
+ return false;
+ }
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ sReturn = "鍒犻櫎澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
+ oCn.RollBack();
+ return false;
+ }
+ //==============================================================================================
+
oCn.Commit();
return true;
}
--
Gitblit v1.9.1