public ActionResult AjaxListStore(jQueryDataTableParamModel param)
{
DataTables table;
User user = (User)Session["CurrentUser"];
user = db.Users.Find(user.UserID);
if (db.Roles.Find(1).Users.Contains(user) || db.Roles.Find(4).Users.Contains(user))
{
table = new DataTables(
((IObjectContextAdapter)new EntityContext()).ObjectContext,
"store",
new string[] { "Stores.StoreName", "Stores.Address", "Stores.Region.RegionName", "Stores.StoreID" },
"EntityContext.Stores",
"AjaxListStore", "SalesRecord",
new string[] { "销售点名", "详细地址", "所属片区", "操作" });
}
else
{
table = new DataTables(
((IObjectContextAdapter)new EntityContext()).ObjectContext,
"store",
new string[] { "s.StoreName", "s.Address", "s.Region.RegionName", "s.StoreID" },
"FLATTEN(select value Users.StoresBelonged from EntityContext.Users where Users.UserID = " + user.UserID + ") as s",
"AjaxListStore", "SalesRecord",
new string[] { "销售点名", "详细地址", "所属片区", "操作" });
}
ViewBag.DataTable = table;
return Json(table.AjaxHandler(param), JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParamModel param)
{
return Json(table.AjaxHandler(param), JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler1(jQueryDataTableParamModel param)
{
storeTable.Where = "Stores.RegionID = " + Session["ViewRegionID"].ToString();
return Json(storeTable.AjaxHandler(param), JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParamModel param)
{
RecordTable.Where = "SalesRecords.Store.StoreID = " + Session["ViewStoreID"].ToString();
return Json(RecordTable.AjaxHandler(param), JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler1(jQueryDataTableParamModel param)
{
CommodityTable.Where = "Commodities.CategoryID = " + Session["ViewCategoryID"].ToString();
return Json(CommodityTable.AjaxHandler(param), JsonRequestBehavior.AllowGet);
}
public object AjaxHandler(jQueryDataTableParamModel param)
{
var query = objContext.CreateQuery<DbDataRecord>("select count(" + select[select.Length - 1] + ") from " + this.from);
var total = 0;
try
{
foreach (var item in query)
{
total = Convert.ToInt32(item[0]);
break;
}
}
catch
{
total = 0;
}
var eSQL = sql;
eSQL += " where " + cwhere;
if (!string.IsNullOrEmpty(param.sSearch))
{
eSQL += " and " + String.Format(where, param.sSearch);
}
var orderBy = " order by " + select[param.iSortCol_0] + " " + param.sSortDir_0;
if (string.IsNullOrEmpty(param.sSortDir_0))
{
orderBy = " order by " + select[select.Count()];
}
eSQL += orderBy;
var entries = objContext.CreateQuery<DbDataRecord>(eSQL);
var result = entries
.Skip(param.iDisplayStart)
.Take(param.iDisplayLength);
var dataList = new List<List<string>>();
try
{
foreach (var item in result)
{
var newRow = new List<string>();
for (int i = 0; i < item.FieldCount; i++)
{
newRow.Add(item[i].ToString());
}
dataList.Add(newRow);
}
}
catch
{
dataList.Clear();
}
return (new
{
sEcho = param.sEcho,
iTotalRecords = total,
iTotalDisplayRecords = entries.Count(),
aaData = dataList
});
}