예제 #1
0
 public ActionResult List(Models.DormApply.List vm)
 {
     return(Code.MvcHelper.Post(null, Url.Action("List", new
     {
         SearchText = vm.SearchText,
         CheckStatusId = vm.CheckStatusId,
         pageIndex = vm.Page.PageIndex,
         pageSize = vm.Page.PageSize
     })));
 }
예제 #2
0
        public ActionResult List()
        {
            var vm = new Models.DormApply.List();

            vm.CheckStatusList = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Value = "-1", Text = "不通过"
                },
                new SelectListItem()
                {
                    Value = "0", Text = "未处理"
                },
                new SelectListItem()
                {
                    Value = "1", Text = "通过"
                }
            };

            using (var db = new XkSystem.Models.DbContext())
            {
                var tb = db.Table <Dorm.Entity.tbDormApply>();
                if (!string.IsNullOrEmpty(vm.SearchText))
                {
                    tb = tb.Where(d => d.tbDorm.DormName.Contains(vm.SearchText) ||
                                  d.tbStudent.StudentCode.Contains(vm.SearchText) ||
                                  d.tbStudent.StudentName.Contains(vm.SearchText) ||
                                  d.tbStudent.StudentNameEn.Contains(vm.SearchText));
                }
                if (vm.CheckStatusId > -2)
                {
                    tb = tb.Where(d => d.CheckStatus == (Code.EnumHelper.CheckStatus)vm.CheckStatusId);
                }
                vm.DormApplyList = (from p in tb
                                    orderby p.No
                                    select new Dto.DormApply.List()
                {
                    #region
                    CheckDate = p.CheckDate,
                    CheckRemark = p.CheckRemark,
                    CheckStatus = p.CheckStatus,
                    Id = p.Id,
                    InputDate = p.InputDate,
                    Remark = p.Remark,
                    StudentCode = p.tbStudent.StudentCode,
                    StudentName = p.tbStudent.StudentName,
                    UserCode = p.tbCheckUser.UserCode,
                    UserName = p.tbCheckUser.UserName,
                    Sex = p.tbStudent.tbSysUser.tbSex.SexName
                          #endregion
                }).ToPageList(vm.Page);
                foreach (var v in vm.DormApplyList)
                {
                    switch (v.CheckStatus)
                    {
                    case Code.EnumHelper.CheckStatus.Fail:
                        v.CheckStatusName = "不通过"; break;

                    case Code.EnumHelper.CheckStatus.None:
                        v.CheckStatusName = "未处理"; break;

                    default:
                        v.CheckStatusName = "通过"; break;
                    }
                }
            }

            return(View(vm));
        }