From d0195342b6bb665df9e1437cf2d7c72c1b8d854f Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期三, 06 七月 2022 14:17:23 +0800 Subject: [PATCH] excel 导入 --- WebAPI/Controllers/WebAPIController.cs | 41 +++++++++++++++++++++++++++++++++++++---- 1 files changed, 37 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 00a000a..643202c 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -2,13 +2,16 @@ using DBUtility; using Microsoft.AspNet.SignalR; using Model; +using Newtonsoft.Json.Linq; using SQLHelper; using System; using System.Collections.Generic; using System.Data; +using System.Data.SqlClient; using System.Linq; using System.Net; using System.Net.Http; +using System.Web; using System.Web.Http; using WebAPI.BLL; using WebAPI.Models; @@ -183,12 +186,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 +220,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> @@ -812,5 +843,7 @@ return objjson; ; } #endregion + + } } -- Gitblit v1.9.1