/// <summary>
/// 更新会员积分
/// </summary>
/// <param name="user"></param>
public static void UpdateUserPoint(Lebi_User user)
{
string point = B_Lebi_User_Point.GetValue("sum(Point)", "User_id=" + user.id + " and Type_id_PointStatus=171");
decimal Point = 0;
Decimal.TryParse(point, out Point);
Lebi_UserLevel userlev = B_Lebi_UserLevel.GetModel(user.UserLevel_id);
if (userlev == null)
{
userlev = new Lebi_UserLevel();
}
List <Lebi_UserLevel> ls = B_Lebi_UserLevel.GetList("Grade > " + userlev.Grade + "", "Grade desc");
//Lebi_UserLevel newlev=new Lebi_UserLevel();
if (ls.Count > 0)
{
foreach (Lebi_UserLevel l in ls)
{
if (Point >= l.Lpoint)
{
user.UserLevel_id = l.id;
//newlev = l;
break;
}
}
}
//if (userlev.Grade < newlev.Grade)
//{
user.Point = Point;
B_Lebi_User.Update(user);
//}
}
public static void AddMoney(Lebi_User user, decimal money, int type, Lebi_Order order, Lebi_Administrator admin, string description, string remark, bool fanxian = true)
{
if (money == 0)
{
return;
}
if (type == 192 || type == 193)
{
if (money > 0)
{
money = 0 - money;
}
}
Lebi_User_Money mo = new Lebi_User_Money();
if (admin != null)
{
mo.Admin_id = admin.id;
mo.Admin_UserName = admin.UserName;
}
mo.Money = money;
mo.Type_id_MoneyStatus = 181;
mo.Type_id_MoneyType = type;
mo.User_id = user.id;
mo.User_UserName = user.UserName;
mo.User_RealName = user.RealName;
mo.Description = description;
mo.Remark = remark;
if (order != null)
{
mo.Order_id = order.id;
mo.Order_Code = order.Code;
mo.Order_PayNo = order.PayNo;
}
//string money_ = B_Lebi_User_Money.GetValue("sum(Money)", "User_id=" + user.id + " and Type_id_MoneyStatus=181");
//decimal Money = 0;
//Decimal.TryParse(money_, out Money);
if (type == 195)//返现
{
user.Money_fanxian = user.Money_fanxian + money;
}
if (type == 192 && fanxian == true)//消费
{
user.Money_fanxian = user.Money_fanxian + money;
if (user.Money_fanxian < 0)
{
user.Money_fanxian = 0;
}
}
user.Money = user.Money + money;
B_Lebi_User.Update(user);
mo.Money_after = user.Money;
mo.Money_fanxian_after = user.Money_fanxian;
B_Lebi_User_Money.Add(mo);
//发送短信
SMS.SendSMS_balance(user);
//APP推送
APP.Push_balance(user);
}
/// <summary>
/// 更新会员资金
/// </summary>
/// <param name="user"></param>
public static void UpdateUserMoney(Lebi_User user)
{
string money = B_Lebi_User_Money.GetValue("sum(Money)", "User_id=" + user.id + " and Type_id_MoneyStatus=181");
decimal Money = 0;
Decimal.TryParse(money, out Money);
user.Money = Money;
B_Lebi_User.Update(user);
}
/// <summary>
/// 更新会员帐户的佣金金额
/// </summary>
/// <param name="user"></param>
/// <param name="money"></param>
private void UpdateUserMoney(Lebi_User user, Lebi_Agent_Money money)
{
if (money.Type_id_AgentMoneyStatus == 382)//已生效佣金
{
user.AgentMoney_history += money.Money;
user.AgentMoney += money.Money;
B_Lebi_User.Update(user);
}
}
/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <param name="money"></param>
/// <param name="type"></param>
/// <param name="admin"></param>
/// <param name="description"></param>
/// <param name="remark"></param>
/// <param name="fanxian">是否包含返现款消费</param>
public static void AddMoney(Lebi_User user, decimal money, int type, Lebi_Administrator admin, string description, string remark, bool fanxian = true)
{
if (money == 0)
{
return;
}
Lebi_User_Money mo = new Lebi_User_Money();
if (admin != null)
{
mo.Admin_id = admin.id;
mo.Admin_UserName = admin.UserName;
}
mo.Money = money;
mo.Type_id_MoneyStatus = 181;
mo.Type_id_MoneyType = type;
mo.User_id = user.id;
mo.User_UserName = user.UserName;
mo.User_RealName = user.RealName;
mo.Description = description;
mo.Remark = remark;
//string money_ = B_Lebi_User_Money.GetValue("sum(Money)", "User_id=" + user.id + " and Type_id_MoneyStatus=181");
//decimal Money = 0;
//Decimal.TryParse(money_, out Money);
if (type == 195)//返现
{
user.Money_fanxian = user.Money_fanxian + money;
}
if (type == 192 && fanxian == true)//消费
{
user.Money_fanxian = user.Money_fanxian + money;
if (user.Money_fanxian < 0)
{
user.Money_fanxian = 0;
}
}
user.Money = user.Money + money;
B_Lebi_User.Update(user);
mo.Money_after = user.Money;
mo.Money_fanxian_after = user.Money_fanxian;
B_Lebi_User_Money.Add(mo);
//发送短信
if (ShopCache.GetBaseConfig().SMS_sendmode.Contains("SMSTPL_balance"))
{
SMS.SendSMS_balance(user);
}
}
/// <summary>
/// 使一个购买单的佣金失效
/// 已完结订单取消完结时使用
/// </summary>
/// <param name="order"></param>
public void AgentMoneyCancal()
{
//string sql = "update Lebi_Agent_Money set Type_id_AgentMoneyType=383 where Order_id=" + order.id + "";
//Common.ExecuteSql(sql);
List <Lebi_Agent_Money> models = B_Lebi_Agent_Money.GetList("Order_id=" + Order.id + "", "");
foreach (Lebi_Agent_Money model in models)
{
model.Type_id_AgentMoneyStatus = 381;
Lebi_User user = B_Lebi_User.GetModel(model.User_id);
if (user != null)
{
B_Lebi_Agent_Money.Update(model);
user.AgentMoney_history -= model.Money;
user.AgentMoney -= model.Money;
B_Lebi_User.Update(user);
//model.Money = 0 - model.Money;
//UpdateUserMoney(user, model);
}
}
}