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 | 296 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 273 insertions(+), 23 deletions(-)
diff --git a/VueWebApi/Controllers/LoginController.cs b/VueWebApi/Controllers/LoginController.cs
index 011d134..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,16 +21,22 @@
//瀹氫箟鍏ㄥ眬淇℃伅杩斿洖鍙橀噺
ToMessage mes = new ToMessage();
RedisHelper redis = new RedisHelper();
+ //鑾峰彇浼佷笟閰嶇疆Enterprise
+ private static readonly string Enterprise = ConfigurationManager.AppSettings["Enterprise"];
+
+
+ #region[PC鐢ㄦ埛鐧诲綍]
/// <summary>
- /// 鐢ㄦ埛鐧诲綍
+ /// PC鐢ㄦ埛鐧诲綍
/// </summary>
/// <param name="username">鐢ㄦ埛缂栫爜</param>
/// <param name="password">瀵嗙爜</param>
+ /// <param name="usertype">鎿嶄綔绔被鍨�(PC APP)</param>
/// <returns></returns>
[Route(template: "LoginSave")]
[HttpGet]
- public HttpResponseMessage LoginSave(string username, string password)
+ public HttpResponseMessage LoginSave(string username, string password, string usertype)
{
try
{
@@ -38,23 +45,24 @@
{
List<User> mss = new List<User>();
User ms = new User();
- //ms.guid=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 = "PC";
+ ms.usertype = usertype;
+ 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.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.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);
//鍐欏叆鐧诲綍鎿嶄綔璁板綍
@@ -66,22 +74,23 @@
else //濡傛灉瀛樺湪
{
//鑾峰彇redis涓綋鍓嶇敤鎴蜂俊鎭�
- User r_loginUser = redis.Get<User>("LoginUserID" + ms.userid, 0);
+ User r_loginUser = redis.Get<User>(Enterprise+"LoginUserID" + ms.usertype + ms.userid, 0);
//濡傛灉session涓殑鐢ㄦ埛usercode鍜宺edis涓殑鐢ㄦ埛usercode鍖归厤
- if (r_loginUser.usercode.Equals(loginUser.usercode))
+ if ((r_loginUser.usercode + r_loginUser.usertype).Equals(loginUser.usercode + loginUser.usertype))
{
mes.data = ms;
- mes.code = "300";
- mes.Message = "褰撳墠璐﹀彿宸茬櫥褰�!";
+ mes.code = "302";
+ mes.Message = "褰撳墠璐﹀彿宸茬櫥褰�,鏄惁寮哄埗涓嬬嚎!";
}
else
{
//閲嶇疆杩囨湡鏃堕棿(娉ㄦ剰锛歳edis绫婚噷闈㈢殑澶辨晥鏃堕棿蹇呴』鍦╧ey鍒涘缓瀹屾垚涔嬪悗鎵嶇敓鏁�)
- redis.Set<User>("LoginUserID" + 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 = "鐧诲綍鎴愬姛!";
}
@@ -105,24 +114,72 @@
mes.code = "300";
mes.Message = e.Message;
}
-
+
return mes.ResponseMess(mes);
}
+ #endregion
+ #region[寮哄埗涓嬬嚎鎺ュ彛]
+ /// <summary>
+ /// 寮哄埗涓嬬嚎鎺ュ彛
+ /// </summary>
+ /// <param name="userid">鐢ㄦ埛id</param>
+ /// <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,string rid)
+ {
+ string sql="";
+ List<object> list = new List<object>();
+ try
+ {
+ 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 = "寮哄埗涓嬬嚎鎴愬姛!";
+ mes.data = null;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes.ResponseMess(mes);
+ }
+ #endregion
#region[鏌ヨ鐧诲綍鑿滃崟]
/// <summary>
- /// 鏌ヨ鍔熻兘鑿滃崟
+ /// 鏌ヨ鐧诲綍鑿滃崟
/// </summary>
+ /// <param name="usertype">鎿嶄綔绔被鍨�(PC APP)</param>
+ /// <param name="usercode">鐧诲綍鐢ㄦ埛缂栫爜</param>
/// <returns></returns>
[Route(template: "LoginMenu")]
[HttpGet]
- public HttpResponseMessage LoginMenu()
+ public HttpResponseMessage LoginMenu(string usertype, string usercode)
{
try
{
- var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
- mes = LoginBLL.LoginMenu(usercode);
+ //var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
+ mes = LoginBLL.LoginMenu(usercode, usertype);
}
catch (Exception e)
{
@@ -142,18 +199,18 @@
/// <param name="password">瀵嗙爜</param>
/// <param name="newpassword">鏂板瘑鐮�</param>
/// <returns></returns>
- [ChannelActionFilter,Route(template: "UpdateUserPassword")]
+ [ChannelActionFilter, Route(template: "UpdateUserPassword")]
[HttpPost]
- public HttpResponseMessage UpdateUserPassword(string usercode, string username, string password,string newpassword)
+ public HttpResponseMessage UpdateUserPassword(string usercode, string username, string password, string newpassword)
{
- mes = LoginBLL.UpdateUserPassword(usercode,username, password,newpassword);
+ mes = LoginBLL.UpdateUserPassword(usercode, username, password, newpassword);
return mes.ResponseMess(mes);
}
#endregion
- #region[鐧诲嚭]
+ #region[PC鐧诲嚭]
/// <summary>
- /// 鐧诲嚭
+ /// PC鐧诲嚭
/// </summary>
/// <param name="userid">鐢ㄦ埛id</param>
/// <param name="usercode">鐢ㄦ埛缂栫爜</param>
@@ -162,11 +219,204 @@
/// <returns></returns>
[Route(template: "LoginOut")]
[HttpPost]
- public HttpResponseMessage LoginOut(int userid, string usercode, string username,string usertype)
+ [ChannelActionFilter]
+ public HttpResponseMessage LoginOut(int userid, string usercode, string username, string usertype)
{
- mes = LoginBLL.LoginOut(userid,usercode, username, usertype);
+ var sql = "";
+ List<object> list = new List<object>();
+ mes = LoginBLL.LoginOut(userid, usercode, username, usertype);
return mes.ResponseMess(mes);
}
#endregion
+
+
+ #region[APP鐢ㄦ埛鐧诲綍]
+ /// <summary>
+ /// APP鐢ㄦ埛鐧诲綍
+ /// </summary>
+ /// <param name="username">鐢ㄦ埛缂栫爜</param>
+ /// <param name="password">瀵嗙爜</param>
+ /// <param name="usertype">鎿嶄綔绔被鍨�(PC APP)</param>
+ /// <param name="rid">鏋佸厜鎺ㄩ�佽幏鍙栬澶囩殑id(鍞竴)</param>
+ /// <returns></returns>
+ [Route(template: "LoginAppSave")]
+ [HttpGet]
+ public HttpResponseMessage LoginAppSave(string username, string password, string usertype, string rid)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ try
+ {
+ DataTable dt = LoginBLL.LoginSearch(username, password);
+ if (dt.Rows.Count > 0)
+ {
+ List<User> mss = new List<User>();
+ User ms = new User();
+ 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 = 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
+ {
+ mes.code = "300";
+ mes.Message = "璐﹀彿鎴栧瘑鐮佷笉姝ｇ‘!";
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ 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
+
+ #region[APP鐧诲嚭]
+ /// <summary>
+ /// APP鐧诲嚭
+ /// </summary>
+ /// <param name="userid">鐢ㄦ埛id</param>
+ /// <param name="usercode">鐢ㄦ埛缂栫爜</param>
+ /// <param name="username">鐢ㄦ埛鍚�</param>
+ /// <param name="usertype">鎿嶄綔绔疨C/APP</param>
+ /// <returns></returns>
+ [Route(template: "LoginAppOut")]
+ [HttpPost]
+ public HttpResponseMessage LoginAppOut(int userid, string usercode, string username, string usertype)
+ {
+ mes = LoginBLL.LoginAppOut(userid, usercode, username, usertype);
+ return mes.ResponseMess(mes);
+ }
+ #endregion
+
+ #region[App鐧诲綍鏌ヨ瀹夌伅鍛煎彨淇℃伅]
+ /// <summary>
+ /// App鐧诲綍鏌ヨ瀹夌伅鍛煎彨淇℃伅
+ /// </summary>
+ /// <param name="rid">鎵嬫満璁惧id(鏋佸厜鐢熸垚)</param>
+ /// <param name="usercode">鐢ㄦ埛缂栫爜</param>
+ /// <param name="username">鐢ㄦ埛鍚嶇О</param>
+ /// <param name="usertype">鎿嶄綔绔疨C/APP</param>
+ /// <returns></returns>
+ [Route(template: "LoginAppAnDonMessage")]
+ [HttpPost]
+ public HttpResponseMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype)
+ {
+ mes = LoginBLL.LoginAppAnDonMessage(rid, usercode, username, usertype);
+ return TJson.toJson(mes);
+ //return mes.ResponseMess(mes);
+ }
+ #endregion
+
}
}
\ No newline at end of file
--
Gitblit v1.9.3