public ActionResult SalaryPaymentView()
{
ISalaryGrantBLL bLL = new SalaryGrantBLL();
IOrgBLL orgBLL = new OrgBLL();
List <SalaryPayment> list = bLL.GetAllSalaryPaymentFromDB();
List <Models.SalaryPayment> salaryPaymentList = new List <Models.SalaryPayment>();
if (list != null)
{
foreach (var sp in list)
{
Models.SalaryPayment salaryPayment = new Models.SalaryPayment
{
Id = sp.Id,
FileNumber = sp.FileNumber,
TotalPerson = sp.TotalPerson,
TotalAmout = sp.TotalAmout,
RegistTime = sp.RegistTime,
FileState = sp.FileState
};
ThirdOrg thirdOrg = orgBLL.GetThirdOrgById(sp.TOrgId);
SecondOrg secondOrg = orgBLL.GetSecondOrgById(thirdOrg.ParentOrgId);
FirstOrg firstOrg = orgBLL.GetFirstOrgById(secondOrg.ParentOrgId);
Models.FirstOrg firstOrgView = new Models.FirstOrg {
Id = firstOrg.Id, OrgLevel = firstOrg.OrgLevel, OrgName = firstOrg.OrgName
};
Models.SecondeOrg secondeOrgView = new Models.SecondeOrg {
Id = secondOrg.Id, OrgName = secondOrg.OrgName, OrgLevel = secondOrg.OrgLevel, ParentOrg = firstOrgView
};
Models.ThirdOrg thirdOrgView = new Models.ThirdOrg {
Id = thirdOrg.Id, ParentOrg = secondeOrgView, OrgLevel = thirdOrg.OrgLevel, OrgName = thirdOrg.OrgName
};
salaryPayment.ThirdOrg = thirdOrgView;
salaryPaymentList.Add(salaryPayment);
}
}
ViewData["salaryPaymentList"] = salaryPaymentList;
return(View());
}
public ActionResult PaymentSearch(FormCollection formCollection)
{
ISalaryGrantBLL salaryGrantBLL = new SalaryGrantBLL();
IOrgBLL orgBLL = new OrgBLL();
List <SalaryPayment> list = salaryGrantBLL.GetAllSalaryPaymentFromDB();
if (formCollection["State"] != "10")
{
var l = from p in list
where p.FileState == (EnumState.SalaryPaymentStateEnum)Convert.ToInt32(formCollection["State"])
select p;
list = l.ToList();
}
if (formCollection["BeginDate"] != "")
{
var l = from p in list
where p.CheckTime.Date >= Convert.ToDateTime(formCollection["BeginDate"])
select p;
list = l.ToList();
if (formCollection["EndDate"] != "")
{
var l2 = from p in list
where p.CheckTime.Date <= Convert.ToDateTime(formCollection["EndDate"])
select p;
list = l2.ToList();
}
}
else
{
if (formCollection["EndDate"] != "")
{
var l = from p in list
where p.CheckTime.Date <= Convert.ToDateTime(formCollection["EndDate"])
select p;
list = l.ToList();
}
}
List <Models.SalaryPayment> salaryPaymentList = new List <Models.SalaryPayment>();
if (list != null)
{
foreach (var sp in list)
{
Models.SalaryPayment salaryPayment = new Models.SalaryPayment
{
Id = sp.Id,
FileNumber = sp.FileNumber,
TotalPerson = sp.TotalPerson,
TotalAmout = sp.TotalAmout,
RegistTime = sp.RegistTime,
FileState = sp.FileState
};
ThirdOrg thirdOrg = orgBLL.GetThirdOrgById(sp.TOrgId);
SecondOrg secondOrg = orgBLL.GetSecondOrgById(thirdOrg.ParentOrgId);
FirstOrg firstOrg = orgBLL.GetFirstOrgById(secondOrg.ParentOrgId);
Models.FirstOrg firstOrgView = new Models.FirstOrg {
Id = firstOrg.Id, OrgLevel = firstOrg.OrgLevel, OrgName = firstOrg.OrgName
};
Models.SecondeOrg secondeOrgView = new Models.SecondeOrg {
Id = secondOrg.Id, OrgName = secondOrg.OrgName, OrgLevel = secondOrg.OrgLevel, ParentOrg = firstOrgView
};
Models.ThirdOrg thirdOrgView = new Models.ThirdOrg {
Id = thirdOrg.Id, ParentOrg = secondeOrgView, OrgLevel = thirdOrg.OrgLevel, OrgName = thirdOrg.OrgName
};
salaryPayment.ThirdOrg = thirdOrgView;
salaryPaymentList.Add(salaryPayment);
}
}
ViewData["salaryPaymentList"] = salaryPaymentList;
return(View("SalaryPaymentView"));
}
public ActionResult SalaryPaymentDetail(string id)
{
ISalaryGrantBLL salaryGrantBLL = new SalaryGrantBLL();
IStaffBLL staffBLL = new StaffBLL();
ISalaryBLL salaryBLL = new SalaryBLL();
ISalaryItemBLL salaryItemBLL = new SalaryItemBLL();
IOrgBLL orgBLL = new OrgBLL();
List <StaffPayment> staffPaymentList = salaryGrantBLL.GetAllStaffPaymentByPaymentId(Convert.ToInt32(id));
List <Models.StaffPayment> staffPaymentListView = new List <Models.StaffPayment>();
foreach (var sp in staffPaymentList)
{
Models.StaffPayment staffPayment = new Models.StaffPayment
{
Id = sp.Id,
OddAmout = sp.OddAmout,
MinusAmout = sp.MinusAmout
};
//获取Model.StaffSalary，为StaffPayment装载StaffSalary
StaffSalary staffSalary = salaryGrantBLL.GetStaffSalaryById(sp.StaffSalaryId);
Models.StaffSalary staffSalaryView = new Models.StaffSalary
{
Id = staffSalary.Id,
StaffFileNumber = staffSalary.StaffFileNumber
};
Staff staff = staffBLL.GetStaffById(staffSalary.StaffId);
staffSalaryView.Staff = new Models.Staff {
Id = staff.Id, StaffName = staff.StaffName
};
ThirdOrg thirdOrg = orgBLL.GetThirdOrgById(staff.ThirdOrgId);
SecondOrg secondOrg = orgBLL.GetSecondOrgById(thirdOrg.ParentOrgId);
FirstOrg firstOrg = orgBLL.GetFirstOrgById(secondOrg.ParentOrgId);
Models.FirstOrg firstOrgView = new Models.FirstOrg {
Id = firstOrg.Id, OrgLevel = firstOrg.OrgLevel, OrgName = firstOrg.OrgName
};
Models.SecondeOrg secondeOrgView = new Models.SecondeOrg {
Id = secondOrg.Id, OrgName = secondOrg.OrgName, OrgLevel = secondOrg.OrgLevel, ParentOrg = firstOrgView
};
staffSalaryView.ThirdOrg = new Models.ThirdOrg {
Id = thirdOrg.Id, ParentOrg = secondeOrgView, OrgLevel = thirdOrg.OrgLevel, OrgName = thirdOrg.OrgName
};
SalaryStandard salaryStandard = salaryBLL.GetSalaryStandardById(staffSalary.StandardId);
Models.SalaryStandard salaryStandardView = new Models.SalaryStandard
{
Id = salaryStandard.Id,
StandardName = salaryStandard.StandardName,
};
List <StandardMapItem> standardMapItemList = salaryBLL.GetAllStandardMapItemByStandardId(salaryStandard.Id);
foreach (var item in standardMapItemList)
{
SalaryItem salaryItem = salaryItemBLL.GetSalaryItemById(item.ItemId);
Models.SalaryItem salaryItemView = new Models.SalaryItem
{
Id = salaryItem.Id,
Name = salaryItem.Name
};
salaryStandardView.ItemAmout.Add(salaryItemView, item.Amout);;
}
staffSalaryView.SalaryStandard = salaryStandardView;
staffPayment.StaffSalary = staffSalaryView;
SalaryPayment salaryPayment = salaryGrantBLL.GetSalaryPaymentById(sp.PaymentId);
staffPayment.SalaryPayment = new Models.SalaryPayment
{
Id = salaryPayment.Id,
TotalPerson = salaryPayment.TotalPerson,
TotalAmout = salaryPayment.TotalAmout,
FileState = salaryPayment.FileState,
FileNumber = salaryPayment.FileNumber,
Registrant = salaryPayment.Registrant,
RegistTime = salaryPayment.RegistTime,
TotalReal = salaryPayment.TotalReal,
CheckBy = salaryPayment.CheckBy,
CheckTime = salaryPayment.CheckTime
};
staffPaymentListView.Add(staffPayment);
}
ViewData["staffPaymentListView"] = staffPaymentListView;
return(View());
}
public ActionResult SalaryGrantSubmitReg(FormCollection formCollection)
{
ISalaryGrantBLL salaryGrantBLL = new SalaryGrantBLL();
//获取发放的人数，即StaffPayment的数量
int count = Convert.ToInt32(formCollection["Count"]);
//获取发放的薪酬单的id
int salaryPaymentId = Convert.ToInt32(formCollection["SalaryPaymentId"]);
SalaryPayment salaryPayment = salaryGrantBLL.GetSalaryPaymentById(salaryPaymentId);
decimal total = salaryPayment.TotalAmout;
decimal totalReal = total;
string action = "";
if (formCollection["SalaryPaymentCheck"] == "Checked")
{
salaryPayment.FileState = EnumState.SalaryPaymentStateEnum.Checked;
salaryPayment.CheckBy = formCollection["CheckBy"];
salaryPayment.CheckTime = DateTime.Now;
action = "SalaryPaymentWaitCheck";
}
else
{
salaryPayment.FileState = EnumState.SalaryPaymentStateEnum.WaitCheck;
salaryPayment.Registrant = formCollection["Registrant"];
action = "SalaryPaymentWaitReg";
}
for (int i = 0; i < count; i++)
{
//获取StaffPayment 的id
int staffPaymentId = Convert.ToInt32(formCollection["StaffPaymentId" + i]);
//获取对应id的Odd和Minus
decimal odd = Convert.ToDecimal(formCollection["OddAmout" + staffPaymentId]);
decimal minus = Convert.ToDecimal(formCollection["MinusAmout" + staffPaymentId]);
totalReal += odd;
totalReal -= minus;
if (!salaryGrantBLL.UpdateStaffPayOddAndMinus(staffPaymentId, odd, minus))
{
TempData["error"] = "操作失败";
return(RedirectToAction(action));
}
}
salaryPayment.TotalReal = totalReal;
salaryPayment.RegistTime = DateTime.Now;
if (!salaryGrantBLL.SaveSalaryPayment(salaryPayment))
{
TempData["error"] = "操作失败";
return(RedirectToAction(action));
}
TempData["info"] = "操作成功";
return(RedirectToAction(action));
}
/// <summary>
/// 保存员工档案
/// </summary>
/// <param name="formCollection">表单容器</param>
/// <returns>设置提示信息并重定向</returns>
public ActionResult SaveStaff(FormCollection formCollection)
{
IStaffBLL bLL = new StaffBLL();
Staff staff = new Staff();
Type type = typeof(Staff);
foreach (var p in type.GetProperties())
{
if (p.Name != "FileState" && p.Name != "IsDel" && p.Name != "ImagePath" && p.Name != "Id" && p.Name != "StaffFileNumber")
{
p.SetValue(staff, Convert.ChangeType(formCollection[p.Name], p.PropertyType));
}
}
if (formCollection["Id"] != null)
{
staff.Id = Convert.ToInt32(formCollection["Id"]);
}
if (formCollection["StaffFile"] == "Checked")
{
staff.FileState = EnumState.StaffFileStateEnum.Checked;
}
else
{
staff.FileState = EnumState.StaffFileStateEnum.WaitCheck;
}
staff.IsDel = false;
if (formCollection["StaffFileNumber"] != null)
{
staff.StaffFileNumber = formCollection["StaffFileNumber"];
}
else
{
staff.StaffFileNumber = DateTime.Now.Year.ToString() + formCollection["FirstOrg"] + formCollection["SecondOrg"] + formCollection["ThirdOrgId"] + new Random().Next(10, 99).ToString();
}
if (formCollection["ImagePath"] != null)
{
staff.ImagePath = formCollection["ImagePath"];
}
if (Request.Files["StaffImage"].ContentLength > 10)
{
HttpPostedFileBase file = Request.Files["StaffImage"];
string path = @"/UploadFiles/" + Guid.NewGuid().ToString() + file.FileName;
file.SaveAs(Server.MapPath(path));
staff.ImagePath = path;
}
if (bLL.SaveStaff(staff))
{
if (formCollection["StaffFile"] == "Checked")
{
//复核之后，员工档案应该生效，因此需要往StaffSalary中插入记录，薪酬统计时是使用StaffSalary表的
ISalaryGrantBLL salaryGrantBLL = new SalaryGrantBLL();
if (salaryGrantBLL.SaveStaffSalary(new StaffSalary {
StaffFileNumber = staff.StaffFileNumber, StaffId = staff.Id, StandardId = staff.StandardId, TOrgId = staff.ThirdOrgId
}))
{
TempData["info"] = "复核通过";
return(Redirect("/StaffManage/StaffCheck"));
}
else
{
TempData["error"] = "复核失败";
return(Redirect("/StaffManage/StaffCheck"));
}
}
else
{
TempData["info"] = "保存成功";
return(Redirect("/StaffManage/StaffView"));
}
}
else
{
TempData["error"] = "保存失败";
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
}
