public ActionResult List(Models.ClassStudent.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
classId = vm.ClassId,
ClassGroupId = vm.ClassGroupId,
searchText = vm.SearchText
})));
}
public ActionResult Export()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ClassStudent.List();
var file = System.IO.Path.GetTempFileName();
var studentList = (from p in db.Table <Basis.Entity.tbClassStudent>()
where p.tbClass.Id == vm.ClassId
select new
{
ClassNo = p.tbClass.No,
p.tbClass.ClassName,
p.tbClass.tbGrade.GradeName,
p.tbStudent.StudentCode,
p.tbStudent.StudentName,
p.tbStudent.tbSysUser.tbSex.SexName,
p.No
}).ToList();
var dtStudent = new System.Data.DataTable();
dtStudent.Columns.AddRange(new System.Data.DataColumn[]
{
new System.Data.DataColumn("年级"),
new System.Data.DataColumn("班序"),
new System.Data.DataColumn("班级"),
new System.Data.DataColumn("学号"),
new System.Data.DataColumn("姓名"),
new System.Data.DataColumn("性别"),
new System.Data.DataColumn("座位号")
});
foreach (var a in studentList)
{
var dr = dtStudent.NewRow();
dr["年级"] = a.GradeName;
dr["班序"] = a.ClassNo;
dr["班级"] = a.ClassName;
dr["学号"] = a.StudentCode;
dr["姓名"] = a.StudentName;
dr["性别"] = a.SexName;
dr["座位号"] = a.No;
dtStudent.Rows.Add(dr);
}
Code.NpoiHelper.DataTableToExcel(file, dtStudent);
if (string.IsNullOrEmpty(file) == false)
{
return(File(file, Code.Common.DownloadType, Code.Common.ExportByExcel));
}
else
{
return(View());
}
}
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ClassStudent.List();
vm.ClassGroupList = ClassGroupController.SelectList(vm.ClassId);
vm.ClassName = db.Set <Basis.Entity.tbClass>().Find(vm.ClassId).ClassName;
var tb = from p in db.Table <Basis.Entity.tbClassStudent>()
where p.tbClass.Id == vm.ClassId &&
p.tbStudent.IsDeleted == false
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText));
}
if (vm.ClassGroupId > 0)
{
tb = tb.Where(d => d.tbClassGroup.Id == vm.ClassGroupId);
}
vm.ClassStudentList = (from p in tb
orderby p.No, p.tbStudent.StudentCode
select new Dto.ClassStudent.List
{
Id = p.Id,
StudentId = p.tbStudent.Id,
ClassId = p.tbClass.Id,
ClassName = p.tbClass.ClassName,
StudentCode = p.tbStudent.StudentCode,
SexName = p.tbStudent.tbSysUser.tbSex.SexName,
No = p.No,
ClassGroupName = p.tbClassGroup.ClassGroupName,
StudentName = p.tbStudent.StudentName
}).ToList();
return(View(vm));
}
}
