public JsonResult DeleteImage(string imageType)
{
string id = GetQueryString("ID");
S_HR_Employee entity = ComprehensiveDbContext.Set <S_HR_Employee>().Find(id);
if (entity != null)
{
switch (imageType)
{
case "Portrait":
entity.Portrait = null;
break;
case "IdentityCardFace":
entity.IdentityCardFace = null;
break;
case "IdentityCardBack":
entity.IdentityCardBack = null;
break;
case "Sign":
entity.SignImage = null;
break;
}
}
ComprehensiveDbContext.SaveChanges();
return(Json(new { ID = id, ImageType = imageType }));
}
protected override void AfterSave(Dictionary <string, string> dic, Base.Logic.Domain.S_UI_Form formInfo, bool isNew)
{
var employee = ComprehensiveDbContext.Set <S_HR_Employee>().Find(dic.GetValue("EmployeeID"));
var fo = new EmployeeFo();
fo.SyncDeptByJob(employee);
//base.AfterSave(dic, formInfo, isNew);
}
public JsonResult SaveExcelData()
{
var reader = new System.IO.StreamReader(HttpContext.Request.InputStream);
string data = reader.ReadToEnd();
var tempdata = JsonConvert.DeserializeObject <Dictionary <string, string> >(data);
var list = JsonConvert.DeserializeObject <List <Dictionary <string, string> > >(tempdata["data"]);
//var currentUser = FormulaHelper.GetUserInfo();
//var orgService = FormulaHelper.GetService<IOrgService>();
//var orgs = orgService.GetOrgs();
foreach (var salaryDic in list)
{
var salary = new T_HR_SalaryManage();
UpdateEntity <T_HR_SalaryManage>(salary, salaryDic);
if (salary.ID == null)
{
salary.ID = FormulaHelper.CreateGuid();
}
EntityCreateLogic <T_HR_SalaryManage>(salary);
var code = salaryDic["Code"];
var currentInfo = ComprehensiveDbContext.Set <S_HR_Employee>().FirstOrDefault(d => d.Code == code && d.IsDeleted == "0");
if (currentInfo != null)
{
salary.EmployeeName = currentInfo.Name;
salary.Employee = currentInfo.ID;
salary.DeptName = currentInfo.DeptName;
salary.Dept = currentInfo.Dept;
salary.Position = currentInfo.Post;
}
//if (!String.IsNullOrEmpty(salary.DeptName))
//{
// var dept = orgs.FirstOrDefault(d => d.Name == salary.DeptName);
// if (dept != null)
// {
// salary.Dept = dept.ID;
// salary.DeptName = dept.Name;
// }
//}
//if (string.IsNullOrWhiteSpace(salary.EmployeeName))
//{
// salary.EmployeeName = salary.Employee;
//}
this.ComprehensiveDbContext.Set <T_HR_SalaryManage>().Add(salary);
ComprehensiveDbContext.SaveChanges();
}
return(Json("Success"));
}
protected override void BeforeSave(Dictionary <string, string> dic, Base.Logic.Domain.S_UI_Form formInfo, bool isNew)
{
var isMain = dic.GetValue("IsMain");
var ID = dic.GetValue("ID");
var employeeID = dic.GetValue("EmployeeID");
if (isMain == "1")
{
var list = ComprehensiveDbContext.Set <S_HR_EmployeeJob>().Where(c => c.IsMain == isMain && c.ID != ID && c.IsDeleted == "0" && c.EmployeeID == employeeID).ToList();
if (list.Count > 0)
{
throw new Formula.Exceptions.BusinessValidationException(string.Format("已存在主责部门职务【{0}:{1}】！", list.FirstOrDefault().DeptIDName, list.FirstOrDefault().JobName));
}
}
//base.BeforeSave(dic, formInfo, isNew);
}
public override JsonResult Delete()
{
string listIDs = Request["ListIDs"];
string[] idArray = listIDs.Split(',');
ComprehensiveDbContext.Set <S_HR_Employee>().Where(c => idArray.Contains(c.ID)).Update(c =>
{
c.IsDeleted = "1";
c.DeleteTime = DateTime.Now;
});
ComprehensiveDbContext.SaveChanges();
EmployeeFo fo = new EmployeeFo();
fo.EmployeeDeleteToUser(listIDs);
return(Json(""));
//return base.Delete();
}
public override JsonResult Delete()
{
string ids = Request["ListIDs"];
string[] idArray = ids.Split(',');
string employeeID = GetQueryString("EmployeeID");
ComprehensiveDbContext.Set <S_HR_EmployeeJob>().Delete(c => idArray.Contains(c.ID));
ComprehensiveDbContext.SaveChanges();
var employee = ComprehensiveDbContext.Set <S_HR_Employee>().Find(employeeID);
var fo = new EmployeeFo();
fo.SyncDeptByJob(employee);
return(Json(""));
}
protected override void AfterSave(Dictionary <string, string> dic, Base.Logic.Domain.S_UI_Form formInfo, bool isNew)
{
var employee = ComprehensiveDbContext.Set <S_HR_Employee>().Find(dic.GetValue("EmployeeID"));
if (employee != null)
{
//var isMain = dic.GetValue("IsMain");
var ID = dic.GetValue("ID");
var postList = ComprehensiveDbContext.Set <S_HR_EmployeeWorkPost>().Where(a => a.EmployeeID == employee.ID && a.ID != ID).ToList();
foreach (var item in postList)
{
item.IsMain = "0";
}
employee.Post = dic.GetValue("Post");
employee.PostLevel = dic.GetValue("PostLevel");
ComprehensiveDbContext.SaveChanges();
}
}
public ActionResult GetPic(string id, string imageType)
{
ImageActionResult result = null;
IUserService service = FormulaHelper.GetService <IUserService>();
S_HR_Employee entity = ComprehensiveDbContext.Set <S_HR_Employee>().Find(id);
byte[] img = null;
if (entity != null)
{
switch (imageType)
{
case "Portrait":
img = entity.Portrait;
break;
case "IdentityCardFace":
img = entity.IdentityCardFace;
break;
case "IdentityCardBack":
img = entity.IdentityCardBack;
break;
case "Sign":
img = entity.SignImage;
break;
}
if (img != null)
{
Image image = ImageHelper.BytesToImage(img);
if (image != null)
{
ImageFormat imageFormat = ImageHelper.GetImageFormat(image);
result = new ImageActionResult(image, imageFormat);
}
}
}
return(result);
}
public override JsonResult Delete()
{
string ids = Request["ListIDs"];
string[] idArray = ids.Split(',');
string employeeID = GetQueryString("EmployeeID");
ComprehensiveDbContext.Set <S_HR_EmployeeWorkPost>().Delete(c => idArray.Contains(c.ID));
ComprehensiveDbContext.SaveChanges();
var employee = ComprehensiveDbContext.Set <S_HR_Employee>().Find(employeeID);
if (employee != null)
{
employee.Post = null;
employee.PostLevel = null;
ComprehensiveDbContext.SaveChanges();
}
return(Json(""));
//return base.Delete();
}
public JsonResult ValidateData()
{
var reader = new System.IO.StreamReader(HttpContext.Request.InputStream);
string data = reader.ReadToEnd();
var tempdata = JsonConvert.DeserializeObject <Dictionary <string, string> >(data);
var excelData = JsonConvert.DeserializeObject <ExcelData>(tempdata["data"]);
var errors = excelData.Vaildate(e =>
{
if (e.FieldName == "Code")
{
if (!string.IsNullOrWhiteSpace(e.Value))
{
var user = ComprehensiveDbContext.Set <S_HR_Employee>().FirstOrDefault(d => d.Code == e.Value);
if (user == null)
{
e.IsValid = false;
e.ErrorText = "该员工在基本信息表中不存在";
}
if (user.IsDeleted == "0")
{
e.IsValid = false;
e.ErrorText = "该员工已被删除";
}
}
else
{
e.IsValid = false;
e.ErrorText = string.Format("员工编号不能为空", e.Value);
}
}
if (e.FieldName == "SendOutDate" && string.IsNullOrWhiteSpace(e.Value))
{
e.IsValid = false;
e.ErrorText = string.Format("发放日期不能为空", e.Value);
}
});
return(Json(errors));
}
public JsonResult SaveExcelData()
{
var reader = new System.IO.StreamReader(HttpContext.Request.InputStream);
string data = reader.ReadToEnd();
var tempdata = JsonConvert.DeserializeObject <Dictionary <string, string> >(data);
var list = JsonConvert.DeserializeObject <List <Dictionary <string, string> > >(tempdata["data"]);
foreach (var salaryDic in list)
{
var bonus = new T_HR_PersonalBonusInput();
UpdateEntity <T_HR_PersonalBonusInput>(bonus, salaryDic);
if (bonus.ID == null)
{
bonus.ID = FormulaHelper.CreateGuid();
}
EntityCreateLogic <T_HR_PersonalBonusInput>(bonus);
var code = salaryDic["Code"];
var currentInfo = ComprehensiveDbContext.Set <S_HR_Employee>().FirstOrDefault(d => d.Code == code && d.IsDeleted == "0");
if (currentInfo != null)
{
bonus.EmployeeName = currentInfo.Name;
bonus.Employee = currentInfo.ID;
bonus.DeptName = currentInfo.DeptName;
bonus.Dept = currentInfo.Dept;
if (string.IsNullOrWhiteSpace(bonus.SendOutDate.ToString()))
{
DateTime dt = (DateTime)bonus.SendOutDate;
bonus.Year = dt.Year.ToString();
bonus.Month = dt.Month.ToString();
}
}
this.ComprehensiveDbContext.Set <T_HR_PersonalBonusInput>().Add(bonus);
ComprehensiveDbContext.SaveChanges();
}
return(Json("Success"));
}
public JsonResult ValidateData()
{
var reader = new System.IO.StreamReader(HttpContext.Request.InputStream);
string data = reader.ReadToEnd();
var tempdata = JsonConvert.DeserializeObject <Dictionary <string, string> >(data);
var excelData = JsonConvert.DeserializeObject <ExcelData>(tempdata["data"]);
var orgService = FormulaHelper.GetService <IOrgService>();
var orgs = orgService.GetOrgs();
var errors = excelData.Vaildate(e =>
{
if (e.FieldName == "Code")
{
if (!string.IsNullOrWhiteSpace(e.Value))
{
var user = ComprehensiveDbContext.Set <S_HR_Employee>().FirstOrDefault(d => d.Code == e.Value);
if (user == null)
{
e.IsValid = false;
e.ErrorText = "该员工在基本信息表中不存在";
}
if (user.IsDeleted == "0")
{
e.IsValid = false;
e.ErrorText = "该员工已删除";
}
}
else
{
e.IsValid = false;
e.ErrorText = string.Format("员工编号不能为空", e.Value);
}
}
//if (e.FieldName == "Employee" && string.IsNullOrWhiteSpace(e.Value))
//{
// e.IsValid = false;
// e.ErrorText = string.Format("员工姓名不能为空", e.Value);
//}
//if (e.FieldName == "DeptName")
//{
// if (!string.IsNullOrWhiteSpace(e.Value))
// {
// var dept = orgs.FirstOrDefault(o => o.Name == e.Value);
// if (dept == null)
// {
// e.IsValid = false;
// e.ErrorText = string.Format("部门（{0}）不存在！", e.Value);
// }
// }
// else
// {
// e.IsValid = false;
// e.ErrorText = "部门字段不能为空！";
// }
//}
if (e.FieldName == "Year" && string.IsNullOrWhiteSpace(e.Value))
{
e.IsValid = false;
e.ErrorText = string.Format("年份不能为空", e.Value);
}
if (e.FieldName == "Month" && string.IsNullOrWhiteSpace(e.Value))
{
e.IsValid = false;
e.ErrorText = string.Format("月份不能为空", e.Value);
}
});
return(Json(errors));
}
protected override void BeforeSave(Dictionary <string, string> dic, Base.Logic.Domain.S_UI_Form formInfo, bool isNew)
{
var list = new List <Dictionary <string, object> >();
var id = dic.GetValue("ID");
var normalValue = 0m;
if (!string.IsNullOrEmpty(dic.GetValue("NormalValue")))
{
normalValue = Convert.ToDecimal(dic.GetValue("NormalValue"));
}
var extraValue = 0m;
if (!string.IsNullOrEmpty(dic.GetValue("AdditionalValue")))
{
extraValue = Convert.ToDecimal(dic.GetValue("AdditionalValue"));
}
if ((normalValue == 0 && extraValue == 0))
{
throw new Formula.Exceptions.BusinessException("每日工时不能为0");
}
var user = FormulaHelper.GetUserInfoByID(dic.GetValue("UserID"));
var employee = this.ComprehensiveDbContext.Set <S_HR_Employee>().FirstOrDefault(d => d.UserID == user.UserID);
var fo = FormulaHelper.CreateFO <WorkHourFO>();
//根据日期段判断
var startDate = dic.GetValue("WorkHourDateStart").Replace("T", " ");
var endDate = dic.GetValue("WorkHourDateEnd").Replace("T", " ");
var projectID = dic.GetValue("ProjectID");
var WorkTimeMajor = dic.GetValue("WorkTimeMajor");
var SubProjectCode = dic.GetValue("SubProjectCode");
var MajorCode = dic.GetValue("MajorCode");
var WorkContent = dic.GetValue("WorkContent");
var dateList = getWorkHourDate(startDate, endDate);
//已存在工时数据
var userID = dic.GetValue("UserID");
var existList = this.ComprehensiveDbContext.Set <S_W_UserWorkHour>().Where(a => a.UserID == userID && dateList.Contains(a.WorkHourDate)).ToList();
foreach (var item in dateList)
{
var existNormalValue = existList.Where(a => a.WorkHourDate == item && a.SupplementID != id).Sum(a => a.NormalValue);
var existExtraValue = existList.Where(a => a.WorkHourDate == item && a.SupplementID != id).Sum(a => a.AdditionalValue);
if (!existNormalValue.HasValue)
{
existNormalValue = 0;
}
if (!existExtraValue.HasValue)
{
existExtraValue = 0;
}
//自动补全正班工日，加班工日不补全
if ((normalValue + existNormalValue) > NormalHoursMax)
{
normalValue = NormalHoursMax - existNormalValue.Value;
}
//throw new Formula.Exceptions.BusinessException("【" + item.ToShortDateString() + "】正常工时不能大于" + NormalHoursMax.ToString());
if ((extraValue + existExtraValue) > maxExtraHour)
{
throw new Formula.Exceptions.BusinessException("【" + item.ToShortDateString() + "】加班工时不能大于" + maxExtraHour.ToString());
}
if ((normalValue == 0 && extraValue == 0))
{
continue;
}
var userWorkHour = existList.FirstOrDefault(d => d.SupplementID == id &&
d.UserID == user.UserID && d.WorkHourDate == item);
if (userWorkHour == null || ComprehensiveDbContext.Entry <S_W_UserWorkHour>(userWorkHour).State == System.Data.EntityState.Deleted)
{
userWorkHour = ComprehensiveDbContext.Set <S_W_UserWorkHour>().Create();
userWorkHour.ID = FormulaHelper.CreateGuid();
userWorkHour.UserID = user.UserID;
userWorkHour.UserName = user.UserName;
userWorkHour.UserDeptID = user.UserOrgID;
userWorkHour.UserDeptName = user.UserOrgName;
userWorkHour.WorkHourDate = item;
userWorkHour.UserCode = user.Code;
if (employee != null)
{
userWorkHour.EmployeeID = employee.ID;
}
userWorkHour.State = "Create";
userWorkHour.IsConfirm = "0";
userWorkHour.IsStep1 = "0";
userWorkHour.IsStep2 = "0";
userWorkHour.CreateUser = CurrentUserInfo.UserName;
userWorkHour.CreateUserID = CurrentUserInfo.UserID;
userWorkHour.SupplementID = id;
userWorkHour.BelongMonth = item.Month;
userWorkHour.BelongYear = item.Year;
userWorkHour.BelongQuarter = ((item.Month - 1) / 3) + 1;
ComprehensiveDbContext.Set <S_W_UserWorkHour>().Add(userWorkHour);
}
if (userWorkHour.State != "Create")
{
continue;
}
userWorkHour.ProjectChargerUser = dic.GetValue("ProjectChargerUser");
userWorkHour.ProjectChargerUserName = dic.GetValue("ProjectChargerUserName");
userWorkHour.ProjectCode = dic.GetValue("ProjectCode");
userWorkHour.ProjectDept = dic.GetValue("ProjectDept");
userWorkHour.ProjectDeptName = dic.GetValue("ProjectDeptName");
userWorkHour.ProjectID = projectID;
userWorkHour.ProjectName = dic.GetValue("ProjectName");
userWorkHour.WorkTimeMajor = dic.GetValue("WorkTimeMajor");
userWorkHour.SubProjectCode = dic.GetValue("SubProjectCode");
userWorkHour.SubProjectName = dic.GetValue("SubProjectName");
userWorkHour.TaskWorkCode = dic.GetValue("TaskWorkCode");
userWorkHour.TaskWorkName = dic.GetValue("TaskWorkName");
userWorkHour.WorkContent = dic.GetValue("WorkContent");
userWorkHour.MajorCode = dic.GetValue("MajorCode");
userWorkHour.MajorName = dic.GetValue("MajorName");
userWorkHour.WorkHourType = dic.GetValue("WorkHourType");
userWorkHour.NormalValue = normalValue;
userWorkHour.AdditionalValue = extraValue;
userWorkHour.WorkHourValue = normalValue + extraValue;
userWorkHour.WorkHourDay = fo.ConvertHourToDay(userWorkHour.WorkHourValue, workHourType, NormalHoursMax);
}
}
