public bool SaveOrUpdate(Base_User data) { try { CommonDao.SaveOrUpdate(data); return true; } catch (Exception e) { Log.Error("用户数据编辑", e); return false; } }
public ActionResult <AjaxResult> SaveData(Base_User theData, string newPwd, string roleIdsJson) { AjaxResult res; if (!newPwd.IsNullOrEmpty()) { theData.Password = newPwd.ToMD5String(); } var roleIds = roleIdsJson?.ToList <string>() ?? new List <string>(); if (theData.Id.IsNullOrEmpty()) { theData.InitEntity(); res = _userBus.AddData(theData, roleIds); } else { res = _userBus.UpdateData(theData, roleIds); } return(JsonContent(res.ToJson())); }
public async Task PressTest() { Base_User base_User = new Base_User { Id = Guid.NewGuid().ToString(), Birthday = DateTime.Now, CreateTime = DateTime.Now, CreatorId = Guid.NewGuid().ToString(), DepartmentId = Guid.NewGuid().ToString(), Password = Guid.NewGuid().ToString(), RealName = Guid.NewGuid().ToString(), Sex = Sex.Man, UserName = Guid.NewGuid().ToString() }; await _repository.InsertAsync(base_User); await _repository.UpdateAsync(base_User); await _repository.GetIQueryable <Base_User>().Where(x => x.Id == base_User.Id).FirstOrDefaultAsync(); await _repository.DeleteAsync(base_User); }
static void Main(string[] args) { //IRepository db1 = DbFactory.GetRepository("oracle", DatabaseType.Oracle); //IRepository db2 = DbFactory.GetRepository("oracle2", DatabaseType.Oracle); //var list = db1.GetList<Base_User>(); //var list2 = db2.GetList<Base_User>(); var db = DbFactory.GetRepository(); db.HandleSqlLog = Console.WriteLine; string tableName = "Base_User1"; var typeConfig = TypeBuilderHelper.GetConfig(typeof(Base_User)); typeConfig.FullName = tableName; typeConfig.Attributes[0].ConstructorArgs[0] = tableName; var type = TypeBuilderHelper.BuildType(typeConfig); var type2 = TypeBuilderHelper.BuildType(typeConfig); var properties = type.GetProperties(); Console.WriteLine(type == type2); Base_User base_User = new Base_User { Id = GuidHelper.GenerateKey(), UserId = GuidHelper.GenerateKey(), UserName = GuidHelper.GenerateKey() }; Base_User base_User2 = new Base_User { Id = GuidHelper.GenerateKey(), UserId = GuidHelper.GenerateKey(), UserName = GuidHelper.GenerateKey() }; db.Insert(base_User.ToJson().ToObject(type)); db.Insert(base_User2.ChangeType(type2)); Console.WriteLine("完成"); Console.ReadLine(); }
/// <summary> /// 私有方法,获取当前用户的方法数据 /// </summary> /// <param name="user"></param> /// <returns></returns> private List <Base_Menu> getMyCategories(Base_User user) { var list = _BaseMenusService.getAll(); if (user == null) { return(null); } if (user.IsAdmin) { return(list); } //获取权限数据 var userRoles = _BaseUserRoleService.getAll(); if (userRoles == null || !userRoles.Any()) { return(null); } var roleIds = userRoles.Where(o => o.UserId == user.Id).Select(x => x.RoleId).Distinct().ToList(); var permissionList = _BaseRolePermissionService.getAll(); if (permissionList == null || !permissionList.Any()) { return(null); } var categoryIds = permissionList.Where(o => roleIds.Contains(o.RoleId)).Select(x => x.MenuId).Distinct().ToList(); if (!categoryIds.Any()) { return(null); } list = list.Where(o => categoryIds.Contains(o.Id)).ToList(); return(list); }
public ActionResult SaveData(Base_SysNavigation theData) { string msg = string.Empty; if (theData.Id.IsNullOrEmpty()) { Base_User base_User = CurrentUserHelper.GetCurrentUserInfo(); _base_SysNavigationBusiness.AddData(theData, base_User); msg = "添加成功!"; } else { _base_SysNavigationBusiness.UpdateData(theData); msg = "修改成功!"; } return(Ok(new AjaxResult { Success = true, Msg = msg, Data = null, ErrorCode = 0 })); }
/// <summary> /// 保存 /// </summary> /// <param name="theData">保存的数据</param> public ActionResult SaveData(Base_User theData, string Pwd, string RoleIdList) { if (!Pwd.IsNullOrEmpty()) { theData.Password = Pwd.ToMD5String(); } var roleIdList = RoleIdList.ToList <string>(); if (theData.Id.IsNullOrEmpty()) { theData.Id = Guid.NewGuid().ToSequentialGuid(); theData.UserId = Guid.NewGuid().ToSequentialGuid(); _base_UserBusiness.AddData(theData); } else { _base_UserBusiness.UpdateData(theData); } _base_UserBusiness.SetUserRole(theData.UserId, roleIdList); return(Success()); }
protected void DotNetCustomCalDotNetack_CustomCalDotNetack(object sender, Controls.CustomCalDotNetack.DotNetCustomCalDotNetack.CustomCalDotNetackEventArgs e) { string args = Request["fguid"]; List = new List<Base_User>(); if (string.IsNullOrEmpty(args)) { List.Add(new Base_User { Fguid = User.Userid, Password = ctlNewPassword.Text }); } else { string[] fguids = args.Split(','); Base_User data; foreach (var item in fguids) { data = new Base_User(); data.Fguid = item; data.Password = ctlNewPassword.Text; List.Add(data); } } _presenter = new PasswordPresenter(this); bool result = _presenter.ChangePassword(); DotNetCustomCalDotNetack.CalDotNetackResult.Result = result.ToString(); }
/// <summary> /// 人脸搜索 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result <int> SearchUserFace(SignFaceAI model) { BasicDataContext basedb = new BasicDataContext(); BusinessDataContext busdb = new BusinessDataContext(); Result <int> resultObj = new Result <int>(); resultObj.Data = -1; try { //查询用户是否注册人脸信息 var userFaceList = DataOperateBusiness <EPM_AIUserFace> .Get(busdb).GetList(t => t.UserId == model.UserId); if (!userFaceList.Any()) { throw new Exception("您还没有注册人脸识别信息!"); } else { var imageType = "BASE64"; var groupIdList = "group1"; string control = "LOW"; model.Image = model.Image.Substring(model.Image.IndexOf(",") + 1); //将‘,’以前的多余字符串删除 var options = new Dictionary <string, object> { { "quality_control", control }, { "liveness_control", control }, { "user_id", model.UserId.ToString() } }; //签到表 Epm_SignInformation modelSign = new Epm_SignInformation(); //人脸日志表 EPM_FaceOperateLog faceLog = new EPM_FaceOperateLog(); Base_User userModel = DataOperateBasic <Base_User> .Get(basedb).GetModel(model.UserId.Value); List <Epm_ProjectCompany> proComList = DataOperateBusiness <Epm_ProjectCompany> .Get(busdb).GetList(t => t.ProjectId == model.ProjectId && (t.PMId == model.UserId || t.LinkManId == model.UserId || t.SafeManId == model.UserId)).ToList(); string type = ""; if (proComList.Any()) { type = string.Join(",", proComList.Select(t => t.Type)); } modelSign.userId = model.UserId; modelSign.userName = userModel.UserName; modelSign.projectId = model.ProjectId; modelSign.projectName = model.ProjectName; modelSign.Latitude = model.Latitude; modelSign.Longitude = model.Longitude; modelSign.gasstationName = model.OilStationName; modelSign.jobInfo = userModel.Post ?? ""; modelSign.type = type; modelSign.picStrength = model.Image; modelSign.SignTime = DateTime.Now; //日志 var requestJson = new { imageType = imageType, groupId = groupIdList, options = new { quality_control = control, liveness_control = control, user_id = model.UserId } }; faceLog.ModelId = modelSign.Id; faceLog.APIType = FaceOperate.Search.ToString(); faceLog.RequestJson = requestJson.ToString(); JObject result = new JObject(); Face client = GetFacaClient(); try { // 带参数调用人脸识别 result = client.Search(model.Image, imageType, groupIdList, options); } catch (Exception) { modelSign.SignResult = SignRes.Other.ToString(); } if (result["error_code"].ToString() == "0" && result["error_msg"].ToString() == "SUCCESS") { var result_list = Newtonsoft.Json.JsonConvert.DeserializeObject(result["result"].ToString()) as JObject; var user_list = result_list["user_list"]; var Obj = JArray.Parse(user_list.ToString()); foreach (var item in Obj) { //80分以上可以判断为同一人,此分值对应万分之一误识率 var score = Convert.ToInt32(item["score"]); if (score > 80) { modelSign.SignResult = SignRes.Success.ToString(); faceLog.IsSuccess = true; resultObj.Data = 1; resultObj.Flag = EResultFlag.Success; } else { modelSign.SignResult = SignRes.NoFace.ToString(); faceLog.IsSuccess = false; } } } else { modelSign.SignResult = SignRes.Fail.ToString(); } faceLog.ResponseJson = result.ToString(); faceLog = SetCurrentUser(faceLog); DataOperateBusiness <EPM_FaceOperateLog> .Get(busdb).Add(faceLog); var rows = DataOperateBusiness <Epm_SignInformation> .Get(busdb).Add(modelSign); if (rows > 0) { resultObj.Flag = EResultFlag.Success; } } } catch (Exception ex) { resultObj.Data = -1; resultObj.Flag = EResultFlag.Failure; resultObj.Exception = new ExceptionEx(ex, "SearchUserFace"); } finally { if (basedb.Database.Connection.State != ConnectionState.Closed) { basedb.Database.Connection.Close(); basedb.Database.Connection.Dispose(); } if (busdb.Database.Connection.State != ConnectionState.Closed) { busdb.Database.Connection.Close(); busdb.Database.Connection.Dispose(); } } return(resultObj); }
//获取登录数据 public Base_User Select(Base_User user) { Base_User list = helper.GetLoginData <Base_User>(user.User_Name, user.User_Pwd).FirstOrDefault(); return(list); }
public int Delete(Base_User user) { return(helper.SingerAndBatchDeleteTable("Dele_Table", "Base_User", "User_ID", user.User_ID.ToString())); }
//创建用户 public int Add(Base_User user) { int h = helper.InsertData(user); return(h); }
//查询登录 public Base_User Select(Base_User user) { return(login.Select(user)); }
/// <summary> /// 添加用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result <int> AddUser(Base_User model, List <Base_Files> fileList) { return(base.Channel.AddUser(model, fileList)); }
/// <summary> /// 根据用户名获取用户信息 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public Base_User getUserInfoByUserName(string UserName) { Base_User getSingle = dbSqlClent.Queryable <Base_User>().Where(model => model.UserId == UserName).Single(); return(getSingle); }
//授权添加 public int Add(Base_User user) { return(login.Add(user)); }
/// <summary> /// 登录验证 /// </summary> /// <param name="username">用户名</param> /// <returns></returns> public UserEntity CheckLogin(string username) { var user = Base_User.SingleOrDefault("where (Account=@0 or Mobile=@0 or Email=@0)", username); return(EntityConvertTools.CopyToModel <Base_User, UserEntity>(user, null)); }
/// <summary> /// 用户实体 /// </summary> /// <param name="keyValue">主键值</param> /// <returns></returns> public UserEntity GetEntity(string keyValue) { var user = Base_User.SingleOrDefault("where UserId=@0", keyValue); return(EntityConvertTools.CopyToModel <Base_User, UserEntity>(user, null)); }
public static void init() { var db = CreateDBInstance.GetInstance(); var updateObj = new Base_User() { Id = 1, UserId = "lxsh", DepartmentID = "0", Birthday = Convert.ToDateTime("2017-05-21 09:56:12.610") }; var updateObjs = new List <Base_User>() { updateObj, new Base_User() { Id = 2, UserId = "sun", DepartmentID = "0" } }.ToArray(); //update reutrn Update Count var t1 = db.Updateable(updateObj).ExecuteCommand(); //Only update Name updateObj = new Base_User() { Id = 1, UserId = "admin", Sex = 1, RealName = "李飞", DepartmentID = "10", Birthday = Convert.ToDateTime("2018-05-21 09:56:12.610") }; var t3 = db.Updateable(updateObj).UpdateColumns(it => new { it.Sex, it.RealName }).ExecuteCommand(); var t3_1 = db.Updateable(updateObj).UpdateColumns(it => it == "DepartmentID").ExecuteCommand(); //Ignore Name and TestId var t4 = db.Updateable(updateObj).IgnoreColumns(it => new { it.UserName, it.Id }).ExecuteCommand(); //Ignore Name and TestId var t5 = db.Updateable(updateObj).IgnoreColumns(it => it == "UserName" || it == "Id").With(SqlWith.UpdLock).ExecuteCommand(); ////Use Lock //var t6 = db.Updateable(updateObj).With(SqlWith.UpdLock).ExecuteCommand(); ////update List<T> //var t7 = db.Updateable(updateObjs).ExecuteCommand(); ////Re Set Value //var t8 = db.Updateable(updateObj) // .ReSetValue(it => it.Name == (it.Name + 1)).ExecuteCommand(); ////Where By Expression //var t9 = db.Updateable(updateObj).Where(it => it.Id == 1).ExecuteCommand(); ////Update By Expression Where By Expression //var t10 = db.Updateable<Student>() // .UpdateColumns(it => new Student() { Name = "a", CreateTime = DateTime.Now }) // .Where(it => it.Id == 11).ExecuteCommand(); ////Rename //db.Updateable<School>().AS("Student").UpdateColumns(it => new School() { Name = "jack" }).Where(it => it.Id == 1).ExecuteCommand(); ////Update Student set Name='jack' Where Id=1 ////Column is null no update //db.Updateable(updateObj).Where(true).ExecuteCommand(); ////sql //db.Updateable(updateObj).Where("id=@x", new { x = "1" }).ExecuteCommand(); //db.Updateable(updateObj).Where("id", "=", 1).ExecuteCommand(); //var t12 = db.Updateable<School>().AS("Student").UpdateColumns(it => new School() { Name = "jack" }).Where(it => it.Id == 1).ExecuteCommandAsync(); //t12.Wait(); ////update one columns //var count = db.Updateable<Student>().UpdateColumns(it => it.SchoolId == it.SchoolId).Where(it => it.Id == it.Id + 1).ExecuteCommand(); ////update one columns //var count2 = db.Updateable<Student>().UpdateColumns(it => it.SchoolId == it.SchoolId + 1).Where(it => it.Id == it.Id + 1).ExecuteCommand(); //var dt = new Dictionary<string, object>(); //dt.Add("id", 1); //dt.Add("name", null); //dt.Add("createTime", DateTime.Now); //var t66 = db.Updateable(dt).AS("student").With(SqlWith.UpdLock).ExecuteCommand(); }
/// <summary> /// 执行登录 /// </summary> /// <param name="user"></param> /// <param name="pwd">OCeSdjE6K7zhDnoxh07rqg==,是111111的aes加密结果,DF57306D30FED672是平台111111加密结果</param> /// <param name="type"></param> /// <param name="token">登录成功输出token</param> /// <returns></returns> private bool login(string user, string pwd, int sys, out string token) { //移动端过来的密码先通过通用解密,再通过c#加密 pwd = APIAESTool.AesDecrypt(pwd); pwd = DesTool.DesEncrypt(pwd); token = ""; #region 调用基础平台验证用户账号密码 if (IsOpenHbLogin == "1") { string url = LoginUrl + "?RequestParam={%22Param%22:{%22envRoot%22:{%22Product%22:%22BIM%22},%22paramRoot%22:{%22UserName%22:%22" + user + "%22,%22UserPass%22:%22" + pwd + "%22}}}"; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url); request.Method = "GET"; request.ContentType = "multipart/form-data"; string responseStr = string.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding("UTF-8")); responseStr = reader.ReadToEnd().ToString(); reader.Close(); LoginResult result = null; if (!string.IsNullOrEmpty(responseStr)) { result = JsonConvert.DeserializeObject <LoginResult>(responseStr);//将文件信息json字符 } if (result == null || result.errorCode != "0") { return(false); } } } #endregion //获取数据库用户信息 Result <UserView> login = new Result <UserView>(); using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(""))) { login = proxy.Login(user, pwd, IsOpenHbLogin); } if (login.Flag == 0 && login.Data != null) { string tempToken = sys == 1 ? login.Data.AndroidToken : login.Data.IosToken;//模拟用户数据库中的token //先去数据库查询该用户是否有token,没有则生成token if (!string.IsNullOrEmpty(tempToken)) { DateTime expiryTime = sys == 1 ? login.Data.AndroidTokenTime.Value : login.Data.IosTokenTime.Value;//模拟用户数据库中的token过期时间 //如果用户有token,检查是否在有效期 if (DateTime.Now <= expiryTime) { token = tempToken; } } //无token或不在有效期则生成新token if (string.IsNullOrEmpty(token)) { token = CreateToken(sys); } using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(login.Data))) { Result <Base_User> baseUser = proxy.GetUserModel(login.Data.UserId); Base_User u = baseUser.Data; if (sys == 1) { u.AndroidToken = token; u.AndroidTokenTime = DateTime.Now.AddDays(7); } else { u.IosToken = token; u.IosTokenTime = DateTime.Now.AddDays(7); } var xxx = proxy.UpdateUser(u); } //TODO:因目前的token只是一个验证凭据,本身不附带业务信息,所以加密需求不强,但一定要使用https连接;如后期有扩展token需求,需要做加密或签名操作 return(true); } else { return(false); } }
/// <summary> /// 登录验证 /// </summary> /// <param name="Account">账户</param> /// <param name="Password">密码</param> /// <returns></returns> public ActionResult CheckLogin(string Account, string Password, string Token) { string Msg = ""; try { IPScanerHelper objScan = new IPScanerHelper(); string IPAddress = NetHelper.GetIPAddress(); objScan.IP = IPAddress; objScan.DataPath = Server.MapPath("~/Resource/IPScaner/QQWry.Dat"); string IPAddressName = objScan.IPLocation(); string outmsg = ""; VerifyIPAddress(Account, IPAddress, IPAddressName, Token); //系统管理 if (Account == ConfigHelper.AppSettings("CurrentUserName")) { if (ConfigHelper.AppSettings("CurrentPassword") == Password) { IManageUser imanageuser = new IManageUser(); imanageuser.UserId = "System"; imanageuser.Account = "System"; imanageuser.UserName = "******"; imanageuser.Gender = "男"; imanageuser.InnerUser = 1; imanageuser.Code = "System"; imanageuser.LogTime = DateTime.Now; imanageuser.CompanyId = "系统"; imanageuser.DepartmentId = "系统"; imanageuser.IPAddress = IPAddress; imanageuser.IPAddressName = IPAddressName; imanageuser.IsSystem = true; ManageProvider.Provider.AddCurrent(imanageuser); //对在线人数全局变量进行加1处理 HttpContext rq = System.Web.HttpContext.Current; rq.Application["OnLineCount"] = (int)rq.Application["OnLineCount"] + 1; Msg = "3";//验证成功 Base_SysLogBll.Instance.WriteLog(Account, OperationType.Login, "1", "登陆成功、IP所在城市:" + IPAddressName); } else { return(Content("4")); } } else { Base_User base_user = base_userbll.UserLogin(Account, Password, out outmsg); switch (outmsg) { case "-1": //账户不存在 Msg = "-1"; Base_SysLogBll.Instance.WriteLog(Account, OperationType.Login, "-1", "账户不存在、IP所在城市:" + IPAddressName); break; case "lock": //账户锁定 Msg = "2"; Base_SysLogBll.Instance.WriteLog(Account, OperationType.Login, "-1", "账户锁定、IP所在城市:" + IPAddressName); break; case "error": //密码错误 Msg = "4"; Base_SysLogBll.Instance.WriteLog(Account, OperationType.Login, "-1", "密码错误、IP所在城市:" + IPAddressName); break; case "succeed": //验证成功 IManageUser imanageuser = new IManageUser(); imanageuser.UserId = base_user.UserId; imanageuser.InnerUser = base_user.InnerUser ?? 1; imanageuser.Account = base_user.Account; imanageuser.UserName = base_user.RealName; imanageuser.Gender = base_user.Gender; imanageuser.Password = base_user.Password; imanageuser.Code = base_user.Code; imanageuser.Secretkey = base_user.Secretkey; imanageuser.LogTime = DateTime.Now; imanageuser.CompanyId = base_user.CompanyId; imanageuser.DepartmentId = base_user.DepartmentId; imanageuser.ObjectId = base_objectuserrelationbll.GetObjectId(imanageuser.UserId); imanageuser.IPAddress = IPAddress; imanageuser.IPAddressName = IPAddressName; imanageuser.IsSystem = false; ManageProvider.Provider.AddCurrent(imanageuser); //对在线人数全局变量进行加1处理 HttpContext rq = System.Web.HttpContext.Current; rq.Application["OnLineCount"] = (int)rq.Application["OnLineCount"] + 1; Msg = "3"; //验证成功 Base_SysLogBll.Instance.WriteLog(Account, OperationType.Login, "1", "登陆成功、IP所在城市:" + IPAddressName); break; default: break; } } } catch (Exception ex) { Msg = ex.Message; } return(Content(Msg)); }
// POST: /Login/ public JsonResult Login(JObject data) { string UserCode = data.Value <string>("user_code"); string Password = data.Value <string>("password"); string IP = data.Value <string>("ip"); string City = data.Value <string>("city"); data["user_code"] = UserCode; data["password"] = Md5Util.MD5(Password); data["LoginIP"] = IP; data["LoginCity"] = City; AppConnectionString = ConfigurationManager.ConnectionStrings["app"].ConnectionString; DataSet dt = base.RunProcedureDataSet(data, "vdp_sys_Login", "app"); //if (dt.Rows.Count > 0) var ResultID = dt.Tables[0].Rows[0]["result_id"]; var ResultMsg = (string)dt.Tables[0].Rows[0]["result_msg"]; //var loginResult = Base_UserService.Instance.Login(UserCode, Md5Util.MD5(Password), IP, City); if (ResultID.ToString() == "0") { ////登录成功后,查询当前用户数据 //var user = Base_UserService.Instance.GetEntity(ParamQuery.Instance() // .AndWhere("UserCode", UserCode).AndWhere("Password", Md5Util.MD5(Password)) // .AndWhere("Enabled", 1).AndWhere("IsAudit", 1)); //user.DepartmentCode = ""; //调用框架中的登录机制 Base_User b = new Base_User(); b.city = "";// (string)dt.Rows[0]["city"]; b.RealName = (string)dt.Tables[1].Rows[0]["real_name"]; b.DepartmentID = (int)dt.Tables[1].Rows[0]["department_id"]; b.UserId = (int)dt.Tables[1].Rows[0]["id"]; b.UserCode = (String)dt.Tables[1].Rows[0]["user_code"]; b.RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"]; b.DepartmentCode = ((int)dt.Tables[1].Rows[0]["department_id"]).ToString(); var loginer = new BaseLoginer { UserId = (int)dt.Tables[1].Rows[0]["id"], //. user.UserId, UserCode = (string)dt.Tables[1].Rows[0]["user_code"], // user.UserCode, // Password = (string)dt.Tables[1].Rows[0]["Password"],// user.Password, UserName = (string)dt.Tables[1].Rows[0]["real_name"], // user.RealName, RoleIDs = (string)dt.Tables[1].Rows[0]["role_ids"], // DepartmentCode =((int)dt.Tables[1].Rows[0]["DepartmentID"]).ToString(), Data = b, IsAdmin = false// user.UserType == 1 //根据用户UserType判断。用户类型:0=未定义 1=超级管理员 2=普通用户 3=其他 }; Session["logininfo"] = ""; //读取配置登录默认失效时长:小时 var effectiveHours = Convert.ToInt32(60 * ConfigUtil.GetConfigDecimal("LoginEffectiveHours")); //执行web登录 FormsAuth.SignIn(loginer.UserId.ToString(), loginer, effectiveHours); LogHelper.Write("登录成功!用户:" + loginer.UserName + ",账号:" + UserCode + ",密码:---"); //设置服务基类中,当前登录用户信息 //this.CurrentBaseLoginer = loginer; //登陆后处理 //更新用户登陆次数及时间(存储过程登录,数据库已经处理) //添加登录日志 string userinfo = string.Format("用户姓名:{0},用户编号:{1},登录账号:{2},登录密码:{3}", loginer.UserName, loginer.UserId, loginer.UserCode, "---" /*loginer.Password*/); // Base_SysLogService.Instance.AddLoginLog(userinfo, IP, City); //更新其它业务 } else { LogHelper.Write("登录失败!账号:" + UserCode + ",密码:" + Password + "。原因:" + ResultMsg); } return(Json(new { s = ResultID, message = ResultMsg }, JsonRequestBehavior.DenyGet)); }
public int DeleteUser(Base_User user) { user.DeleteMark = 1; return(dbUtil._myDb.Update(user)); }
/// <summary> /// 保存用户表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="userEntity">用户实体</param> /// <returns></returns> public string SaveForm(string keyValue, UserEntity userEntity) { try { using (var tran = QSDMS_SQLDB.GetInstance().GetTransaction()) { #region 基本信息 if (!string.IsNullOrEmpty(keyValue)) { userEntity.Modify(keyValue); userEntity.Password = null; Base_User model = Base_User.SingleOrDefault("where UserId=@0", keyValue); model = EntityConvertTools.CopyToModel <UserEntity, Base_User>(userEntity, model); model.UserId = keyValue; model.Update(); } else { userEntity.Create(); keyValue = userEntity.UserId; userEntity.Secretkey = Md5Helper.MD5(CommonHelper.CreateNo(), 16).ToLower(); userEntity.Password = Md5Helper.MD5(DESEncrypt.Encrypt(userEntity.Password, userEntity.Secretkey).ToLower(), 32).ToLower(); userEntity.EnabledMark = 1; userEntity.DeleteMark = 0; Base_User model = EntityConvertTools.CopyToModel <UserEntity, Base_User>(userEntity, null); model.Insert(); } #endregion #region 默认添加 角色、岗位、职位 Base_UserRelation.Delete("where UserId=@0 and IsDefault=1", userEntity.UserId); List <UserRelationEntity> userRelationEntitys = new List <UserRelationEntity>(); //角色 这里多个角色逻辑处理 //if (!string.IsNullOrEmpty(userEntity.RoleId)) //{ // userRelationEntitys.Add(new UserRelationEntity // { // Category = (int)QSDMS.Model.Enums.UserCategoryEnum.角色, // UserRelationId = Guid.NewGuid().ToString(), // UserId = userEntity.UserId, // ObjectId = userEntity.RoleId, // CreateDate = DateTime.Now, // CreateUserId = OperatorProvider.Provider.Current().UserId, // CreateUserName = OperatorProvider.Provider.Current().UserName, // IsDefault = 1, // }); //} //一个用户多个角色 if (!string.IsNullOrEmpty(userEntity.RoleId)) { Base_UserRole.Delete("where UserId=@0", userEntity.UserId); string[] roles = userEntity.RoleId.Split(','); for (int i = 0; i < roles.Length; i++) { //用户角色表 string roleid = roles[i]; var userrole = new UserRoleEntity(); userrole.UserRoleId = Util.Util.NewUpperGuid(); userrole.UserId = userEntity.UserId; userrole.RoleId = roleid.Split('|')[0]; userrole.RoleName = roleid.Split('|')[1]; Base_UserRole model = EntityConvertTools.CopyToModel <UserRoleEntity, Base_UserRole>(userrole, null); model.Insert(); //用户关系表 userRelationEntitys.Add(new UserRelationEntity { Category = (int)QSDMS.Model.Enums.UserCategoryEnum.角色, UserRelationId = Guid.NewGuid().ToString(), UserId = userEntity.UserId, ObjectId = userrole.RoleId, CreateDate = DateTime.Now, CreateUserId = OperatorProvider.Provider.Current().UserId, CreateUserName = OperatorProvider.Provider.Current().UserName, IsDefault = 1, }); } } //岗位 if (!string.IsNullOrEmpty(userEntity.DutyId)) { userRelationEntitys.Add(new UserRelationEntity { Category = (int)QSDMS.Model.Enums.UserCategoryEnum.岗位, UserRelationId = Guid.NewGuid().ToString(), UserId = userEntity.UserId, ObjectId = userEntity.DutyId, CreateDate = DateTime.Now, CreateUserId = OperatorProvider.Provider.Current().UserId, CreateUserName = OperatorProvider.Provider.Current().UserName, IsDefault = 1, }); } //职位 if (!string.IsNullOrEmpty(userEntity.PostId)) { userRelationEntitys.Add(new UserRelationEntity { Category = (int)QSDMS.Model.Enums.UserCategoryEnum.职位, UserRelationId = Guid.NewGuid().ToString(), UserId = userEntity.UserId, ObjectId = userEntity.PostId, CreateDate = DateTime.Now, CreateUserId = OperatorProvider.Provider.Current().UserId, CreateUserName = OperatorProvider.Provider.Current().UserName, IsDefault = 1, }); } //插入用户关系表 foreach (UserRelationEntity userRelationItem in userRelationEntitys) { Base_UserRelation model = EntityConvertTools.CopyToModel <UserRelationEntity, Base_UserRelation>(userRelationItem, null); model.Insert(); } #endregion Base_UserAuthorize.Delete("where UserId=@0", userEntity.UserId); //插入用户对应数据权限 if (!string.IsNullOrEmpty(userEntity.AuthorizeDataId)) { string[] uthorizeDatas = userEntity.AuthorizeDataId.Split(','); for (int i = 0; i < uthorizeDatas.Length; i++) { string objectid = uthorizeDatas[i]; var userAuthorize = new UserAuthorizeEntity(); userAuthorize.UserAuthorizeId = Util.Util.NewUpperGuid(); userAuthorize.UserId = userEntity.UserId; userAuthorize.ObjectId = objectid.Split('|')[0]; userAuthorize.ObjectName = objectid.Split('|')[1]; Base_UserAuthorize model = EntityConvertTools.CopyToModel <UserAuthorizeEntity, Base_UserAuthorize>(userAuthorize, null); model.Insert(); } } tran.Complete(); } return(keyValue); } catch (Exception ex) { throw ex; } }
public int Delete(Base_User user) { return(login.Delete(user)); }
/// <summary> /// 获得单前模块的单据编号如果没有定义规则就返回空 /// </summary> /// <param name="userId">用户ID</param> /// <param name="moduleId">模块ID</param> /// <returns>单据号</returns> public string GetBillCode(string userId, string moduleId) { IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); //获得模板ID string billCode = "";//单据号 Base_User base_user = database.FindEntity <Base_User>(userId); Base_CodeRule base_coderule = Repository().FindEntity("ModuleId", moduleId); try { int nowSerious = 0; //取得流水号种子 List <Base_CodeRuleSerious> base_coderuleseriouslist = database.FindList <Base_CodeRuleSerious>("CodeRuleId", base_coderule.CodeRuleId); //取得最大种子 Base_CodeRuleSerious maxCodeRuleSerious = base_coderuleseriouslist.Find(delegate(Base_CodeRuleSerious p) { return(p.ValueType == "0" && p.UserId == null); }); if (!string.IsNullOrEmpty(base_coderule.CodeRuleId)) { List <Base_CodeRuleDetail> base_coderuledetailList = database.FindList <Base_CodeRuleDetail>("CodeRuleId", base_coderule.CodeRuleId); foreach (Base_CodeRuleDetail base_coderuledetail in base_coderuledetailList) { switch (base_coderuledetail.FullName) { //自定义项 case "0": billCode = billCode + base_coderuledetail.FormatStr; break; //日期 case "1": //日期字符串类型 billCode = billCode + DateTime.Now.ToString(base_coderuledetail.FormatStr); //处理自动更新流水号 if (base_coderuledetail.AutoReset == 1) { //判断是否有流水号 if (maxCodeRuleSerious != null) { //当上次更新时间跟本次日期不一致时重置流水号种子 if (maxCodeRuleSerious.LastUpdateDate != DateTime.Now.ToString(base_coderuledetail.FormatStr)) { maxCodeRuleSerious.LastUpdateDate = DateTime.Now.ToString(base_coderuledetail.FormatStr); //更新最后更新时间 maxCodeRuleSerious.NowValue = 1; //重置种子 database.Update <Base_CodeRuleSerious>(maxCodeRuleSerious, isOpenTrans); //重置种子以后删除掉之前用户占用了的种子。 StringBuilder deleteSql = new StringBuilder(string.Format("delete Base_CodeRuleSerious where CodeRuleId='{0} AND UserId IS NOT NULL '", base_coderule.CodeRuleId)); database.ExecuteBySql(deleteSql, isOpenTrans); } } } break; //流水号 case "2": //查找当前用户是否已有之前未用掉的种子 Base_CodeRuleSerious base_coderuleserious = base_coderuleseriouslist.Find(delegate(Base_CodeRuleSerious p) { return(p.UserId == userId && p.Enabled == 1); }); //如果没有就取当前最大的种子 if (base_coderuleserious == null) { //取得系统最大的种子 int maxSerious = (int)maxCodeRuleSerious.NowValue; nowSerious = maxSerious; base_coderuleserious = new Base_CodeRuleSerious(); base_coderuleserious.Create(); base_coderuleserious.NowValue = maxSerious; base_coderuleserious.UserId = userId; base_coderuleserious.ValueType = "1"; base_coderuleserious.Enabled = 1; base_coderuleserious.CodeRuleId = base_coderule.CodeRuleId; database.Insert <Base_CodeRuleSerious>(base_coderuleserious, isOpenTrans); //处理种子更新 maxCodeRuleSerious.NowValue += 1; //种子自增 database.Update <Base_CodeRuleSerious>(maxCodeRuleSerious, isOpenTrans); } else { nowSerious = (int)base_coderuleserious.NowValue; } string seriousStr = new string('0', (int)(base_coderuledetail.FLength)) + nowSerious.ToString(); seriousStr = seriousStr.Substring(seriousStr.Length - (int)(base_coderuledetail.FLength)); billCode = billCode + seriousStr; break; //部门 case "3": Base_Department base_department = database.FindEntity <Base_Department>(base_user.DepartmentId); billCode = billCode + base_coderuledetail.FormatStr; if (base_coderuledetail.FormatStr == "code") { billCode = billCode + base_department.Code; } else { billCode = billCode + base_department.FullName; } break; //公司 case "4": Base_Company base_company = database.FindEntity <Base_Company>(base_user.CompanyId); if (base_coderuledetail.FormatStr == "code") { billCode = billCode + base_company.Code; } else { billCode = billCode + base_company.FullName; } break; //用户 case "5": if (base_coderuledetail.FormatStr == "code") { billCode = billCode + base_user.Code; } else { billCode = billCode + base_user.Account; } break; default: break; } } } } catch (Exception ex) { Base_SysLogBll.Instance.WriteLog("", OperationType.Other, "-1", string.Format("{0}在获取{1}单据编码时错误:", base_user.RealName, base_coderule.FullName) + ex.Message); database.Rollback(); return(billCode); } database.Commit(); return(billCode); }
public int AddUser(Base_User user) { return(dbUtil._myDb.Insert(user)); }
public ActionResult SubmitUserForm(string KeyValue, Ho_PartnerUser model, string BuildFormJson) { IDatabase database = DataFactory.Database(); DbTransaction isOpenTrans = database.BeginTrans(); try { string Message = KeyValue == "" ? "新增成功。" : "编辑成功。"; if (!string.IsNullOrEmpty(KeyValue)) { var userList = database.FindList <Base_User>(" and Account = '" + model.Account + "'"); if (model.UserRole == "运营商")//选择了运营商才添加 { if (userList.Count < 1) { //如果添加运营商,则要往后台用户表添加一个帐号 var user = new Base_User() { Account = model.Account, Password = "******", RealName = model.Name, Mobile = model.Account, SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")), InnerUser = 3, DepartmentId = "运营商", CompanyId = KeyValue, //把用户编号记录 Code = "bd548d5b-1783-4582-9007-bb5c87803679" }; user.Create(); user.Password = model.Password; database.Insert(user, isOpenTrans); //权限分配-复制上级权限-bd548d5b-1783-4582-9007-bb5c87803679(此用户不能删除) CopyUserRight("bd548d5b-1783-4582-9007-bb5c87803679", user.UserId, isOpenTrans); } else { //修改后台用户信息 userList[0].Account = model.Account; userList[0].RealName = model.Name; userList[0].ModifyDate = DateTime.Now; database.Update(userList[0]); } } else { if (userList.Count > 0) { //删除已有后台用户 database.Delete <Base_User>(userList[0].UserId); } } model.Modify(KeyValue); var IsOk = database.Update(model, isOpenTrans); Base_SysLogBll.Instance.WriteLog(KeyValue, OperationType.Update, IsOk > 0 ? "成功" : "失败", "用户" + Message); } else //新建 { //检测手机号和身份证号的唯一性 var accountIsMobile = database.FindEntityByWhere <Ho_PartnerUser>(" and Account='" + model.Account + "'"); if (accountIsMobile != null && accountIsMobile.Number != null) { return(Content(new JsonMessage { Success = false, Code = "1", Message = "手机号码已存在" }.ToString())); } if (!string.IsNullOrEmpty(model.CardCode)) { var accountIsCardCode = database.FindEntityByWhere <Ho_PartnerUser>(" and CardCode='" + model.CardCode + "'"); if (accountIsCardCode != null && accountIsCardCode.Number != null) { return(Content(new JsonMessage { Success = false, Code = "1", Message = "身份证号码已存在" }.ToString())); } } model.Password = PasswordHash.CreateHash(model.Password); model.Create(); var IsOk = database.Insert(model, isOpenTrans); if (model.UserRole == "运营商")//选择了运营商才添加 { //如果添加运营商,则要往后台用户表添加一个帐号 var user = new Base_User() { Account = model.Account, Password = model.Password, RealName = model.Name, Mobile = model.Account, SortCode = CommonHelper.GetInt(BaseFactory.BaseHelper().GetSortCode <Base_User>("SortCode")), InnerUser = 3, DepartmentId = "运营商", CompanyId = model.Number, Code = "bd548d5b-1783-4582-9007-bb5c87803679" }; user.Create(); database.Insert(user, isOpenTrans); //权限分配-复制上级权限-bd548d5b-1783-4582-9007-bb5c87803679(此用户不能删除) CopyUserRight("bd548d5b-1783-4582-9007-bb5c87803679", user.UserId, isOpenTrans); } Base_SysLogBll.Instance.WriteLog(KeyValue, OperationType.Update, IsOk > 0 ? "成功" : "失败", "用户" + Message); } database.Commit(); return(Content(new JsonMessage { Success = true, Code = "1", Message = Message }.ToString())); } catch (Exception ex) { database.Rollback(); return(Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString())); } }
public int UpdateUser(Base_User user) { return(dbUtil._myDb.Update(user)); }