public object GetBrandList() { int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 15; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageAdminListCount(string.Empty); string url = "/web/admin/web_admin_list.aspx?"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageAdminList((pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetBrandList() { int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 5; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount(" SELECT COUNT(*) FROM M_FareTemplate ", null); string url = "/web/database/fareDeliery_list.aspx?"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT * FROM M_FareTemplate WHERE 1=1 LIMIT @StartSize,@EndSize", new { StartSize = (pageNow - 1) * pageSize, EndSize = pageSize }).Select(info => { return(new { info.FareName, info.FareSysID, info.UpdateTime }); }); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetBrandList() { int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 18; string url = "/web/database/imges.aspx?"; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_FileManage>("1=1 AND FileName NOT LIKE '%Themb%'", null); object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_FileManage>(" 1=1 AND FileName NOT LIKE '%Themb%' ORDER BY CreatTime ASC LIMIT @PageNow ,@PageSize ", new { PageNow = (pageNow - 1) * pageSize, pageSize = pageSize });//.Select(info => new { FilePath = "http://mallmanage.51ipc.com/" + info.FilePath, info.FileName,info.FileSysID }); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetList() { int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 10; int devCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageRollListCount(); string url = "/web/database/roll.aspx?"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageRollList((pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetList() { int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 20; int devCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_ErrorLog>(" 1=1 ", null); string url = "/web/database/log_error.aspx?"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_ErrorLog>(" 1=1 ORDER BY ErrLogTime DESC LIMIT @StartSize,@EndSize ", new { StartSize = (pageNow - 1) * pageSize, EndSize = pageSize }); PageNavHelper pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetSizeList() { string bySysID = ToolHelper.UrlParDecode(Request.QueryString["bySysID"], ""); string searchName = string.Empty; int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); int pageSize = 20; int productCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageCagegoryListCount(bySysID); string url = "/web/database/category.aspx?"; url += "bySysID=" + ToolHelper.UrlParEncode(bySysID, "") + "&"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageCagegoryList(bySysID, (pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(productCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetBrandList() { string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], ""); int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); iptSearch.Value = searchName; int pageSize = 10; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageBrandListCount(searchName); string url = "/web/database/brand.aspx?"; url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageBrandList(searchName, (pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetGoodsList(string suppliersID, string payID, string byReBackType, string byAuthType, string sltOrderBy) { string devSort = string.Empty; string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], ""); string byTimeStart = ToolHelper.UrlParDecode(Request.QueryString["byTimeStart"], ""); string byTimeEnd = ToolHelper.UrlParDecode(Request.QueryString["byTimeEnd"], ""); int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); if (sltOrderBy == "0") { devSort = " ORDER BY O.PayTime DESC "; } if (sltOrderBy == "1") { devSort = " ORDER BY R.CreatTime DESC "; } if (sltOrderBy == "2") { devSort = " ORDER BY O.UpdateTime DESC "; } iptSearch.Value = searchName; sltByTimeStart.Value = byTimeStart; sltByTimeEnd.Value = byTimeEnd; int pageSize = 20; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackOrderListCount(byTimeStart, byTimeEnd, suppliersID, payID, byReBackType, byAuthType, searchName); string url = "/web/order/order_list.aspx?"; url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&"; url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&"; url += "byPayID=" + ToolHelper.UrlParEncode(payID, "") + "&"; url += "byReBackType=" + ToolHelper.UrlParEncode(byReBackType, "") + "&"; url += "byAuthType=" + ToolHelper.UrlParEncode(byAuthType, "") + "&"; url += "bySuppliers=" + ToolHelper.UrlParEncode(suppliersID, "") + "&"; url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&"; url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackOrderList(byTimeStart, byTimeEnd, suppliersID, payID, byReBackType, byAuthType, searchName, devSort, (pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }
public object GetGoodsList(string byCateType, string bySuppliers, string byIsEnable, string byOrderBy) { string devSort = string.Empty; string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], ""); int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1")); if (byOrderBy == "0") { devSort = " ORDER BY GoodsNumber ASC, OrderBy ASC,GoodsID "; } if (byOrderBy == "1") { devSort = " ORDER BY ShopPrice ASC ,OrderBy ASC,GoodsID "; } if (byOrderBy == "2") { devSort = " ORDER BY SaleNumber DESC ,OrderBy ASC,GoodsID "; } if (byOrderBy == "3") { devSort = " ORDER BY AddTime DESC ,OrderBy ASC,GoodsID "; } iptSearch.Value = searchName; int pageSize = 10; int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsListCount(byCateType, bySuppliers, byIsEnable, searchName); string url = "/web/goods/goods_list.aspx?"; url += "byCateType=" + ToolHelper.UrlParEncode(byCateType, "") + "&"; url += "bySuppliers=" + ToolHelper.UrlParEncode(bySuppliers, "") + "&"; url += "byIsEnable=" + ToolHelper.UrlParEncode(byIsEnable, "") + "&"; url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&"; url += "byOrderBy=" + ToolHelper.UrlParEncode(byOrderBy, "") + "&"; object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsList(byCateType, bySuppliers, byIsEnable, devSort, searchName, (pageNow - 1) * pageSize, pageSize); PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow="); pageNav.InnerHtml = pageNavHelper.ToHtml(); return(dt); }