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