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)); } }