From e25efe9c507544cd3984f48634e38f7e61350107 Mon Sep 17 00:00:00 2001
From: 仲国强 <519541279@qq.com>
Date: 星期三, 20 十月 2021 15:54:21 +0800
Subject: [PATCH] 列表自动渲染字段示例

---
 WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs |   16 ++++++++--------
 1 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
index d70d501..b833c56 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
@@ -83,12 +83,12 @@
 
         [Route("Sc_MouldOtherOutBill/GetMouldOtherOutBill")]
         [HttpGet]
-        public object GetMouldOtherOutBill(string sWhere,string user)
+        public object GetMouldOtherOutBill(string sWhere,string user, string Organization)
         {
             try
             {
                 //缂栬緫鏉冮檺
-                if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherOutBillList", 1, true, user))
+                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldOtherOutBillList", 1, true, user))
                 {
                     objJsonResult.code = "0";
                     objJsonResult.count = 0;
@@ -97,7 +97,7 @@
                     return objJsonResult;
                 }
 
-                ds = Sc_MouldOtherOutBill(sWhere);
+                ds = Sc_MouldOtherOutBill(sWhere,Organization);
                 objJsonResult.code = "1";
                 objJsonResult.count = 1;
                 objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
@@ -114,15 +114,15 @@
             }
         }
 
-        public static DataSet Sc_MouldOtherOutBill(string sWhere)
+        public static DataSet Sc_MouldOtherOutBill(string sWhere, string Organization)
         {
+            string sql1 = string.Format(@"select * from h_v_Sc_MouldOtherOutBillList where 搴撳瓨缁勭粐='" + Organization + "'");
             if (sWhere == null || sWhere.Equals(""))
             {
-                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList order by 鏃ユ湡 desc", "h_v_Sc_MouldOtherOutBillList");
+                return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by 鏃ユ湡 desc", "h_v_Sc_MouldOtherOutBillList");
             }
             else
             {
-                string sql1 = "select * from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
                 string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc";
                 return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
             }
@@ -218,7 +218,7 @@
             try
             {
                 //缂栬緫鏉冮檺
-                if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherOutBill_Edit", 1, true, msg4))
+                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldOtherOutBill_Edit", 1, true, msg4))
                 {
                     objJsonResult.code = "0";
                     objJsonResult.count = 0;
@@ -351,7 +351,7 @@
         public object DeltetMouldOtherOutBill(string HInterID,string user)
         {
             //缂栬緫鏉冮檺
-            if (!DBUtility.ClsPub.Security_Log("Sc_MouldOtherInBill_Delete", 1, true,user))
+            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldOtherInBill_Delete", 1, true,user))
             {
                 objJsonResult.code = "0";
                 objJsonResult.count = 0;

--
Gitblit v1.9.1