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);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'");
id = Rint("id");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
if (order.Type_id_OrderType == 212)
{
Response.Redirect(URL("P_UserReturnDetails", id));
}
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_UserOrders", "") + "\"><span>" + Tag("我的订单") + "</span></a><em>»</em><a href=\"" + URL("P_UserOrderDetails", id) + "\"><span>" + Tag("订单") + "：" + order.Code + "</span></a>";
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserOrderDetails'");
id = Rint_Para("0");
comments = B_Lebi_Comment.GetList("TableName='Order' and Keyid=" + order.id, "id desc");
transport_orders = B_Lebi_Transport_Order.GetList("Order_id=" + order.id, "id desc");
bills = B_Lebi_Bill.GetList("Order_id=" + order.id, "id desc");
order_products = B_Lebi_Order_Product.GetList("Order_id=" + order.id, "id desc");
pay = B_Lebi_Pay.GetModel(order.Pay_id);
if (pay == null)
{
pay = new Lebi_Pay();
}
}
/// <summary>
/// 返回销售商品数量
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static int ProductCount(string where)
{
string sum = B_Lebi_Order_Product.GetValue("sum(Count)", "Order_id in (select id from Lebi_Order where " + where + ")");
if (String.IsNullOrEmpty(sum))
{
sum = 0.ToString();
}
return(Convert.ToInt32(sum));
}
/// <summary>
/// 收货确认后，更新订单产品的收货数量
/// </summary>
/// <param name="torder"></param>
public static void UpdateShouHuoCount(Lebi_Transport_Order torder)
{
if (torder.Type_id_TransportOrderStatus != 223)
{
return;
}
Lebi_Order order = B_Lebi_Order.GetModel(torder.Order_id);
if (order == null)
{
return;
}
List <Lebi_Order_Product> ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", "");
List <Lebi_Transport_Order> torders = B_Lebi_Transport_Order.GetList("Order_id=" + torder.Order_id + " and Type_id_TransportOrderStatus=223", "");
//bool shouhuoall = true;
foreach (Lebi_Order_Product op in ops)
{
//op.Count_Received = 0;
foreach (Lebi_Transport_Order to in torders)
{
foreach (TransportProduct p in GetTransportProduct(to))
{
if (p.Product_id == op.Product_id)
{
op.Count_Received = op.Count_Received + p.Count;
if (op.Count_Shipped < op.Count_Received)
{
op.Count_Received = op.Count_Shipped;
}
break;
}
}
}
//if (op.Count_Received < op.Count_Shipped)
// shouhuoall = false;
B_Lebi_Order_Product.Update(op);//更新收货数量
}
order.IsReceived = 1;
order.IsReceived_All = 1;
ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", "");
foreach (Lebi_Order_Product op in ops)
{
if (op.Count_Received < op.Count_Shipped)
{
order.IsReceived_All = 0;
}
}
order.Time_Received = System.DateTime.Now;
B_Lebi_Order.Update(order);
if (order.IsReceived_All == 1)//全部收货完成
{
Order.Received(order);
}
}
public int Count_NewComment()
{
if (CurrentUser.id > 0)
{
return(B_Lebi_Order_Product.Counts("User_id=" + CurrentUser.id + " and IsCommented=0"));
}
else
{
return(0);
}
}
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 int Count_Comment(int IsCommented)
{
if (CurrentUser.id > 0)
{
string sql = " IsCommented=" + IsCommented + "";
if (IsCommented == 0)
{
sql += " and id in(select id from [Lebi_Order_Product] where Order_id in(select id from [Lebi_Order] where User_id=" + CurrentUser.id + " and IsReceived = 1))";
}
return(B_Lebi_Order_Product.Counts("User_id=" + CurrentUser.id + " and " + sql + ""));
}
else
{
return(0);
}
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_Pay", "") + "\"><span>" + Tag("在线付款") + "</span></a>";
order_id = Rint("order_id");
order = B_Lebi_Order.GetModel(order_id);
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id || order.IsInvalid == 1 || order.IsPaid == 1)
{
PageError();
}
else
{
if (order.Type_id_OrderType == 215)
{
List <Lebi_Order> ors = B_Lebi_Order.GetList("Order_id=" + order.id + "", "");
decimal moeny = 0;
foreach (Lebi_Order or in ors)
{
moeny += or.Money_Pay;
}
order.Money_Pay = moeny;
B_Lebi_Order.Update(order);
}
}
string onpaywhere = "IsUsed=1 and parentid=0";
if (CurrentSite.IsMobile == 1)
{
onpaywhere += " and (showtype='' or showtype like '%wap%')";
}
else
{
onpaywhere += " and (showtype='' or showtype like '%web%')";
}
onlinepays = B_Lebi_OnlinePay.GetList(onpaywhere, "Sort desc");
order_products = B_Lebi_Order_Product.GetList("Order_id = " + order.id, "id desc");
}
/// <summary>
/// 返回成本
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static decimal Money_CostCount(string where)
{
List <Lebi_Order_Product> models = B_Lebi_Order_Product.GetList("Order_id in (select id from Lebi_Order where " + where + ") and Price_Cost = 0", "");
if (models.Count > 0)
{
foreach (Lebi_Order_Product m in models)
{
m.Price_Cost = Shop.Bussiness.EX_Product.GetProduct(m.Product_id).Price_Cost;
B_Lebi_Order_Product.Update(m);
}
}
string sum = B_Lebi_Order_Product.GetValue("sum(Price_Cost * Count)", "Order_id in (select id from Lebi_Order where " + where + ")");
if (String.IsNullOrEmpty(sum))
{
sum = 0.ToString();
}
return(Convert.ToDecimal(sum));
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
LoadTheme(themecode, siteid, languagecode, pcode);
if (CurrentUser.id == 0)
{
Response.Write("<script type=\"text/javascript\">alert('" + Tag("已购买商品在已收货之后才可以发表评价") + "');window.location.href='" + URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "") + "';</script>");
Response.End();
//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 href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserComment", "1") + "\"><span>" + Tag("商品评价") + "</span></a><em>»</em><a href=\"" + URL("P_UserCommentWrite", "") + "\"><span>" + Tag("发表评价") + "</span></a>";
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserCommentWrite'");
id = Rint("id");
order_product = B_Lebi_Order_Product.GetModel("id = " + id + " and IsCommented = 0 and User_id=" + CurrentUser.id + "");
if (order_product == null)
{
Response.Write("<script type=\"text/javascript\">alert('" + Tag("已购买商品在已收货之后才可以发表评价") + "');javascript:window.history.back();</script>");
Response.End();
}
}
/// <summary>
/// 单品代理佣金
/// </summary>
private void AgentProductMoney()
{
List <Lebi_Order_Product> Products = B_Lebi_Order_Product.GetList("Order_id=" + Order.id + "", "");
if (Products == null)
{
return;
}
int pid = 0;
decimal money = 0;
Lebi_Agent_Product_User auser;
foreach (Lebi_Order_Product model in Products)
{
Lebi_Product pro = B_Lebi_Product.GetModel(model.Product_id);
pid = pro.Product_id == 0 ? pro.id : pro.Product_id;
Lebi_Agent_Product apro = B_Lebi_Agent_Product.GetModel("Product_id=" + pid + "");
if (apro == null)
{
continue;
}
auser = B_Lebi_Agent_Product_User.GetModel("User_id=" + apro.User_id + " and IsFailure=0");
if (auser == null)
{
continue;
}
if (auser.Time_end.Date < System.DateTime.Now.Date)
{
continue;
}
Lebi_User user = B_Lebi_User.GetModel(apro.User_id);
if (user == null)
{
continue;
}
money = model.Price * model.Count * auser.Commission / 100;
AddMoney(money, user, 392, 0, model.Product_id, pid, pro.Number);
}
}
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);
CurrentPage = B_Lebi_Theme_Page.GetModel("Code='P_UserReturnShip'");
id = Rint("id");
tid = Rint("id");
order = B_Lebi_Order.GetModel("User_id = " + CurrentUser.id + " and id = " + id + "");
if (order == null)
{
PageError();
}
if (order.User_id != CurrentUser.id)
{
PageError();
}
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_UserReturnDetails", "" + id + "") + "\"><span>" + Tag("订单") + "：" + order.Code + "</span></a><em>»</em><a href=\"" + URL("P_UserReturnShip", "") + "\"><span>" + Tag("发货") + "</span></a>";
where = "Order_id=" + order.id + "";
order_products = B_Lebi_Order_Product.GetList(where, "id desc");
}
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);
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_UserComment", "") + "\"><span>" + Tag("商品评价") + "</span></a>";
//key={0}&type={1}&status={2}&dateFrom={3}&dateTo={4}
key = Rstring("key");
type = Rint("type");
status = Rint("status");
dateFrom = Rstring("dateFrom");
dateTo = Rstring("dateTo");
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
pageindex = RequestTool.RequestInt("page", 1);
types = B_Lebi_Type.GetList("Class='CommentStatus'", "sort desc");
if (type == 0)
{
where = "Parentid = 0 and TableName = 'Product' and User_id=" + CurrentUser.id + "";
if (key != "")
{
where += " and (Content like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + lbsql_dateFrom + "')<=0 and datediff(d,Time_Add,'" + lbsql_dateTo + "')>=0)";
}
if (status > 0)
{
where += " and (Status = " + status + ")";
}
comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex);
foreach (Shop.Model.Lebi_Comment c in comments)
{
c.IsRead = 1;
B_Lebi_Comment.Update(c);
}
int recordCount = B_Lebi_Comment.Counts(where);
//string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}");
//PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, page, PageSize, recordCount, CurrentLanguage);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
}
else
{
//待评价商品
where = "IsCommented = 0 and User_id=" + CurrentUser.id + "";
if (key != "")
{
where += " and (Product_Name like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + lbsql_dateFrom + "')<=0 and datediff(d,Time_Add,'" + lbsql_dateTo + "')>=0)";
}
order_products = B_Lebi_Order_Product.GetList(where, "id desc", PageSize, pageindex);
int recordCount = B_Lebi_Order_Product.Counts(where);
string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}");
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
}
}
/// <summary>
/// 订单提交
/// </summary>
/// <param name="user"></param>
/// <param name="order"></param>
public static void SendSMS_ordersubmit(Lebi_User user, Lebi_Order order)
{
BaseConfig conf = ShopCache.GetBaseConfig();
int IsUserSms = 0;
int IsUserSms2 = 0;
int IsAdminSms = 0;
int IsSupplierSms = 0;
if (conf.SMS_sendmode.Contains("SMSTPL_ordersubmit"))
{
IsUserSms = 1;
}
if (conf.SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit"))
{
IsAdminSms = 1;
}
if (conf.SMS_sendmode.Contains("SMSTPL_orderpickup"))
{
IsUserSms2 = 1;
}
if (order.Supplier_id > 0)
{
if (ShopCache.GetBaseConfig_Supplier(order.Supplier_id).SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit"))
{
IsSupplierSms = 1;
}
}
if (IsUserSms == 0 && IsUserSms2 == 0 && IsAdminSms == 0 && IsSupplierSms == 0)
{
return;
}
if (user.Language == "")
{
user.Language = Language.Languages().FirstOrDefault().Code;
}
string list = "";
List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", "");
foreach (Lebi_Order_Product pro in pros)
{
list += "" + Language.Tag("商品编号", user.Language) + "：" + pro.Product_Number + "；" + Language.Tag("商品", user.Language) + "：" + Language.Content(pro.Product_Name, user.Language) + "；" + Language.Tag("数量", user.Language) + "：" + pro.Count + "；";
}
if (IsUserSms == 1)
{
string content = Language.Content(conf.SMSTPL_ordersubmit, user.Language);
content = ReplaceSMSTag(content, user, conf);
content = content.Replace("{$OrderNO}", order.Code);
content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code));
content = content.Replace("{$Order}", list);
Send(order.T_MobilePhone, content);
}
if (IsAdminSms == 1 || IsSupplierSms == 1)
{
string Admin_content = Language.Content(conf.SMSTPL_Admin_ordersubmit, user.Language);
Admin_content = ReplaceSMSTag(Admin_content, user, conf);
Admin_content = Admin_content.Replace("{$OrderNO}", order.Code);
Admin_content = Admin_content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code));
Admin_content = Admin_content.Replace("{$Order}", list);
string transport = "order.Transport_Name";
if (order.PickUp_Name != "")
{
transport += "|" + order.PickUp_Name + "|" + order.PickUp_Date.ToString("yyyy-MM-dd");
}
Admin_content = Admin_content.Replace("{$Transport}", transport);
if (IsAdminSms == 1)
{
Send(conf.SMS_reciveno, Admin_content);
}
if (IsSupplierSms == 1)
{
BaseConfig_Supplier config_supplier = ShopCache.GetBaseConfig_Supplier(order.Supplier_id);
Send(config_supplier.SMS_reciveno, Admin_content);
}
}
if (IsUserSms2 == 1)
{
string content = Language.Content(conf.SMSTPL_orderpickup, user.Language);
content = ReplaceSMSTag(content, user, conf);
content = content.Replace("{$OrderNO}", order.Code);
content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code));
content = content.Replace("{$Order}", list);
content = content.Replace("{$PickUpStation}", order.PickUp_Name);
content = content.Replace("{$PickUpTime}", order.PickUp_Date.ToString("yyyy-MM-dd"));
Send(order.T_MobilePhone, content);
}
}
