From b0c29a051b101921da5e757cae7250f92e878d41 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 06 四月 2022 16:58:58 +0800
Subject: [PATCH] 采购订单委外订单 安瑞采购经理职位查看权限

---
 WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs |   67 +++++++++++++++++++++++----------
 1 files changed, 47 insertions(+), 20 deletions(-)

diff --git a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs
index 104769c..230388f 100644
--- a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs
+++ b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs
@@ -28,36 +28,45 @@
         /// </summary>
         [Route("Gy_WorkPayTypeBill/GetWorkPayTypelist")]
         [HttpGet]
-        public object GetWorkPayTypelist(string sWhere)
+        public object GetWorkPayTypelist(string sWhere,string user)
         {
             try
             {
+                if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType", 1, false, user))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn("select * from h_v_Gy_WorkPayTypeList " + sWhere, "h_v_Gy_WorkPayTypeList");
+                    ds = oCN.RunProcReturn("select * from h_v_Gy_WorkPayTypeList order by 宸ヨ祫绫诲瀷浠g爜 ", "h_v_Gy_WorkPayTypeList");
                 }
                 else
                 {
                     string sql1 = "select * from h_v_Gy_WorkPayTypeList where 1 = 1 ";
-                    string sql = sql1 + sWhere;
+                    string sql = sql1 + sWhere+ " order by 宸ヨ祫绫诲瀷浠g爜 ";
                     ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkPayTypeList");
                 }
-                if (ds == null || ds.Tables[0].Rows.Count == 0)
-                {
-                    objJsonResult.code = "0";
-                    objJsonResult.count = 0;
-                    objJsonResult.Message = "false锛�";
-                    objJsonResult.data = null;
-                    return objJsonResult;
-                }
-                else
-                {
-                    objJsonResult.code = "1";
-                    objJsonResult.count = 1;
-                    objJsonResult.Message = "Sucess锛�";
-                    objJsonResult.data = ds.Tables[0];
-                    return objJsonResult;
-                }
+
+                //if (ds.Tables[0].Rows.Count != 0 || ds != null)
+                //{
+                objJsonResult.code = "1";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "Sucess锛�";
+                objJsonResult.data = ds.Tables[0];
+                return objJsonResult;
+                //}
+                //else
+                //{
+                //objJsonResult.code = "0";
+                //objJsonResult.count = 0;
+                //objJsonResult.Message = "鏃犳暟鎹�";
+                //objJsonResult.data = null;
+                //return objJsonResult;
+                //}
             }
             catch (Exception e)
             {
@@ -78,8 +87,16 @@
         /// </summary>
         [Route("Gy_WorkPayTypeBill/Delete_Json")]
         [HttpGet]
-        public object Delete_Json(string HInterID)
+        public object Delete_Json(string HInterID,string user)
         {
+            if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType_Delete", 1, false, user))
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
             //鐢╥d鏌ュ埌璇ュ璞�
             string sql = "select * from Gy_WorkPayType where HItemID =  " + HInterID;
             ds = oCN.RunProcReturn(sql, "Gy_WorkPayType");
@@ -160,11 +177,21 @@
             string msg1 = _value.ToString();
             string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
             string msg2 = sArray[0].ToString();
+            string msg4 = sArray[2].ToString();
 
             ListModels oListModels = new ListModels();
 
             try
             {
+                if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType_Edit", 1, false, msg4))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+
                 DLL.ClsGy_WorkPayTypeBill oBill = new DLL.ClsGy_WorkPayTypeBill();
                 List<Model.ClsGy_WorkPayType_Model> lsmain = new List<Model.ClsGy_WorkPayType_Model>();
                 msg2 = msg2.Replace("\\", "");

--
Gitblit v1.9.1