protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_message", "站内信"))
{
WindowNoPower();
}
User_Name = RequestTool.RequestString("User_Name");
ids = RequestTool.RequestString("ids");
if (ids != "")
{
user = B_Lebi_Supplier.GetList("id in (lbsql{" + ids + "})", "id desc");
if (user != null)
{
}
}
}
public string SupplierOptions(int sid)
{
string str = "";
List <Lebi_Supplier> models = B_Lebi_Supplier.GetList("Type_id_SupplierStatus=442", "");
foreach (Lebi_Supplier model in models)
{
string sel = "";
if (model.id == sid)
{
sel = "selected";
}
str += "<option value=\"" + model.id + "\" " + sel + ">" + model.SubName + "</option>";
}
return(str);
}
/// <summary>
///
/// </summary>
/// <param name="sid"></param>
/// <returns></returns>
public string GetShops(int sid)
{
string str = "";
List <Lebi_Supplier> shops = B_Lebi_Supplier.GetList("Type_id_SupplierStatus=442 and IsSupplierTransport=1", "");
foreach (Lebi_Supplier shop in shops)
{
string sel = "";
if (sid == shop.id)
{
sel = "selected";
}
str += "<option value=\"" + shop.id + "\" " + sel + ">" + shop.Company + "</option>";
}
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_user_list", "商家列表"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
key = RequestTool.RequestString("key");
//lang = RequestTool.RequestString("lang");
level_id = RequestTool.RequestInt("level_id", 0);
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
status = RequestTool.RequestInt("status", 0);
type = RequestTool.RequestString("type");
if (type == "")
{
type = "supplier";
}
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
string where = "Supplier_Group_id in (select g.id from Lebi_Supplier_Group as g where g.type=lbsql{'" + type + "'})";
if (key != "")
{
where += " and (Name like lbsql{'%" + key + "%'} or Company like lbsql{'%" + key + "%'} or UserName like lbsql{'%" + key + "%'} or RealName like lbsql{'%" + key + "%'} or Phone like lbsql{'%" + key + "%'} or SupplierNumber like lbsql{'%" + key + "%'})";
}
//if (lang != "")
// where += " and Language = '" + lang + "'";
if (level_id > 0)
{
where += " and Supplier_Group_id = " + level_id;
}
if (status != 0)
{
where += " and Type_id_SupplierStatus = " + status;
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Reg,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Reg,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
models = B_Lebi_Supplier.GetList(where, "Time_Reg desc", PageSize, page);
int recordCount = B_Lebi_Supplier.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&level_id=" + level_id + "&status=" + status + "&key=" + key + "&type=" + type, page, PageSize, recordCount);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_message_write", "发送站内信"))
{
WindowNoPower();
}
User_Name = RequestTool.RequestString("User_Name");
ids = RequestTool.RequestString("ids");
if (ids != "")
{
user = B_Lebi_Supplier.GetList("id in (lbsql{" + ids + "})", "id desc");
if (user != null)
{
}
}
su = new SearchUser(CurrentAdmin, CurrentLanguage.Code);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
site = new Site_Supplier();
backurl = RequestTool.RequestString("url").Replace("<", "").Replace(">", "");
if (backurl == "")
{
backurl = site.AdminPath + "/login.aspx";
}
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a>" + Tag("É̼Ò×¢²á") + "</a>";
verifieds = B_Lebi_Supplier_Verified.GetList("", "Sort desc");
logintype = RequestTool.RequestString("logintype", "");
List <Lebi_Supplier> suppliers = B_Lebi_Supplier.GetList("User_id=" + CurrentUser.id + "", "id desc");
if (suppliers.Count == 0)
{
supplier = new Lebi_Supplier();
supplier.Type_id_SupplierStatus = 441;
}
if (logintype == "" && suppliers.Count > 0)
{
supplier = suppliers.FirstOrDefault();
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel(supplier.Supplier_Group_id);
logintype = group.type;
}
else
{
foreach (Lebi_Supplier sup in suppliers)
{
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel(sup.Supplier_Group_id);
if (logintype == group.type)
{
supplier = sup;
}
}
}
logintype = logintype == "" ? "supplier" : logintype;
if (supplier == null)
{
supplier = new Lebi_Supplier();
supplier.Address = CurrentUser.Address;
supplier.Area_id = CurrentUser.Area_id;
supplier.Fax = CurrentUser.Fax;
supplier.Email = CurrentUser.Email;
supplier.MobilePhone = CurrentUser.MobilePhone;
supplier.Msn = CurrentUser.Msn;
supplier.Phone = CurrentUser.Phone;
supplier.Postalcode = CurrentUser.Postalcode;
supplier.QQ = CurrentUser.QQ;
supplier.RealName = CurrentUser.RealName;
supplier.UserName = CurrentUser.UserName;
supplier.User_id = CurrentUser.id;
supplier.Type_id_SupplierStatus = 441;
status = Tag("ÐÂ×¢²á");
}
else
{
if (supplier.Type_id_SupplierStatus == 442)
{
Response.Redirect(site.AdminPath + "/login.aspx");
}
status = TypeName(supplier.Type_id_SupplierStatus);
}
}
/// <summary>
/// 发送站内信
/// </summary>
public void Message_Write()
{
if (!EX_Admin.Power("supplier_message_write", "发送站内信"))
{
AjaxNoPower();
return;
}
int Mode = RequestTool.RequestInt("Mode", 0);
int type_id = RequestTool.RequestInt("type_id", 0);
string Title = Language.RequestString("Title");
string Content = Language.RequestString("Content");
string User_Name_To = RequestTool.RequestString("User_Name_To");
//string UserLevel_ids = RequestTool.RequestString("UserLevel_ids");
string User_ids = RequestTool.RequestString("User_ids");
//string UserName_ids = RequestTool.RequestString("UserName_ids");
SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code);
//if (User_ids != "")
// Mode = 1;
//if (Mode == 0)
//{
// Lebi_User user = B_Lebi_User.GetModel("UserName = '******'");
// if (user == null)
// {
// Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}");
// return;
// }
// Lebi_Message model = new Lebi_Message();
// model.Title = Shop.Bussiness.Language.Content(Title, user.Language);
// model.Content = Shop.Bussiness.Language.Content(Content, user.Language);
// model.User_id_From = 0;
// model.User_Name_From = "管理员";
// model.User_id_To = user.id;
// model.User_Name_To = User_Name_To;
// model.IsRead = 0;
// model.IsSystem = 0;
// model.Time_Add = System.DateTime.Now;
// model.Language = user.Language;
// model.Message_Type_id = type_id;
// model.IP = RequestTool.GetClientIP();
// B_Lebi_Message.Add(model);
// Log.Add("发送站内信-指定会员", "Message", "", CurrentAdmin, User_Name_To);
//}
//else
//{
//string gradename = "";
string where = "";
if (User_Name_To != "")
{
where = "UserName = lbsql{'" + User_Name_To + "'}";
}
else if (User_ids != "")
{
where = "id in (lbsql{" + User_ids + "})";
}
else
{
where = "1=1 " + su.SQL;
}
//int i = 0;
List <Lebi_Supplier> modellist = B_Lebi_Supplier.GetList(where, "");
if (modellist.Count == 0)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
foreach (Lebi_Supplier user in modellist)
{
Lebi_Message model = new Lebi_Message();
model.Title = Shop.Bussiness.Language.Content(Title, user.Language);
model.Content = Shop.Bussiness.Language.Content(Content, user.Language);
model.User_id_From = 0;
model.User_Name_From = "管理员";
model.User_id_To = user.id;
model.User_Name_To = user.UserName;
model.IsRead = 0;
model.IsSystem = 0;
model.Time_Add = System.DateTime.Now;
model.Language = user.Language;
model.Message_Type_id = type_id;
model.IP = RequestTool.GetClientIP();
model.Supplier_id = user.id;
B_Lebi_Message.Add(model);
}
Log.Add("发送站内信", "Message", "", CurrentAdmin, su.Description);
//}
Response.Write("{\"msg\":\"OK\"}");
}
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);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_ShopSearch'");
keyword = RequestTool.RequestSafeString("keyword");
string key = RequestTool.RequestSafeString("key");
if (keyword == "" && key != "")
{
keyword = key;
}
sort = Rstring_Para("1");
area_id = RequestTool.RequestInt("area_id", 0);
id = 0;
where = "Supplier_Group_id in (select w.id from [Lebi_Supplier_Group] as w where w.type='supplier' or w.type='')";
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a class=\"text\"><span>" + Tag("µêÆÌËÑË÷") + "</span></a><em>»</em><a class=\"text\"><span>¡°" + keyword + "¡±</span></a>";
if (keyword != "")
{
string wherekeyword = "";
if (keyword.IndexOf(" ") > -1)
{
string[] keywordsArr;
keywordsArr = keyword.Split(new char[1] {
' '
});
foreach (string keywords in keywordsArr)
{
if (keywords != "")
{
if (wherekeyword == "")
{
wherekeyword = "(Name like lbsql{'%" + keywords + "%'} or SubName like lbsql{'%" + keywords + "%'})";
}
else
{
wherekeyword += " and (Name like lbsql{'%" + keywords + "%'} or SubName like lbsql{'%" + keywords + "%'})";
}
}
}
}
else
{
wherekeyword = "(Name like lbsql{'%" + keyword + "%'} or SubName like lbsql{'%" + keyword + "%'})";
}
where = wherekeyword;
}
if (area_id > 0)
{
where += " and area_id in (" + EX_Area.Area_ids(area_id) + ")";
}
//SQLDataAccess.SQLPara sp = new SQLDataAccess.SQLPara(where, "id desc", "*");
shops = B_Lebi_Supplier.GetList(where, "id desc", PageSize, pageindex);
recordCount = B_Lebi_Supplier.Counts(where);
string url = URL("P_ShopSearch", keyword + "," + sort + ",{0}");
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = URL("P_ShopSearch", keyword + "," + sort + "," + (pageindex + 1) + "");
}