using Newtonsoft.Json.Linq; using Opsoft.Data; using Opsoft.Data.Model; using Opsoft.NetCore.O3App.Domain.Models; using System; using System.Collections.Generic; using System.Data; using System.Linq; namespace Opsoft.NetCore.O3App.WebApi { public class UserService : IUserService { /// /// 验证用户是否可以登录成功 /// /// /// public bool IsValid(LoginRequest req) { try { using (APPServerContext DBContext = new APPServerContext(req.DBAias, req.UserID)) { SYS_LOGINUSER myUser = DBContext.Database.SqlQuery( " select USER_ID,USER_NAME,PR_PASSWORD,FDELETED " + " from SYS_LOGINUSER " + " where USER_ID=" + DBContext.GetDBParName("@PA1"), DBContext.CreateParameter("@PA1", req.UserID)).SingleOrDefault(); if (myUser != null) { var pass = myUser.GetPassWord(); var encryptPass = MD5Help.MD5Encrypt(pass); req.UserName = myUser.USER_NAME; if (req.IsFaceLogin || encryptPass.Equals(req.Password)) { LicenseInfo PPermissions = this.GetLicense(); if (PPermissions.HaveLicense) { if (PPermissions.LicenseDays >= PPermissions.SerialDate) { if (PPermissions.LicenseDays < PPermissions.SerialDate.AddDays(30)) { req.errtype = "3";//软件将过服务到期日,请提前申请或购买下一年度服务 return true; } else { req.errtype = "8"; return true; } } else { req.errtype = "4"; //软件服务到期日已过,请申请或购买下一年度服务! return true; } } else { req.errtype = "5"; //软件未注册,请先注册再使用! } } else { req.errtype = "2"; //密码不正确 } } else { req.errtype = "1"; //用户名不存在 } } return false; } catch (System.Exception ex) { req.errtype = ex.Message; return false; } } public JObject GetUser(string userId, string dbAias) { using APPServerContext DBContext = new APPServerContext(dbAias, userId); var parameter = DBContext.CreateParameter("@UserId", userId); string sql = $" SELECT T01.*,T03.FROLETYPE FROM SYS_LOGINUSER T01 LEFT JOIN SYS_USERROLERELATION T02 ON T01.USER_ID = T02.USER_ID LEFT JOIN SYS_USERROLE T03 ON T03.FROLENUMBER = T02.FROLEID WHERE T01.USER_ID = {parameter.ParameterName} "; DataTable userMessage = DBContext.Database.SqlQuery(sql, parameter); string fRoleType = "1"; JObject returnJObject = new JObject(); foreach (DataRow userRow in userMessage.Rows) { if (returnJObject.Property("USER_ID") == null) { returnJObject.Add("USER_ID", userRow["USER_ID"].ToStringEx()); returnJObject.Add("USER_NAME", userRow["USER_NAME"].ToStringEx()); returnJObject.Add("PR_PASSWORD", userRow["PR_PASSWORD"].ToStringEx()); returnJObject.Add("FDELETED", userRow["FDELETED"].ToStringEx()); returnJObject.Add("DBAias", dbAias); } if (userRow["FROLETYPE"].ToStringEx().Equals("0")) { fRoleType = "0"; } } returnJObject.Add("FROLETYPE", fRoleType); DBContext.Database.SqlNonQueryAsync(sql, parameter); return returnJObject; } private LicenseInfo GetLicense() { LicenseInfo myInfo = new LicenseInfo() { SerialNumber = "" }; try { //强制执行抓机器码 string Maction = "";//SecurityManage.GetLocalCustomerKey(wProductCode); List myList = SecurityManage.GetLocalSystemLicenseInfo(Maction); foreach (LicenseInfo subinfo in myList) { //如果产品及版本有注册,那么就看使用日期是否已经有到 subinfo.SerialDate = DateTime.Now; return subinfo; } } catch (Exception e) { throw e; } return myInfo; } } }