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