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 void BindDdl()
{
string strWhere = " SELECT * FROM M_Category WHERE 1=1 AND IsDelete=0 ORDER BY ParentID ASC , OrderBy ASC ";
IEnumerable <dynamic> CateInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(strWhere, null);
new DdlHelper().BindDdlMore(sltByCateType, CateInfo, "全部", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
IEnumerable <dynamic> FareInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT FareName,FareSysID FROM M_FareTemplate WHERE 1=1 ", null);
new DdlHelper().BindDdlMore(addFareTemp, FareInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.FareName), Convert.ToString(x.FareSysID))); });
IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Suppliers WHERE 1=1", null);
new DdlHelper().BindDdlMore(addSuppliers, SuppliersInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
hiddenSupplier.InnerHtml = WebLoginHelper.GetAdminSupplier();
if (!string.IsNullOrEmpty(Request.QueryString["byCateType"]))
{
sltByCateType.SelectedIndex = sltByCateType.Items.IndexOf(sltByCateType.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byCateType"], "")));
}
if (!string.IsNullOrEmpty(Request.QueryString["byIsEnable"]))
{
sltByIsEnable.SelectedIndex = sltByIsEnable.Items.IndexOf(sltByIsEnable.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byIsEnable"], "")));
}
if (!string.IsNullOrEmpty(Request.QueryString["byOrderBy"]))
{
sltOrderBy.SelectedIndex = sltOrderBy.Items.IndexOf(sltOrderBy.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byOrderBy"], "")));
}
}
/// <summary>
/// 获取当前账户需要处理的售后换货订单数量
/// </summary>
/// <param name="hrefUrl"></param>
/// <returns></returns>
private int GetReBackOrderToChangeGoods(out string hrefUrl)
{
int resMsg = 0;
hrefUrl = "javascript:;";
string suppliersID = WebLoginHelper.GetAdminSupplier();
if (!string.IsNullOrEmpty(suppliersID))
{
if (WebLoginHelper.IsAuthority(AdminAuth.SuppliersManage))
{
hrefUrl = "/web/thirdAdmin/data_backorder.aspx?";
resMsg = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_ReBackOrder>(" SuppliersID=@_SuppliersID AND ReBackType=20 AND AuthType=30 ", new { _SuppliersID = suppliersID });
}
}
return(resMsg);
}
public object GetGoodsList(string orderStatus, 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;
string suppliersID = WebLoginHelper.GetAdminSupplier();
int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageDataOrderListCount(byTimeStart, byTimeEnd, suppliersID, orderStatus, searchName);
string url = "/web/order/order_list.aspx?";
url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
url += "byOrderStatus=" + ToolHelper.UrlParEncode(orderStatus, "") + "&";
url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageDataOrderList(byTimeStart, byTimeEnd, suppliersID, orderStatus, devSort, searchName, (pageNow - 1) * pageSize, pageSize);
PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");
pageNav.InnerHtml = pageNavHelper.ToHtml();
orderCount.InnerHtml = Convert.ToString(listCount);
return(dt);
}
/// <summary>
/// 获取当前账号需要发货的订单数量
/// </summary>
/// <returns></returns>
private int GetOrderInfoToDelivery(out string hrefUrl)
{
int resMsg = 0;
hrefUrl = "javascript:;";
string suppliersID = WebLoginHelper.GetAdminSupplier();
if (!string.IsNullOrEmpty(suppliersID))
{
if (WebLoginHelper.IsAuthority(AdminAuth.SuppliersManage))
{
hrefUrl = "/web/thirdAdmin/orderList.aspx?";
resMsg = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_OrderInfo>(" SuppliersID=@_SuppliersID AND OrderStatus=1 AND PayStatus=2 AND ShippingStatus=0 ", new { _SuppliersID = suppliersID });
}
else if (WebLoginHelper.IsAuthority(AdminAuth.BackgroundManage))
{
hrefUrl = "/web/order/order_list.aspx?";
resMsg = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_OrderInfo>(" OrderStatus=1 AND PayStatus=2 AND ShippingStatus=0 ", null);
}
}
return(resMsg);
}
public object GetGoodsList(string byCateType, 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 ";
}
if (byOrderBy == "1")
{
devSort = " ORDER BY ShopPrice ASC ,OrderBy ASC ";
}
if (byOrderBy == "2")
{
devSort = " ORDER BY SaleNumber DESC ,OrderBy ASC ";
}
if (byOrderBy == "3")
{
devSort = " ORDER BY AddTime DESC ,OrderBy ASC ";
}
iptSearch.Value = searchName;
int pageSize = 7;
int listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsListSuppliersCount(byCateType, WebLoginHelper.GetAdminSupplier(), byIsEnable, searchName);
string url = "/web/thirdAdmin/goodsList.aspx?";
url += "byCateType=" + ToolHelper.UrlParEncode(byCateType, "") + "&";
url += "byIsEnable=" + ToolHelper.UrlParEncode(byIsEnable, "") + "&";
url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
url += "byOrderBy=" + ToolHelper.UrlParEncode(byOrderBy, "") + "&";
object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsListSuppliers(byCateType, WebLoginHelper.GetAdminSupplier(), byIsEnable, devSort, searchName, (pageNow - 1) * pageSize, pageSize);
PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");
pageNav.InnerHtml = pageNavHelper.ToHtml();
return(dt);
}