From d1dc6aaa453c38c6282930d85c58388b89aac065 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 29 八月 2025 14:28:28 +0800
Subject: [PATCH] 111
---
MES.Service/service/LoginService.cs | 76 ++++++++++++++++++++++++++++----------
MESApplication/appsettings.json | 2
2 files changed, 57 insertions(+), 21 deletions(-)
diff --git a/MES.Service/service/LoginService.cs b/MES.Service/service/LoginService.cs
index 4776b8b..c9656bb 100644
--- a/MES.Service/service/LoginService.cs
+++ b/MES.Service/service/LoginService.cs
@@ -1,6 +1,7 @@
锘縰sing System.Data;
using System.Text;
using MES.Service.DB;
+using MES.Service.Modes;
namespace MES.Service.service;
@@ -10,51 +11,86 @@
public DataTable login(string name, string pwd)
{
- var sql = string.Format(@"select * from SYS_USER where FCODE = '{0}'",
- name);
- var dataTable = SQLHelper.ExecuteQuery(sql);
- if (dataTable.Rows.Count <= 0) throw new Exception("鐢ㄦ埛涓嶅瓨鍦�");
+ using var db = SqlSugarHelper.GetInstance();
+
+ var user = db.Queryable<SysUser>()
+ .Where(u => u.Fcode == name)
+ .First();
+
+ if (user == null) throw new Exception("鐢ㄦ埛涓嶅瓨鍦�");
- var row = dataTable.Rows[0];
- var db_password = row["FPASSWORD"].ToString();
- db_password = ProPass(db_password);
+ var db_password = ProPass(user.Fpassword);
if (!pwd.Equals(db_password)) throw new Exception("鐢ㄦ埛鍚嶆垨鑰呭瘑鐮侀敊璇�");
+ // 杞崲涓篋ataTable浠ヤ繚鎸佸吋瀹规��
+ var userList = new List<SysUser> { user };
+ var dataTable = new DataTable();
+
+ // 娣诲姞闇�瑕佺殑鍒�
+ dataTable.Columns.Add("FID", typeof(string));
+ dataTable.Columns.Add("FCODE", typeof(string));
+ dataTable.Columns.Add("FNAME", typeof(string));
+ dataTable.Columns.Add("FPASSWORD", typeof(string));
+ dataTable.Columns.Add("DEPARTMENTID", typeof(string));
+ dataTable.Columns.Add("FACTORY", typeof(string));
+ dataTable.Columns.Add("FCOMPANY", typeof(string));
+
+ var row = dataTable.NewRow();
+ row["FID"] = user.Fid;
+ row["FCODE"] = user.Fcode;
+ row["FNAME"] = user.Fname;
+ row["FPASSWORD"] = user.Fpassword;
+ row["DEPARTMENTID"] = user.Departmentid;
+ row["FACTORY"] = user.Factory;
+ row["FCOMPANY"] = user.Fcompany;
+
+ dataTable.Rows.Add(row);
+
return dataTable;
}
public DataTable getUserMenu(string name)
{
- var sql = "";
-
+ using var db = SqlSugarHelper.GetInstance();
+
+ DataTable dataTable;
+
if ("PL017".Equals(name))
- sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
+ {
+ var sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
+ dataTable = db.Ado.GetDataTable(sql);
+ }
else
- sql = string.Format(@"select PAGE_VIEW,PATH,ICOIMG
+ {
+ var sql = @"select PAGE_VIEW,PATH,ICOIMG
from (select PAGE_VIEW,PATH,ICOIMG
from MES_SYS_GUP_USER a
join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
- where USERID = (select fid from SYS_USER where FCODE = '{0}')
+ where USERID = (select fid from SYS_USER where FCODE = @name)
union all
select PAGE_VIEW,PATH,ICOIMG
from MES_SYS_GUP_USER a
join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
- where a.ROLEID = (select FCODE from SYS_USER where FCODE = '{0}'))
- group by PATH, PAGE_VIEW, ICOIMG", name);
+ where a.ROLEID = (select FCODE from SYS_USER where FCODE = @name))
+ group by PATH, PAGE_VIEW, ICOIMG";
+ dataTable = db.Ado.GetDataTable(sql, new { name = name });
+ }
- return SQLHelper.ExecuteQuery(sql);
+ return dataTable;
}
public int resetPassword(string newPwd, string name, string pwd)
{
login(name, pwd);
var passwordHash = encryptPass(newPwd);
- var sql = string.Format(
- @"update SYS_USER set FPASSWORD = '{0}' where FCODE = '{1}'",
- passwordHash,
- name);
- return SQLHelper.ExecuteNonQuery(sql);
+
+ using var db = SqlSugarHelper.GetInstance();
+
+ return db.Updateable<SysUser>()
+ .SetColumns(u => u.Fpassword == passwordHash)
+ .Where(u => u.Fcode == name)
+ .ExecuteCommand();
}
private string encryptPass(string str)
diff --git a/MESApplication/appsettings.json b/MESApplication/appsettings.json
index 29d6c8f..a48ef04 100644
--- a/MESApplication/appsettings.json
+++ b/MESApplication/appsettings.json
@@ -10,6 +10,6 @@
"AppSettings": {
"TestErpUrl": "http://192.168.0.208:8066/WebService1.asmx/MesToErpinfoTest",
"ProductionErpUrl": "http://192.168.0.208:8066/WebService1.asmx/MesToErpinfoTest",
- "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = lts_dev; Password=ltsdev"
+ "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = lts_dev; Password=ltsdev;Pooling=true;Min Pool Size=5;Max Pool Size=100;Connection Timeout=30;Connection Lifetime=300;Incr Pool Size=5;Decr Pool Size=2"
}
}
--
Gitblit v1.9.3