/// <summary> /// 水质管理"searchString", ViewBag.search /// </summary> /// <returns></returns> public ActionResult waterquality(int?page, string searchString, GridSortOptions model) { var c = new ecoBioWmsContext(); ViewBag.model = model; ViewBag.page = page; ViewBag.search = searchString; ViewBag.Column = ""; ViewBag.Direction = ""; //IEnumerable<DataManualCollection> list = (IEnumerable<DataManualCollection>)from s in c.DataManualCollections orderby s.manual_collection_sn descending select s; //if (!String.IsNullOrEmpty(searchString)) //{ // double v = Convert.ToDouble(searchString); // list = list.Where(p => p.manual_collection_value == v); // ViewBag.search = searchString; //} //if (!string.IsNullOrEmpty(model.Column)) //{ // ViewBag.Column = model.Column; // ViewBag.Direction = model.Direction; // list = list.OrderBy(model.Column, model.Direction); //} //list = list.AsPagination(page ?? 1, 5); //return View(list); return(View()); }
public ActionResult griddata(int? page, int? pagesize, string sortname, string snsortorder, string search) { var c = new ecoBioWmsContext(); //var list = from s in c.DataManualCollections // select new ecoBio.Wms.ViewModel.TableData // { // date = s.manual_collection_date, // guid = s.process_unit_guid.Value, // name = s.client_code, // sn = s.manual_collection_sn, // value = s.manual_collection_value.Value // }; //if (!String.IsNullOrEmpty(search)) //{ // double v = Convert.ToDouble(search); // list = list.Where(p => p.value == v); //} //list = list.OrderBy(s => s.sn); //int pageSize = (pagesize ?? 20); ; //int pageNumber = (page ?? 1); //PagedList<TableData> vs = list.ToPagedList(pageNumber, pageSize); //ligerGrid ligd = new ligerGrid { Rows=vs , Total=vs.TotalCount }; //GridData gd = new GridData { Data = vs, IsNextPage = vs.IsNextPage, IsPreviousPage = vs.IsPreviousPage, PageIndex = vs.PageIndex, PageSize = vs.PageSize, TotalCount = vs.TotalPages, TotalPages = vs.TotalPages }; //var json = JsonHelper.ToJson(ligd); //return Json(ligd, JsonRequestBehavior.AllowGet); var json = JsonHelper.ToJson(""); return Json(json, JsonRequestBehavior.AllowGet); }
public JsonResult waterloaddata(int?page, string search) { var c = new ecoBioWmsContext(); #region 2013年4月22日注释 //var list = from s in c.DataManualCollections // select new ecoBio.Wms.ViewModel.TableData // { // date = s.manual_collection_date, // guid = s.process_unit_guid.Value, // name = s.client_code, // sn = s.manual_collection_sn, // value = s.manual_collection_value.Value // }; //if (!String.IsNullOrEmpty(search)) //{ // double v = Convert.ToDouble(search); // list = list.Where(p => p.value == v); //} //list = list.OrderBy(s => s.sn); //int pageSize = 11; //int pageNumber = (page ?? 1); //PagedList<TableData> vs = list.ToPagedList(pageNumber, pageSize); //GridData gd = new GridData { Data = vs, IsNextPage = vs.IsNextPage, IsPreviousPage = vs.IsPreviousPage, PageIndex = vs.PageIndex, PageSize = vs.PageSize, TotalCount = vs.TotalPages, TotalPages = vs.TotalPages }; ////object o=list.ToPagedList(pageNumber, pageSize); //var json = JsonHelper.ToJson(gd); //return Json(gd, JsonRequestBehavior.AllowGet); #endregion var json = JsonHelper.ToJson(""); return(Json(json)); }
/// <summary> /// 进水负荷 /// </summary> /// <returns></returns> public ActionResult waterload() { var c = new ecoBioWmsContext(); //var list = from s in c.DataManualCollections orderby s.manual_collection_sn ascending select s; // list = list.OrderByDescending(s => s.manual_collection_sn); //return View(list.ToPagedList(1, 11)); return(View()); }
/// <summary> /// 历史趋势//search,sn,date,value,sort /// </summary> /// <returns></returns> public ActionResult historytrend(string sortOrder, string searchString, string currentFilter, int?page) { var c = new ecoBioWmsContext(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "Date desc" : "Date"; ViewBag.CurrentSort = sortOrder; ViewBag.CurrentFilter = searchString; //if (Request.HttpMethod == "GET") //{ // searchString = currentFilter; //} //else //{ // page = 1; //} //var list = from s in c.DataManualCollections select s; //if (!String.IsNullOrEmpty(searchString)) //{ // double v = Convert.ToDouble(searchString); // list = list.Where(p => p.manual_collection_value == v); //} //switch (sortOrder) //{ // case "Name desc": // list = list.OrderByDescending(s => s.process_unit_guid); break; // case "Date": // list = list.OrderBy(s => s.manual_collection_date); break; // case "Date desc": // list = list.OrderByDescending(s => s.manual_collection_date); break; // default: // list = list.OrderBy(s => s.process_unit_guid); break; //} //int pageSize = 11; //int pageNumber = (page ?? 1); //return View(list.ToPagedList(pageNumber, pageSize)); return(View()); }
/// <summary> /// 历史趋势//search,sn,date,value,sort /// </summary> /// <returns></returns> public ActionResult historytrend(string sortOrder, string searchString, string currentFilter, int? page) { var c = new ecoBioWmsContext(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "Date desc" : "Date"; ViewBag.CurrentSort = sortOrder; ViewBag.CurrentFilter = searchString; //if (Request.HttpMethod == "GET") //{ // searchString = currentFilter; //} //else //{ // page = 1; //} //var list = from s in c.DataManualCollections select s; //if (!String.IsNullOrEmpty(searchString)) //{ // double v = Convert.ToDouble(searchString); // list = list.Where(p => p.manual_collection_value == v); //} //switch (sortOrder) //{ // case "Name desc": // list = list.OrderByDescending(s => s.process_unit_guid); break; // case "Date": // list = list.OrderBy(s => s.manual_collection_date); break; // case "Date desc": // list = list.OrderByDescending(s => s.manual_collection_date); break; // default: // list = list.OrderBy(s => s.process_unit_guid); break; //} //int pageSize = 11; //int pageNumber = (page ?? 1); //return View(list.ToPagedList(pageNumber, pageSize)); return View(); }
/// <summary> /// 水质管理"searchString", ViewBag.search /// </summary> /// <returns></returns> public ActionResult waterquality(int? page, string searchString, GridSortOptions model) { var c = new ecoBioWmsContext(); ViewBag.model = model; ViewBag.page = page; ViewBag.search = searchString; ViewBag.Column = ""; ViewBag.Direction = ""; //IEnumerable<DataManualCollection> list = (IEnumerable<DataManualCollection>)from s in c.DataManualCollections orderby s.manual_collection_sn descending select s; //if (!String.IsNullOrEmpty(searchString)) //{ // double v = Convert.ToDouble(searchString); // list = list.Where(p => p.manual_collection_value == v); // ViewBag.search = searchString; //} //if (!string.IsNullOrEmpty(model.Column)) //{ // ViewBag.Column = model.Column; // ViewBag.Direction = model.Direction; // list = list.OrderBy(model.Column, model.Direction); //} //list = list.AsPagination(page ?? 1, 5); //return View(list); return View(); }
/// <summary> /// 进水负荷 /// </summary> /// <returns></returns> public ActionResult waterload() { var c = new ecoBioWmsContext(); //var list = from s in c.DataManualCollections orderby s.manual_collection_sn ascending select s; // list = list.OrderByDescending(s => s.manual_collection_sn); //return View(list.ToPagedList(1, 11)); return View(); }