From c8d7eae2ecd99377e65fc1c74820ff212d08a381 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期五, 15 九月 2023 11:24:30 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/WebAPIController.cs | 26 +++++++++++++------------- 1 files changed, 13 insertions(+), 13 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index ab01574..6bbaac2 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -87,7 +87,7 @@ /// <returns></returns> [Route("Web/GetUser")] [HttpGet] - public object GetUser(string UserName, string PassWord, string HOrgName) + public object GetUser(string UserName, string PassWord) { try { @@ -103,17 +103,17 @@ objjson.data = null; return objjson; } - string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a - where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName); - DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check"); - if (_ds == null || _ds.Tables[0].Rows.Count == 0) - { - objjson.code = "0"; - objjson.count = 0; - objjson.Message = "鐢ㄦ埛" + UserName + "娌℃湁璇ョ粍缁囨潈闄�"; - objjson.data = null; - return objjson; - } + //string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a + // where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName); + //DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check"); + //if (_ds == null || _ds.Tables[0].Rows.Count == 0) + //{ + // objjson.code = "0"; + // objjson.count = 0; + // objjson.Message = "鐢ㄦ埛" + UserName + "娌℃湁璇ョ粍缁囨潈闄�"; + // objjson.data = null; + // return objjson; + //} objjson.code = "0"; objjson.count = 1; @@ -384,7 +384,7 @@ //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Warehouse != "") { - sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) "; + sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%') "; } try { -- Gitblit v1.9.1