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);
}