/// <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);
}
