public ActionResult List(Models.MoralData.List vm) { return(Code.MvcHelper.Post(returnUrl: Url.Action("List", new { searchText = vm.SearchText, moralId = vm.MoralId, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }
public ActionResult Check() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.MoralData.List(); var tb = (from p in db.Table <Moral.Entity.tbMoralData>() /*where p.tbMoralItem.tbMoralGroup.tbMoral.MoralType == Code.EnumHelper.MoralType.Once*/ select p); if (vm.MoralId.HasValue && vm.MoralId.Value > 0) { tb = tb.Where(p => p.tbMoralItem.tbMoralGroup.tbMoral.Id == vm.MoralId.Value); } if (!string.IsNullOrWhiteSpace(vm.SearchText)) { tb = tb.Where(p => p.tbStudent.StudentCode.Contains(vm.SearchText) || p.tbStudent.StudentName.Contains(vm.SearchText)); } if (Code.Common.UserType != Code.EnumHelper.SysUserType.Administrator) { tb = tb.Where(p => p.tbSysUser.Id == Code.Common.UserId); } vm.MoralDataList = (from p in tb orderby p.InputDate descending select new Dto.MoralData.List() { Id = p.Id, No = p.No, DataText = p.DataText, MoralName = p.tbMoralItem.tbMoralGroup.tbMoral.MoralName, InputDate = p.InputDate, MoralDate = p.MoralDate, MoralItemId = p.tbMoralItem.Id, MoralId = p.tbMoralItem.tbMoralGroup.tbMoral.Id, MoralItemName = p.tbMoralItem.MoralItemName, MoralOptionId = p.tbMoralOption != null ? p.tbMoralOption.Id : 0, MoralOptionName = p.tbMoralOption != null ? p.tbMoralOption.MoralOptionName : "-", MoralOptionScore = p.tbMoralOption != null ? p.tbMoralOption.MoralOptionValue : Decimal.Zero, StudentGroupName = p.tbClassGroup != null ? p.tbClassGroup.ClassGroupName : "-", ClassName = p.tbClass != null ? p.tbClass.ClassName : "-", StudentName = p.tbStudent != null ? p.tbStudent.StudentName : "-", SysUserName = p.tbSysUser.UserName, CheckStatus = p.CheckStatus }).ToPageList(vm.Page); //vm.MoralList = MoralController.SelectList(Code.EnumHelper.MoralType.Once); vm.MoralList = MoralController.SelectList(); //vm.MoralClassList return(View(vm)); } }