Esempio n. 1
0
        /// <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());
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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));
        }
Esempio n. 4
0
        /// <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());
        }
Esempio n. 5
0
        /// <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());
        }
Esempio n. 6
0
        /// <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();
        }
Esempio n. 7
0
        /// <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();
        }
Esempio n. 8
0
 /// <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();
 }