protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("statis_sales", "销售报表"))
{
PageReturnMsg = PageNoPowerMsg();
}
display = RequestTool.RequestInt("display", 0);
Pay_id = RequestTool.RequestInt("Pay_id", 0);
Transport_id = RequestTool.RequestInt("Transport_id", 0);
dateFrom = RequestTool.RequestString("dateFrom");
if (dateFrom == "")
{
dateFrom = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
}
dateTo = RequestTool.RequestString("dateTo");
if (dateTo == "")
{
dateTo = System.DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
}
Y_dateFrom = Convert.ToDateTime(dateFrom).Year;
M_dateFrom = Convert.ToDateTime(dateFrom).Month;
D_dateFrom = Convert.ToDateTime(dateFrom).Day;
Y_dateTo = Convert.ToDateTime(dateTo).Year;
M_dateTo = Convert.ToDateTime(dateTo).Month;
D_dateTo = Convert.ToDateTime(dateTo).Day;
pays = B_Lebi_Pay.GetList("", "Sort desc");
transports = B_Lebi_Transport.GetList("", "Sort desc");
}
public string GetOptionTransport(int ID)
{
List <Lebi_Transport> models = B_Lebi_Transport.GetList("", "");
string str = "<option value=\"\">请选择</option>";
foreach (Lebi_Transport model in models)
{
string sel = "";
if (ID == model.id)
{
sel = "selected";
}
str += "<option value=\"" + model.id + "\" " + sel + ">" + model.Name + "</option>";
}
return(str);
}
public string transportlist(int sid)
{
List <Lebi_Transport> models = B_Lebi_Transport.GetList("", "Sort desc");
string str = "";
foreach (Lebi_Transport m in models)
{
string sel = "";
if (m.id == sid)
{
sel = "selected";
}
str += "<option code=\"" + m.Type_id_TransportType + "\" value=\"" + m.id + "\" " + sel + ">" + m.Name + "</option>";
}
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_transport_list", "配送方式"))
{
PageReturnMsg = PageNoPowerMsg();
}
key = RequestTool.RequestString("key");
PageSize = RequestTool.getpageSize(25);
string where = "1=1";
//if (pid > 0)
// where += " and Parentid="+pid;
if (key != "")
{
where += " and [Name] like lbsql{'%" + key + "%'}";
}
models = B_Lebi_Transport.GetList(where, "Sort asc", PageSize, page);
int recordCount = B_Lebi_Transport.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&key=" + key, page, PageSize, recordCount);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("statis_orderproduct", "订单报表"))
{
PageReturnMsg = PageNoPowerMsg();
}
key = RequestTool.RequestString("key");
peisongdian = RequestTool.RequestString("peisongdian");
IsPay = RequestTool.RequestInt("IsPay", -1);
Pay_id = RequestTool.RequestInt("Pay_id", 0);
Transport_id = RequestTool.RequestInt("Transport_id", 0);
supplier_id = RequestTool.RequestString("supplier_id");
dateFrom = RequestTool.RequestString("dateFrom");
if (dateFrom == "")
{
dateFrom = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
}
dateTo = RequestTool.RequestString("dateTo");
if (dateTo == "")
{
dateTo = System.DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
}
suppliers = B_Lebi_Supplier.GetList("", "");
where = "1=1";
if (IsPay != -1)
{
where += " and IsPaid = " + IsPay;
}
if (Pay_id != 0)
{
where += " and Pay_id = " + Pay_id;
}
if (Transport_id != 0)
{
where += " and Transport_id = " + Transport_id;
}
if (dateFrom != "" && dateTo != "")
{
where += " and Time_Add>='" + dateFrom + "' and Time_Add<='" + dateTo + " 23:59:59'";
}
if (supplier_id != "")
{
try
{
supplier_id = Convert.ToInt32(supplier_id).ToString();
}
catch
{
supplier_id = "0";
}
where += " and Supplier_id = " + supplier_id;
}
if (peisongdian != "")
{
where += " and Supplier_Delivery_id in (select w.id from [Lebi_Supplier_Delivery] as w where w.Name like '%" + peisongdian + "%')";
}
if (key != "")
{
where += " and (Code like lbsql{'%" + key + "%'} or T_Name like lbsql{'%" + key + "%'}))";
}
PageSize = RequestTool.getpageSize(25);
page = RequestTool.RequestInt("page");
orders = B_Lebi_Order.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Order.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&peisongdian=" + peisongdian + "&supplier_id=" + supplier_id + "&dateTo=" + dateTo + "&dateFrom=" + dateFrom + "&IsPay=" + IsPay + "&Pay_id=" + Pay_id + "&Transport_id=" + Transport_id, page, PageSize, recordCount);
where = Server.UrlEncode(where);
pays = B_Lebi_Pay.GetList("", "Sort desc");
transports = B_Lebi_Transport.GetList("", "Sort desc");
//Response.Write(where);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("statis_orderproduct", "订单报表"))
{
PageReturnMsg = PageNoPowerMsg();
}
key = RequestTool.RequestString("key");
orderkey = RequestTool.RequestString("orderkey");
IsPay = RequestTool.RequestInt("IsPay", -1);
Pay_id = RequestTool.RequestInt("Pay_id", 0);
Transport_id = RequestTool.RequestInt("Transport_id", 0);
supplier_id = RequestTool.RequestString("supplier_id");
dateFrom = RequestTool.RequestString("dateFrom");
if (dateFrom == "")
{
dateFrom = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
}
dateTo = RequestTool.RequestString("dateTo");
if (dateTo == "")
{
dateTo = System.DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
}
suppliers = B_Lebi_Supplier.GetList("", "");
where = "1=1";
if (IsPay != -1)
{
where += " and w.IsPaid = " + IsPay;
}
if (Pay_id != 0)
{
where += " and w.Pay_id = " + Pay_id;
}
if (Transport_id != 0)
{
where += " and w.Transport_id = " + Transport_id;
}
where += " and (datediff(d,w.Time_Add,'" + dateFrom + "')<=0 and datediff(d,w.Time_Add,'" + dateTo + "')>=0)";
if (supplier_id != "")
{
try
{
supplier_id = Convert.ToInt32(supplier_id).ToString();
}
catch
{
supplier_id = "0";
}
where += " and w.Supplier_id = " + supplier_id;
}
if (orderkey != "")
{
where += " and w.Code like '%" + orderkey + "%'";
}
where = "Order_id in (select w.id from Lebi_Order as w where " + where + ")";
if (key != "")
{
where += " and (Product_Name like lbsql{'%" + key + "%'} or Product_Number like lbsql{'%" + key + "%'})";
}
PageSize = RequestTool.getpageSize(25);
//PageSize = 100;
page = RequestTool.RequestInt("page");
pros = B_Lebi_Order_Product.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Order_Product.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&orderkey=" + orderkey + "&supplier_id=" + supplier_id + "&dateTo=" + dateTo + "&dateFrom=" + dateFrom + "&IsPay=" + IsPay + "&Pay_id=" + Pay_id + "&Transport_id=" + Transport_id, page, PageSize, recordCount);
where = Server.UrlEncode(where);
pays = B_Lebi_Pay.GetList("", "Sort desc");
transports = B_Lebi_Transport.GetList("", "Sort desc");
//Response.Write(where);
}