public void FaFang()
{
DateTime dt = DateTime.Now.Date;
if (DB.SysLogs.Any(a => a.Description == "奖金发放" && a.CreateTime >= dt))
{
LogHelper.Info(dt + "已经执行过奖金发放功能");
return;
}
//if (DateTime.Now.DayOfWeek == DayOfWeek.Monday )
//{
// LogHelper.Info(dt + "今天不是周一不发放奖金");
// return;
//}
var list = DB.Fin_Info.Where(p => p.IsSettlement == false).ToList();
foreach (var item in list)
{
Member_Info model = DB.Member_Info.FindEntity(item.MemberId);
model.Coins += item.RealAmount;
model.CommissionSum += item.RealAmount;
DB.Fin_LiuShui.AddLS(model.MemberId, item.RealAmount.Value, item.TypeName, "奖金");
DB.Member_Info.Update(model);
Fin_Info finmodel = DB.Fin_Info.FindEntity(item.FinId);
finmodel.IsSettlement = true;
DB.Fin_Info.Update(finmodel);
}
DB.SysLogs.setSysLogsData1("00", "定时任务", "Edit", "奖金发放");
}
/// <summary>
/// 增加奖金
/// </summary>
/// <param name="member">要增加奖金的会员,</param>
/// <param name="refMember">相关的会员,</param>
/// <param name="amount">金额</param>
/// <param name="db">数据库连接实例</param>
/// <param name="typeName">奖金类型名称</param>
/// <param name="Comment">奖金描述</param>
/// <returns></returns>
public JsonHelp InsertFin(DbMallEntities db, Member_Info member, Member_Info refMember, decimal amount, string typeName, string Comment)
{
JsonHelp json = new JsonHelp(true);
if (amount < 0)
{
json.Msg = "奖金不能小于0";
return(json);
}
else if (amount == 0)
{
//奖金为0，直接返回，不向数据库增加数据
json.Msg = "奖金为0";
return(json);
}
//检查是否锁定此会员不得奖
if (member.IsLockCommission == true)
{
json.Msg = "此会员已锁定得奖，奖金不能分配";
return(json);
}
var Poundage = System.DB.XmlConfig.XmlSite.Poundage;
var ChongXiao = System.DB.XmlConfig.XmlSite.ChongXiao;
//插入费用明细
var mFin = new Fin_Info();
mFin.MemberId = member.MemberId;
mFin.MemberCode = member.Code;
mFin.NickName = member.NickName;
mFin.Amount = amount;
if (typeName == "挂卖奖励收益")
{
mFin.Poundage = 0;
mFin.CongXiao = 0;
if (typeName == "挂卖奖励收益")
{
mFin.RealAmount = 2100;
}
}
else
{
mFin.Poundage = 0;
mFin.CongXiao = 0;
mFin.RealAmount = mFin.Amount;
}
mFin.TypeName = typeName;
mFin.Comment = string.IsNullOrEmpty(Comment) ? typeName : Comment;
mFin.RefMemberId = refMember.MemberId;
mFin.RefMemberCode = refMember.Code;
mFin.RefNickName = refMember.NickName;
mFin.CreateTime = DateTime.Now;
mFin.IsSettlement = true;
mFin.SettlementTime = mFin.CreateTime;
db.Fin_Info.Add(mFin);
if (typeName == "挂卖奖励收益")
{
if (typeName == "挂卖奖励收益")
{
member.Commission += Convert.ToDecimal(mFin.RealAmount);
member.CommissionSum += Convert.ToDecimal(mFin.RealAmount);
Fin_LiuShui _liushui = new Fin_LiuShui();
//收益
_liushui.MemberId = member.MemberId;
_liushui.Code = member.Code;
_liushui.NickName = member.NickName;
_liushui.Type = "流水账单";
_liushui.Comment = "收益(+)";
_liushui.Amount = mFin.RealAmount;
_liushui.CreateTime = DateTime.Now;
DB.Fin_LiuShui.Insert(_liushui);
//累计收益
_liushui.MemberId = member.MemberId;
_liushui.Code = member.Code;
_liushui.NickName = member.NickName;
_liushui.Type = "流水账单";
_liushui.Comment = "累计收益(+)";
_liushui.Amount = mFin.RealAmount;
_liushui.CreateTime = DateTime.Now;
}
}
else
{
member.Commission += mFin.RealAmount;
member.CommissionSum += mFin.RealAmount;
//收益
Fin_LiuShui _liushui = new Fin_LiuShui();
_liushui.MemberId = member.MemberId;
_liushui.Code = member.Code;
_liushui.NickName = member.NickName;
_liushui.Type = "流水账单";
_liushui.Comment = "收益(+)";
_liushui.Amount = mFin.RealAmount;
_liushui.CreateTime = DateTime.Now;
//累计收益
_liushui.MemberId = member.MemberId;
_liushui.Code = member.Code;
_liushui.NickName = member.NickName;
_liushui.Type = "流水账单";
_liushui.Comment = "累计收益(+)";
_liushui.Amount = mFin.RealAmount;
_liushui.CreateTime = DateTime.Now;
}
json.Msg = "插入奖金成功";
return(json);
}
/// <summary>
/// 增加佣金
/// </summary>
/// <param name="db">数据库实体</param>
/// <param name="member">要增加佣金的会员,</param>
/// <param name="refMember">相关的会员,</param>
/// <param name="amount">金额</param>
/// <param name="db">数据库连接实例</param>
/// <param name="typeName">佣金类型名称</param>
/// <param name="Comment">佣金描述</param>
/// <returns></returns>DbMallEntities
public JsonHelp InsertFin(DbMallEntities db, Member_Info member, Member_Info refMember, decimal amount, string typeName, string Comment = "")
{
JsonHelp json = new JsonHelp(true);
if (amount < 0)
{
json.Msg = "佣金不能小于0";
return(json);
}
else if (amount == 0)
{
//佣金为0，直接返回，不向数据库增加数据
json.Msg = "佣金为0";
return(json);
}
//检查是否锁定此会员不得奖
if (member.IsLockCommission == true)
{
json.Msg = "此会员已锁定得奖，佣金不能分配";
return(json);
}
var Poundage = DB.XmlConfig.XmlSite.Poundage;
var ChongXiao = DB.XmlConfig.XmlSite.ChongXiao;
//插入费用明细
var mFin = new Fin_Info();
mFin.MemberId = member.MemberId;
mFin.MemberCode = member.Code;
mFin.NickName = member.NickName;
mFin.Amount = amount;
mFin.Poundage = amount * Poundage / 100m;
mFin.CongXiao = amount * ChongXiao / 100m;
mFin.RealAmount = mFin.Amount - mFin.Poundage;
mFin.TypeName = typeName;
mFin.Comment = string.IsNullOrEmpty(Comment) ? typeName : Comment;
mFin.RefMemberId = refMember.MemberId;
mFin.RefMemberCode = refMember.Code;
mFin.RefNickName = refMember.NickName;
mFin.CreateTime = DateTime.Now;
if (DB.XmlConfig.XmlSite.IsMiaoJie == true)
{
mFin.IsSettlement = true;
mFin.SettlementTime = mFin.CreateTime;
}
else
{
mFin.IsSettlement = false;
}
db.Fin_Info.Add(mFin);
if (DB.XmlConfig.XmlSite.IsMiaoJie == true)
{
var Comminssion = mFin.RealAmount * 50 / 100m;
var Coins = mFin.RealAmount * 50 / 100m;
member.Commission += Comminssion;
member.CommissionSum += Comminssion;
member.Coins += Coins;
member.ShopCoins += Convert.ToDecimal(mFin.CongXiao);
}
json.Msg = "插入佣金成功";
return(json);
}
/// <summary>
/// 增加佣金
/// </summary>
/// <param name="member">拿奖人</param>
/// <param name="refMember">相关人</param>
/// <param name="amount">金额</param>
/// <param name="typeName">奖名</param>
/// <param name="Comment">描述</param>
/// <param name="awardType">发奖类型（佣金，股份，分红）</param>
/// <returns></returns>
public JsonHelp InsertFin(Member_Info member, Member_Info refMember, decimal amount, string typeName, string Comment = "")
{
JsonHelp json = new JsonHelp(true);
#region 拓展奖(对碰奖)日封顶
#endregion
//if (amount < 0)
//{
// json.Msg = "佣金不能小于0";
// return json;
//}
//else if (amount == 0)
//{
// //佣金为0，直接返回，不向数据库增加数据
// json.Msg = "佣金为0";
// return json;
//}
//检查是否锁定此会员不得奖
if (member.IsLockCommission == true)
{
json.Msg = "此会员已锁定得奖，佣金不能分配";
return(json);
}
var Poundage = DB.XmlConfig.XmlSite.Poundage;
var ChongXiao = DB.XmlConfig.XmlSite.ChongXiao;
//插入费用明细
var mFin = new Fin_Info();
mFin.MemberId = member.MemberId;
mFin.MemberCode = member.Code;
mFin.NickName = member.NickName;
mFin.Amount = amount;
mFin.Poundage = amount * Poundage / 100m;
mFin.CongXiao = 0;
mFin.RealAmount = mFin.Amount - mFin.Poundage - mFin.CongXiao;
mFin.TypeName = typeName;
mFin.Comment = string.IsNullOrEmpty(Comment) ? typeName : Comment;
mFin.RefMemberId = refMember.MemberId;
mFin.RefMemberCode = refMember.Code;
mFin.RefNickName = refMember.NickName;
mFin.CreateTime = DateTime.Now;
mFin.GroupDate = (int)(mFin.CreateTime.Value - new DateTime(1900, 1, 1)).TotalDays;
if (mFin.Comment == "中级会员级差奖" || mFin.Comment == "高级会员级差奖" || mFin.TypeName == "代理推荐奖" || mFin.TypeName == "平级奖" || mFin.TypeName == "超越奖")
{
mFin.IsSettlement = false;
}
else
{
mFin.IsSettlement = true;
mFin.SettlementTime = mFin.CreateTime;
}
json.IsSuccess = DB.Fin_Info.Insert(mFin);
if (json.IsSuccess == false)
{
return(json);
}
else if (mFin.IsSettlement.Value)
{
member.Coins += mFin.RealAmount;
member.CommissionSum += mFin.RealAmount;
if (typeName == "分红奖")
{
member.FHSum = 0;
}
else if (typeName == "突出贡献奖")
{
member.LAmount = 0;
}
DB.Fin_LiuShui.AddLS(member.MemberId, mFin.RealAmount.Value, mFin.TypeName, "奖金");
var r = DB.Member_Info.Where(a => a.MemberId == member.MemberId).Update(a => new Member_Info()
{
LAmount = member.LAmount, FHSum = member.FHSum, Coins = member.Coins, CommissionSum = member.CommissionSum, ShopCoins = member.ShopCoins
});
json.IsSuccess = r > 0;
if (json.IsSuccess == false)
{
return(json);
}
}
json.Msg = "插入余额成功";
return(json);
}
