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