From 091468bc308c7eb8141b47d02b704f7c53782a76 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 02 十二月 2021 17:38:50 +0800 Subject: [PATCH] 器具领用退库单 增加 存储过程 更新 器具档案的 使用寿命、剩余寿命; --- WorkM/流转卡管理/Sc_ProcessExchangeBillList.cs | 11 +++++++++-- 1 files changed, 9 insertions(+), 2 deletions(-) diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs" index efbd15e..f57b907 100644 --- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs" +++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/Sc_ProcessExchangeBillList.cs" @@ -27,6 +27,7 @@ public const string ModRightNameDelete = ModRightName + "_Delete"; public const string ModRightNameMoney = ModRightName + "_Money"; public const string ModRightNameQty = ModRightName + "_Qty"; + public const string ModRightNameCF = ModRightName + "_CF"; DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); public Sc_ProcessExchangeBill oFrm; public string sDlgWhere = ""; //澶栫獥浣撻�掑叆 @@ -53,11 +54,11 @@ //杩囨护鏉′欢 if (frmCondition.SqlStr.Trim().Length == 0) { - sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by 鍗曟嵁鍙� desc,hsubid "; + sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by 鍗曟嵁鍙� desc,hsubid "; } else { - sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " order by 鍗曟嵁鍙� desc,hsubid "; + sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by 鍗曟嵁鍙� desc,hsubid "; } // @@ -866,6 +867,12 @@ private void cf_Click(object sender, EventArgs e) { + //鍒ゆ柇鏉冮檺 + if (!DBUtility.ClsPub.Security_Log(ModRightNameCF, 1, true, DBUtility.ClsPub.CurUserName)) + { + return; + } + Int64 lngBillKey = 0; if (grdMain.CurrentRow == null) return; -- Gitblit v1.9.1