From 56239876629dcb4d8b0a7e2aaed5ce38fe01fe39 Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期二, 26 十月 2021 10:05:21 +0800
Subject: [PATCH] nothing
---
WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs | 127 +++---------------------------------------
1 files changed, 9 insertions(+), 118 deletions(-)
diff --git a/WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs b/WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs
index df9c210..a64e2ce 100644
--- a/WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs
+++ b/WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs
@@ -27,19 +27,20 @@
/// </summary>
[Route("Cg_POOrderBill/list")]
[HttpGet]
- public object list(string sWhere, string user)
+ public object list(string sWhere)
{
try
{
- //鍒ゆ柇鏄惁鏈夐噰璐粡鐞嗘潈闄�
- bool isCgjl = Security_Log("Cg_POOrderBill_PurchasManager", 1, true, user);
- if (!isCgjl)
+ if (sWhere == null || sWhere.Equals(""))
{
- sWhere += " and HEmpID in (select HEmpID from Gy_Czygl where Czymc='Admin' )";
+ ds = oCN.RunProcReturn("select * from h_v_IF_POOrderBillList " + sWhere, "h_v_IF_POOrderBillList");
}
- string sql = "select * from h_v_IF_POOrderBillList where 1 = 1 " + sWhere;
- ds = oCN.RunProcReturn(sql, "h_v_IF_POOrderBillList");
-
+ else
+ {
+ string sql1 = "select * from h_v_IF_POOrderBillList where 1 = 1 ";
+ string sql = sql1 + sWhere;
+ ds = oCN.RunProcReturn(sql, "h_v_IF_POOrderBillList");
+ }
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess锛�";
@@ -140,116 +141,6 @@
objJsonResult.Message = "Exception锛�" + e.ToString();
objJsonResult.data = null;
return objJsonResult;
- }
- }
-
-
-
-
- //鍒ゆ柇鏄惁瀛樺湪鏉冮檺,骞跺啓鍏ユ棩蹇�
- public static bool Security_Log(string gnsy, int LogTF, bool Msg, string CurUserName)
- {
- //gnsy 鍔熻兘绱㈠紩,妯″潡
- //usercode 褰撳墠鐢ㄦ埛浠ｇ爜
- //LogTF 1鍒ゆ柇鏉冮檺骞跺啓鏃ュ織锛�2鍙啓鏃ュ織锛�3鍙垽鏂潈闄�
- //Msg 娌℃湁鏉冮檺鏃� 鏄惁鎻愮ず妗�
- string UserID = CurUserName;
- try
- {
- ClsSqlHelper oCn = new ClsSqlHelper();
- DataSet Ds = new DataSet();
- DataSet DsUser = new DataSet();
- DataSet DsJS = new DataSet();//瑙掕壊
- long ModID = 0;
- bool HavRight = false;
- //鎵惧埌妯″潡鏉冮檺
- Ds = oCn.RunProcReturn("select * from xt_xtgnb where gnsy='" + gnsy.Trim() + "'", "xt_xtgnb");
- if (Ds.Tables[0].Rows.Count == 0)
- {
- if (Msg == true)
- {
- //MessageBox.Show("娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒", "鎻愮ず");
- }
- return false;
- }
- else
- {
- ModID = ClsPub.isLong(Ds.Tables[0].Rows[0]["ID"].ToString()); //杩斿洖妯″潡
- }
- if (LogTF == 1 || LogTF == 3)//闇�瑕佸垽鏂潈闄�
- {
- //鏍规嵁鐢ㄦ埛鍚嶇О鍒ゆ柇鏉冮檺
- DsUser = oCn.RunProcReturn("select * from gy_czygl where czymc='" + UserID.Trim() + "'", "gy_czygl");
- if (DsUser.Tables[0].Rows.Count == 0)
- {
- if (Msg == true)
- {
- //MessageBox.Show("娌℃湁鎵惧埌褰撳墠鎿嶄綔鍛橈紒", "鎻愮ず");
- }
- return false;
- }
- //鏍规嵁鐢ㄦ埛鍚嶇О鍒ゆ柇鏉冮檺
- if ((bool)DsUser.Tables[0].Rows[0]["ManagerFlag"]) //鏄惁绠＄悊鍛�
- {
- HavRight = true;
- }
- else
- {
- if (DsUser.Tables[0].Rows[0]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1")
- {
- HavRight = true;
- }
- else
- {
- //鑾峰彇鐢ㄦ埛缁� 骞跺惊鐜垽鏂潈闄�
- //鍒ゆ柇瑙掕壊鏄惁鏈夋潈闄�
- DsJS = oCn.RunProcReturn("select isnull(AuthorityID,'') AuthorityID from System_UserGroupinfo a inner join System_UserGroup b on a.GroupID=b.GroupID " +
- " Where a.USERID='" + UserID.Trim() + "'", "gy_czygl");
- if (DsJS == null)
- {
- HavRight = false;
- }
- else
- {
- HavRight = false;
- for (int i = 0; i < DsJS.Tables[0].Rows.Count; i++)
- {
- if (ClsPub.isStrNull(DsJS.Tables[0].Rows[i]["AuthorityID"]).Length > ModID)
- {
- if (DsJS.Tables[0].Rows[i]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1")
- {
- HavRight = true;
- break;
- }
- }
- }
-
- }
- }
- }
-
- if (HavRight == false)
- {
- if (Msg == true)
- {
- //MessageBox.Show("鎮ㄦ病鏈夋潈闄�,璇蜂笌绠＄悊鍛樿仈绯伙紒", "鎻愮ず");
- }
- }
- }
- //闇�瑕佸啓鍏ユ棩蹇�
- if ((LogTF == 1 && HavRight) || LogTF == 2)
- {
- //Add_Log(Ds.Tables[0].Rows[0]["id"].ToString().Trim(), gnsy + "," + Ds.Tables[0].Rows[0]["gnmc"].ToString().Trim(), CurUserName);
- }
- return HavRight;
- }
- catch (Exception e)
- {
- if (Msg == true)
- {
- //MessageBox.Show("鍒ゆ柇鏉冮檺鏃跺彂鐜伴敊璇�,璇蜂笌绠＄悊鍛樿仈绯伙紒", "鎻愮ず");
- }
- return false;
}
}
--
Gitblit v1.9.1