public ActionResult Index(OrderQueryModels query, string msg) { ViewBag.Msg = msg; IList <Inpinke_Order> list = DBOrderBLL.GetOrderByQueryModels(PageInfo, query); ViewBag.QueryModel = query; return(View(list)); }
/// <summary> /// 查询订单 /// </summary> /// <param name="pInfo"></param> /// <param name="qModel"></param> /// <returns></returns> public static IList <Inpinke_Order> GetOrderByQueryModels(PageInfo pInfo, OrderQueryModels qModel) { try { IList <Inpinke_Order> list = new List <Inpinke_Order>(); string field = " O.* "; string table = " Inpinke_Order O left join Inpinke_User U on O.UserID=U.ID "; string where = FormatQModel.FormatQueryModel <OrderQueryModels>(qModel); string orderby = " O.ID desc"; string countQ = PagerHelper.GetCountSQL(table, where); string qSql = PagerHelper.GetPager(table, pInfo.Skip, pInfo.PageSize, field, orderby, where); pInfo.Total = InpinkeDataContext.Instance.ExecuteQuery <int>(countQ).FirstOrDefault(); list = InpinkeDataContext.Instance.ExecuteQuery <Inpinke_Order>(qSql).ToList(); return(list); } catch (Exception ex) { Logger.Error(string.Format("GetOrderByQueryModels Error:{0}", ex.ToString())); return(null); } }