public ActionResult behaviorloglist(UserBehaviorLogModel seachmodel, int page = 1)
{
behaviorloglistViewModel model = new behaviorloglistViewModel();
int totalrowcount = 0;
UserBehaviorLogModel seach = new UserBehaviorLogModel();
seach.PageIndex = page;
seach.PageSize = PageSize;
seach.BehaviorType = seachmodel.BehaviorType;
seach.MemberName = seachmodel.MemberName;
seach.MemberPhone = seachmodel.MemberPhone;
List <UserBehaviorLogModel> list = logbll.GetUserBehaviorLogByPage(seach, out totalrowcount);
PagedList <UserBehaviorLogModel> pagelist = null;
if (list.Count > 0)
{
pagelist = new PagedList <UserBehaviorLogModel>(list, page, PageSize, totalrowcount);
}
model.currentpage = page;
model.list = pagelist;
model.pagesize = PageSize;
model.totalcount = totalrowcount;
ViewBag.PageTitle = "操作日志";
this.ViewData["seachmodel.BehaviorType"] = GetBehaviorTypeListItem(1);
return(View(model));
}
/// <summary>
/// 惩罚会员静态金额
/// </summary>
/// <param name="memberphone"></param>
/// <param name="money"></param>
/// <returns></returns>
public string punishmentStaticMoney(int memberid, decimal money, string reason)
{
string result = "0";
MemberInfoModel member = MemberInfoDAL.GetMember(memberid);
if (member == null)
{
return("0无此会员");
}
using (TransactionScope scope = new TransactionScope())
{
int rowcount = MemberCapitalDetailDAL.UpdateStaticPunishMoney(member.ID, money, member.TruethName, member.MobileNum);
if (rowcount < 1)
{
return("0操作失败");
}
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = member.ID;
logmodel.MemberName = member.TruethName;
logmodel.MemberPhone = member.MobileNum;
logmodel.OrderCode = "";
logmodel.OrderID = 0;
logmodel.ProduceMoney = (0 - money);
logmodel.Remark = "会员:" + member.MobileNum + " 被平台惩罚：" + money.ToString() + " 元，原因：" + reason;
logmodel.Type = 3;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0操作失败");
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
log.BehaviorType = 10;
log.HOrderCode = "";
log.MemberID = member.ID;
log.MemberName = member.TruethName;
log.MemberPhone = member.MobileNum;
log.ProcAmount = money;
log.Remark = "会员：" + member.MobileNum + " 被惩罚静态资金" + money + "元";
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 为会员分派动态奖金
/// </summary>
/// <param name="memberphone"></param>
/// <param name="money"></param>
/// <returns></returns>
public string FenPaiMoneyToDynamic(int memberid, decimal money)
{
string result = "0";
MemberInfoModel member = MemberInfoDAL.GetMember(memberid);
if (member == null)
{
return("0无此会员");
}
using (TransactionScope scope = new TransactionScope())
{
int rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFunds(member.ID, money, member.TruethName, member.MobileNum);
if (rowcount < 1)
{
return("0操作失败");
}
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = member.ID;
logmodel.MemberName = member.TruethName;
logmodel.MemberPhone = member.MobileNum;
logmodel.OrderCode = "";
logmodel.OrderID = 0;
logmodel.ProduceMoney = money;
logmodel.Remark = "会员:" + member.MobileNum + " 得到系统派发的奖金";
logmodel.Type = 3;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0操作失败");
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
log.BehaviorType = 9;
log.HOrderCode = "";
log.MemberID = member.ID;
log.MemberName = member.TruethName;
log.MemberPhone = member.MobileNum;
log.ProcAmount = money;
log.Remark = "会员：" + member.MobileNum + " 获得系统奖励动态资金" + money + "元";
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 更新提供帮助订单为已打款
/// </summary>
/// <param name="hid"></param>
/// <returns></returns>
public int UpdateToPlayMoneyV1(int hid, int aid)
{
int result = 0;
string value = SysAdminConfigDAL.GetConfigsByID(6); //得到打款后返还金额
string inteist = SysAdminConfigDAL.GetConfigsByID(7); //得到打款后利率
string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率
HelpeOrderModel order = HelpeOrderDAL.GetHelpOrderInfo(hid);
List <MatchOrderModel> matchorders = MatchOrderDAL.GetMatchOrderInfo(hid, aid);
using (TransactionScope scope = new TransactionScope())
{
//更改状态为已打款（此处不在变更利率为打款后利率）
//int rowcount = HelpeOrderDAL.UpdateStatusandinster(hid, 4, decimal.Parse(inteist));
int rowcount = HelpeOrderDAL.UpdateStatus(hid, 4);
if (rowcount < 1)
{
return(0);
}
rowcount = MatchOrderDAL.UpdateStatusToPayed(hid, aid);
if (rowcount < 1)
{
return(0);
}
//更新匹配接受订单的状态为对方已打款
rowcount = AcceptHelpOrderDAL.UpdateStatus(aid, 4);
if (rowcount < 1)
{
return(0);
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = matchorders[0].AcceptOrderCode;
log.BehaviorSource = 1;
log.BehaviorType = 4;
log.HOrderCode = matchorders[0].HelperOrderCode;
log.MemberID = order.MemberID;
log.MemberName = order.MemberName;
log.MemberPhone = order.MemberPhone;
log.ProcAmount = matchorders[0].MatchedMoney;
log.Remark = "会员：" + order.MemberPhone + " 变更单据为打款";
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = 1;
}
return(result);
}
/// <summary>
/// 为会员派发利息(V3版)
/// </summary>
/// <param name="day"></param>
/// <returns></returns>
public string PaymentInterestV3()
{
string result = "";
int days = int.Parse(SysAdminConfigDAL.GetConfigsByID(10));
using (TransactionScope scope = new TransactionScope())
{
//为每个单据派发利息
int rowcount = MemberCapitalDetailDAL.PaymentInterestForOrderWithLog(days);
if (rowcount < 1)
{
result = "0为单据派发利息失败";
return(result);
}
//更改会员的当前利率和利息
rowcount = MemberCapitalDetailDAL.ResetInster(days);
//汇总并加入到账户信息记录日志
rowcount = MemberCapitalDetailDAL.SumInterestMoneyWithoutLog();
if (rowcount < 1)
{
result = "0为会员更新利息总额失败";
return(result);
}
//解冻单据利率为2，状态为5的单据的利息
rowcount = MemberCapitalDetailDAL.UpdateStaticCaptail();
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
log.BehaviorType = 11;
log.HOrderCode = "";
log.MemberID = 0;
log.MemberName = "";
log.MemberPhone = "";
log.ProcAmount = 0;
log.Remark = "系统派发利息";
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 添加用户操作日志
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int AddUserBehaviorLog(UserBehaviorLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserBehaviorLog(");
strSql.Append("Remark,AddTime,MemberID,MemberPhone,MemberName,BehaviorSource,BehaviorType,ProcAmount,HOrderCode,AOrderCode");
strSql.Append(") values (");
strSql.Append("@Remark,GETDATE(),@MemberID,@MemberPhone,@MemberName,@BehaviorSource,@BehaviorType,@ProcAmount,@HOrderCode,@AOrderCode");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@MemberID", SqlDbType.Int),
new SqlParameter("@MemberPhone", SqlDbType.NVarChar),
new SqlParameter("@MemberName", SqlDbType.NVarChar),
new SqlParameter("@BehaviorSource", SqlDbType.Int),
new SqlParameter("@BehaviorType", SqlDbType.Int),
new SqlParameter("@ProcAmount", SqlDbType.Decimal),
new SqlParameter("@HOrderCode", SqlDbType.NVarChar),
new SqlParameter("@AOrderCode", SqlDbType.NVarChar)
};
parameters[0].Value = model.Remark;
parameters[1].Value = model.MemberID;
parameters[2].Value = model.MemberPhone;
parameters[3].Value = model.MemberName;
parameters[4].Value = model.BehaviorSource;
parameters[5].Value = model.BehaviorType;
parameters[6].Value = model.ProcAmount;
parameters[7].Value = model.HOrderCode;
parameters[8].Value = model.AOrderCode;
object obj = helper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 查询系统的操作变动信息
/// </summary>
/// <param name="model"></param>
/// <param name="totalrowcount"></param>
/// <returns></returns>
public List <UserBehaviorLogModel> GetUserBehaviorLogByPage(UserBehaviorLogModel model, out int totalrowcount)
{
return(UserBehaviorLogDAL.GetUserBehaviorLogByPage(model, out totalrowcount));
}
/// <summary>
/// 登录信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public SysAdminUserModel GetUserForLogin(SysAdminUserModel user)
{
SysAdminUserModel result = null;
string sqltxt = @"SELECT ID ,
UserName ,
UserPwd ,
UserStatus ,
UserEmail ,
TruethName ,
UserPhone ,
Question ,
Answer ,
GID ,
GName,
LoginName,HeaderImg,WebSkin,LastLoginIP,LastLoginTime,IsAdmin
FROM dbo.SysAdminUser
WHERE LoginName=@loginname ";
SqlParameter[] paramter =
{
new SqlParameter("@loginname", user.LoginName)
};
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
result = new SysAdminUserModel();
result.Answer = dt.Rows[0]["Answer"].ToString();
result.GID = int.Parse(dt.Rows[0]["GID"].ToString());
result.GName = dt.Rows[0]["GName"].ToString();
result.ID = int.Parse(dt.Rows[0]["ID"].ToString());
result.LoginName = dt.Rows[0]["LoginName"].ToString();
result.Question = dt.Rows[0]["Question"].ToString();
result.TruethName = dt.Rows[0]["TruethName"].ToString();
result.UserEmail = dt.Rows[0]["UserEmail"].ToString();
result.UserName = dt.Rows[0]["UserName"].ToString();
result.UserPhone = dt.Rows[0]["UserPhone"].ToString();
result.UserPwd = dt.Rows[0]["UserPwd"].ToString();
result.HeaderImg = dt.Rows[0]["HeaderImg"].ToString();
result.UserStatus = int.Parse(dt.Rows[0]["UserStatus"].ToString());
result.WebSkin = string.IsNullOrWhiteSpace(dt.Rows[0]["WebSkin"].ToString()) ? "default" : dt.Rows[0]["WebSkin"].ToString();
result.LastLoginIP = string.IsNullOrWhiteSpace(dt.Rows[0]["LastLoginIP"].ToString()) ? "" : dt.Rows[0]["LastLoginIP"].ToString();
result.LastLoginTime = string.IsNullOrWhiteSpace(dt.Rows[0]["LastLoginTime"].ToString()) ? DateTime.MinValue : DateTime.Parse(dt.Rows[0]["LastLoginTime"].ToString());
result.IsAdmin = dt.Rows[0]["IsAdmin"].ToString().ParseToInt(0);
if (result.UserPwd != user.UserPwd)
{
result.LoginResult = "0用户密码不正确";
return(result);
}
if (result.UserStatus == 0)
{
result.LoginResult = "0用户已经被禁用";
return(result);
}
UpdateLoginMsg(user.LastLoginTime, user.LastLoginIP, result.ID);
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
log.BehaviorType = 1;
log.HOrderCode = "";
log.MemberID = result.ID;
log.MemberName = result.UserName;
log.MemberPhone = result.UserPhone;
log.ProcAmount = 0;
log.Remark = "管理员：" + result.UserName + "登陆";
int rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
result.LoginResult = "1";
}
else
{
result = new SysAdminUserModel();
result.LoginResult = "0无此用户";
return(result);
}
return(result);
}
/// <summary>
/// 会员间赠送激活码
/// </summary>
/// <param name="soucememberID">原始会员ID</param>
/// <param name="type">赠送激活码类型</param>
/// <param name="acceptMemberPhone">接受会员电话</param>
/// <param name="count">赠送数量</param>
/// <returns>返回值（-1 接受会员不存在 -2 没有足够的激活币赠送 0 数据库操作失败 1 成功）</returns>
public int GiveActiveCodeFromMember(int soucememberID, int type, string acceptMemberPhone, int count)
{
int result = 0;
//读取接受会员信息
MemberInfoModel member = GetMember(acceptMemberPhone);
if (member == null)
{
return(-1);
}
if (member.MStatus != 2)
{
return(-1);
}
//开启事务
using (TransactionScope scope = new TransactionScope())
{
//查询该会员名下可用类型的激活码数量
List <MemberActiveCodeModel> aclist = GetMemberActiveCodeList(soucememberID, type);
if (aclist.Count < count)
{
return(-2);
}
//修改激活码的所有者信息
string sqltxt = @"UPDATE TOP ( @count)
MemberActiveCode
SET MemberID = @memberid ,
MemberPhone = @MemberPhone ,
MemberName = @MemberName
WHERE MemberID = @soucemid
AND AMStatus = 1
AND AMType = @AMType";
SqlParameter[] paramter =
{
new SqlParameter("@memberid", member.ID),
new SqlParameter("@MemberPhone", member.MobileNum),
new SqlParameter("@MemberName", member.TruethName),
new SqlParameter("@soucemid", soucememberID),
new SqlParameter("@AMType", type),
new SqlParameter("@count", count)
};
int row = helper.ExecuteSql(sqltxt, paramter);
if (row < 0)
{
return(0);
}
int rowcount = row;
//记录转出者名下日志
MemberInfoModel sourcemodel = GetMember(soucememberID);
ActiveCodeLogModel souce = new ActiveCodeLogModel();
souce.MemberID = soucememberID;
souce.MemberName = sourcemodel.TruethName;
souce.MemberPhone = sourcemodel.MobileNum;
souce.ActiveCode = "";
souce.AID = 0;
souce.Remark = " 转出" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币");
row = OperateLogDAL.AddActiveCodeLog(souce);
if (row < 0)
{
return(0);
}
//记录转入者名下日志
ActiveCodeLogModel accept = new ActiveCodeLogModel();
accept.MemberID = member.ID;
accept.MemberName = member.TruethName;
accept.MemberPhone = member.MobileNum;
accept.ActiveCode = "";
accept.AID = 0;
accept.Remark = "接收" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币");
row = OperateLogDAL.AddActiveCodeLog(accept);
if (row < 0)
{
return(0);
}
//记录系统操作日志
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 1;
if (type == 1)
{
log.BehaviorType = 8;
}
else
{
log.BehaviorType = 7;
}
log.HOrderCode = "";
log.MemberID = member.ID;
log.MemberName = member.TruethName;
log.MemberPhone = member.MobileNum;
log.ProcAmount = 0;
log.Remark = "会员：" + member.MobileNum + " 得到来自" + sourcemodel.MobileNum + "转来的" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币");
UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = 1;
}
return(result);
}
/// <summary>
/// 分配激活码
/// </summary>
/// <param name="codes"></param>
/// <param name="memberphone"></param>
/// <returns></returns>
public int AssignedCode(List <string> codes, string memberphone)
{
int result = 0;
//得到激活码信息
List <ActiveCodeModel> codelist = GetCodeMassage(codes);
//得到被分配会员信息
MemberInfoModel member = GetMember(memberphone);
if (member.MStatus != 2)
{
return(0);
}
//开启事务，分配激活码
try
{
using (TransactionScope scope = new TransactionScope())
{
//更改原表状态
result = UpdateStatus(codelist);
if (result < codelist.Count)
{
throw new Exception("更改激活码原表失败");
}
List <MemberActiveCodeModel> maclist = new List <MemberActiveCodeModel>();
foreach (var item in codelist)
{
MemberActiveCodeModel mac = new MemberActiveCodeModel();
mac.ActiveCode = item.ActivationCode;
mac.MemberID = member.ID;
mac.MemberName = member.TruethName;
mac.MemberPhone = member.MobileNum;
mac.AMType = item.AType;
maclist.Add(mac);
}
result = AddMemberActiveCode(maclist);
if (result < 1)
{
return(0);
}
ActiveCodeLogModel activemodel = new ActiveCodeLogModel();
activemodel.ActiveCode = "";
activemodel.Addtime = DateTime.Now;
activemodel.AID = 0;
activemodel.MemberID = member.ID;
activemodel.MemberName = member.TruethName;
activemodel.MemberPhone = member.MobileNum;
activemodel.Remark = "接收" + codelist.Count + "个" + (codelist[0].AType == 1 ? "激活币" : "排单币");
OperateLogDAL.AddActiveCodeLog(activemodel);
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
if (codelist[0].AType == 1)
{
log.BehaviorType = 8;
}
else
{
log.BehaviorType = 7;
}
log.HOrderCode = "";
log.MemberID = member.ID;
log.MemberName = member.TruethName;
log.MemberPhone = member.MobileNum;
log.ProcAmount = 0;
log.Remark = "系统派发激活码/排单币" + codelist.Count + "个";
UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = 1;
}
}
catch
{
return(0);
}
return(result);
}
/// <summary>
/// 添加一条提供帮助单据
/// </summary>
public string AddHelpeOrder(HelpeOrderModel model)
{
string result = "0";
string minhelpamont = SystemConfigs.GetminHelpAmont(); //得到最小的提供帮助限制
string maxhelpamont = SystemConfigs.GetmaxHelpAmont(); //得到最大的提供帮助限制
string interest = SysAdminConfigDAL.GetConfigsByID(5); //得到排单后的利率
string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率
decimal reinteist = SysAdminConfigDAL.GetConfigsByID(16).ParseToDecimal(10); //得到首次推荐的利率
decimal maxcount = SysAdminConfigDAL.GetConfigsByID(17).ParseToInt(1); //得到每日最大排单数
MemberExtendInfoModel meinfo = MemberExtendInfoDAL.GetMemberExtendInfo(model.MemberID);
int helpcount = HelpeOrderDAL.GetTodayHelpCount(model.MemberID);
if (model.Amount < minhelpamont.ParseToDecimal(0))
{
return("0超出了平台规定的最小规定值");
}
if (model.Amount > maxhelpamont.ParseToDecimal(0))
{
return("0超出了平台规定的最大规定值");
}
if (helpcount >= maxcount)
{
return("0今天已经提供过帮助");
}
bool isfirst = false;//默认不是第一次
if (meinfo == null)
{
isfirst = true;
}
else
{
isfirst = meinfo.MemberHelpCount == 0;
}
if (string.IsNullOrWhiteSpace(model.ActiveCode))
{
return("0没有填写排单币");
}
ActiveCodeModel activemodel = ActiveCodeDAL.GetActiveCodeExtendModel(model.ActiveCode);
if (activemodel == null)//没有该激活码信息为失败
{
return("0排单币无效");
}
if (activemodel.AStatus == 10)//改激活码已使用为失败
{
return("0排单币已经被使用");
}
if (model.Amount % 100 > 0)
{
return("0提供金额应为100的整数倍");
}
ReMemberRelationModel remember = ReMemberRelationDAL.GetReMemberRelation(model.MemberID);
using (TransactionScope scope = new TransactionScope())
{
//更改激活码的使用状态
int rowcount = ActiveCodeDAL.UpdateStatus(activemodel.ID, 10);
if (rowcount < 1)
{
return("0操作失败");
}
rowcount = ActiveCodeDAL.UpdateMemberActiveToUse(model.MemberID, model.OrderCode, model.ActiveCode);
if (rowcount < 1)
{
return("0操作失败");
}
//插入激活码的使用日志
ActiveCodeLogModel aclogmodel = new ActiveCodeLogModel();
aclogmodel.ActiveCode = model.ActiveCode;
aclogmodel.AID = model.ActiveCodeID;
aclogmodel.MemberID = model.MemberID;
aclogmodel.MemberName = model.MemberName;
aclogmodel.MemberPhone = model.MemberPhone;
aclogmodel.Remark = "会员:" + model.MemberName + " 使用排单币:" + model.ActiveCode + " 进行排单";
rowcount = OperateLogDAL.AddActiveCodeLog(aclogmodel);
if (rowcount < 1)
{
return("0操作失败");
}
//更改会员的资金信息和利率
decimal dinterest = 1;
if (!string.IsNullOrWhiteSpace(interest))
{
if (!decimal.TryParse(interest, out dinterest))
{
return("0操作失败");
}
}
//rowcount = MemberCapitalDetailDAL.UpdateMemberStaticCapital(model.MemberID, model.Amount, dinterest,model.MemberName,model.MemberPhone);
rowcount = MemberCapitalDetailDAL.UpdateMemberStaticFreezeMoneyAndinster(model.MemberID, model.Amount, dinterest, model.MemberName, model.MemberPhone);
if (rowcount < 1)
{
return("0操作失败");
}
//插入表记录
model.IsFristOrder = isfirst ? 1 : 0;
int orderid = dal.AddHelpeOrder(model);
if (orderid < 1)
{
return("0操作失败");
}
//更新会员的统计信息
rowcount = MemberExtendInfoDAL.Update(model.MemberID, model.Amount);
if (rowcount < 1)
{
return("0操作失败");
}
//插入会员的资金变动纪录
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = model.MemberID;
logmodel.MemberName = model.MemberName;
logmodel.MemberPhone = model.MemberPhone;
logmodel.OrderCode = model.OrderCode;
logmodel.OrderID = orderid;
logmodel.ProduceMoney = model.Amount;
logmodel.Remark = "会员:" + model.MemberPhone + " 申请提供帮助 " + model.Amount.ToString() + "元";
logmodel.Type = 1;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0操作失败");
}
//为推荐人添加领导奖
rowcount = MemberCapitalDetailDAL.PaymentLeaderPrize(model.MemberID, model.Amount, inteistlist, model.OrderCode, orderid);
if (rowcount < 1)
{
return("0操作失败");
}
//若此会员第一次排单，则给推荐人奖励
if (isfirst)
{
rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFreezeMoney(remember.MemberID, (model.Amount * reinteist / 100), remember.MemberTruthName, remember.MemberPhone);
if (rowcount < 1)
{
return("0操作失败");
}
LeaderAmountModel leadermodel = new LeaderAmountModel();//插入领导奖记录
leadermodel.OrderID = orderid;
leadermodel.OrderCode = model.OrderCode;
leadermodel.MemberPhone = remember.MemberPhone;
leadermodel.MemberName = remember.MemberTruthName;
leadermodel.MemberID = remember.MemberID;
leadermodel.LType = 1;
leadermodel.Amount = (model.Amount * reinteist / 100);
rowcount = MemberCapitalDetailDAL.AddLeaderAmount(leadermodel);
if (rowcount < 1)
{
return("0操作失败");
}
AmountChangeLogModel logmodel1 = new AmountChangeLogModel();
logmodel1.MemberID = remember.MemberID;
logmodel1.MemberName = remember.MemberTruthName;
logmodel1.MemberPhone = remember.MemberPhone;
logmodel1.OrderCode = model.OrderCode;
logmodel1.OrderID = orderid;
logmodel1.ProduceMoney = (model.Amount * reinteist / 100);
logmodel1.Remark = "会员:" + remember.MemberPhone + " 得到来自 " + model.MemberPhone + "的首单推荐奖(已冻结)" + (model.Amount * reinteist / 100).ToString() + "元";
logmodel1.Type = 3;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel1);
if (rowcount < 1)
{
return("0操作失败");
}
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 1;
log.BehaviorType = 2;
log.HOrderCode = model.OrderCode;
log.MemberID = model.MemberID;
log.MemberName = model.MemberName;
log.MemberPhone = model.MemberPhone;
log.ProcAmount = model.Amount;
log.Remark = "会员：" + model.MemberPhone + "提供帮助单号为：" + model.OrderCode;
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 更新状态为已完成
/// </summary>
/// <returns></returns>
public int UpdateSingleOrderToComplete(int aid, int hid)
{
int result = 0;
//List<MatchOrderModel> matchorders = MatchOrderDAL.GetMatchOrderInfo(0, aid);
HelpeOrderModel helporder = HelpeOrderDAL.GetHelpOrderInfo(hid); //查询提供帮助的单据
AcceptHelpOrderModel accorder = AcceptHelpOrderDAL.GetAcceptOrderInfo(aid); //查询接受单据的信息
List <MatchOrderModel> matchinfo = MatchOrderDAL.GetMatchOrderInfo(hid, aid); //单据的匹配信息
string value = SysAdminConfigDAL.GetConfigsByID(4); //得到注册返还金额
string scvalue = SysAdminConfigDAL.GetConfigsByID(6); //得到注册返还金额
string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率
int day = SysAdminConfigDAL.GetConfigsByID(22).ParseToInt(20); //得到领导奖推荐奖冻结天数
string inteist = SysAdminConfigDAL.GetConfigsByID(7); //得到打款后利率
using (TransactionScope scope = new TransactionScope())
{
//更改当前的接受单据状态和完成金额
int rowcount = AcceptHelpOrderDAL.UpdateStatusAndMoneyToComplete(aid, matchinfo[0].MatchedMoney);
if (rowcount < 1)
{
return(0);
}
//更改匹配信息
rowcount = MatchOrderDAL.UpdateStatusToComplete(hid, aid);
if (rowcount < 1)
{
return(0);
}
//更改匹配的提供帮助订单的状态
rowcount = HelpeOrderDAL.UpdateStatusForCompleteV1(helporder.ID, matchinfo[0].MatchedMoney);
if (rowcount < 1)
{
return(0);
}
decimal diffamount = (helporder.Amount - helporder.PayedAmount - matchinfo[0].MatchedMoney);
if (diffamount == 0)
{
//返还匹配会员的静态冻结资金和利息
rowcount = MemberCapitalDetailDAL.UpdateStaticInterestAndStaticFreezeMoney(helporder.MemberID, helporder.Amount, helporder.Interest);
if (rowcount < 1)
{
return(0);
}
//更改单据利率为高利率
rowcount = HelpeOrderDAL.UpdateCurrentInterest(hid, inteist.ParseToInt(2));
if (rowcount < 1)
{
return(0);
}
//更改该单据的利息为0
rowcount = HelpeOrderDAL.UpdateHelperOrderClearInterest(helporder.ID);
if (rowcount < 1)
{
return(0);
}
//返还推荐奖
if (helporder.IsFristOrder == 1 && helporder.IsRecommendBack == 0)
{
decimal inster = SysAdminConfigDAL.GetConfigsByID(16).ParseToInt(10);//得到首次推荐的利率
decimal money = helporder.Amount * inster / 100;
ReMemberRelationModel model = ReMemberRelationDAL.GetReMemberRelation(helporder.MemberID);
if (day == 0)//若为0，则当时返还
{
//返还推荐奖
rowcount = MemberCapitalDetailDAL.UpdateDynamicInterestForComplete(model.MemberID, money);
if (rowcount < 1)
{
return(0);
}
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = model.MemberID;
logmodel.MemberName = model.MemberTruthName;
logmodel.MemberPhone = model.MemberPhone;
logmodel.OrderCode = helporder.OrderCode;
logmodel.OrderID = helporder.ID;
logmodel.ProduceMoney = money;
logmodel.Remark = "会员:" + model.MemberPhone + " 得到来自单据：" + helporder.OrderCode + "的推荐奖";
logmodel.Type = 3;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return(result);
}
}
else
{
//返还推荐奖到待返还列表
WaitFreeLeaderAmountModel waitfreemodel = new WaitFreeLeaderAmountModel();
waitfreemodel.MemberID = model.MemberID;
waitfreemodel.MemberName = model.MemberTruthName;
waitfreemodel.MemberPhone = model.MemberPhone;
waitfreemodel.Amount = money;
waitfreemodel.AStatus = 1;
waitfreemodel.TheoryFreeTime = DateTime.Now.AddDays(day);
waitfreemodel.Type = 2;
waitfreemodel.OrderCode = helporder.OrderCode;
waitfreemodel.OrderID = helporder.ID;
rowcount = MemberCapitalDetailDAL.AddWaitFreeMoney(waitfreemodel);
if (rowcount < 1)
{
return(0);
}
}
//返还激活码的钱
rowcount = MemberCapitalDetailDAL.UpdateStaticFreezeMoneyForReiger(helporder.MemberID, value.ParseToDecimal(0));
//更改单据为已经派发推荐奖
rowcount = HelpeOrderDAL.UpdateHelperOrderIsRecommendBack(helporder.ID);
}
if (helporder.IsLeaderBack == 0)
{
if (day == 0)
{
//返还领导奖
rowcount = MemberCapitalDetailDAL.PaymentLeaderPrizeForComplete(helporder.MemberID, inteistlist, helporder.OrderCode, helporder.ID);
}
else
{
//返还领导奖到待返还列表
rowcount = MemberCapitalDetailDAL.PaymentLeaderPrizeForComplete(helporder.MemberID, inteistlist, helporder.OrderCode, helporder.ID, day);
}
//更新单据状态
rowcount = HelpeOrderDAL.UpdateHelperOrderIsLeaderBack(helporder.ID);
}
//返还该单据排单币的金额
if (helporder.SchedulingAmount == 0)
{
rowcount = MemberCapitalDetailDAL.UpdateMemberStaticCapital(helporder.MemberID, scvalue.ParseToDecimal(0), helporder.MemberName, helporder.MemberPhone);
if (rowcount < 1)
{
return(0);
}
rowcount = HelpeOrderDAL.UpdateHelperOrderIsRecommendBack(helporder.ID, scvalue.ParseToDecimal(0));//更新单据的排单币金额
if (rowcount < 1)
{
return(0);
}
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = helporder.MemberID;
logmodel.MemberName = helporder.MemberName;
logmodel.MemberPhone = helporder.MemberPhone;
logmodel.OrderCode = helporder.OrderCode;
logmodel.OrderID = helporder.ID;
logmodel.ProduceMoney = scvalue.ParseToDecimal(0);
logmodel.Remark = "会员:" + helporder.MemberPhone + " 打款完成，返还排单币" + scvalue + "元";
logmodel.Type = 5;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return(0);
}
}
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = accorder.OrderCode;
log.BehaviorSource = 1;
log.BehaviorType = 5;
log.HOrderCode = helporder.OrderCode;
log.MemberID = accorder.MemberID;
log.MemberName = accorder.MemberName;
log.MemberPhone = accorder.MemberPhone;
log.ProcAmount = matchinfo[0].MatchedMoney;
log.Remark = "会员：" + accorder.MemberPhone + "为单据" + accorder.OrderCode + "确认收款";
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = 1;
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public string AddAcceptHelpOrder(AcceptHelpOrderModel model)
{
string result = "0";
MemberCapitalDetailModel moneydetail = MemberCapitalDetailDAL.GetMemberStaticCapital(model.MemberID);
int rows = AcceptHelpOrderDAL.GetNotFinishOrderByMember(model.MemberID);
if (rows > 0)
{
return("0还有未完成的接受帮助单据");
}
string maxacceptamont = SystemConfigs.GetmaxAcceptAmont(); //得到最大的接受帮助限制
string minacceptamont = SystemConfigs.GetminAcceptAmont(); //得到最小的接受帮助限制
if (model.Amount > maxacceptamont.ParseToDecimal(0))
{
return("0超出了平台规定的最大接受值");
}
if (model.Amount < minacceptamont.ParseToDecimal(0))
{
return("0超出了平台规定的最小接受值");
}
int daynum = SysAdminConfigBLL.GetConfigValue(24).ParseToInt(15);
MemberExtendInfoModel extentmember = MemberExtendInfoDAL.GetMemberExtendInfo(model.MemberID);
if (DateTime.Now < extentmember.LastHelperTime.AddDays(daynum))
{
return("0会员提供帮助单据仍处于冻结期");
}
using (TransactionScope scope = new TransactionScope())
{
//插入表
int orderid = dal.AddAcceptHelpOrder(model);
if (orderid < 1)
{
return("0操作失败");
}
//扣减会员的相应金额记录
int rowcount = 0;
if (model.SourceType == 1)
{
if (moneydetail.StaticCapital < model.Amount)
{
return("0操作失败");
}
rowcount = MemberCapitalDetailDAL.DeductionMemberStaticCapital(model.MemberID, 0 - model.Amount, 0);
//清空会员的利率(不判断结果，不排除没有这样单据的可能，因为存在特殊账户)
int rowcounts = HelpeOrderDAL.UpdateCurrentInterestToClear(model.MemberID);
}
else
{
if (moneydetail.DynamicFunds < model.Amount)
{
return("0操作失败");
}
rowcount = MemberCapitalDetailDAL.DeductionMemberDynamicFunds(model.MemberID, 0 - model.Amount, 0);
}
if (rowcount < 1)
{
return("0操作失败");
}
//点击接受帮助后不再为会员计算利息
//增加会员的资金变动记录
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = model.MemberID;
logmodel.MemberName = model.MemberName;
logmodel.MemberPhone = model.MemberPhone;
logmodel.OrderCode = model.OrderCode;
logmodel.OrderID = orderid;
logmodel.ProduceMoney = 0 - model.Amount;
logmodel.Remark = "会员:" + model.MemberPhone + " 申请接受帮助 " + model.Amount.ToString() + "元";
logmodel.Type = 1;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0操作失败");
}
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = model.OrderCode;
log.BehaviorSource = 1;
log.BehaviorType = 3;
log.HOrderCode = "";
log.MemberID = model.MemberID;
log.MemberName = model.MemberName;
log.MemberPhone = model.MemberPhone;
log.ProcAmount = model.Amount;
log.Remark = "会员：" + model.MemberPhone + "接受帮助单号为：" + model.OrderCode;
rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 查询用户操作数据
/// </summary>
/// <param name="model"></param>
/// <param name="totalrowcount"></param>
/// <returns></returns>
public static List <UserBehaviorLogModel> GetUserBehaviorLogByPage(UserBehaviorLogModel model, out int totalrowcount)
{
List <UserBehaviorLogModel> list = new List <UserBehaviorLogModel>();
string columms = @" ID,MemberID,MemberPhone,MemberName,BehaviorSource,BehaviorType,ProcAmount,HOrderCode,AOrderCode,Remark,AddTime,CASE BehaviorType WHEN 1 THEN '登陆' WHEN 2 THEN '提供帮助' WHEN 3 THEN '接受帮助' WHEN 4 THEN '变更打款' WHEN 5 THEN '确认单据' WHEN 6 THEN '撤销单据' WHEN 7 THEN '发放排单币' WHEN 8 THEN '发放激活币' WHEN 9 THEN '奖励会员' WHEN 10 THEN '惩罚会员' WHEN 11 THEN '系统派息' END AS BehaviorTypeName,CASE BehaviorSource WHEN 1 THEN '前端' WHEN 2 THEN '后台' END AS BehaviorSourceName ";
string where = "";
if (model != null)
{
if (model.BehaviorType > 0)
{
where += @"BehaviorType='" + model.BehaviorType + "'";
}
if (!string.IsNullOrWhiteSpace(model.MemberName) && string.IsNullOrWhiteSpace(where))
{
where += @" MemberName=" + model.MemberID.ToString();
}
else if (!string.IsNullOrWhiteSpace(where) && !string.IsNullOrWhiteSpace(model.MemberName))
{
where += @" AND MemberName=" + model.MemberID.ToString();
}
if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where))
{
where += @" MemberPhone = '" + model.MemberPhone + "'";
}
else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where))
{
where += @" AND MemberPhone = '" + model.MemberPhone + "'";
}
}
PageProModel page = new PageProModel();
page.colums = columms;
page.orderby = "ID";
page.pageindex = model.PageIndex;
page.pagesize = model.PageSize;
page.tablename = @"dbo.UserBehaviorLog";
page.where = where;
DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
UserBehaviorLogModel usermodel = new UserBehaviorLogModel();
if (item["ID"].ToString() != "")
{
usermodel.ID = int.Parse(item["ID"].ToString());
}
usermodel.Remark = item["Remark"].ToString();
if (item["AddTime"].ToString() != "")
{
usermodel.AddTime = DateTime.Parse(item["AddTime"].ToString());
}
if (item["MemberID"].ToString() != "")
{
usermodel.MemberID = int.Parse(item["MemberID"].ToString());
}
usermodel.MemberPhone = item["MemberPhone"].ToString();
usermodel.MemberName = item["MemberName"].ToString();
if (item["BehaviorSource"].ToString() != "")
{
usermodel.BehaviorSource = int.Parse(item["BehaviorSource"].ToString());
}
if (item["BehaviorType"].ToString() != "")
{
usermodel.BehaviorType = int.Parse(item["BehaviorType"].ToString());
}
if (item["ProcAmount"].ToString() != "")
{
usermodel.ProcAmount = decimal.Parse(item["ProcAmount"].ToString());
}
usermodel.HOrderCode = item["HOrderCode"].ToString();
usermodel.AOrderCode = item["AOrderCode"].ToString();
usermodel.BehaviorSourceName = item["BehaviorSourceName"].ToString();
usermodel.BehaviorTypeName = item["BehaviorTypeName"].ToString();
list.Add(usermodel);
}
}
return(list);
}
/// <summary>
/// 前端会员登陆
/// </summary>
/// <param name="phone"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public MemberInfoModel GetMemberInfo(string phone, string pwd, out string logmsg)
{
MemberInfoModel model = null;
string sqltxt = @"SELECT ID ,
TruethName ,
Sex ,
TelPhone ,
MobileNum ,
Email ,
IdentificationID ,
Province ,
City ,
Area ,
[Address] ,
WeixinNum ,
AliPayName ,
AliPayNum ,
SecurityQuestion ,
SecurityAnswer ,
LogPwd ,
MStatus ,
AddTime
FROM dbo.MemberInfo
WHERE MobileNum=@MobileNum";
SqlParameter[] paramter = { new SqlParameter("@MobileNum", phone) };
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
if (dt.Rows.Count > 0)
{
string logpwd = dt.Rows[0]["LogPwd"].ToString();
if (logpwd != pwd)
{
logmsg = "登陆密码不正确";
return(null);
}
if (dt.Rows[0]["MStatus"].ToString() == "1")
{
logmsg = "该账户未激活";
return(null);
}
if (dt.Rows[0]["MStatus"].ToString() == "3")
{
logmsg = "该账户已被冻结";
return(null);
}
model = new MemberInfoModel();
if (dt.Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[0]["ID"].ToString());
}
if (dt.Rows[0]["Area"].ToString() != "")
{
model.Area = dt.Rows[0]["Area"].ToString();
}
model.Address = dt.Rows[0]["Address"].ToString();
model.WeixinNum = dt.Rows[0]["WeixinNum"].ToString();
model.AliPayName = dt.Rows[0]["AliPayName"].ToString();
model.AliPayNum = dt.Rows[0]["AliPayNum"].ToString();
model.SecurityQuestion = dt.Rows[0]["SecurityQuestion"].ToString();
model.SecurityAnswer = dt.Rows[0]["SecurityAnswer"].ToString();
model.LogPwd = "password";
if (dt.Rows[0]["MStatus"].ToString() != "")
{
model.MStatus = int.Parse(dt.Rows[0]["MStatus"].ToString());
}
if (dt.Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(dt.Rows[0]["AddTime"].ToString());
}
model.TruethName = dt.Rows[0]["TruethName"].ToString();
if (dt.Rows[0]["Sex"].ToString() != "")
{
model.Sex = int.Parse(dt.Rows[0]["Sex"].ToString());
}
model.TelPhone = dt.Rows[0]["TelPhone"].ToString();
model.MobileNum = dt.Rows[0]["MobileNum"].ToString();
model.Email = dt.Rows[0]["Email"].ToString();
model.IdentificationID = dt.Rows[0]["IdentificationID"].ToString();
if (dt.Rows[0]["Province"].ToString() != "")
{
model.Province = dt.Rows[0]["Province"].ToString();
}
if (dt.Rows[0]["City"].ToString() != "")
{
model.City = dt.Rows[0]["City"].ToString();
}
logmsg = "1";
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 1;
log.BehaviorType = 1;
log.HOrderCode = "";
log.MemberID = model.ID;
log.MemberName = model.TruethName;
log.MemberPhone = model.MobileNum;
log.ProcAmount = 0;
log.Remark = "会员：" + model.MobileNum + "登陆";
int rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
return(model);
}
else
{
logmsg = "手机号不存在";
return(null);
}
}
