public ActionResult Save(Models.ExamCourseRate.List vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var arrystr = new string[] { };
var txtId = Request["txtId"] != null ? Request["txtId"].Split(',') : arrystr;
var txtExamCourseId = Request["txtExamCourseId"] != null ? Request["txtExamCourseId"].Split(',') : arrystr;
var txtExamCourseId1 = Request["txtExamCourseId1"] != null ? Request["txtExamCourseId1"].Split(',') : arrystr;
var txtCourseRate = Request["txtRate"] != null ? Request["txtRate"].Split(',') : null;
//验证
var list = from p in db.Table <Exam.Entity.tbExamCourseRate>()
where p.tbExamCourse.IsDeleted == false && p.tbExamCourse1.IsDeleted == false
select p;
for (var i = 0; i < txtId.Count(); i++)
{
if (string.IsNullOrEmpty(txtId[i]) == false)
{
var courseRateId = txtId[i].ConvertToInt();
var tb = list.Where(d => d.Id == courseRateId).FirstOrDefault();
var courseRate = txtCourseRate != null ? txtCourseRate[i].ConvertToDecimal() : decimal.Zero;
if (tb != null)
{
tb.Rate = courseRate;
}
else
{
//没有id的，执行插入操作
if (txtExamCourseId[i].ConvertToInt() == txtExamCourseId1[i].ConvertToInt())
{
tb = new Exam.Entity.tbExamCourseRate();
tb.tbExamCourse = db.Set <Exam.Entity.tbExamCourse>().Find(txtExamCourseId[i].ConvertToInt());
tb.tbExamCourse1 = db.Set <Exam.Entity.tbExamCourse>().Find(txtExamCourseId1[i].ConvertToInt());
tb.Rate = courseRate;
db.Set <Exam.Entity.tbExamCourseRate>().Add(tb);
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加考试课程比例");
}
}
}
}
//关联的考试课程比例
var txtUnionCourseId = Request["txtUnionCourseId"] != null ? Request["txtUnionCourseId"].Split(',') : arrystr;
var txtUnionRate = Request["txtUnionRate"] != null ? Request["txtUnionRate"].Split(',') : null;
var cboxlist = new List <int>();
var CboxIdUnion = Request["CboxIdUnion"] != null ? Request["CboxIdUnion"].Split(',') : null;
if (CboxIdUnion == null && txtId.Count() <= 1)
{
return(Code.MvcHelper.Post(null, string.Empty, "至少选择一次考试才能保存!"));
}
if (CboxIdUnion != null)
{
for (var i = 0; i < CboxIdUnion.Count(); i++)
{
cboxlist.Add(CboxIdUnion[i].ConvertToInt());
}
}
for (var i = 0; i < txtUnionCourseId.Count(); i++)
{
if (cboxlist.Contains(txtUnionCourseId[i].ConvertToInt()))
{
var examCourse1Id = txtUnionCourseId[i].ConvertToInt();
var tb = list.Where(d => d.tbExamCourse1.Id == examCourse1Id && d.tbExamCourse.Id == vm.ExamCourseId).FirstOrDefault();
//var tb = db.Table<Exam.Entity.tbExamCourseRate>().Where(d => d.tbExamCourse1.Id == examCourse1Id && d.tbExamCourse.Id == vm.ExamCourseId).FirstOrDefault();
var courseRate = txtUnionRate != null ? txtUnionRate[i].ConvertToDecimal() : decimal.Zero;
if (tb == null)
{
tb = new Exam.Entity.tbExamCourseRate();
tb.tbExamCourse = db.Set <Exam.Entity.tbExamCourse>().Find(vm.ExamCourseId);
tb.tbExamCourse1 = db.Set <Exam.Entity.tbExamCourse>().Find(examCourse1Id);
tb.Rate = courseRate;
db.Set <Exam.Entity.tbExamCourseRate>().Add(tb);
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加考试课程比例");
}
else
{
tb.Rate = courseRate;
}
}
}
db.SaveChanges();
return(Code.MvcHelper.Post(null, string.Empty, "提交成功!"));
}
}
public ActionResult List(Models.ExamCourseRate.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { ExamUionId = vm.ExamUionId, subjectId = vm.SubjectId, ExamCourseId = vm.ExamCourseId, examId = vm.ExamId })));
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamCourseRate.List();
vm.ExamList = Exam.Controllers.ExamController.SelectPublishList();
if (vm.ExamUionId == 0 && vm.ExamList.Count > 0)
{
vm.ExamUionId = vm.ExamList.FirstOrDefault().Value.ConvertToInt();
}
vm.SubjectList = Exam.Controllers.ExamCourseController.GetExamSubjectList(vm.ExamUionId);
var tc = (from p in db.Table <Exam.Entity.tbExamCourse>()
where p.tbExam.IsDeleted == false &&
p.tbCourse.IsDeleted == false &&
p.tbCourse.tbSubject.IsDeleted == false &&
p.Id == vm.ExamCourseId
select new
{
ExamName = p.tbExam.ExamName,
CourseName = p.tbCourse.CourseName,
SubjectId = p.tbCourse.tbSubject.Id,
}).FirstOrDefault();
if (tc != null && vm.SubjectId == 0)
{
vm.SubjectId = tc.SubjectId;
}
var tb = (from p in db.Table <Exam.Entity.tbExamCourseRate>()
where p.tbExamCourse.Id == vm.ExamCourseId
select new Dto.ExamCourseRate.List
{
Id = p.Id,
ExamCourseId = p.tbExamCourse.Id,
ExamCourseId1 = p.tbExamCourse1.Id,
CourseName = p.tbExamCourse1.tbCourse.CourseName,
ExamName = p.tbExamCourse1.tbExam.ExamName,
Status = p.tbExamCourse1.Id == vm.ExamCourseId ? false : true,
Rate = p.Rate
}).ToList();
if (tb.Where(c => c.ExamCourseId == vm.ExamCourseId && c.ExamCourseId1 == vm.ExamCourseId).FirstOrDefault() == null)
{
tb.Add(new Dto.ExamCourseRate.List
{
Id = db.Table <Entity.tbExamCourseRate>().Select(d => d.Id).DefaultIfEmpty(0).Max() + 1,
ExamCourseId = vm.ExamCourseId,
ExamCourseId1 = vm.ExamCourseId,
CourseName = tc.CourseName,
ExamName = tc.ExamName,
Status = false,
Rate = null
});
}
vm.ExamCourseRateList = tb;
//关联考试
var tv = (from p in db.Table <Exam.Entity.tbExamCourse>()
where p.tbCourse.IsDeleted == false &&
p.tbExam.Id == vm.ExamUionId &&
p.tbCourse.tbSubject.Id == vm.SubjectId
orderby p.tbCourse.No
select new Dto.ExamCourseRate.List
{
ExamCourseId = p.Id,
CourseName = p.tbCourse.CourseName,
Status = p.Id != vm.ExamCourseId
}).ToList();
vm.ExamCourseUnionList = tv;
return(View(vm));
}
}
