public ActionResult Edit(StaffSkillViewModel staffSkill)
{
if (ModelState.IsValid)
{
StaffSkill ss = db.StaffSkills.Find(staffSkill.Id);
/*查找员工技能预留字段(value)*/
var fieldValueList = (from ssr in db.StaffSkillReserves
join rf in db.ReserveFields on ssr.FieldId equals rf.Id
where ssr.Number == staffSkill.Id && rf.Status == true
select new StaffSkillViewModel {
Id = ssr.Id, Description = rf.Description, Value = ssr.Value
}).ToList();
//ViewBag.fieldValueList = fieldValueList;
/*给预留字段赋值*/
foreach (var temp in fieldValueList)
{
StaffSkillReserve ssr = db.StaffSkillReserves.Find(temp.Id);
ssr.Value = Request[temp.Description];
db.SaveChanges();
}
ss.ValidDate = staffSkill.ValidDate;
ss.StaffNumber = staffSkill.StaffNumber;
ss.SkillRemark = staffSkill.SkillRemark;
ss.SkillNumber = staffSkill.SkillNumber;
ss.BillTypeNumber = staffSkill.BillTypeNumber;
ss.BillNumber = staffSkill.BillNumber;
ss.ChangePerson = base.Name;
ss.ChangeTime = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(staffSkill));
}
public ActionResult Create(StaffSkill staffSkill)
{
if (ModelState.IsValid)
{
/*先保存员工技能固定的字段（为了生成主键Id）*/
db.StaffSkills.Add(staffSkill);
db.SaveChanges();
/*查找员工技能预留字段(name)*/
var fieldList = (from p in db.ReserveFields where p.TableName == "StaffSkills" select p).ToList();
ViewBag.fieldList = fieldList;
/*遍历，保存员工技能变化的字段*/
foreach (var temp in fieldList)
{
StaffSkillReserve ssr = new StaffSkillReserve();
ssr.Number = staffSkill.Id;
ssr.FieldId = temp.Id;
ssr.Value = Request[temp.FieldName];
/*占位，为了在Index中显示整齐的格式*/
if (ssr.Value == null)
{
ssr.Value = " ";
}
db.StaffSkillReserves.Add(ssr);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(staffSkill));
}
public ActionResult DeleteConfirmed(int id)
{
/*Step1：删除预留字段*/
var item = (from ssr in db.StaffSkillReserves
where ssr.Number == id
select new StaffSkillViewModel {
Id = ssr.Id
}).ToList();
foreach (var temp in item)
{
StaffSkillReserve ssr = db.StaffSkillReserves.Find(temp.Id);
db.StaffSkillReserves.Remove(ssr);
}
db.SaveChanges();
/*Step2：删除固定字段*/
StaffSkill staffSkill = db.StaffSkills.Find(id);
db.StaffSkills.Remove(staffSkill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(StaffSkill staffSkill3)
{
if (ModelState.IsValid)
{
staffSkill3.RecordTime = DateTime.Now;
if (staffSkill3.ValidDate < DateTime.Today)
{
ModelState.AddModelError("", "生效日期错误！请重新选择");
CreateInite();
StaffSkillViewModel staffSkill = new StaffSkillViewModel();
staffSkill.Id = staffSkill3.Id;
staffSkill.BillNumber = staffSkill3.BillNumber;
staffSkill.StaffNumber = staffSkill3.StaffNumber;
staffSkill.SkillNumber = staffSkill3.SkillNumber;
staffSkill.SkillRemark = staffSkill3.SkillRemark;
staffSkill.ValidDate = staffSkill3.ValidDate;
return(View(staffSkill));
}
staffSkill3.BillNumber = GenerateBillNumber(staffSkill3.BillTypeNumber);
staffSkill3.RecordPerson = base.Name;
/*先保存员工技能固定的字段（为了生成主键Id）*/
db.StaffSkills.Add(staffSkill3);
db.SaveChanges();
//提交审核
byte status = AuditApplicationStaffSkill(staffSkill3);
if (status == 7)
{
ViewBag.alertMessage = true;
CreateInite();
StaffSkillViewModel staffSkill = new StaffSkillViewModel();
staffSkill.Id = staffSkill3.Id;
// staffSkill.BillTypeNumber = GenerateBillNumber();
staffSkill.BillNumber = staffSkill3.BillNumber;
staffSkill.StaffNumber = staffSkill3.StaffNumber;
staffSkill.SkillNumber = staffSkill3.SkillNumber;
staffSkill.SkillRemark = staffSkill3.SkillRemark;
staffSkill.ValidDate = staffSkill3.ValidDate;
return(View(staffSkill3));
}
else
{
//需要对原表做出的修改
staffSkill3.AuditStatus = status;
db.SaveChanges();
}
/*查找员工技能预留字段(name)*/
var fieldList = (from p in db.ReserveFields join q in db.TableNameContrasts on p.TableNameId equals q.Id where q.TableName == "StaffSkills" select p).ToList();
ViewBag.fieldList = fieldList;
/*遍历，保存员工技能变化的字段*/
foreach (var temp in fieldList)
{
StaffSkillReserve ssr = new StaffSkillReserve();
ssr.Number = staffSkill3.Id;
ssr.FieldId = temp.Id;
ssr.Value = Request[temp.FieldName];
/*占位，为了在Index中显示整齐的格式*/
if (ssr.Value == null)
{
ssr.Value = " ";
}
db.StaffSkillReserves.Add(ssr);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
CreateInite();
StaffSkillViewModel staffSkill = new StaffSkillViewModel();
staffSkill.Id = staffSkill3.Id;
// staffSkill.BillTypeNumber = GenerateBillNumber();
staffSkill.BillNumber = staffSkill3.BillNumber;
staffSkill.StaffNumber = staffSkill3.StaffNumber;
staffSkill.SkillNumber = staffSkill3.SkillNumber;
staffSkill.SkillRemark = staffSkill3.SkillRemark;
staffSkill.ValidDate = staffSkill3.ValidDate;
return(View(staffSkill));
}
}
