public ActionResult GetJsonQualityItemType(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.QualityItem.List(); vm.QualityItemTypeList = typeof(Code.EnumHelper.QualityItemType).ToItemList(); return(Json(vm.QualityItemTypeList, JsonRequestBehavior.AllowGet)); } }
public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.QualityItem.List(); vm.QualityItemTypeList = typeof(Code.EnumHelper.QualityItemType).ToItemList(); var tb = from p in db.Table <Quality.Entity.tbQualityItem>() .Include(d => d.tbQualityItemGroup) where p.tbQualityItemGroup.tbQuality.Id == vm.QualityId && p.IsDeleted == false && p.tbQualityItemGroup.IsDeleted == false && ((vm.QualityItemGroupId == null || vm.QualityItemGroupId == 0)? true :p.tbQualityItemGroup.Id == vm.QualityItemGroupId) select p; var aa = tb.ToList(); if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.QualityItemName.Contains(vm.SearchText)); } vm.QualityItemGroupList = (from p in db.Table <Quality.Entity.tbQualityItemGroup>() where p.tbQuality.Id == vm.QualityId orderby p.No select new System.Web.Mvc.SelectListItem { Text = p.QualityItemGroupName, Value = p.Id.ToString(), }).Distinct().ToList(); vm.QualityItemList = (from p in tb orderby p.No select new Dto.QualityItem.List { Id = p.Id, No = p.No, QualityItemName = p.QualityItemName, QualityItemType = p.QualityItemType, QualityItemGroupName = p.tbQualityItemGroup.QualityItemGroupName, IsVertical = p.IsVertical, }).ToList(); return(View(vm)); } }
public ActionResult List(Models.QualityItem.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, qualityItemGroupId = vm.QualityItemGroupId, qualityId = vm.QualityId }))); }