From c4c8ad30b13937190c3e17e50ccbe22d17cb97c9 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 11 八月 2022 14:16:51 +0800
Subject: [PATCH] 优化
---
WebAPI/Controllers/WebAPIController.cs | 81 +++++++++++++++++++++++++++++++---------
1 files changed, 63 insertions(+), 18 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index e15b8b0..222cebe 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;
@@ -180,7 +183,17 @@
DataSet ds = null;
ClsCNSRM oCnLoc = new ClsCNSRM();
DAL.ClsUser oUser = new DAL.ClsUser();
- ds = oUser.CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+ 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(FCusName);
+ LogService.Write("DBUtility.ClsPub.StrToPsd(PassWord.Trim()):" + DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+ //if (FCusName == "澶忓疂鐢靛櫒")
+ // ds = CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+ //else
+ // ds = CheckCzymc(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
+
+ ds = CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim()));
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
@@ -209,6 +222,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>
@@ -233,12 +274,13 @@
return objJsonResult; ;
}
//===========
- oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czymc='" + UserName + "'", "Gy_Czygl");
+ //LogService.Write("select Czmm from Gy_Czygl where Czymc='" + UserName + "' and Czmm = '" + DBUtility.ClsPub.StrToPsd(oldPassword.Trim()) + "'");
+ oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czymc='" + UserName + "' and Czmm = '" + DBUtility.ClsPub.StrToPsd(oldPassword.Trim()) + "'", "Gy_Czygl");
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
- objJsonResult.Message = "娌℃湁杩欎釜鐢ㄦ埛锛屼笉鑳戒慨鏀瑰瘑鐮侊紒";
+ objJsonResult.Message = "鍘熷瘑鐮侀敊璇紒";
objJsonResult.data = null;
return objJsonResult; ;
}
@@ -368,13 +410,13 @@
try
{
- oCn.BeginTran();
- oCn.RunProc("Insert into SRM_OpenTmp " +
- " (HNumber,HModel,HName) " +
- " Values('" + HNumber + "','" + HName + "','" + HName + "')", ref DBUtility.ClsPub.sExeReturnInfo);
- //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
- //oCn.RunProc("Update Gy_OpenTmp set HEndflag=0 where HItemID=" + oModel.HParentID, ref ClsPub.sExeReturnInfo);
- oCn.Commit();
+ //oCn.BeginTran();
+ //oCn.RunProc("Insert into SRM_OpenTmp " +
+ // " (HNumber,HModel,HName) " +
+ // " Values('" + HNumber + "','" + HName + "','" + HName + "')", ref DBUtility.ClsPub.sExeReturnInfo);
+ ////淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
+ ////oCn.RunProc("Update Gy_OpenTmp set HEndflag=0 where HItemID=" + oModel.HParentID, ref ClsPub.sExeReturnInfo);
+ //oCn.Commit();
objjson.code = "0";
objjson.count = 1;
objjson.Message = "淇濆瓨鎴愬姛!";
@@ -404,9 +446,9 @@
ClsCNSRM oCn = new ClsCNSRM();
try
{
- oCn.BeginTran();
- oCn.RunProc("Delete from SRM_OpenTmp where HItemID='" + DBUtility.ClsPub.isLong(HItemID) + "'", ref DBUtility.ClsPub.sExeReturnInfo);
- oCn.Commit();
+ //oCn.BeginTran();
+ //oCn.RunProc("Delete from SRM_OpenTmp where HItemID='" + DBUtility.ClsPub.isLong(HItemID) + "'", ref DBUtility.ClsPub.sExeReturnInfo);
+ //oCn.Commit();
objjson.code = "0";
objjson.count = 1;
objjson.Message = "鍒犻櫎鎴愬姛!";
@@ -776,7 +818,8 @@
objJsonResult.Message = "杩斿洖鏁版嵁鎴愬姛锛�";
objJsonResult.data = oDs;
}
- else {
+ else
+ {
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "杩斿洖鏁版嵁澶辫触锛�";
@@ -789,18 +832,20 @@
#region[鏇存敼鍏憡鐘舵�乚
[Route("UpdateMessage")]
[HttpGet]
- public object UpdateMessage(string UserName, string HInterID,string HEntryID)
+ public object UpdateMessage(string UserName, string HInterID, string HEntryID)
{
ClsCNSRM oCn = new ClsCNSRM();
oCn.BeginTran();
- oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='"+ UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='"+ HEntryID + "'", ref ClsPub.sExeReturnInfo);
+ oCn.RunProc("Update OA_InformBillSub set HReadFlag=1 HUpDater='" + UserName + "',HUpDateDate=getdate() where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'", ref ClsPub.sExeReturnInfo);
oCn.Commit();
objjson.code = "1";
objjson.count = 1;
- objjson.Message =ClsPub.sExeReturnInfo;
+ objjson.Message = ClsPub.sExeReturnInfo;
objjson.data = null;
- return objjson;;
+ return objjson; ;
}
#endregion
+
+
}
}
--
Gitblit v1.9.1