/// <summary> /// 数据更新 /// </summary> /// <param name="userModel">数据库实体</param> /// <returns>影响记录条数</returns> public int Update(Model.TableModel.Sys_user userModel) { return(DbEngine.QueryInt <Model.TableModel.Sys_user>("update", new List <Model.TableModel.Sys_user>() { userModel })); }
/// <summary> /// 视图类转实体类 /// </summary> /// <param name="model">视图类</param> /// <returns>实体类</returns> private ModelView.SysUserView Model2View(Model.TableModel.Sys_user model) { ModelView.SysUserView view = new ModelView.SysUserView(); view.id = model.id; view.company_no = model.company_no; view.dept_no = model.dept_no; view.factory_no = model.factory_no; view.is_worker = model.is_worker ? "是" : "否"; view.line_no = model.line_no; view.loginable = model.loginable ? "是" : "否"; view.pwd_changeable = model.pwd_changeable ? "是" : "否"; view.status_name = model.status_name; view.status_no = model.status_no; view.user_address = model.user_address; view.user_card_id = model.user_card_id; view.user_card_no = model.user_card_no; view.user_email = model.user_email; view.user_gender = model.user_gender; view.user_mobile = model.user_mobile; view.user_name = model.user_name; view.user_no = model.user_no; view.user_phone = model.user_phone; view.user_position = model.user_position; view.user_pwd = "******"; view.valid_start_time = model.valid_start_time.HasValue ? ((DateTime)model.valid_start_time).ToString("yyyy-MM-dd HH:mm:ss.fff") : string.Empty; view.valid_stop_time = model.valid_stop_time.HasValue ? ((DateTime)model.valid_stop_time).ToString("yyyy-MM-dd HH:mm:ss.fff") : string.Empty; view.workshop_no = model.workshop_no; return(view); }
/// <summary> /// 数据更新 /// </summary> /// <param name="newValue">更新后对象</param> /// <returns>影响记录条数</returns> public int Update(ModelView.SysUserView newValue) { Model.TableModel.Sys_user model = View2Model(newValue); List <Model.TableModel.Sys_user> modelList = new List <Model.TableModel.Sys_user>(); modelList.Add(model); return(DbEngine.QueryInt <Model.TableModel.Sys_user>("update", modelList)); }
/// <summary> /// 根据用户编号获取用户名 /// </summary> /// <param name="userNo">用户编号</param> /// <returns>用户名</returns> public string GetUserName(string userNo) { Ctrl.SysUserCtrl sysUserCtrl = new SysUserCtrl(); Model.TableModel.Sys_user userModel = sysUserCtrl.GetUserModel(userNo); if (userModel == null) { return(string.Empty); } return(userModel.user_name); }
/// <summary> /// 用户校验 /// </summary> /// <param name="userNo">用户编号</param> /// <param name="userPwd">用户密码</param> /// <returns>校验结果</returns> public bool UserValid(string userNo, string userPwd) { Ctrl.SysUserCtrl sysUserCtrl = new SysUserCtrl(); Model.TableModel.Sys_user userModel = sysUserCtrl.GetUserModel(userNo); if (userModel == null) { return(false); } return(Common.Md5Operate.GetMD5String(userPwd) == userModel.user_pwd); }
/// <summary> /// 删除操作 /// </summary> /// <param name="oldValues">要删除的多个值</param> /// <returns>影响记录条数</returns> public int Delete(List <ModelView.SysUserView> oldValues) { List <Model.TableModel.Sys_user> modelList = new List <Model.TableModel.Sys_user>(); foreach (ModelView.SysUserView item in oldValues) { Model.TableModel.Sys_user model = View2Model(item); modelList.Add(model); } return(DbEngine.QueryInt <Model.TableModel.Sys_user>("Delete", modelList)); }
/// <summary> /// 修改用户密码 /// </summary> /// <param name="userNo">用户编号</param> /// <returns>修改结果</returns> public bool ChangePwd(string userNo, string oldPwd, string newPwd) { Ctrl.SysUserCtrl sysUserCtrl = new SysUserCtrl(); Model.TableModel.Sys_user userModel = sysUserCtrl.GetUserModel(userNo); if (userModel == null) { return(false); } if (Common.Md5Operate.GetMD5String(oldPwd) != userModel.user_pwd) { return(false); } userModel.user_pwd = Common.Md5Operate.GetMD5String(newPwd); return(sysUserCtrl.Update(userModel) > 0); }
/// <summary> /// 视图类转实体类 /// </summary> /// <param name="view">视图类</param> /// <returns>实体类</returns> private Model.TableModel.Sys_user View2Model(ModelView.SysUserView view) { Model.TableModel.Sys_user model = new Model.TableModel.Sys_user(); if (string.IsNullOrEmpty(view.id)) { model.id = Common.Md5Operate.CreateGuidId(); } else { model.id = view.id; } model.status_name = view.status_name; model.status_no = string.IsNullOrEmpty(view.status_no) ? "310" : view.status_no; GlobalDataCtrl globalDataCtrl = new GlobalDataCtrl(); model.user_no = string.IsNullOrEmpty(view.user_no) ? globalDataCtrl.GetNextNoByTblName("sys_user") : view.user_no; model.user_name = view.user_name; model.user_card_id = view.user_card_id; model.user_card_no = view.user_card_no; model.user_pwd = string.IsNullOrEmpty(view.user_pwd) ? Common.Md5Operate.GetMD5String("123456") : Common.Md5Operate.GetMD5String(view.user_pwd); switch (view.user_gender) { case "男": model.user_gender = "男"; break; case "女": model.user_gender = "女"; break; default: model.user_gender = "未知"; break; } if (view.loginable == "是") { model.loginable = true; } else { model.loginable = false; } if (view.pwd_changeable == "是") { model.pwd_changeable = true; } else { model.pwd_changeable = false; } DateTime dt = DateTime.Now; if (string.IsNullOrEmpty(view.valid_start_time)) { model.valid_start_time = null; } else { model.valid_start_time = DateTime.TryParse(view.valid_start_time, out dt) ? dt:(DateTime?)null; } if (string.IsNullOrEmpty(view.valid_stop_time)) { model.valid_stop_time = null; } else { model.valid_stop_time = DateTime.TryParse(view.valid_stop_time, out dt) ? dt : (DateTime?)null; } model.user_position = view.user_position; model.user_email = view.user_email; model.user_phone = view.user_phone; model.user_mobile = view.user_mobile; model.user_address = view.user_address; model.company_no = string.IsNullOrEmpty(view.company_no) ? "dfs_c" : view.company_no; model.dept_no = string.IsNullOrEmpty(view.dept_no) ? "01" : view.dept_no; model.factory_no = string.IsNullOrEmpty(view.factory_no) ? "dfs_f" : view.factory_no; model.workshop_no = string.IsNullOrEmpty(view.workshop_no) ? "ws01" : view.workshop_no; model.line_no = string.IsNullOrEmpty(view.line_no) ? "line01" : view.line_no; if (view.pwd_changeable == "是") { model.pwd_changeable = true; } else { model.pwd_changeable = false; } return(model); }