From 4d4e3ad417beccd49f1fe61a158bb1bc3a3537c2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 27 十二月 2022 15:18:17 +0800
Subject: [PATCH] 采购订单,erp同步接口开发
---
VueWebApi/Controllers/LoginController.cs | 159 +++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 137 insertions(+), 22 deletions(-)
diff --git a/VueWebApi/Controllers/LoginController.cs b/VueWebApi/Controllers/LoginController.cs
index f3e034a..3e66357 100644
--- a/VueWebApi/Controllers/LoginController.cs
+++ b/VueWebApi/Controllers/LoginController.cs
@@ -1,6 +1,7 @@
锘縰sing Newtonsoft.Json;
using System;
using System.Collections.Generic;
+using System.Configuration;
using System.Data;
using System.Linq;
using System.Net;
@@ -20,6 +21,10 @@
//瀹氫箟鍏ㄥ眬淇℃伅杩斿洖鍙橀噺
ToMessage mes = new ToMessage();
RedisHelper redis = new RedisHelper();
+ //鑾峰彇浼佷笟閰嶇疆Enterprise
+ private static readonly string Enterprise = ConfigurationManager.AppSettings["Enterprise"];
+
+
#region[PC鐢ㄦ埛鐧诲綍]
/// <summary>
@@ -40,24 +45,24 @@
{
List<User> mss = new List<User>();
User ms = new User();
- ms.guid = username + password + Guid.NewGuid().ToString();
+ ms.guid = usertype+username + password + Guid.NewGuid().ToString();
ms.userid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
ms.usercode = dt.Rows[0]["USERCODE"].ToString();
ms.username = dt.Rows[0]["USERNAME"].ToString();
ms.password = dt.Rows[0]["PASSWORD"].ToString();
ms.usertype = usertype;
- ms.rediskey = "LoginUserID" + ms.usertype + ms.userid;
+ ms.rediskey = Enterprise+"LoginUserID" + ms.usertype + ms.userid;
mss.Add(ms);
HttpContext.Current.Session.Clear(); //浠庝細璇濈姸鎬侀泦鍚堜腑鍒犻櫎鎵�鏈夌殑閿��
//HttpContext.Current.Session["User"] = JsonConvert.SerializeObject(ms);
//User loginUser = JsonConvert.DeserializeObject<User>(HttpContext.Current.Session["User"].ToString());
User loginUser = JsonConvert.DeserializeObject<User>(JsonConvert.SerializeObject(ms));
//濡傛灉redis鐧诲綍鐢ㄦ埛涓笉瀛樺湪褰撳墠鐢ㄦ埛
- if (redis.Get<User>("LoginUserID" + ms.usertype + ms.userid, 0) == null)
+ if (redis.Get<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, 0) == null)
{
//redis.Remove("LoginUserID" + ms.userid, 0);
//鍐欏叆redis(娉ㄦ剰锛歳edis绫婚噷闈㈢殑澶辨晥鏃堕棿蹇呴』鍦╧ey鍒涘缓瀹屾垚涔嬪悗鎵嶇敓鏁�)
- redis.Set<User>("LoginUserID" + ms.usertype + ms.userid, ms, redis.secondsTimeOut, 0);
+ redis.Set<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, ms, redis.secondsTimeOut, 0);
//鐧诲綍淇℃伅鍐欏叆session
HttpContext.Current.Session["User"] = JsonConvert.SerializeObject(ms);
//鍐欏叆鐧诲綍鎿嶄綔璁板綍
@@ -69,7 +74,7 @@
else //濡傛灉瀛樺湪
{
//鑾峰彇redis涓綋鍓嶇敤鎴蜂俊鎭�
- User r_loginUser = redis.Get<User>("LoginUserID" + ms.usertype + ms.userid, 0);
+ User r_loginUser = redis.Get<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, 0);
//濡傛灉session涓殑鐢ㄦ埛usercode鍜宺edis涓殑鐢ㄦ埛usercode鍖归厤
if ((r_loginUser.usercode + r_loginUser.usertype).Equals(loginUser.usercode + loginUser.usertype))
{
@@ -80,11 +85,12 @@
else
{
//閲嶇疆杩囨湡鏃堕棿(娉ㄦ剰锛歳edis绫婚噷闈㈢殑澶辨晥鏃堕棿蹇呴』鍦╧ey鍒涘缓瀹屾垚涔嬪悗鎵嶇敓鏁�)
- redis.Set<User>("LoginUserID" + ms.usertype + loginUser.userid, loginUser, redis.secondsTimeOut, 0);
+ redis.Set<User>(Enterprise+"LoginUserID" + ms.usertype + loginUser.userid, loginUser, redis.secondsTimeOut, 0);
//鐧诲綍淇℃伅鍐欏叆session
HttpContext.Current.Session["User"] = JsonConvert.SerializeObject(ms);
//鍐欏叆鐧诲綍鎿嶄綔璁板綍
mes = LoginBLL.LoginBas(ms.usercode, ms.usertype);
+ mes.data = ms;
mes.code = "200";
mes.Message = "鐧诲綍鎴愬姛!";
}
@@ -121,14 +127,28 @@
/// <param name="usercode">鐢ㄦ埛缂栫爜</param>
/// <param name="username">鐢ㄦ埛鍚�</param>
/// <param name="usertype">鎿嶄綔绔疨C/APP</param>
+ /// <param name="rid">rid鏋佸厜鎺ㄩ�佽幏鍙栬澶噄d</param>
/// <returns></returns>
[Route(template: "ForcedOffline")]
[HttpPost]
- public HttpResponseMessage ForcedOffline(int userid, string usercode, string username, string usertype)
+ public HttpResponseMessage ForcedOffline(int userid, string usercode, string username, string usertype,string rid)
{
+ string sql="";
+ List<object> list = new List<object>();
try
{
- redis.Remove("LoginUserID" + usertype + userid, 0); //鍒犻櫎redis
+ if (usertype == "APP")
+ {
+ //鏇存柊rid
+ sql = @"update [dbo].[TUser] set rid=@rid where usercode=@usercode";
+ list.Add(new { str = sql, parm = new { rid = rid, usercode = username } });
+ bool aa = DapperHelper.DoTransaction(list);
+ redis.Remove(Enterprise+"LoginUserID" + usertype + userid, 1); //鍒犻櫎redis
+ }
+ else
+ {
+ redis.Remove(Enterprise+"LoginUserID" + usertype + userid, 0); //鍒犻櫎redis
+ }
mes.code = "200";
mes.count = 0;
mes.Message = "寮哄埗涓嬬嚎鎴愬姛!";
@@ -202,6 +222,8 @@
[ChannelActionFilter]
public HttpResponseMessage LoginOut(int userid, string usercode, string username, string usertype)
{
+ var sql = "";
+ List<object> list = new List<object>();
mes = LoginBLL.LoginOut(userid, usercode, username, usertype);
return mes.ResponseMess(mes);
}
@@ -228,27 +250,86 @@
DataTable dt = LoginBLL.LoginSearch(username, password);
if (dt.Rows.Count > 0)
{
- //鍐欏叆鐧诲綍鎿嶄綔璁板綍
- mes = LoginBLL.LoginBas(username, usertype);
- //鏇存柊rid
- sql = @"update [dbo].[TUser] set rid=@rid where usercode=@usercode";
- list.Add(new { str = sql, parm = new { rid = rid, usercode = username } });
- bool aa = DapperHelper.DoTransaction(list);
-
List<User> mss = new List<User>();
User ms = new User();
- //ms.guid = username + password + Guid.NewGuid().ToString();
- ms.guid = rid.ToString();
+ ms.guid = usertype+username + password + Guid.NewGuid().ToString();
ms.userid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
ms.usercode = dt.Rows[0]["USERCODE"].ToString();
ms.username = dt.Rows[0]["USERNAME"].ToString();
ms.password = dt.Rows[0]["PASSWORD"].ToString();
ms.usertype = usertype;
+ ms.rediskey = Enterprise+"LoginUserID" + ms.usertype + ms.userid;
mss.Add(ms);
+ HttpContext.Current.Session.Clear(); //浠庝細璇濈姸鎬侀泦鍚堜腑鍒犻櫎鎵�鏈夌殑閿��
+ User loginUser = JsonConvert.DeserializeObject<User>(JsonConvert.SerializeObject(ms));
+ //濡傛灉redis鐧诲綍鐢ㄦ埛涓笉瀛樺湪褰撳墠鐢ㄦ埛
+ if (redis.Get<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, 1) == null)
+ {
+ //鍐欏叆redis(娉ㄦ剰锛歳edis绫婚噷闈㈢殑澶辨晥鏃堕棿蹇呴』鍦╧ey鍒涘缓瀹屾垚涔嬪悗鎵嶇敓鏁�)
+ redis.Set<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, ms, redis.secondsTimeOut, 1);
+ //鐧诲綍淇℃伅鍐欏叆session
+ HttpContext.Current.Session["User"] = JsonConvert.SerializeObject(ms);
+ //鏇存柊rid
+ sql = @"update [dbo].[TUser] set rid=@rid where usercode=@usercode";
+ list.Add(new { str = sql, parm = new { rid = rid, usercode = username } });
+ bool aa = DapperHelper.DoTransaction(list);
+ //鍐欏叆鐧诲綍鎿嶄綔璁板綍
+ mes = LoginBLL.LoginBas(ms.usercode, ms.usertype);
+ mes.code = "200";
+ mes.Message = "鐧诲綍鎴愬姛!";
+ mes.data = ms;
+ }
+ else //濡傛灉瀛樺湪
+ {
+ //鑾峰彇redis涓綋鍓嶇敤鎴蜂俊鎭�
+ User r_loginUser = redis.Get<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, 1);
+ //濡傛灉session涓殑鐢ㄦ埛usercode鍜宺edis涓殑鐢ㄦ埛usercode鍖归厤
+ if ((r_loginUser.usercode + r_loginUser.usertype).Equals(loginUser.usercode + loginUser.usertype))
+ {
+ mes.data = ms;
+ mes.code = "302";
+ mes.Message = "褰撳墠璐﹀彿宸茬櫥褰�,鏄惁寮哄埗涓嬬嚎!";
+ }
+ else
+ {
+ //閲嶇疆杩囨湡鏃堕棿(娉ㄦ剰锛歳edis绫婚噷闈㈢殑澶辨晥鏃堕棿蹇呴』鍦╧ey鍒涘缓瀹屾垚涔嬪悗鎵嶇敓鏁�)
+ redis.Set<User>(Enterprise+"LoginUserID" + ms.usertype + loginUser.userid, loginUser, redis.secondsTimeOut, 1);
+ //鐧诲綍淇℃伅鍐欏叆session
+ HttpContext.Current.Session["User"] = JsonConvert.SerializeObject(ms);
+ //鏇存柊rid
+ sql = @"update [dbo].[TUser] set rid=@rid where usercode=@usercode";
+ list.Add(new { str = sql, parm = new { rid = rid, usercode = username } });
+ bool aa = DapperHelper.DoTransaction(list);
+ //鍐欏叆鐧诲綍鎿嶄綔璁板綍
+ mes = LoginBLL.LoginBas(ms.usercode, ms.usertype);
+ mes.data = ms;
+ mes.code = "200";
+ mes.Message = "鐧诲綍鎴愬姛!";
+ }
+ }
- mes.code = "200";
- mes.Message = "鐧诲綍鎴愬姛!";
- mes.data = ms;
+
+ ////鍐欏叆鐧诲綍鎿嶄綔璁板綍
+ //mes = LoginBLL.LoginBas(username, usertype);
+ ////鏇存柊rid
+ //sql = @"update [dbo].[TUser] set rid=@rid where usercode=@usercode";
+ //list.Add(new { str = sql, parm = new { rid = rid, usercode = username } });
+ //bool aa = DapperHelper.DoTransaction(list);
+
+ //List<User> mss = new List<User>();
+ //User ms = new User();
+ ////ms.guid = username + password + Guid.NewGuid().ToString();
+ //ms.guid = rid.ToString();
+ //ms.userid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
+ //ms.usercode = dt.Rows[0]["USERCODE"].ToString();
+ //ms.username = dt.Rows[0]["USERNAME"].ToString();
+ //ms.password = dt.Rows[0]["PASSWORD"].ToString();
+ //ms.usertype = usertype;
+ //mss.Add(ms);
+
+ //mes.code = "200";
+ //mes.Message = "鐧诲綍鎴愬姛!";
+ //mes.data = ms;
}
else
{
@@ -262,6 +343,40 @@
mes.Message = e.Message;
}
+ return mes.ResponseMess(mes);
+ }
+ #endregion
+
+ #region[APP淇敼瀵嗙爜]
+ /// <summary>
+ /// APP淇敼瀵嗙爜
+ /// </summary>
+ /// <param name="usercode">鐢ㄦ埛缂栫爜</param>
+ /// <param name="username">鐢ㄦ埛鍚嶇О</param>
+ /// <param name="password">瀵嗙爜</param>
+ /// <param name="newpassword">鏂板瘑鐮�</param>
+ /// <returns></returns>
+ [ChannelActionFilterAttributeApp, Route(template: "AppUpdateUserPassword")]
+ [HttpPost]
+ public HttpResponseMessage AppUpdateUserPassword(string usercode, string username, string password, string newpassword)
+ {
+ mes = LoginBLL.AppUpdateUserPassword(usercode, username, password, newpassword);
+ return mes.ResponseMess(mes);
+ }
+ #endregion
+
+ #region[APP瀵嗙爜閲嶇疆]
+ /// <summary>
+ /// APP瀵嗙爜閲嶇疆
+ /// </summary>
+ /// <param name="usercode">鐢ㄦ埛缂栧彿</param>
+ /// <param name="username">鐢ㄦ埛鍚嶇О</param>
+ /// <returns></returns>
+ [ChannelActionFilterAttributeApp, Route(template: "ResettUserPassword")]
+ [HttpPost]
+ public HttpResponseMessage ResettUserPassword(string usercode, string username)
+ {
+ mes = LoginBLL.ResettUserPassword(usercode, username);
return mes.ResponseMess(mes);
}
#endregion
@@ -298,10 +413,10 @@
public HttpResponseMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype)
{
mes = LoginBLL.LoginAppAnDonMessage(rid, usercode, username, usertype);
- return mes.ResponseMess(mes);
+ return TJson.toJson(mes);
+ //return mes.ResponseMess(mes);
}
#endregion
-
}
}
\ No newline at end of file
--
Gitblit v1.9.3