public object GetGoodsList(string comfirmStatus, string byPayID)
{
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"));
iptSearch.Value = searchName;
sltByTimeStart.Value = byTimeStart;
sltByTimeEnd.Value = byTimeEnd;
int pageSize = 20;
decimal moneyAmount = 0;
int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUnusualRebackTradeListCount(byTimeStart, byTimeEnd, comfirmStatus, byPayID, searchName);
string url = "/web/order/reback_trade.aspx?";
url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
url += "byComfirmStatus=" + ToolHelper.UrlParEncode(comfirmStatus, "") + "&";
url += "byPayID=" + ToolHelper.UrlParEncode(byPayID, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUnusualRebackTradeList(byTimeStart, byTimeEnd, comfirmStatus, byPayID, searchName, (pageNow - 1) * pageSize, pageSize, out moneyAmount);
PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");
pageNav.InnerHtml = pageNavHelper.ToHtml();
moneyAccount.InnerHtml = Convert.ToString(moneyAmount);
return(dt);
}
private object GetUserList(string byUserType)
{
string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
int pageNow = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
iptSearch.Value = searchName;
int pageSize = 50;
int devCount = 0;
string url = "/web/admin/web_user_list.aspx?";
url += "byScreenType=" + ToolHelper.UrlParEncode(byUserType, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
IEnumerable <dynamic> dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUserList(byUserType, searchName, (pageNow - 1) * pageSize, pageSize, out devCount);
PageNavHelper pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow=");
pageNav.InnerHtml = pageNavHelper.ToHtml();
int i = 1 * pageSize * (pageNow - 1) + 1;
return(dt.Select(info => {
return new
{
RowNo = i++,
info.UserName,
info.NickName,
info.Phone,
info.RegTime,
info.LastLogin,
info.CpyName,
info.NSex
};
}));;
}
public object GetGoodsList(string byOrderStatus, string sltOrderBy, string byReBackType)
{
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.ShippingTime DESC ";
}
if (sltOrderBy == "1")
{
devSort = " ORDER BY R.CreatTime DESC ";
}
iptSearch.Value = searchName;
sltByTimeStart.Value = byTimeStart;
sltByTimeEnd.Value = byTimeEnd;
int pageSize = 20;
string suppliersID = WebLoginHelper.GetAdminSupplier();
int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackThirdOrderListCount(byTimeStart, byTimeEnd, suppliersID, byOrderStatus, byReBackType, searchName);
string url = "/web/thirdAdmin/reback_order.aspx?";
url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
url += "byReBackType=" + ToolHelper.UrlParEncode(byReBackType, "") + "&";
url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackThirdOrderList(byTimeStart, byTimeEnd, suppliersID, byOrderStatus, byReBackType, 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 orderStatus)
{
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"));
sltByTimeStart.Value = byTimeStart;
sltByTimeEnd.Value = byTimeEnd;
iptSearch.Value = searchName;
int pageSize = 20;
string suppliersID = WebLoginHelper.GetAdminSupplier();
int listCount = 0;
string url = "/web/thirdAdmin/data_goodsInfo.aspx?";
url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
url += "byOrderStatus=" + ToolHelper.UrlParEncode(orderStatus, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageDataGoodsList(byTimeStart, byTimeEnd, suppliersID, orderStatus, searchName, (pageNow - 1) * pageSize, pageSize, out listCount);
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 = 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 orderStatus, string suppliersID, string payID, 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 O.AddTime 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).GetByPageOrderListCount(byTimeStart, byTimeEnd, suppliersID, orderStatus, payID, searchName);
string url = "/web/order/order_list.aspx?";
url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
url += "byOrderStatus=" + ToolHelper.UrlParEncode(orderStatus, "") + "&";
url += "byPayID=" + ToolHelper.UrlParEncode(payID, "") + "&";
url += "bySuppliers=" + ToolHelper.UrlParEncode(suppliersID, "") + "&";
url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageOrderList(byTimeStart, byTimeEnd, suppliersID, orderStatus, payID, 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);
}
