var data = (from u in _stone_storageService.LoadSearchData(roleQuery).AsEnumerable()
select new
{
u.ID ,
datetime = u.datetime.ToString(),
u.S_Number,
u.Settlement_Method,
u.supplier,
u.R_Amount,
u. Approval_Status ,
u.founder,
u.reviewer,
u.subject
});
//构造成Json的格式传递
var result = new { total = Math.Ceiling(Convert.ToDouble(roleQuery.Total * 1.0 / pageSize)), rows = data, records = roleQuery.Total };
//var result = new { total = Math.Ceiling(Convert.ToDouble(data1.Count() * 1.0 / pageSize)), rows = data1, records = data1.Count() };
return Json(result, JsonRequestBehavior.AllowGet);
以S_Number字段去除重复值,其余字段可以有重复值。
求大神指教!!!