public ActionResult Create(ReserveField reserveField)
{
if (ModelState.IsValid)
{
// var reservef = db.ReserveFields.Where(rf => rf.TableName.Equals(reserveField.TableName)).ToList();
// var reservef = db.TableNameContrasts.Where(rf=>rf.Id.E)
//var reservef = (from p in db.ReserveFields
// join q in db.TableNameContrasts on p.TableNameId equals q.Id
// select p).ToList();
var reservef = (from p in db.ReserveFields where p.Id == reserveField.TableNameId select p).ToList();
foreach (var temp in reservef)
{
if (temp.FieldName == reserveField.FieldName)
{
ModelState.AddModelError("", "抱歉，该字段已经被注册！");
return(View(reserveField));
}
if (temp.Description == reserveField.Description)
{
ModelState.AddModelError("", "抱歉，该字段的描述已经被注册！");
return(View(reserveField));
}
}
reserveField.RecordPerson = this.Name;
reserveField.RecordTime = DateTime.Now;
db.ReserveFields.Add(reserveField);
db.SaveChanges();
return(RedirectToAction("Index", new { table = reserveField.TableName }));
}
return(View(reserveField));
}
public ActionResult DeleteConfirmed(int id)
{
ReserveField reserveField = db.ReserveFields.Find(id);
db.ReserveFields.Remove(reserveField);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(ReserveField reserveField)
{
if (ModelState.IsValid)
{
db.Entry(reserveField).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { table = reserveField.TableName }));
}
return(View(reserveField));
}
public ActionResult Edit([Bind(Include = "Id,TableName,FieldName,Description,Status")] ReserveField reserveField)
{
if (ModelState.IsValid)
{
db.Entry(reserveField).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reserveField));
}
//public ActionResult IndexInfo(string table)
//{
// return View(db.ReserveFields.Where(rf=>rf.TableName.Equals(table)).ToList());
//}
// GET: ReserveRecord/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReserveField reserveField = db.ReserveFields.Find(id);
if (reserveField == null)
{
return(HttpNotFound());
}
return(View(reserveField));
}
// GET: ReserveRecord/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReserveField reserveField = db.ReserveFields.Find(id);
if (reserveField == null)
{
return(HttpNotFound());
}
ViewBag.TableNameId = new SelectList(db.TableNameContrasts, "Id", "TableDescription");
return(View(reserveField));
}
public ActionResult Create([Bind(Include = "Id,TableName,FieldName,Description,Status")] ReserveField reserveField)
{
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "部门信息表", Value = "Departments"
});
items.Add(new SelectListItem {
Text = "员工档案表", Value = "Staffs"
});
items.Add(new SelectListItem {
Text = "员工技能表", Value = "StaffSkills"
});
items.Add(new SelectListItem {
Text = "员工技能表", Value = "StaffSkills"
});
items.Add(new SelectListItem {
Text = "人事变更申请表", Value = "StaffChanges"
});
items.Add(new SelectListItem {
Text = "离职申请表", Value = "StaffApplications"
});
items.Add(new SelectListItem {
Text = "离职档案表", Value = "StaffArchives"
});
items.Add(new SelectListItem {
Text = "合同管理表", Value = "Contracts"
});
ViewBag.List = items;
if (ModelState.IsValid)
{
db.ReserveFields.Add(reserveField);
/*状态设置为有效*/
reserveField.Status = "true";
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reserveField));
}
public ActionResult DeleteConfirmed(int id)
{
//确保固定字段表、变化字段表和变化字段存储表的数据一致性。
ReserveField reserveField = db.ReserveFields.Find(id);
var item = (from p in db.TableNameContrasts where p.Id == reserveField.TableNameId
select p.TableName).ToList().FirstOrDefault();
//var item = (from p in db.ReserveFields
// join q in db.TableNameContrasts on p.TableNameId equals reserveField.Id
// select q.TableName).ToList().FirstOrDefault();
if (item == "StaffArchives")
{
foreach (StaffArchiveReserve t in db.StaffArchiveReserves.Where(sarq => sarq.FieldId.Equals(id)).ToList())
{
db.StaffArchiveReserves.Remove(t);
db.SaveChanges();
}
}
if (item == "StaffChanges")
{
foreach (StaffChangeReserve t in db.StaffChangeReserves.Where(scr => scr.FieldId.Equals(id)).ToList())
{
db.StaffChangeReserves.Remove(t);
db.SaveChanges();
}
}
if (item == "Staffs")
{
var staffReserves = (from p in db.StaffReserves where p.FieldId == id select p).ToList();
foreach (var staffReserve in staffReserves)
{
db.StaffReserves.Remove(staffReserve);
}
db.SaveChanges();
//foreach (StaffReserve t in db.StaffReserves.Where(sr => sr.FieldId.Equals(id)).ToList())
//{
// db.StaffReserves.Remove(t);
// db.SaveChanges();
//}
}
if (item == "StaffSkills")
{
foreach (StaffSkillReserve t in db.StaffSkillReserves.Where(skr => skr.FieldId.Equals(id)).ToList())
{
db.StaffSkillReserves.Remove(t);
db.SaveChanges();
}
}
if (item == "Departments")
{
foreach (DepartmentReserve t in db.DepartmentReserves.Where(dr => dr.FieldId.Equals(id)).ToList())
{
db.DepartmentReserves.Remove(t);
db.SaveChanges();
}
}
if (item == "StaffApplications")
{
foreach (StaffApplicationReserve t in db.StaffApplicationReserves.Where(sar => sar.FieldId.Equals(id)).ToList())
{
db.StaffApplicationReserves.Remove(t);
db.SaveChanges();
}
}
db.ReserveFields.Remove(reserveField);
db.SaveChanges();
return(RedirectToAction("Index", new { table = reserveField.TableName }));
}
