/// <summary>
/// 更新处理
/// </summary>
/// <returns></returns>
private bool Update_deal()
{
var result = new UserResourceBLL().Update(param, GetLoginUserId(), id);
if (result == ERROR_CODE.SUCCESS)
{
Response.Write("<script>alert('员工修改成功！');</script>");
paramcopy = param;
return(true);
}
else if (result == ERROR_CODE.USER_NOT_FIND)// 用户丢失
{
Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
Response.Redirect("Login.aspx");
return(false);
}
else if (result == ERROR_CODE.EXIST)
{
Response.Write("<script>alert('存在相同用户名，请修改！');</script>");
}
else if (result == ERROR_CODE.SYS_NAME_EXIST)
{
Response.Write("<script>alert('该姓名已存在！');</script>");
return(false);
}
return(false);
}
/// <summary>
/// 新增员工信息
/// </summary>
/// <param name="data"></param>
/// <param name="user_id"></param>
/// <param name="id"></param>
/// <returns></returns>
public ERROR_CODE Insert(SysUserAddDto data, long user_id, out long id)
{
id = data.sys_res.id = _dal.GetNextIdCom();
sys_resource findRes;
if (string.IsNullOrEmpty(data.sys_res.mobile_phone))
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where email='{data.sys_res.email}' and delete_time=0");
}
else
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where (email='{data.sys_res.email}' or mobile_phone='{data.sys_res.mobile_phone}') and delete_time=0");
}
if (findRes != null)
{
return(ERROR_CODE.SYS_NAME_EXIST);
}
data.sys_res.create_user_id = data.sys_res.update_user_id = user_id;
data.sys_res.create_time = data.sys_res.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Insert(data.sys_res);
//操作日志新增一条日志,操作对象种类：员工
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS, //员工
oper_object_id = data.sys_res.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data.sys_res),
remark = "保存员工信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
data.sys_user.id = id;
//加密
data.sys_user.password = new Tools.Cryptographys().SHA1Encrypt(data.sys_user.password);
new sys_user_dal().Insert(data.sys_user);
add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS,
oper_object_id = data.sys_user.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data.sys_user),
remark = "保存客户信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log);
if (data.timeoffPolicy != null)
{
new TimeOffPolicyBLL().AddTimeoffResource(id.ToString(), data.timeoffPolicy.timeoff_policy_id, data.timeoffPolicy.effective_date, user_id);
}
if (data.internalCost != null && data.internalCost.Count > 0)
{
var costDal = new sys_resource_internal_cost_dal();
foreach (var cost in data.internalCost)
{
cost.resource_id = id;
cost.id = costDal.GetNextIdCom();
costDal.Insert(cost);
}
}
if (data.availability != null)
{
data.availability.id = _dal.GetNextIdCom();
data.availability.resource_id = id;
data.availability.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
data.availability.update_time = data.availability.create_time;
data.availability.create_user_id = user_id;
data.availability.update_user_id = user_id;
new sys_resource_availability_dal().Insert(data.availability);
}
sys_resource_additional_time_dal timeDal = new sys_resource_additional_time_dal();
if (data.addTime1 != null)
{
data.addTime1.id = timeDal.GetNextIdCom();
data.addTime1.resource_id = id;
timeDal.Insert(data.addTime1);
}
if (data.addTime2 != null)
{
data.addTime2.id = timeDal.GetNextIdCom();
data.addTime2.resource_id = id;
timeDal.Insert(data.addTime2);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 更新员工信息
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <param name="resourceId"></param>
/// <returns></returns>
public ERROR_CODE Update(SysUserAddDto data, long userId, long resourceId)
{
// 检查邮箱和手机号是否重复
sys_resource findRes;
if (string.IsNullOrEmpty(data.sys_res.mobile_phone))
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where email='{data.sys_res.email}' and id<>{data.sys_res.id} and delete_time=0");
}
else
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where (email='{data.sys_res.email}' or mobile_phone='{data.sys_res.mobile_phone}') and id<>{data.sys_res.id} and delete_time=0");
}
if (findRes != null)
{
return(ERROR_CODE.SYS_NAME_EXIST);
}
var resOld = GetResourceById(resourceId);
data.sys_res.update_user_id = userId;
data.sys_res.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
var desc = OperLogBLL.CompareValue <sys_resource>(resOld, data.sys_res);
if (!string.IsNullOrEmpty(desc))
{
_dal.Update(data.sys_res);
OperLogBLL.OperLogUpdate(desc, data.sys_res.id, userId, OPER_LOG_OBJ_CATE.RESOURCE, "编辑员工");
}
var userDal = new sys_user_dal();
var userOld = userDal.FindById(resourceId);
if (userOld.password != data.sys_user.password)
{
data.sys_user.password = new Tools.Cryptographys().SHA1Encrypt(data.sys_user.password);
}
desc = OperLogBLL.CompareValue <sys_user>(userOld, data.sys_user);
if (!string.IsNullOrEmpty(desc))
{
userDal.Update(data.sys_user);
OperLogBLL.OperLogUpdate(desc, data.sys_user.id, userId, OPER_LOG_OBJ_CATE.RESOURCE, "编辑员工");
}
// 员工每天工作时间
var dal = new sys_resource_availability_dal();
var ava = dal.FindSignleBySql <sys_resource_availability>($"select * from sys_resource_availability where resource_id={resourceId} and delete_time=0");
if (ava == null)
{
data.availability.id = dal.GetNextIdCom();
data.availability.resource_id = resourceId;
data.availability.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
data.availability.update_time = data.availability.create_time;
data.availability.create_user_id = userId;
data.availability.update_user_id = userId;
dal.Insert(data.availability);
}
else
{
data.availability.id = ava.id;
data.availability.resource_id = resourceId;
data.availability.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
data.availability.update_user_id = userId;
data.availability.create_time = ava.create_time;
data.availability.create_user_id = ava.create_user_id;
dal.Update(data.availability);
}
// 员工休假-额外时间
sys_resource_additional_time_dal timeDal = new sys_resource_additional_time_dal();
if (data.addTime1 != null)
{
var time1 = timeDal.FindSignleBySql <sys_resource_additional_time>($"select * from sys_resource_additional_time where resource_id={resourceId} and period_year={data.addTime1.period_year.Value}");
if (time1 == null)
{
data.addTime1.id = timeDal.GetNextIdCom();
data.addTime1.resource_id = resourceId;
timeDal.Insert(data.addTime1);
}
else
{
time1.time_vacation = data.addTime1.time_vacation;
time1.time_personal = data.addTime1.time_personal;
time1.time_sick = data.addTime1.time_sick;
time1.time_float = data.addTime1.time_float;
timeDal.Update(time1);
}
}
if (data.addTime2 != null)
{
var time2 = timeDal.FindSignleBySql <sys_resource_additional_time>($"select * from sys_resource_additional_time where resource_id={resourceId} and period_year={data.addTime2.period_year.Value}");
if (time2 == null)
{
data.addTime2.id = timeDal.GetNextIdCom();
data.addTime2.resource_id = resourceId;
timeDal.Insert(data.addTime2);
}
else
{
time2.time_vacation = data.addTime2.time_vacation;
time2.time_personal = data.addTime2.time_personal;
time2.time_sick = data.addTime2.time_sick;
time2.time_float = data.addTime2.time_float;
timeDal.Update(time2);
}
}
return(ERROR_CODE.SUCCESS);
}
