public ActionResult List(Models.StudyApply.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, pageSize = vm.Page.PageSize, pageCount = vm.Page.PageCount, pageIndex = vm.Page.PageIndex }))); }
public ActionResult List() { if (Code.Common.UserType != Code.EnumHelper.SysUserType.Student) { return(Content(Code.Common.Redirect(Url.Action("Index", "SysIndex", new { area = "Sys" }), "当前身份类别无法访问该功能!"))); } using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.StudyApply.List(); var tbStudy = from p in db.Table <Study.Entity.tbStudy>() where p.tbYear.IsDeleted == false && p.tbYear.IsDisable == false && p.tbYear.No == DateTime.Now.Year select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tbStudy = tbStudy.Where(d => d.StudyName.Contains(vm.SearchText)); } var tbStudyApply = from p in db.Table <Study.Entity.tbStudyApply>() where p.tbStudent.IsDeleted == false && p.tbStudy.IsDeleted == false && p.tbStudent.tbSysUser.Id == Code.Common.UserId select p; vm.StudyApplyList = (from p in tbStudy orderby p.No descending select new Dto.StudyApply.List { Id = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.Id).FirstOrDefault(), No = p.No, StudyName = p.StudyName, ApplyFrom = p.ApplyFrom, ApplyTo = p.ApplyTo, IsApply = p.IsApply, IsRoom = p.IsRoom, YearName = p.tbYear.YearName, StudyId = p.Id, Remark = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.Remark).FirstOrDefault(), CheckStatus = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckStatus).FirstOrDefault(), CheckDate = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckDate).FirstOrDefault(), CheckRemark = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckRemark).FirstOrDefault(), CheckUserName = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.tbCheckUser.UserName).FirstOrDefault() }).ToPageList(vm.Page); return(View(vm)); } }
public ActionResult Export() { var vm = new Models.StudyApply.List(); using (var db = new XkSystem.Models.DbContext()) { var file = System.IO.Path.GetTempFileName(); var tbStudy = from p in db.Table <Study.Entity.tbStudy>() where p.tbYear.IsDeleted == false && p.tbYear.IsDisable == false && p.tbYear.No == DateTime.Now.Year select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tbStudy = tbStudy.Where(d => d.StudyName.Contains(vm.SearchText)); } var tbStudyApply = from p in db.Table <Study.Entity.tbStudyApply>() where p.tbStudent.IsDeleted == false && p.tbStudy.IsDeleted == false && p.tbStudent.tbSysUser.Id == Code.Common.UserId select p; vm.StudyApplyList = (from p in tbStudy orderby p.No descending select new Dto.StudyApply.List { Id = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.Id).FirstOrDefault(), No = p.No, StudyName = p.StudyName, ApplyFrom = p.ApplyFrom, ApplyTo = p.ApplyTo, IsApply = p.IsApply, IsRoom = p.IsRoom, YearName = p.tbYear.YearName, StudyId = p.Id, Remark = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.Remark).FirstOrDefault(), CheckStatus = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckStatus).FirstOrDefault(), CheckDate = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckDate).FirstOrDefault(), CheckRemark = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.CheckRemark).FirstOrDefault(), CheckUserName = tbStudyApply.Where(d => d.tbStudy.Id == p.Id).Select(d => d.tbCheckUser.UserName).FirstOrDefault() }).ToPageList(vm.Page); var dt = new System.Data.DataTable(); dt.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("申请结束时间"), new System.Data.DataColumn("审批状态") }); var index = 0; foreach (var a in vm.StudyApplyList) { index++; var dr = dt.NewRow(); dr["序号"] = index.ToString(); dr["晚自习名称"] = a.StudyName; dr["学年学期学段"] = a.YearName; dr["晚自习模式"] = a.IsRoom ? "教室模式" : "班级模式"; dr["开放申请"] = a.IsApply ? "开放" : "关闭"; dr["申请开始时间"] = a.ApplyFrom.ToString(Code.Common.StringToDateTime); dr["申请结束时间"] = a.ApplyTo.ToString(Code.Common.StringToDateTime); dr["审批状态"] = a.Id != 0 ? a.CheckStatusName : ""; dt.Rows.Add(dr); } Code.NpoiHelper.DataTableToExcel(file, dt); if (string.IsNullOrEmpty(file) == false) { return(File(file, Code.Common.DownloadType, Code.Common.ExportByExcel)); } else { return(View()); } } }