From c84bde120726e5a729d087995504e7207c3f8969 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期六, 07 五月 2022 15:23:59 +0800 Subject: [PATCH] nothing --- WebAPI/Controllers/WebAPIController.cs | 37 +++++++++++++++++++++++++++++++++---- 1 files changed, 33 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 00a000a..e892707 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -6,6 +6,7 @@ using System; using System.Collections.Generic; using System.Data; +using System.Data.SqlClient; using System.Linq; using System.Net; using System.Net.Http; @@ -183,12 +184,12 @@ Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); //LogService.Write("娴嬭瘯1锛�"+ DBUtility.ClsPub.sExeReturnInfo); string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); - //LogService.Write("娴嬭瘯2锛�" + DBUtility.ClsPub.sExeReturnInfo); - //LogService.Write(FCusName); + LogService.Write(FCusName); + LogService.Write("DBUtility.ClsPub.StrToPsd(PassWord.Trim()):" + DBUtility.ClsPub.StrToPsd(PassWord.Trim())); if (FCusName == "澶忓疂鐢靛櫒") - ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); + ds = CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); else - ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); + ds = CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -217,6 +218,34 @@ return objJsonResult; ; } } + public DataSet CheckMainID(string MainID, string sPsd) + { + DataSet DS; + try + { + SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); + DS = oCn.RunProcReturn("select * from Gy_Czygl where Czybm='" + MainID + "' and Czmm='" + sPsd + "' ", "Gy_Czygl"); + if (DS.Tables[0].Rows.Count == 0) + return null; + else + { + return DS; + } + } + catch (Exception e) + { + throw (e); + } + } + public DataSet CheckCzymc(string sUser, string sPsd) + { + SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); + SqlParameter[] prams ={oCn.MakeInParam("@Czymc",SqlDbType.VarChar,100,sUser ), + oCn.MakeInParam("@Czmm",SqlDbType.VarChar ,100,sPsd ), + }; + return oCn.RunProcReturn("select * from Gy_Czygl where Czymc='" + sUser + "' and Czmm='" + sPsd + "' ", prams, "Gy_Czygl"); + } + /// <summary> /// 淇敼瀵嗙爜 /// </summary> -- Gitblit v1.9.1