public MODEL.ViewModel.EasyUIGrid GetaccountRecordGrid(MODEL.ViewModel.DataTableRequest request) { try { var predicate = PredicateBuilder.True <accountRecord>(); DateTime time = TypeParser.ToDateTime("1975-1-1"); int total = 0; predicate = predicate.And(p => p.typefund == 2); //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("published")) //{ // var i=TypeParser.ToInt32(FilterHelper.GetParaValue("published",request.Where,"&*&")); // predicate = predicate.And(p1 => p1.ispublish == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("check")) //{ // var i = TypeParser.ToInt32(FilterHelper.GetParaValue("check", request.Where, "&*&")); // predicate = predicate.And(p2 => p2.ischeck == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("searchmsg")) //{ // var i = FilterHelper.GetParaValue("searchmsg", request.Where, "&*&"); // predicate = predicate.And(p1 => p1.productname.Contains(i) || p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} //else if (!string.IsNullOrEmpty(request.Search)) //{ // var i = request.Search; // predicate = predicate.Or(p1 => p1.productname.Contains(i)|| p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} var data = base.LoadPagedList(request.PageNumber, request.PageSize, ref total, predicate, request.Model, p => true, request.SortOrder, request.SortName).Select(p => new ViewModelAccountRecord() { id = p.id, aid = p.aid, typefund = p.typefund, money = p.money, membername = p.membername, status = p.status, createdate = p.createdate, finishdate = p.finishdate, membercode = p.membercode, payaddress = p.Member.payaddress, paycode = p.Member.paycode, payname = p.Member.payname, paybank = p.Member.paybank, // paybao = p.Member.paybao }); //var list = ViewModelProduct.ToListViewModel(data); return(new MODEL.ViewModel.EasyUIGrid() { draw = request.Draw, rows = data, total = total }); } catch (Exception) { throw; } }
public MODEL.ViewModel.EasyUIGrid GetProductGrid(MODEL.ViewModel.DataTableRequest request) { try { var predicate = PredicateBuilder.True <product>(); DateTime time = TypeParser.ToDateTime("1975-1-1"); int total = 0; predicate = predicate.And(p => p.isdelete != 1); //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("published")) //{ // var i=TypeParser.ToInt32(FilterHelper.GetParaValue("published",request.Where,"&*&")); // predicate = predicate.And(p1 => p1.ispublish == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("check")) //{ // var i = TypeParser.ToInt32(FilterHelper.GetParaValue("check", request.Where, "&*&")); // predicate = predicate.And(p2 => p2.ischeck == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("searchmsg")) //{ // var i = FilterHelper.GetParaValue("searchmsg", request.Where, "&*&"); // predicate = predicate.And(p1 => p1.productname.Contains(i) || p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} //else if (!string.IsNullOrEmpty(request.Search)) //{ // var i = request.Search; // predicate = predicate.Or(p1 => p1.productname.Contains(i)|| p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} var data = base.LoadPagedList(request.PageNumber, request.PageSize, ref total, predicate, request.Model, p => true, request.SortOrder, request.SortName).Select(p => new ViewModelProduct() { Pid = p.pid, PcId = p.pcid, SupplierId = p.supplierid.Value, ProductName = p.productname, IsPublish = p.ispublish.Value, PublishDate = p.publishdate == null ? time : p.publishdate.Value, IsHot = p.ishot.Value, CreateDate = p.createdate == null ? time : p.createdate, IsCheck = p.ischeck == null ? 0 : p.ischeck.Value, Special = p.isspecial == null ? 0 : p.isspecial.Value, SupplierName = p.supplier.suppliername }); //var list = ViewModelProduct.ToListViewModel(data); return(new MODEL.ViewModel.EasyUIGrid() { draw = request.Draw, rows = data, total = total }); } catch (Exception) { throw; } }
public EasyUIGrid GetAllSuppliers(MODEL.ViewModel.DataTableRequest request) { int total = 0; return(new EasyUIGrid() { rows = GetAllSuppliers(request, ref total), total = total }); }
public MODEL.ViewModel.EasyUIGrid GetUpgradeRecordGrid(MODEL.ViewModel.DataTableRequest request) { try { var predicate = PredicateBuilder.True <UpgradeRecord>(); DateTime time = TypeParser.ToDateTime("1975-1-1"); int total = 0; predicate = predicate.And(p => p.isdelete != 1); //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("published")) //{ // var i=TypeParser.ToInt32(FilterHelper.GetParaValue("published",request.Where,"&*&")); // predicate = predicate.And(p1 => p1.ispublish == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("check")) //{ // var i = TypeParser.ToInt32(FilterHelper.GetParaValue("check", request.Where, "&*&")); // predicate = predicate.And(p2 => p2.ischeck == i); //} //if (!string.IsNullOrEmpty(request.Where) && request.Where.Contains("searchmsg")) //{ // var i = FilterHelper.GetParaValue("searchmsg", request.Where, "&*&"); // predicate = predicate.And(p1 => p1.productname.Contains(i) || p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} //else if (!string.IsNullOrEmpty(request.Search)) //{ // var i = request.Search; // predicate = predicate.Or(p1 => p1.productname.Contains(i)|| p1.keyword.Contains(i) || p1.supplier.suppliername.Contains(i) || p1.product_category.categoryname.Contains(i)); //} var data = base.LoadPagedList(request.PageNumber, request.PageSize, ref total, predicate, request.Model, p => true, request.SortOrder, request.SortName); //var list = ViewModelProduct.ToListViewModel(data); return(new MODEL.ViewModel.EasyUIGrid() { draw = request.Draw, rows = data, total = total }); } catch (Exception) { throw; } }