protected void Page_Load(object sender, EventArgs e)
{
int id = RequestTool.RequestInt("id", 0);
if (id == 0)
{
if (!EX_Admin.Power("supplier_user_add", "添加商家"))
{
WindowNoPower();
}
}
else
{
if (!EX_Admin.Power("supplier_user_edit", "编辑商家"))
{
WindowNoPower();
}
}
model = B_Lebi_Supplier.GetModel(id);
if (model == null)
{
model = new Lebi_Supplier();
model.Type_id_SupplierStatus = 441;
user = new Lebi_User();
}
else
{
user = B_Lebi_User.GetModel(model.User_id);
}
Count_pay = B_Lebi_User_Money.Counts("User_id=" + model.User_id + " and Type_id_MoneyType=198");
type = RequestTool.RequestString("type");
}
/// <summary>
/// 编辑会员密码
/// </summary>
public void User_Edit_Password()
{
if (!EX_Admin.Power("supplier_user_edit", "编辑商家"))
{
AjaxNoPower();
return;
}
int id = RequestTool.RequestInt("id", 0);
string PWD1 = RequestTool.RequestString("PWD1");
string PWD2 = RequestTool.RequestString("PWD2");
MD5CryptoServiceProvider hashmd5 = new MD5CryptoServiceProvider();
string PWD = BitConverter.ToString(hashmd5.ComputeHash(Encoding.Default.GetBytes(PWD1))).Replace("-", "").ToLower();
if (PWD1 != PWD2)
{
Response.Write("{\"msg\":\"两次输入的密码不一致\"}");
return;
}
Lebi_Supplier model = B_Lebi_Supplier.GetModel(id);
model.Password = PWD;
B_Lebi_Supplier.Update(model);
Log.Add("编辑商家密码", "Supplier_User", id.ToString(), CurrentAdmin, model.UserName);
string result = "{\"msg\":\"OK\"}";
Response.Write(result);
}
/// <summary>
/// 编辑商家
/// </summary>
public void Description_Edit()
{
if (!Power("supplier_profile", "编辑资料"))
{
AjaxNoPower();
return;
}
string UserName = RequestTool.RequestSafeString("UserName");
Lebi_Supplier model = B_Lebi_Supplier.GetModel(CurrentSupplier.id);
if (model == null)
{
Response.Write("{\"msg\":\"账号不存在\"}");
return;
}
model.Name = Language.RequestSafeString("Name");
model.Description = Language.RequestStringForUserEditor("Description");
model.SEO_Title = Language.RequestSafeString("SEO_Title");
model.SEO_Keywords = Language.RequestSafeString("SEO_Keywords");
model.SEO_Description = Language.RequestSafeString("SEO_Description");
B_Lebi_Supplier.SafeBindForm(model);
B_Lebi_Supplier.Update(model);
Log.Add("编辑资料", "User", CurrentSupplier.id.ToString(), CurrentSupplier, model.UserName);
string result = "{\"msg\":\"OK\"}";
Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_servicepanel_list", "客服面板"))
{
WindowNoPower();
}
model = B_Lebi_Supplier.GetModel(CurrentSupplier.id);
if (model == null)
{
model = new Lebi_Supplier();
}
string con = model.ServicePanel;
sp = B_ServicePanel.GetModel(con);
//===================================
//这么取数据
//string con = "[{\"x\":\"111\",\"y\":\"112\".....}]";
//Shop.Model.ServicePanel sp = B_ServicePanel.GetModel(con);
//这个sp里面就有你要的数据了
//例如 sp.x
//保存的话,可以把以上的sp直接转化为json格式的字符串
//如
//Model.ServicePanel sp = new Model.ServicePanel();
//sp.x = "";
//sp.y = "";
//sp.theme = "";
//string json = B_ServicePanel.ToJson(sp);
//=====================================
}
protected void Page_Load(object sender, EventArgs e)
{
int id = RequestTool.RequestInt("id", 0);
if (!EX_Admin.Power("supplier_user_login", "商家后台维护"))
{
PageNoPower();
}
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(id);
if (supplier == null)
{
PageError();
}
user = B_Lebi_User.GetModel(supplier.User_id);
if (user == null)
{
PageError();
}
int AdminLogin = 1; //管理员登录标识 by Lebi.Kingdge 2017-6-23
if (EX_User.UserLogin(user.UserName, user.Password, user.DT_id, false, AdminLogin))
{
string msg = "";
EX_Supplier.Login(user, "", supplier.id, out msg, 1);
Response.Redirect(site.SupplierPath);
}
}
public string suppliername(int id)
{
Lebi_Supplier model = B_Lebi_Supplier.GetModel(id);
if (model == null)
{
return("");
}
return(model.SubName);
}
/// <summary>
/// 获取供应商
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Lebi_Supplier GetSupplier(int id)
{
Lebi_Supplier user = B_Lebi_Supplier.GetModel("id = " + id);
if (user == null)
{
user = new Lebi_Supplier();
}
return(user);
}
public Lebi_Supplier GetSupplier(int id)
{
Lebi_Supplier model = B_Lebi_Supplier.GetModel(id);
if (model == null)
{
model = new Lebi_Supplier();
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_user_edit", "编辑商家"))
{
WindowNoPower();
}
int id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Supplier.GetModel(id);
if (model == null)
{
model = new Lebi_Supplier();
}
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
if (SYS.IsClosetuihuo == "1")
{
PageError();
}
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'");
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturn", "" + id + "") + "\"><span>" + Tag("退货订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnApply", "") + "\"><span>" + Tag("退货申请") + "</span></a>";
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnApply'");
id = Rint_Para("0");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
where = "Order_id=" + order.id + "";
order_products = B_Lebi_Order_Product.GetList(where, "id desc");
if (order.Supplier_id > 0)
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(order.Supplier_id);
if (supplier != null)
{
shouhuoren = supplier.RealName;
shouhuodizhi = supplier.Address;
shouhuodianhua = supplier.Phone;
shouhuoyoubian = supplier.Postalcode;
}
}
else
{
Lebi_Express_Shipper shipper = B_Lebi_Express_Shipper.GetList("", "Sort desc", 1, 1).FirstOrDefault();
if (shipper != null)
{
shouhuoren = shipper.UserName;
shouhuodizhi = shipper.Address;
shouhuodianhua = shipper.Tel;
shouhuoyoubian = shipper.ZipCode;
}
}
}
public void LoadPage()
{
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_Product'");
int id = Rint("id");
product = EX_Product.GetProduct(id);
if (product.id == 0)
{
Response.End();
}
Protype = B_Lebi_Pro_Type.GetModel(product.Pro_Type_id);
GetProWords();
supplier = B_Lebi_Supplier.GetModel(product.Supplier_id);
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
product.IsSupplierTransport = supplier.IsSupplierTransport;
}
protected int sid = 0;//结算供应商ID
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
if (CurrentUser.id == 0)
{
//未登录
if (SYS.IsAnonymousUser != "1")
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
}
sid = RequestTool.RequestInt("sid", 0);
if (SYS.IsSupplierCash == "1")
{
supplier = B_Lebi_Supplier.GetModel(sid);
}
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
CookieTool.SetCookieString("supplier", supplier.id.ToString(), 60);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Basket", "") + "\"><span>" + Tag("购物车") + "</span></a><em>»</em><a href=\"" + URL("P_CheckOut", "") + "\"><span>" + Tag("收银台") + "</span></a>";
basket = new Basket(sid);
if (basket.Products.Count == 0)
{
Response.Redirect(URL("P_Basket", ""));
}
if (CurrentUser.id > 0)
{
string sqlwhere = "";
if (DataBase.DBType == "sqlserver")
{
sqlwhere = " and datediff(d,Time_End,'" + FormatTime(System.DateTime.Now) + "')<0";
}
if (DataBase.DBType == "access")
{
sqlwhere = " and datediff('d',Time_End,'" + FormatTime(System.DateTime.Now) + "')<0";
}
cards = B_Lebi_Card.GetList("User_id=" + CurrentUser.id + " and Type_id_CardType=312 and Type_id_CardStatus in (201,203) " + sqlwhere + "", "id asc");//状态为已发放或部分使用
moneycards = B_Lebi_Card.GetList("User_id=" + CurrentUser.id + " and Type_id_CardType=311 and Type_id_CardStatus in (201,203) " + sqlwhere + "", "id asc");
}
ProPerty135 = B_Lebi_ProPerty.GetList("Type_id_ProPertyType=135", "Sort desc");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_money_list", "资金明细"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
user_id = RequestTool.RequestInt("user_id", 0);
key = RequestTool.RequestString("key");
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
status = RequestTool.RequestInt("status", 0);
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
string where = "1=1";
if (status > 0)
{
where += " and Type_id_MoneyStatus=" + status + "";
}
if (user_id > 0)
{
where += " and Supplier_id=" + user_id + "";
}
if (key != "")
{
where += " and (Supplier_id in (select id from [Lebi_Supplier] where UserName like lbsql{'%" + key + "%'} or RealName like lbsql{'%" + key + "%'}) or Remark like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
models = B_Lebi_Supplier_Money.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Supplier_Money.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&status = " + status + "&user_id = " + user_id, page, PageSize, recordCount);
user = B_Lebi_Supplier.GetModel(user_id);
if (user == null)
{
user = new Lebi_Supplier();
}
}
/// <summary>
/// 编辑商家
/// </summary>
public void Profile_Edit()
{
if (!Power("supplier_profile", "编辑资料"))
{
AjaxNoPower();
return;
}
string UserName = RequestTool.RequestSafeString("UserName");
Lebi_Supplier model = B_Lebi_Supplier.GetModel(CurrentSupplier.id);
if (model == null)
{
Response.Write("{\"msg\":\"账号不存在\"}");
return;
}
B_Lebi_Supplier.SafeBindForm(model);
B_Lebi_Supplier.Update(model);
Log.Add("编辑资料", "User", CurrentSupplier.id.ToString(), CurrentSupplier, model.UserName);
string result = "{\"msg\":\"OK\"}";
Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_skin", "编辑皮肤"))
{
PageReturnMsg = PageNoPowerMsg();
}
int id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Supplier.GetModel("User_id = " + CurrentSupplier.User_id + "");
if (model == null)
{
model = new Lebi_Supplier();
}
Lebi_Supplier_Skin skin = B_Lebi_Supplier_Skin.GetModel(id);
if (skin != null)
{
model.Supplier_Skin_id = skin.id;
model.head = skin.head;
model.shortbar = skin.shortbar;
model.longbar = skin.longbar;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_verified", "身份验证"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
user_id = RequestTool.RequestInt("user_id", 0);
string where = "1=1";
if (user_id > 0)
{
where += " and Supplier_id=" + user_id;
}
models = B_Lebi_Supplier_Verified_Log.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Supplier_Verified_Log.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&user_id=" + user_id, page, PageSize, recordCount);
user = B_Lebi_Supplier.GetModel("id = " + user_id);
if (user == null)
{
user = new Lebi_Supplier();
}
}
/// <summary>
/// 获取一个支付方式的对于供应商设置或（默认设置）
/// </summary>
/// <param name="pay"></param>
/// <returns></returns>
public Lebi_OnlinePay Getpay(Lebi_OnlinePay pay)
{
if (order.IsSupplierCash == 0)
{
return(pay);
}
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(order.Supplier_id);
if (supplier != null)
{
//供应商发货商城收款的情况
if (supplier.IsCash == 0)
{
return(pay);
}
}
Lebi_OnlinePay p = B_Lebi_OnlinePay.GetModel("parentid=" + pay.id + " and Supplier_id=" + order.Supplier_id + " and IsUsed=1");
if (p != null)
{
if (Lang(p.Name) == "")
{
p.Name = pay.Name;
}
if (Lang(p.Description) == "")
{
p.Name = pay.Name;
}
if (p.Logo == "")
{
p.Logo = pay.Logo;
}
}
return(p);
}
/// <summary>
/// 退货单发货
/// </summary>
public void torder_shipping()
{
int order_id = RequestTool.RequestInt("order_id", 0);
Lebi_Order model = B_Lebi_Order.GetModel("User_id=" + CurrentUser.id + " and id = " + order_id);
if (model == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (model.IsVerified != 1)
{
Response.Write("{\"msg\":\"" + Tag("请等待客服人员确认") + "\"}");
return;
}
Lebi_Transport_Order torder = B_Lebi_Transport_Order.GetModel("Order_id=" + model.id + "");
if (torder != null)
{
torder.Code = RequestTool.RequestSafeString("Code");
torder.Transport_Name = RequestTool.RequestSafeString("Transport_Name");
B_Lebi_Transport_Order.Update(torder);
}
else
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(model.Supplier_id);
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
torder = new Lebi_Transport_Order();
torder.Code = RequestTool.RequestSafeString("Code");
torder.Order_id = model.id;
torder.T_Address = model.T_Address;
torder.T_Email = model.T_Email;
torder.T_MobilePhone = model.T_MobilePhone;
torder.T_Name = model.T_Name;
torder.T_Phone = model.T_Phone;
//torder.Transport_Code = model.Transport_Code;
//torder.Transport_id = model.Transport_id;
torder.Transport_Name = RequestTool.RequestSafeString("Transport_Name");
torder.User_id = model.User_id;
torder.Supplier_id = supplier.id;
torder.Supplier_SubName = supplier.SubName;
List <TransportProduct> tps = new List <TransportProduct>();
TransportProduct tp;
List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", "");
foreach (Lebi_Order_Product pro in pros)
{
tp = new TransportProduct();
tp.Count = pro.Count;
tp.ImageBig = pro.ImageBig;
tp.ImageMedium = pro.ImageMedium;
tp.ImageOriginal = pro.ImageOriginal;
tp.ImageSmall = pro.ImageSmall;
tp.Product_Number = pro.Product_Number;
tp.Product_id = pro.Product_id;
tp.Product_Name = pro.Product_Name;
tps.Add(tp);
pro.Count_Shipped = pro.Count;
B_Lebi_Order_Product.Update(pro);
}
JavaScriptSerializer jss = new JavaScriptSerializer();
torder.Product = jss.Serialize(tps);
torder.Type_id_TransportOrderStatus = 220;//默认状态：在途
B_Lebi_Transport_Order.Add(torder);
model.IsShipped = 1;
model.IsShipped_All = 1;
B_Lebi_Order.Update(model);
}
Response.Write("{\"msg\":\"OK\"}");
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
pcode = "P_ShopIndex";
LoadTheme(themecode, siteid, languagecode, pcode);
id = RequestTool.RequestInt("id", 0); //商家ID
cid = RequestTool.RequestInt("cid", 0); //商品分类
list = RequestTool.RequestString("list"); //列表或网格
sort = RequestTool.RequestString("sort"); //排序
key = RequestTool.RequestSafeString("keyword"); //关键词
pageindex = RequestTool.RequestInt("page", 1);
parentcid = 0;
supplier = B_Lebi_Supplier.GetModel("id = " + id);
if (supplier == null)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
int Supplier_id = supplier.User_id;
if (cid != 0)
{
producttype = B_Lebi_Supplier_ProductType.GetModel(cid);
if (producttype.parentid > 0)
{
parentcid = producttype.parentid;
}
else
{
parentcid = cid;
}
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_ShopIndex", id) + "\"><span>" + Lang(supplier.Name) + "</span></a>";
where = ProductWhere + " and Supplier_id = " + id + "";
if (cid > 0)
{
if (DataBase.DBType == "sqlserver")
{
where += " and Charindex('," + cid + ",',','+Supplier_ProductType_ids+',')>0";
}
if (DataBase.DBType == "access")
{
where += " and Instr(','+Supplier_ProductType_ids+',','," + cid + ",')>0";
}
}
if (key != "")
{
where += " and Name like '%" + key + "%'";
}
if (sort == "")
{
sort = "1";
}
if (sort == "1")
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
else if (sort == "1a")
{
order = " Count_Sales_Show asc"; ordertmp = "";
}
else if (sort == "2")
{
order = " Price desc"; ordertmp = "a";
}
else if (sort == "2a")
{
order = " Price asc"; ordertmp = "";
}
else if (sort == "3")
{
order = " Count_Comment desc"; ordertmp = "a";
}
else if (sort == "3a")
{
order = " Count_Comment asc"; ordertmp = "";
}
else if (sort == "4")
{
order = " Time_Add desc"; ordertmp = "a";
}
else if (sort == "4a")
{
order = " Time_Add asc"; ordertmp = "";
}
else if (sort == "5")
{
order = " Count_Views_Show desc"; ordertmp = "a";
}
else if (sort == "5a")
{
order = " Count_Views_Show asc"; ordertmp = "";
}
else
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
products = B_Lebi_Product.GetList(where, order, PageSize, pageindex);
recordCount = B_Lebi_Product.Counts(where);
//id={0}&pid={1}&cid={2}&list={3}&sort={4}&tid={5}&page={6}
string url = URL("P_ShopIndex", id + "," + cid + "," + list + "," + sort + ",{0}," + key + "");
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = URL("P_ShopIndex", id + "," + cid + "," + list + "," + sort + "," + (pageindex + 1) + "," + key + "");
string supplierservicepannelcon = supplier.ServicePanel;
supplierservicepannel = B_ServicePanel.GetModel(supplierservicepannelcon);
headcontent = supplier.head;
longbar = supplier.longbar;
shortbar = supplier.shortbar;
if (CurrentSite.IsMobile == 0) //只针对PC站点 lebi.kingdge 2015-12-30
{
//跳转至设置的皮肤页面
Lebi_Supplier_Skin skin = B_Lebi_Supplier_Skin.GetModel(supplier.Supplier_Skin_id);
if (skin != null)
{
string filename = HttpContext.Current.Request.Url.AbsolutePath.ToString().ToLower();
if (!filename.Contains("default" + skin.id + ".aspx"))
{
string tourl = Shop.Bussiness.Site.Instance.WebPath + "/" + CurrentLanguage.Path + "/shop/default" + skin.id + ".aspx?id=" + supplier.id + "&cid=" + cid + "&list=" + list + "&sort=" + sort + "&page=" + pageindex;
tourl = ThemeUrl.CheckPath(tourl);
Response.Redirect(tourl);
//Response.Write(tourl);
}
}
}
}
/// <summary>
/// 余额购买其他内容
/// </summary>
public void BuyOther()
{
int keyid = RequestTool.RequestInt("keyid");
string tablename = RequestTool.RequestSafeString("tablename");
decimal postmoney = RequestTool.RequestDecimal("money");
string paypwd = RequestTool.RequestSafeString("paypwd");
decimal money = 0;
if (EX_User.MD5(paypwd) != CurrentUser.Pay_Password)
{
Response.Write("{\"msg\":\"" + Tag("支付密码错误") + "\"}");
return;
}
if (tablename == "Agent_Product_Level")
{
Lebi_Agent_Product_Level lev = B_Lebi_Agent_Product_Level.GetModel(keyid);
if (lev == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Agent_Product_User user = B_Lebi_Agent_Product_User.GetModel("User_id=" + CurrentUser.id + "");
if (user == null)
{
//新购买的情况
money = lev.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user = new Lebi_Agent_Product_User();
user.Agent_Product_Level_id = lev.id;
user.Commission = lev.Commission;
user.Count_Product = lev.Count_Product;
user.Count_product_change = lev.Count_product_change;
user.User_id = CurrentUser.id;
user.User_UserName = CurrentUser.UserName;
user.Time_end = System.DateTime.Now.AddYears(lev.Years);
B_Lebi_Agent_Product_User.Add(user);
}
else
{
if (user.Agent_Product_Level_id == lev.id)
{
//续费的情况
money = lev.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user.Time_end = user.Time_end.AddYears(lev.Years);
B_Lebi_Agent_Product_User.Update(user);
//更新代理商品的过期时间
}
else
{
//升级的情况
Lebi_Agent_Product_Level userlev = B_Lebi_Agent_Product_Level.GetModel(user.Agent_Product_Level_id);
if (userlev.Sort > lev.Sort)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = lev.Price - userlev.Price;
if (money < 0)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user.Agent_Product_Level_id = lev.id;
user.Commission = lev.Commission;
user.Count_Product = lev.Count_Product;
user.Count_product_change = lev.Count_product_change;
B_Lebi_Agent_Product_User.Update(user);
}
}
EX_User.GiveUserCard(CurrentUser, lev.CardOrder_id);//赠送代金券
Money.AddMoney(CurrentUser, 0 - money, 196, null, "", "");
}
else if (tablename == "Agent_Area")
{
Lebi_Agent_Area area = B_Lebi_Agent_Area.GetModel(keyid);
if (area == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (area.User_id > 0 && area.User_id != CurrentUser.id)
{
Response.Write("{\"msg\":\"" + Tag("不能代理此区域") + "\"}");
return;
}
money = area.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
if (area.User_id == 0)
{
//新购买的情况
area.User_id = CurrentUser.id;
area.User_UserName = CurrentUser.UserName;
area.Time_end = System.DateTime.Now.AddYears(1);
area.IsFailure = 0;
B_Lebi_Agent_Area.Update(area);
}
else
{
//续费的情况
area.Time_end = area.Time_end.AddYears(1);
area.IsFailure = 0;
B_Lebi_Agent_Area.Update(area);
}
EX_User.GiveUserCard(CurrentUser, area.CardOrder_id);//赠送代金券
Money.AddMoney(CurrentUser, 0 - money, 196, null, "", "");
}
else if (tablename == "suppliermargin")//供应商保证金
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
//新购买的情况
money = supplier.Money_Margin - supplier.Money_Margin_pay;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Money_Margin_pay += money;
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 197, null, "", "");
}
else if (tablename == "suppliermargin")//供应商保证金
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = supplier.Money_Margin - supplier.Money_Margin_pay;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Money_Margin_pay += money;
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 197, null, "", "");
}
else if (tablename == "supplierservice")//供应商服务费
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel("id=" + supplier.Supplier_Group_id);
if (group == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = supplier.Money_Service;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Time_End = supplier.Time_End.AddDays(group.ServiceDays);
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 198, null, "", "");
}
Response.Write("{\"msg\":\"OK\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("order_edit", "编辑订单"))
{
NewPageNoPower();
}
int id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Order.GetModel(id);
if (model == null)
{
model = new Lebi_Order();
shop = new Lebi_Supplier();
}
else
{
if (model.Supplier_id > 0)
{
shop = B_Lebi_Supplier.GetModel(model.Supplier_id);
}
if (shop == null)
{
shop = new Lebi_Supplier();
}
if (domain3admin && CurrentAdmin.Site_ids != "")
{
if (!("," + CurrentAdmin.Site_ids + ",").Contains("," + model.Site_id + ","))
{
PageError();
return;
}
}
}
if (model.Type_id_OrderType == 212)
{
str = "- ";
}
//if (model.Type_id_OrderType == 212)
// Response.Redirect("Torder_view.aspx?id=" + id);
pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", "");
Logs = B_Lebi_Log.GetList("TableName='Order' and Keyid='" + model.id + "'", "id desc");
torders = B_Lebi_Transport_Order.GetList("Order_id=" + model.id + "", "id desc");
comms = B_Lebi_Comment.GetList("TableName='Order' and Keyid=" + model.id + "", "id desc");
langs = Language.Languages();
Lebi_Bill bill = B_Lebi_Bill.GetModel("Order_id=" + model.id + "");
if (bill == null)
{
billstatus = Tag("不开发票");
}
else
{
billstatus = EX_Type.TypeName(bill.Type_id_BillStatus);
}
TransportCount = B_Lebi_Transport_Order.Counts("Order_id=" + model.id + "");
CommentCount = B_Lebi_Comment.Counts("TableName='Order' and Keyid=" + model.id + "");
LogCount = B_Lebi_Log.Counts("TableName='Order' and Keyid='" + model.id + "'");
deliveries = B_Lebi_Supplier_Delivery.GetList("Supplier_id = " + model.Supplier_id + "", "Sort desc");
DeliveryCount = B_Lebi_Supplier_Delivery.Counts("Supplier_id = " + model.Supplier_id + "");
if (model.Promotion_Type_ids != "")
{
//List<Lebi_Promotion_Type> Promotions = B_Lebi_Promotion_Type.GetList("id in (" + model.Promotion_Type_ids + ")", "");
//foreach (Lebi_Promotion_Type p in Promotions)
//{
// if (Promotion == "")
// Promotion = Lang(p.Name);
// else
// Promotion += "<br/>" + Lang(p.Name);
//}
Promotion = Lang(model.Promotion_Type_Name);
}
}
/// <summary>
/// 客服面板设置信息
/// </summary>
public void ServicePanel_Config()
{
if (!Power("supplier_servicepanel_list", "客服面板"))
{
AjaxNoPower();
return;
}
Model.ServicePanel sp = new Model.ServicePanel();
sp.X = RequestTool.RequestSafeString("X");
sp.Y = RequestTool.RequestSafeString("Y");
sp.Theme = RequestTool.RequestSafeString("Theme");
sp.Status = RequestTool.RequestSafeString("Status");
sp.IsFloat = RequestTool.RequestSafeString("IsFloat");
sp.Style = RequestTool.RequestSafeString("Style");
string con = B_ServicePanel.ToJson(sp);
//BaseConfig bconf = ShopCache.GetBaseConfig();
Lebi_Supplier model = B_Lebi_Supplier.GetModel(CurrentSupplier.id);
if (model == null)
{
Response.Write("{\"msg\":\"账号不存在\"}");
return;
}
model.ServicePanel = con;
B_Lebi_Supplier.Update(model);
Log.Add("配置客服面板", "ServicePanel", CurrentSupplier.id.ToString(), CurrentSupplier, "");
string temp = "";
temp += "var ShopstartX = document.body.clientWidth-" + RequestTool.RequestSafeString("X") + ";\n";
if (RequestTool.RequestSafeString("IsFloat") == "1" && RequestTool.RequestSafeString("Style") == "1")
{
temp += "var ShopstartY = " + RequestTool.RequestSafeString("Y") + ";\n";
}
else if (RequestTool.RequestSafeString("IsFloat") == "0" && RequestTool.RequestSafeString("Style") == "1")
{
temp += "var ShopstartY = " + RequestTool.RequestSafeString("Y") + ";\n";
}
if (RequestTool.RequestSafeString("IsFloat") == "1" && RequestTool.RequestSafeString("Style") == "1")
{
temp += "var verticalpos='fromtop';\n";
}
else if (RequestTool.RequestSafeString("IsFloat") == "0" && RequestTool.RequestSafeString("Style") == "1")
{
temp += "var verticalpos='frombottom';\n";
}
temp += "var winWidth = 0;\n";
temp += "function iecompattest(){\n";
temp += " return (document.compatMode && document.compatMode!='BackCompat')? document.documentElement : document.body\n";
temp += "}\n";
temp += "function ShopServicePannelstaticbar(){\n";
temp += " if (window.innerWidth)\n";
temp += " winWidth = window.innerWidth;\n";
temp += " else if ((document.body) && (document.body.clientWidth))\n";
temp += " winWidth = document.body.clientWidth;\n";
temp += " if (document.documentElement && document.documentElement.clientWidth){winWidth = document.documentElement.clientWidth;}\n";
temp += " ShopstartX = winWidth-"+ RequestTool.RequestSafeString("X") + ";\n";
temp += " barheight=document.getElementById('divShopServicePannel').offsetHeight\n";
temp += " var ns = (navigator.appName.indexOf('Netscape') != -1) || window.opera;\n";
temp += " var d = document;\n";
temp += " function ml(id){\n";
temp += " var el=d.getElementById(id);\n";
temp += " el.style.visibility='visible'\n";
temp += " if(d.layers)el.style=el;\n";
temp += " el.sP=function(x,y){this.style.left=x+'px';this.style.top=y+'px';};\n";
temp += " el.x = ShopstartX;\n";
temp += " if (verticalpos=='fromtop')\n";
temp += " el.y = ShopstartY;\n";
temp += " else{\n";
temp += " el.y = ns ? pageYOffset + innerHeight : iecompattest().scrollTop + iecompattest().clientHeight;\n";
temp += " el.y -= ShopstartY;\n";
temp += " }\n";
temp += " return el;\n";
temp += " }\n";
temp += " window.ShopServicePannel=function(){\n";
temp += " if (verticalpos=='fromtop'){\n";
temp += " var pY = ns ? pageYOffset : iecompattest().scrollTop;\n";
temp += " ftlObj.y += (pY + ShopstartY - ftlObj.y)/8;\n";
temp += " }\n";
temp += " else{\n";
temp += " var pY = ns ? pageYOffset + innerHeight - barheight: iecompattest().scrollTop + iecompattest().clientHeight - barheight;\n";
temp += " ftlObj.y += (pY - ShopstartY - ftlObj.y)/8;\n";
temp += " }\n";
temp += " ftlObj.sP(ftlObj.x, ftlObj.y);\n";
temp += " setTimeout('stayTopLeft()', 10);\n";
temp += " }\n";
temp += " ftlObj = ml('ShopServicePannel');\n";
temp += " ShopServicePannel();\n";
temp += "}\n";
temp += "if(typeof(HTMLElement)!='undefined'){\n";
temp += " HTMLElement.prototype.contains=function (obj)\n";
temp += " {\n";
temp += " while(obj!=null&&typeof(obj.tagName)!='undefind'){\n";
temp += " if(obj==this) return true;\n";
temp += " obj=obj.parentNode;\n";
temp += " }\n";
temp += " return false;\n";
temp += " }\n";
temp += "}\n";
temp += "if (window.addEventListener)\n";
temp += "window.addEventListener('load', ShopServicePannelstaticbar, false)\n";
temp += "else if (window.attachEvent)\n";
temp += "window.attachEvent('onload', ShopServicePannelstaticbar)\n";
temp += "else if (document.getElementById)\n";
temp += "window.onload=ShopServicePannelstaticbar;\n";
temp += "window.onresize=ShopServicePannelstaticbar;\n";
temp += "function ShopServicePannelOver(){\n";
temp += " document.getElementById('ShopServicePannelMenu').style.display = 'none';\n";
temp += " document.getElementById('ShopServicePannelOnline').style.display = 'block';\n";
temp += " document.getElementById('divShopServicePannel').style.width = '170px';\n";
temp += "}\n";
temp += "function ShopServicePannelOut(){\n";
temp += " document.getElementById('ShopServicePannelMenu').style.display = 'block';\n";
temp += " document.getElementById('ShopServicePannelOnline').style.display = 'none';\n";
temp += "}\n";
temp += "if(typeof(HTMLElement)!='undefined') \n";
temp += "{\n";
temp += " HTMLElement.prototype.contains=function(obj)\n";
temp += " {\n";
temp += " while(obj!=null&&typeof(obj.tagName)!='undefind'){\n";
temp += " if(obj==this) return true;\n";
temp += " obj=obj.parentNode;\n";
temp += " }\n";
temp += " return false;\n";
temp += " };\n";
temp += "}\n";
temp += "function ShowShopServicePannel(theEvent){\n";
temp += " if (theEvent){\n";
temp += " var browser=navigator.userAgent;\n";
temp += " if (browser.indexOf('Firefox')>0){\n";
temp += " if (document.getElementById('ShopServicePannelOnline').contains(theEvent.relatedTarget)) {\n";
temp += " return;\n";
temp += " }\n";
temp += " }\n";
temp += " if (browser.indexOf('MSIE')>0 || browser.indexOf('Safari')>0){ //IE Safari\n";
temp += " if (document.getElementById('ShopServicePannelOnline').contains(event.toElement)) {\n";
temp += " return;\n";
temp += " }\n";
temp += " }\n";
temp += " }\n";
temp += " document.getElementById('ShopServicePannelMenu').style.display = 'block';\n";
temp += " document.getElementById('ShopServicePannelOnline').style.display = 'none';\n";
temp += "}";
HtmlEngine save = new HtmlEngine();
save.CreateFile("/supplier/js/user/ServicePanel" + CurrentSupplier.id + ".js", temp);
Response.Write("{\"msg\":\"OK\"}");
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
pcode = "P_ShopProductCategory";
LoadTheme(themecode, siteid, languagecode, pcode);
id = RequestTool.RequestInt("id", 0); //商家ID
cid = RequestTool.RequestInt("cid", 0); //商品分类
list = RequestTool.RequestString("list"); //列表或网格
sort = RequestTool.RequestString("sort"); //排序
keyword = RequestTool.RequestSafeString("keyword"); //关键词
pageindex = RequestTool.RequestInt("page", 1);
parentcid = 0;
supplier = B_Lebi_Supplier.GetModel("id = " + id);
if (supplier == null)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
int Supplier_id = supplier.User_id;
if (cid != 0)
{
producttype = B_Lebi_Supplier_ProductType.GetModel(cid);
if (producttype.parentid > 0)
{
parentcid = producttype.parentid;
}
else
{
parentcid = cid;
}
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_ShopIndex", id) + "\"><span>" + Lang(supplier.Name) + "</span></a><em>»</em><a href=\"" + URL("P_ShopProductCategory", "" + id + "," + cid + "," + list + "," + sort + ",1," + keyword + "") + "\"><span>" + Tag("商品列表") + "</span></a>";
where = ProductWhere + " and Type_id_ProductType = 320 and Supplier_id = " + id + "";
if (cid > 0)
{
where += " and " + ShopCategoryWhere(cid);
}
if (keyword != "")
{
//增加空格划词搜索 by kingdge 2013-09-18
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 + "%'}";
}
else
{
wherekeyword += " and Name like lbsql{'%" + keywords + "%'}";
}
}
}
}
else
{
wherekeyword = "Name like lbsql{'%" + keyword + "%'}";
}
where += " and ((" + wherekeyword + ") or Number like lbsql{'%" + keyword + "%'} or Code like lbsql{'%" + keyword + "%'})";
path += "<em>»</em><a class=\"text\"><span>“" + keyword + "”</span></a>";
}
if (sort == "")
{
sort = "1";
}
if (sort == "1")
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
else if (sort == "1a")
{
order = " Count_Sales_Show asc"; ordertmp = "";
}
else if (sort == "2")
{
order = " Price desc"; ordertmp = "a";
}
else if (sort == "2a")
{
order = " Price asc"; ordertmp = "";
}
else if (sort == "3")
{
order = " Count_Comment desc"; ordertmp = "a";
}
else if (sort == "3a")
{
order = " Count_Comment asc"; ordertmp = "";
}
else if (sort == "4")
{
order = " Time_Add desc"; ordertmp = "a";
}
else if (sort == "4a")
{
order = " Time_Add asc"; ordertmp = "";
}
else if (sort == "5")
{
order = " Count_Views_Show desc"; ordertmp = "a";
}
else if (sort == "5a")
{
order = " Count_Views_Show asc"; ordertmp = "";
}
else
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
products = B_Lebi_Product.GetList(where, order, PageSize, pageindex);
recordCount = B_Lebi_Product.Counts(where);
//id={0}&pid={1}&cid={2}&list={3}&sort={4}&tid={5}&page={6}
string url = URL("P_ShopProductCategory", id + "," + cid + "," + list + "," + sort + ",{0}," + keyword + "");
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = URL("P_ShopProductCategory", id + "," + cid + "," + list + "," + sort + "," + (pageindex + 1) + "," + keyword + "");
string supplierservicepannelcon = supplier.ServicePanel;
supplierservicepannel = B_ServicePanel.GetModel(supplierservicepannelcon);
headcontent = supplier.head;
longbar = supplier.longbar;
shortbar = supplier.shortbar;
//跳转至设置的皮肤页面
Lebi_Supplier_Skin skin = B_Lebi_Supplier_Skin.GetModel(supplier.Supplier_Skin_id);
if (skin != null)
{
string filename = HttpContext.Current.Request.Url.AbsolutePath.ToString().ToLower();
if (!filename.Contains("default" + skin.id + ".aspx") && filename.Contains("default.aspx"))
{
string tourl = Shop.Bussiness.Site.Instance.WebPath + "/" + CurrentLanguage.Path + "/shop/default" + skin.id + ".aspx?id=" + supplier.id + "&cid=" + cid + "&list=" + list + "&sort=" + sort + "&page=" + pageindex + "&keyword=" + keyword;
tourl = ThemeUrl.CheckPath(tourl);
Response.Redirect(tourl);
//Response.Write(tourl);
}
}
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
pcode = "P_ShopProductCategory";
LoadTheme(themecode, siteid, languagecode, pcode);
id = Rint_Para("0"); //商家ID
cid = Rint_Para("1"); //商品分类
list = Rstring_Para("2"); //列表或网格
sort = Rstring_Para("3"); //排序
key = Rstring_Para("5"); //关键词
pageindex = RequestTool.RequestInt("page", 1);
parentcid = 0;
supplier = B_Lebi_Supplier.GetModel("id = " + id);
if (supplier == null)
{
Response.Redirect(URL("P_404", ""));
Response.End();
}
int Supplier_id = supplier.User_id;
if (cid != 0)
{
producttype = B_Lebi_Supplier_ProductType.GetModel(cid);
if (producttype.parentid > 0)
{
parentcid = producttype.parentid;
}
else
{
parentcid = cid;
}
}
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_ShopIndex", id) + "\"><span>" + Lang(supplier.Name) + "</span></a>";
if (key != "")
{
path += " > " + key;
}
where = "Type_id_ProductStatus = 101 and Product_id=0 and Supplier_id = " + id + "";
if (cid > 0)
{
if (DataBase.DBType == "sqlserver")
{
where += " and Charindex('," + cid + ",',','+Supplier_ProductType_ids+',')>0";
}
if (DataBase.DBType == "access")
{
where += " and Instr(','+Supplier_ProductType_ids+',','," + cid + ",')>0";
}
}
if (key != "")
{
where += " and Name like '%" + key + "%'";
}
if (sort == "")
{
sort = "1";
}
if (sort == "1")
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
else if (sort == "1a")
{
order = " Count_Sales_Show asc"; ordertmp = "";
}
else if (sort == "2")
{
order = " Price desc"; ordertmp = "a";
}
else if (sort == "2a")
{
order = " Price asc"; ordertmp = "";
}
else if (sort == "3")
{
order = " Count_Comment desc"; ordertmp = "a";
}
else if (sort == "3a")
{
order = " Count_Comment asc"; ordertmp = "";
}
else if (sort == "4")
{
order = " Time_Add desc"; ordertmp = "a";
}
else if (sort == "4a")
{
order = " Time_Add asc"; ordertmp = "";
}
else if (sort == "5")
{
order = " Count_Views_Show desc"; ordertmp = "a";
}
else if (sort == "5a")
{
order = " Count_Views_Show asc"; ordertmp = "";
}
else
{
order = " Count_Sales_Show desc"; ordertmp = "a";
}
products = B_Lebi_Product.GetList(where, order, PageSize, pageindex);
recordCount = B_Lebi_Product.Counts(where);
//id={0}&pid={1}&cid={2}&list={3}&sort={4}&tid={5}&page={6}
string url = URL("P_ShopProductCategory", id + "," + cid + "," + list + "," + sort + ",{0}," + key + "");
HeadPage = Shop.Bussiness.Pager.GetPaginationStringForWebSimple(url, pageindex, PageSize, recordCount, CurrentLanguage);
FootPage = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, pageindex, PageSize, recordCount, CurrentLanguage);
string supplierservicepannelcon = supplier.ServicePanel;
supplierservicepannel = B_ServicePanel.GetModel(supplierservicepannelcon);
headcontent = supplier.head;
longbar = supplier.longbar;
shortbar = supplier.shortbar;
}
/// <summary>
/// 编辑商家资金
/// </summary>
public void Money_Edit()
{
int id = RequestTool.RequestInt("id", 0);
SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code);
if (id > 0)
{
if (!EX_Admin.Power("supplier_money_edit", "编辑商家资金"))
{
AjaxNoPower();
return;
}
Lebi_Supplier_Money model = B_Lebi_Supplier_Money.GetModel(id);
Lebi_Supplier user = B_Lebi_Supplier.GetModel(model.Supplier_id);
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("商家账号不存在") + "\"}");
return;
}
model.Type_id_MoneyStatus = RequestTool.RequestInt("Type_id_MoneyStatus", 0);
model.Type_id_SupplierMoneyType = RequestTool.RequestInt("Type_id_SupplierMoneyType", 0);
model.Admin_UserName = CurrentAdmin.UserName;
model.Admin_id = CurrentAdmin.id;
model.Remark = RequestTool.RequestString("Remark");
model.Time_Update = DateTime.Now;
B_Lebi_Supplier_Money.Update(model);
EX_Supplier.UpdateUserMoney(user);
Log.Add("编辑商家资金", "Supplier_Money", id.ToString(), CurrentAdmin, user.UserName);
}
else
{
if (!EX_Admin.Power("supplier_money_add", "添加商家资金"))
{
AjaxNoPower();
return;
}
string Mode = RequestTool.RequestString("mode");
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");
Lebi_Supplier user = B_Lebi_Supplier.GetModel("UserName = lbsql{'" + User_Name_To + "'}");
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("商家账号不存在") + "\"}");
return;
}
Lebi_Supplier_Money model = new Lebi_Supplier_Money();
Log.Add("添加商家资金", "Supplier_Money", id.ToString(), CurrentAdmin, User_Name_To + " ->" + RequestTool.RequestDecimal("Money", 0));
model.Money = RequestTool.RequestDecimal("Money", 0);
model.Type_id_MoneyStatus = RequestTool.RequestInt("Type_id_MoneyStatus", 0);
model.Type_id_SupplierMoneyType = RequestTool.RequestInt("Type_id_SupplierMoneyType", 0);
model.Admin_UserName = CurrentAdmin.UserName;
model.Admin_id = CurrentAdmin.id;
model.Remark = RequestTool.RequestString("Remark");
model.Time_Update = DateTime.Now;
model.Supplier_id = user.id;
model.User_UserName = user.UserName;
model.Supplier_SubName = user.SubName;
B_Lebi_Supplier_Money.Add(model);
EX_Supplier.UpdateUserMoney(user);
}
string result = "{\"msg\":\"OK\"}";
Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_message_list", "站内信列表"))
{
PageReturnMsg = PageNoPowerMsg();
}
lang = RequestTool.RequestString("lang");
key = RequestTool.RequestString("key");
type = RequestTool.RequestString("type");
type_id = RequestTool.RequestString("type_id");
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
user_id = RequestTool.RequestInt("user_id", 0);
if (user_id > 0)
{
modeluser = B_Lebi_Supplier.GetModel(user_id);
if (modeluser == null)
{
UserName = "";
}
else
{
UserName = modeluser.UserName;
}
}
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
string where = "Supplier_id > 0";
if (key != "")
{
where += " and (Title like lbsql{'%" + key + "%'} or User_Name_To like lbsql{'%" + key + "%'} or User_Name_From like lbsql{'%" + key + "%'})";
}
if (user_id > 0)
{
where += " and (User_id_To = " + user_id + " or User_id_From = " + user_id + ")";
}
if (lang != "")
{
where += " and Language = lbsql{'" + lang + "'}";
}
if (type == "0")
{
where += " and User_id_To =0";
}
if (type == "1")
{
where += " and User_id_From =0";
}
if (type_id != "")
{
where += " and Message_Type_id = " + type_id;
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
models = B_Lebi_Message.GetList(where, "Time_Add desc", PageSize, page);
int recordCount = B_Lebi_Message.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&user_id=" + user_id + "&type=" + type + "&lang=" + lang + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type_id=" + type_id + "&key=" + key, page, PageSize, recordCount);
}
/// <summary>
/// 编辑商家
/// </summary>
public void User_Edit()
{
if (!EX_Admin.Power("supplier_user_edit", "编辑商家"))
{
AjaxNoPower();
return;
}
int id = RequestTool.RequestInt("id", 0);
string UserName = RequestTool.RequestString("UserName");
int Level_id = RequestTool.RequestInt("Level_id", 0);
int IsCash = RequestTool.RequestInt("IsCash", 0);
int IsSupplierTransport = RequestTool.RequestInt("IsSupplierTransport", 0);
Lebi_User user = new Lebi_User();
if (UserName != "")
{
user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}");
if (user == null)
{
Response.Write("{\"msg\":\"帐号不存在\"}");
return;
}
string where = "User_id='" + user.id + "'";
if (id > 0)
{
where += " and id!=" + id + "";
}
int count = B_Lebi_Supplier.Counts(where);
if (count > 0)
{
Response.Write("{\"msg\":\"此帐号已注册\"}");
return;
}
}
if (IsCash == 1 && IsSupplierTransport == 0)
{
Response.Write("{\"msg\":\"独立收款的商家必须独立发货\"}");
return;
}
Lebi_Supplier model = B_Lebi_Supplier.GetModel(id);
//model.IsCash = 0;
//model.IsSupplierTransport = 0;
if (model == null)
{
model = new Lebi_Supplier();
}
B_Lebi_Supplier.SafeBindForm(model);
model.Name = Language.RequestString("Name");
model.Description = Language.RequestString("Description");
model.ClassName = Language.RequestString("ClassName");
model.SEO_Title = Language.RequestString("SEO_Title");
model.SEO_Keywords = Language.RequestString("SEO_Keywords");
model.SEO_Description = Language.RequestString("SEO_Description");
model.Supplier_Group_id = Level_id;
if (model.id == 0)
{
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel(Level_id);
if (group != null)
{
model.Supplier_Group_id = group.id;
model.Money_Service = group.ServicePrice;
model.Money_Margin = group.MarginPrice;
model.BillingDays = group.BillingDays;
}
model.User_id = user.id;
model.UserName = user.UserName;
B_Lebi_Supplier.Add(model);
model.id = B_Lebi_Supplier.GetMaxId();
}
else
{
if (IsSupplierTransport != model.IsSupplierTransport)
{
string sql = "update [Lebi_Order_Product] set IsSupplierTransport=" + model.IsSupplierTransport + " where Supplier_id=" + id + "";
Common.ExecuteSql(sql);
string sql2 = "update [Lebi_Product] set IsSupplierTransport=" + model.IsSupplierTransport + " where Supplier_id=" + id + "";
Common.ExecuteSql(sql2);
}
user = B_Lebi_User.GetModel(model.User_id);
B_Lebi_Supplier.Update(model);
}
if (model.Type_id_SupplierStatus == 442)
{
try
{
Lebi_Supplier_User suser = B_Lebi_Supplier_User.GetModel("User_id=" + model.User_id + " and Supplier_id=" + model.id + "");
if (suser == null)
{
suser = new Lebi_Supplier_User();
suser.RemarkName = user.RealName;
if (suser.RemarkName == "")
{
suser.RemarkName = user.UserName;
}
suser.Supplier_id = model.id;
suser.User_id = model.User_id;
suser.Type_id_SupplierUserStatus = 9011;
B_Lebi_Supplier_User.Add(suser);
}
else
{
suser.Supplier_id = model.id;
suser.User_id = model.User_id;
suser.Type_id_SupplierUserStatus = 9011;
B_Lebi_Supplier_User.Update(suser);
}
}
catch
{ }
}
if (model.Domain != "")
{
ThemeUrl.CreateURLRewrite_shop();
}
if (model.Type_id_SupplierStatus == 444) //如果状态冻结 商品全部冻结 by lebi.kingdge 2015-02-09
{
string sql = "update [Lebi_Product] set Type_id_ProductStatus=103 where Supplier_id=" + id + "";
Common.ExecuteSql(sql);
}
Log.Add("编辑商家信息", "Supplier_User", id.ToString(), CurrentAdmin, model.UserName);
string result = "{\"msg\":\"OK\", \"id\":\"" + model.id + "\"}";
Response.Write(result);
}
/// <summary>
/// 用户这注册
/// </summary>
public void User_Reg()
{
string verifycode = RequestTool.RequestString("verifycode");
string code = CurrentCheckCode;
string UserName = RequestTool.RequestSafeString("UserName");
//检查用户名存在
if (CurrentUser.id == 0 || CurrentUser.IsAnonymous == 1)
{
Response.Write("{\"msg\":\"" + Tag("请登录") + "\"}");
return;
}
if (SYS.Verifycode_SupplierRegister == "1")
{
if (code != verifycode)
{
Response.Write("{\"msg\":\"" + Tag("验证码错误") + "\"}");
return;
}
}
//检查用户名存在
int count = B_Lebi_Supplier.Counts("UserName !='' and UserName=lbsql{'" + CurrentUser.UserName + "'}");
if (count > 0)
{
Response.Write("{\"msg\":\"" + Tag("商家已注册") + "\"}");
return;
}
Lebi_Supplier model = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id + "");
if (model == null)
{
model = new Lebi_Supplier();
}
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel(RequestTool.RequestInt("Supplier_Group_id"));
if (group == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
B_Lebi_Supplier.SafeBindForm(model);
model.User_id = CurrentUser.id;
model.UserName = CurrentUser.UserName;
model.Email = RequestTool.RequestSafeString("Email");
model.RealName = RequestTool.RequestSafeString("RealName");
model.Company = RequestTool.RequestSafeString("Company");
model.Name = RequestTool.RequestSafeString("Name");
model.Name = "[{\"L\":\"" + Language.DefaultLanguage().Code + "\",\"C\":\"" + model.Name + "\"}]";
model.SubName = RequestTool.RequestSafeString("SubName");
model.MobilePhone = RequestTool.RequestSafeString("MobilePhone");
model.Phone = RequestTool.RequestSafeString("Phone");
model.QQ = RequestTool.RequestSafeString("QQ");
model.Language = CurrentLanguage.Code;
model.Time_Reg = DateTime.Now;
model.Time_This = DateTime.Now;
model.Time_Last = DateTime.Now;
model.Count_Login = 1;
model.IP_This = RequestTool.GetClientIP();
model.IP_Last = RequestTool.GetClientIP();
model.Type_id_SupplierStatus = 441;
model.BillingDays = group.BillingDays;
model.Money_Service = group.ServicePrice;
model.Money_Margin = group.MarginPrice;
model.Time_Begin = DateTime.Now;
model.Time_End = DateTime.Now.AddDays(group.ServiceDays);
if (model.id == 0)
{
B_Lebi_Supplier.Add(model);
model.id = B_Lebi_Supplier.GetMaxId();
}
else
{
B_Lebi_Supplier.Update(model);
}
if (group.Verified_ids != "")
{
List <Lebi_Supplier_Verified> models = B_Lebi_Supplier_Verified.GetList("id in (" + group.Verified_ids + ")", "Sort desc");
foreach (Lebi_Supplier_Verified m in models)
{
string where = "Verified_id = " + m.id + " and Supplier_id = " + model.id + "";
Lebi_Supplier_Verified_Log log = B_Lebi_Supplier_Verified_Log.GetModel(where);
if (log == null)
{
log = new Lebi_Supplier_Verified_Log();
}
//log = B_Lebi_Supplier_Verified_Log.SafeBindForm(log);
log.ImageUrl = RequestTool.RequestSafeString("Image" + m.id);
log.Type_id_SupplierVerifiedStatus = 9020;
log.Time_Add = DateTime.Now;
log.Verified_id = m.id;
log.Supplier_id = model.id;
if (log.id == 0)
{
B_Lebi_Supplier_Verified_Log.Add(log);
}
else
{
B_Lebi_Supplier_Verified_Log.Update(log);
}
}
}
EX_Supplier.SupplierRegister(model);//触发事件
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 导出供应商订单数据(商品)
/// </summary>
public void SupplierOrder_product_Export()
{
if (!EX_Admin.Power("statis_orderproduct", "订单报表"))
{
PageNoPower();
}
string where = RequestTool.RequestString("where");
where = Server.UrlDecode(where).Replace("´", "'");
//SystemLog.Add(where);
string titles = "" + Tag("序号") + "," + Tag("供应商") + "," + Tag("配送点") + "," + Tag("单号") + "," + Tag("订购日期") + "," + Tag("发货时间") + "," + Tag("支付状态") + "," + Tag("支付方式") + "," + Tag("配送方式") + "," + Tag("商品名称") + "," + Tag("条形码") + "," + Tag("商品条码") + "," + Tag("单位") + "," + Tag("数量") + "," + Tag("金额") + "";
string[] arr = titles.Split(',');
DataTable dt = new DataTable();
foreach (string col in arr)
{
dt.Columns.Add(col);
}
DataRow r = dt.NewRow();
dt.Rows.Add(r);
//List<Lebi_Order_Product> models = B_Lebi_Order_Product.GetList("Order_id in (select id from Lebi_Order where " + where + ")", "id desc");
List <Lebi_Order_Product> models = B_Lebi_Order_Product.GetList(where, "id desc");
//Response.Write(models.Count);
//Response.End();
StringBuilder sb = new StringBuilder();
if (!Shop.LebiAPI.Service.Instanse.Check("managelicenese"))
{
sb.Append("LebiShop V" + SYS.Version + "." + SYS.Version_Son + " (http://www.lebi.cn),\r\n");
}
sb.Append(titles + "\r\n");
//sb.Append("标签,");
//sb.Append(tag + "\r\n");
int i = 0;
Lebi_Supplier supplier;
Lebi_Supplier_Delivery delivery;
Lebi_Order order;
foreach (Lebi_Order_Product model in models)
{
order = Shop.Bussiness.Order.GetOrder(model.Order_id);
i++;
supplier = B_Lebi_Supplier.GetModel(order.Supplier_id);
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
delivery = B_Lebi_Supplier_Delivery.GetModel(order.Supplier_Delivery_id);
if (delivery == null)
{
delivery = new Lebi_Supplier_Delivery();
}
sb.Append(i + ",");
sb.Append(out_txt(supplier.SubName) + ",");
sb.Append(out_txt(delivery.Name) + ",");
sb.Append(order.Code + ",");
sb.Append(order.Time_Add.ToString("yyyy-MM-dd HH:mm:ss") + ",");
if (order.IsShipped == 1)
{
sb.Append(order.Time_Shipped.ToString("yyyy-MM-dd HH:mm:ss") + ",");
}
else
{
sb.Append("-,");
}
sb.Append((order.IsPaid == 1 ? Tag("已支付") : Tag("未支付")) + ",");
sb.Append(out_txt(Lang(order.Pay) + Lang(order.OnlinePay)) + ",");
sb.Append(out_txt(order.Transport_Name) + ",");
sb.Append(out_txt(Lang(model.Product_Name)) + ",");
sb.Append(model.Product_Number + ",");
sb.Append(Shop.Bussiness.EX_Product.GetProduct(model.Product_id).Code + ",");
sb.Append(Lang(Shop.Bussiness.EX_Product.ProductUnit(Shop.Bussiness.EX_Product.GetProduct(model.Product_id).Units_id)) + ",");
sb.Append(model.Count + ",");
sb.Append(model.Price * model.Count);
sb.Append("\r\n");
}
FileTool.StringTofile(sb.ToString(), "order", ".csv");
}