public ActionResult Edit(Models.QualitySelf.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
int qualitySelfId = 0;
if (error.Count == decimal.Zero)
{
//获取学生信息
var student = (from p in db.Table <Student.Entity.tbStudent>()
where p.IsDeleted == false &&
p.tbSysUser.IsDeleted == false &&
p.tbSysUser.Id == Code.Common.UserId
select p).FirstOrDefault();
if (student != null)
{
//自评校验
if (vm.Type == 1 && vm.QualitySelfEdit.Content == null)
{
var errorMsg = new { Status = decimal.Zero, Message = "请填写完整的自评内容；" };
return(Json(errorMsg));
}
if (vm.QualitySelfEdit.Id == 0)
{
if (vm.Type == 1)//自评
{
var tb = new Quality.Entity.tbQualitySelf();
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualitySelf>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.YearId);
tb.tbStudent = student;
tb.Content = vm.QualitySelfEdit.Content;
tb.InputDate = DateTime.Now;
db.Set <Quality.Entity.tbQualitySelf>().Add(tb);
}
else if (vm.Type == 2)//学期期待
{
var tb = new Quality.Entity.tbQualityPlan();
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualityPlan>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.YearId);
tb.tbStudent = student;
tb.Content = vm.QualitySelfEdit.Content;
tb.InputDate = DateTime.Now;
db.Set <Quality.Entity.tbQualityPlan>().Add(tb);
}
else if (vm.Type == 3)//学期总结
{
var tb = new Quality.Entity.tbQualitySummary();
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualitySummary>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.YearId);
tb.tbStudent = student;
tb.Content = vm.QualitySelfEdit.Content;
tb.InputDate = DateTime.Now;
db.Set <Quality.Entity.tbQualitySummary>().Add(tb);
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加评价");
}
}
else
{
if (vm.Type == 1)//自评
{
var tb = new Quality.Entity.tbQualitySelf();
tb = (from p in db.Table <Quality.Entity.tbQualitySelf>()
where p.Id == vm.QualitySelfEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
qualitySelfId = tb.Id;
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualitySelf>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.Content = vm.QualitySelfEdit.Content;
//tb.InputDate = DateTime.Now;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改评价");
}
}
}
else if (vm.Type == 2)//学期期待
{
var tb = new Quality.Entity.tbQualityPlan();
tb = (from p in db.Table <Quality.Entity.tbQualityPlan>()
where p.Id == vm.QualitySelfEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
qualitySelfId = tb.Id;
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualityPlan>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.Content = vm.QualitySelfEdit.Content;
//tb.InputDate = DateTime.Now;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改评价");
}
}
}
else if (vm.Type == 3)//学期总结
{
var tb = new Quality.Entity.tbQualitySummary();
tb = (from p in db.Table <Quality.Entity.tbQualitySummary>()
where p.Id == vm.QualitySelfEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
qualitySelfId = tb.Id;
tb.No = vm.QualitySelfEdit.No == null?db.Table <Quality.Entity.tbQualitySummary>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.QualitySelfEdit.No;
tb.Content = vm.QualitySelfEdit.Content;
//tb.InputDate = DateTime.Now;
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改评价");
}
}
}
}
}
}
return(Code.MvcHelper.Post(error));
}
}
public ActionResult Edit(int id = 0, int type = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.QualitySelf.Edit();
vm.Type = type;
if (id != 0 && type == 1)//自评
{
var tb = (from p in db.Table <Quality.Entity.tbQualitySelf>()
.Include(d => d.tbYear)
where p.Id == id &&
p.tbStudent.IsDeleted == false &&
p.tbStudent.tbSysUser.IsDeleted == false &&
p.tbStudent.tbSysUser.Id == Code.Common.UserId
select new Dto.QualitySelf.Edit
{
Id = p.Id,
Content = p.Content,
}).FirstOrDefault();
if (tb != null)
{
vm.QualitySelfEdit = tb;
}
}
else if (id != 0 && type == 2)//学期期待
{
var tb = (from p in db.Table <Quality.Entity.tbQualityPlan>()
where p.Id == id &&
p.tbStudent.IsDeleted == false &&
p.tbStudent.tbSysUser.IsDeleted == false &&
p.tbStudent.tbSysUser.Id == Code.Common.UserId
select new Dto.QualitySelf.Edit
{
Id = p.Id,
Content = p.Content,
}).FirstOrDefault();
if (tb != null)
{
vm.QualitySelfEdit = tb;
}
}
else if (id != 0 && type == 3)//学期总结
{
var tb = (from p in db.Table <Quality.Entity.tbQualitySummary>()
where p.Id == id &&
p.tbStudent.IsDeleted == false &&
p.tbStudent.tbSysUser.IsDeleted == false &&
p.tbStudent.tbSysUser.Id == Code.Common.UserId
select new Dto.QualitySelf.Edit
{
Id = p.Id,
Content = p.Content,
}).FirstOrDefault();
if (tb != null)
{
vm.QualitySelfEdit = tb;
}
}
return(View(vm));
}
}
