public static Hashtable Insert(Model.SHMoney model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SHMoney(");
strSql.Append("MAgencyType,MColor,ViewLevel,TJCount,TJAgency,TemaCount,DTopMoney,SQHelpCount,XYLastMemberCount,XFMouthMinHelpMoney,XFMounthMoney,MAgencyName,InitMaxTZ,XYFloat,Money,BTFloat,TJFloat,TXFloat,TakeOffFloat,ReBuyFloat,MCWFloat");
strSql.Append(") values (");
strSql.Append("@MAgencyType,@MColor,@ViewLevel,@TJCount,@TJAgency,@TemaCount,@DTopMoney,@SQHelpCount,@XYLastMemberCount,@XFMouthMinHelpMoney,@XFMounthMoney,@MAgencyName,@InitMaxTZ,@XYFloat,@Money,@BTFloat,@TJFloat,@TXFloat,@TakeOffFloat,@ReBuyFloat,@MCWFloat");
strSql.Append(") ");
strSql.AppendFormat(";select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MAgencyType", SqlDbType.VarChar, 10),
new SqlParameter("@MColor", SqlDbType.VarChar, 10),
new SqlParameter("@ViewLevel", SqlDbType.Int, 4),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@TJAgency", SqlDbType.VarChar, 10),
new SqlParameter("@TemaCount", SqlDbType.Int, 4),
new SqlParameter("@DTopMoney", SqlDbType.Decimal, 9),
new SqlParameter("@SQHelpCount", SqlDbType.Int, 4),
new SqlParameter("@XYLastMemberCount", SqlDbType.Int, 4),
new SqlParameter("@XFMouthMinHelpMoney", SqlDbType.Decimal, 9),
new SqlParameter("@XFMounthMoney", SqlDbType.Decimal, 9),
new SqlParameter("@MAgencyName", SqlDbType.VarChar, 20),
new SqlParameter("@InitMaxTZ", SqlDbType.Int, 4),
new SqlParameter("@XYFloat", SqlDbType.Decimal, 9),
new SqlParameter("@Money", SqlDbType.VarChar, 50),
new SqlParameter("@BTFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TJFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TXFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TakeOffFloat", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyFloat", SqlDbType.Decimal, 9),
new SqlParameter("@MCWFloat", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MAgencyType;
parameters[1].Value = model.MColor;
parameters[2].Value = model.ViewLevel;
parameters[3].Value = model.TJCount;
parameters[4].Value = model.TJAgency;
parameters[5].Value = model.TemaCount;
parameters[6].Value = model.DTopMoney;
parameters[7].Value = model.SQHelpCount;
parameters[8].Value = model.XYLastMemberCount;
parameters[9].Value = model.XFMouthMinHelpMoney;
parameters[10].Value = model.XFMounthMoney;
parameters[11].Value = model._MAgencyName;
parameters[12].Value = model.InitMaxTZ;
parameters[13].Value = model.XYFloat;
parameters[14].Value = model.Money;
parameters[15].Value = model.BTFloat;
parameters[16].Value = model.TJFloat;
parameters[17].Value = model.TXFloat;
parameters[18].Value = model.TakeOffFloat;
parameters[19].Value = model.ReBuyFloat;
parameters[20].Value = model.MCWFloat;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
protected override void SetValue()
{
sjmodel = TModel;
hdmid.Value = sjmodel.MID;
Model.SHMoney shmoney = null;
foreach (Model.SHMoney item in BLL.Configuration.Model.SHMoneyList.Values.Where(emp => emp.MAgencyType != "001"))
{
MAgencyTypeColor += "<td style='width:60px;color:#00CCFF;'>" + item.MAgencyName + "<br />[" + item.Money + "]</td>";
if (shmoney == null && item.Money > sjmodel.MAgencyType.Money)
{
shmoney = item;
}
}
//获取次数
int count = BLL.LuckyMoney.GetModelList(" FHTimes = " + Convert.ToInt32(sjmodel.AgencyCode) + " and MID = '" + sjmodel.MID + "' ").Count;
if (shmoney != null && count >= sjmodel.MAgencyType.TeamCount)
{
//可以升级下一级
MyMAgencyTypeRdo += "<input name='AgencyTypeList' id='" + shmoney.MAgencyType + "' value='" + shmoney.MAgencyType + "' type='radio' />" + shmoney.MAgencyName + "[" + (shmoney.Money - sjmodel.MAgencyType.Money) + "] ";
}
if (string.IsNullOrEmpty(MyMAgencyTypeRdo))
{
MyMAgencyTypeRdo += "暂不可升级";
}
}
public string UpMAgencyType(Model.SHMoney shmoney, string mid, string moneyType, Model.Member shmodel, decimal appendMoney, string bdmid = "")
{
Model.Member model = DAL.Member.GetModel(mid);
if (model == null)
{
return("升级会员不存在");
}
decimal sjmoney = appendMoney;
Hashtable MyHs = new Hashtable();
lock (DAL.Member.tempMemberList)
{
DAL.Member.tempMemberList.Clear();
DAL.Member.tempMemberAdd(model);
{
string PCode = "005";//升级
if (!model.MState)
{
string error = Validation2(model, shmoney);
if (!string.IsNullOrEmpty(error))
{
return(error);
}
PCode = "001";//激活升级
model.MConfig.YJCount += 1;
DAL.MemberConfig.UpdateConfigTran(model.MID, "YJCount", "1", model, false, SqlDbType.Int, MyHs);
model.MConfig.JTFHState = true;
DAL.MemberConfig.UpdateConfigTran(model.MID, "JTFHState", "1", model, true, SqlDbType.Bit, MyHs);
model.MConfig.DTFHState = true;
DAL.MemberConfig.UpdateConfigTran(model.MID, "DTFHState", "1", model, true, SqlDbType.Bit, MyHs);
model.RoleCode = "Nomal";
model.Role = BLL.Roles.RolsList["Nomal"];
model.MDate = DateTime.Now;
model.MState = true;
model.FHState = false;
model.ValidTime = DateTime.Now;
}
if (shmoney != null)
{
// 二次升级的奖金按照升级之前的级别拿比例
model.AgencyCode = shmoney.MAgencyType;
model.MAgencyType = shmoney;
}
DAL.Member.UpdateRole(model, MyHs);
if (DAL.CommonBase.RunHashtable(MyHs))
{
DAL.Member.tempMemberList.Clear(); //清空临时字典
DAL.BMember.tempBMemberList.Clear(); //清空临时字典
return("1");
}
}
}
return("升级失败");
}
public static string Validation2(Model.Member shmodel, Model.SHMoney sh = null)
{
Model.Member MTJ = DAL.Member.GetModel(shmodel.MTJ);
//Model.Member MSH = DAL.Member.GetModel(shmodel.MSH);
Model.Member MBD = DAL.Member.GetModel(shmodel.MBD);
return("");
}
public static Hashtable Insert(Model.SHMoney model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SHMoney(");
strSql.Append("MAgencyType,MAgencyName,Money,BTFloat,TJFloat,TXFloat,TakeOffFloat,ReBuyFloat,MCWFloat,MColor,ViewLevel,TJCount,YJMoney,TeamCount,teamPer,MinTeamMoney,SubCount,DPFloat,DPTopMoney)");
strSql.Append(" values (");
strSql.Append("@MAgencyType,@MAgencyName,@Money,@BTFloat,@TJFloat,@TXFloat,@TakeOffFloat,@ReBuyFloat,@MCWFloat,@MColor,@ViewLevel,@TJCount,@YJMoney,@TeamCount,@teamPer,@MinTeamMoney,@SubCount,@DPFloat,@DPTopMoney)");
SqlParameter[] parameters =
{
new SqlParameter("@MAgencyType", SqlDbType.VarChar, 10),
new SqlParameter("@MAgencyName", SqlDbType.VarChar, 20),
new SqlParameter("@Money", SqlDbType.VarChar, 50),
new SqlParameter("@BTFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TJFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TXFloat", SqlDbType.Decimal, 9),
new SqlParameter("@TakeOffFloat", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyFloat", SqlDbType.Decimal, 9),
new SqlParameter("@MCWFloat", SqlDbType.Decimal, 9),
new SqlParameter("@MColor", SqlDbType.VarChar, 10),
new SqlParameter("@ViewLevel", SqlDbType.Int, 4),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@YJMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TeamCount", SqlDbType.Int, 4),
new SqlParameter("@teamPer", SqlDbType.Decimal, 9),
new SqlParameter("@MinTeamMoney", SqlDbType.Decimal, 9),
new SqlParameter("@SubCount", SqlDbType.Int, 4),
new SqlParameter("@DPFloat", SqlDbType.Decimal, 9),
new SqlParameter("@DPTopMoney", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MAgencyType;
parameters[1].Value = model._MAgencyName;
parameters[2].Value = model.Money;
parameters[3].Value = model.BTFloat;
parameters[4].Value = model.TJFloat;
parameters[5].Value = model.TXFloat;
parameters[6].Value = model.TakeOffFloat;
parameters[7].Value = model.ReBuyFloat;
parameters[8].Value = model.MCWFloat;
parameters[9].Value = model.MColor;
parameters[10].Value = model.ViewLevel;
parameters[11].Value = model.TJCount;
parameters[12].Value = model.YJMoney;
parameters[13].Value = model.TeamCount;
parameters[14].Value = model.teamPer;
parameters[15].Value = model.MinTeamMoney;
parameters[16].Value = model.SubCount;
parameters[17].Value = model.DPFloat;
parameters[18].Value = model.DPTopMoney;
strSql.AppendFormat(";select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static List <Model.SHMoney> GetSHMoneyList()
{
List <Model.SHMoney> list = new List <Model.SHMoney>();
DataTable dt = GetSHMoneyListDataTable();
foreach (DataRow dr in dt.Rows)
{
Model.SHMoney model = TranEntity(dr);
list.Add(model);
}
return(list);
}
protected override string btnModify_Click()
{
//判断是否信息完整
if (string.IsNullOrEmpty(TModel.BankCardName) || (string.IsNullOrEmpty(TModel.BankNumber) && string.IsNullOrEmpty(TModel.NumID)))
{
return("请先完善资料");
}
//校验激活码
string activeCode = Request.Form["txtActiveCode"];
Model.ActiveCode list = BLL.ActiveCode.GetList("Code='" + activeCode + "' and UseState not in (2,4)").FirstOrDefault();
if (list == null)
{
return("激活码无效");
}
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList["002"];//默认002
//if (BLL.ChangeMoney.EnoughChange(TModel.MID, BLL.Configuration.Model.YLMoney, "MHB"))
//{
try
{
if (BLL.Member.upmidlist.Contains(TModel.MID))
{
return("2");
}
else
{
BLL.Member.upmidlist.Add(TModel.MID);
}
Hashtable MyHs = new Hashtable();
list.UseMID = TModel.MID;
list.UseState = 2;
list.UseTime = DateTime.Now;
BLL.ActiveCode.Update(list, MyHs);
return(BllModel.UpMAgencyType(shmoney, TModel.MID, TModel, 0, MyHs));
}
finally
{
if (BLL.Member.upmidlist.Contains(TModel.MID))
{
BLL.Member.upmidlist.Remove(TModel.MID);
}
}
//}
//else
//{
// return "您的激活币账号余额不足";
//}
}
protected override string btnModify_Click()
{
//if (Check_SQ_Answer())
//{
sjmodel = TModel;
if (!string.IsNullOrEmpty(Request.Form["hdmid"]))
{
sjmodel = BllModel.GetModel(Request.Form["hdmid"]);
}
if (BLL.Configuration.Model.SHMoneyList.ContainsKey(Request.Form["AgencyTypeList"]))
{
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList[Request.Form["AgencyTypeList"]];
if (BLL.ChangeMoney.EnoughChange(TModel.MID, shmoney.Money - sjmodel.MAgencyType.Money, "MJB"))
{
try
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
return("升级处理中，请等待！");
}
else
{
BLL.Member.upmidlist.Add(sjmodel.MID);
}
Hashtable MyHs = new Hashtable();
return(BllModel.UpMAgencyType(shmoney, Request.Form["hdmid"], TModel, shmoney.Money - sjmodel.MConfig.SHMoney, MyHs));
}
finally
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
BLL.Member.upmidlist.Remove(sjmodel.MID);
}
}
}
else
{
return("您的账号余额不足");
}
}
else
{
return("未知会员级别");
}
//}
//else
// return "密保问题错误*";
}
public static Model.SHMoney GetModelByStr(string strWhere)
{
Model.SHMoney model = null;
if (!string.IsNullOrEmpty(strWhere))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select *,Money + ' (' + MAgencyName + ')' as 'MoneyMAgencyName' ");
strSql.AppendFormat(" FROM SHMoney where {0} ", strWhere);
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
model = TranEntity(dt.Rows[0]);
}
}
return(model);
}
/// <summary>
/// 得到绑定列表
/// </summary>
/// <returns></returns>
public static Dictionary <string, Model.SHMoney> GetSHMoneyList(DataTable table)
{
Dictionary <string, Model.SHMoney> SHMoneyList = new Dictionary <string, Model.SHMoney>();
if (table == null)
{
table = GetSHMoneyListDataTable();
}
foreach (DataRow dr in table.Rows)
{
Model.SHMoney model = TranEntity(dr);
SHMoneyList.Add(model.MAgencyType, model);
}
return(SHMoneyList);
}
protected override string btnModify_Click()
{
sjmodel = TModel;
if (!string.IsNullOrEmpty(Request.Form["hdmid"]))
{
sjmodel = BllModel.GetModel(Request.Form["hdmid"]);
}
if (BLL.Configuration.Model.SHMoneyList.ContainsKey(Request.Form["AgencyTypeList"]))
{
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList[Request.Form["AgencyTypeList"]];
if (BLL.ChangeMoney.EnoughChange(TModel.MID, shmoney.Money - sjmodel.MAgencyType.Money, "MJB"))
{
try
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
return("升级处理中，请等待！");
}
else
{
BLL.Member.upmidlist.Add(sjmodel.MID);
}
return(BllModel.UpMAgencyType(shmoney, Request.Form["hdmid"], "MJB", TModel, shmoney.Money - sjmodel.MConfig.SHMoney));
}
finally
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
BLL.Member.upmidlist.Remove(sjmodel.MID);
}
}
}
else
{
return("您的报单币账户余额不足");
}
}
else
{
return("未知会员级别");
}
}
protected override string btnAdd_Click()
{
//查询是否申请过了
Model.MemberApply app = BLL.MemberApply.CheckHasApplyed(TModel.MID, 0, Request.Form["rdoupmagecy"]);
if (app != null)
{
return("您已经申请过了，请等待管理员审核。");
}
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList[Request.Form["rdoupmagecy"]];
//查看直推人数
if (TModel.MConfig.TJCount < shmoney.TJCount || TModel.MConfig.YJCount < shmoney.TemaCount)
{
return("申请失败，要申请到" + shmoney.MAgencyName + ",必须达到推荐人数" + shmoney.TJCount + "，团队人数" + shmoney.TemaCount);
}
else
{
//查询推荐人数中有多少经理，高级经理，
string sql = "select count(1) from Member WHERE MTJ='" + TModel.MID + "' AND AgencyCode='" + shmoney.TJAgency + "'";
object objCount = BLL.CommonBase.GetSingle(sql);
if (Convert.ToInt16(objCount) < shmoney.TJCount || TModel.MConfig.YJCount < shmoney.TemaCount)
{
return("申请失败，您的推荐人数不足或团队人数不足");
}
else
{
Model.MemberApply apply = new Model.MemberApply();
apply.ApplyTime = DateTime.Now;
apply.ApplyType = shmoney.MAgencyType;
apply.MID = TModel.MID;
apply.MTel = TModel.Tel;
apply.State = 0;
if (BLL.MemberApply.Insert(apply))
{
return("申请成功，请等待管理员审核。");
}
}
}
return("申请失败");
}
/// <summary>
/// 转换数据实体
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private static Model.SHMoney TranEntity(DataRow row)
{
if (row != null)
{
Model.SHMoney model = new Model.SHMoney();
if (row["MAgencyType"] != null)
{
model.MAgencyType = row["MAgencyType"].ToString();
}
if (row["MAgencyName"] != null)
{
model._MAgencyName = row["MAgencyName"].ToString();
}
if (row["Money"] != null && row["Money"].ToString() != "")
{
model.Money = int.Parse(row["Money"].ToString());
}
if (row["BTFloat"] != null && row["BTFloat"].ToString() != "")
{
model.BTFloat = decimal.Parse(row["BTFloat"].ToString());
}
if (row["TJFloat"] != null && row["TJFloat"].ToString() != "")
{
model.TJFloat = decimal.Parse(row["TJFloat"].ToString());
}
if (row["TXFloat"] != null && row["TXFloat"].ToString() != "")
{
model.TXFloat = decimal.Parse(row["TXFloat"].ToString());
}
if (row["TakeOffFloat"] != null && row["TakeOffFloat"].ToString() != "")
{
model.TakeOffFloat = decimal.Parse(row["TakeOffFloat"].ToString());
}
if (row["ReBuyFloat"] != null && row["ReBuyFloat"].ToString() != "")
{
model.ReBuyFloat = decimal.Parse(row["ReBuyFloat"].ToString());
}
if (row["MCWFloat"] != null && row["MCWFloat"].ToString() != "")
{
model.MCWFloat = decimal.Parse(row["MCWFloat"].ToString());
}
if (row["MColor"] != null)
{
model.MColor = row["MColor"].ToString();
}
if (row["ViewLevel"] != null && row["ViewLevel"].ToString() != "")
{
model.ViewLevel = int.Parse(row["ViewLevel"].ToString());
}
if (row["TJCount"] != null && row["TJCount"].ToString() != "")
{
model.TJCount = int.Parse(row["TJCount"].ToString());
}
if (row["YJMoney"] != null && row["YJMoney"].ToString() != "")
{
model.YJMoney = decimal.Parse(row["YJMoney"].ToString());
}
if (row["TeamCount"] != null && row["TeamCount"].ToString() != "")
{
model.TeamCount = int.Parse(row["TeamCount"].ToString());
}
if (row["teamPer"] != null && row["teamPer"].ToString() != "")
{
model.teamPer = decimal.Parse(row["teamPer"].ToString());
}
if (row["MinTeamMoney"] != null && row["MinTeamMoney"].ToString() != "")
{
model.MinTeamMoney = decimal.Parse(row["MinTeamMoney"].ToString());
}
if (row["SubCount"] != null && row["SubCount"].ToString() != "")
{
model.SubCount = int.Parse(row["SubCount"].ToString());
}
if (row["DPFloat"] != null && row["DPFloat"].ToString() != "")
{
model.DPFloat = decimal.Parse(row["DPFloat"].ToString());
}
if (row["DPTopMoney"] != null && row["DPTopMoney"].ToString() != "")
{
model.DPTopMoney = decimal.Parse(row["DPTopMoney"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected override string btnModify_Click()
{
//if (Check_SQ_Answer())
//{
sjmodel = TModel;
if (!string.IsNullOrEmpty(Request.Form["hdmid"]))
{
sjmodel = BllModel.GetModel(Request.Form["hdmid"]);
}
//if (!sjmodel.MState)
//{
// if (string.IsNullOrWhiteSpace(Request.Form["txtMBD"]))
// {
// return "接点人不能为空";
// }
//}
if (BLL.Configuration.Model.SHMoneyList.ContainsKey(Request.Form["AgencyTypeList"]))
{
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList[Request.Form["AgencyTypeList"]];
if (BLL.ChangeMoney.EnoughChange(TModel.MID, shmoney.Money - sjmodel.MAgencyType.Money, "MJB"))
{
try
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
return("升级处理中，请等待！");
}
else
{
BLL.Member.upmidlist.Add(sjmodel.MID);
}
var result = BllModel.UpMAgencyType(shmoney, Request.Form["hdmid"], "MJB", TModel, shmoney.Money - sjmodel.MConfig.SHMoney, Request.Form["txtMBD"]);
if (TModel.Role.IsAdmin)
{
BLL.OperationRecordBLL.Add(TModel.MID, ChangeType.O_SJHY, "升级会员");
}
return(result);
}
finally
{
if (BLL.Member.upmidlist.Contains(sjmodel.MID))
{
BLL.Member.upmidlist.Remove(sjmodel.MID);
}
}
}
else
{
return("您的" + BLL.Reward.List["MJB"].RewardName + "账户余额不足");
}
}
else
{
return("未知会员级别");
}
//}
//else
// return "密保问题错误*";
}
/// <summary>
/// 转换数据实体
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private static Model.SHMoney TranEntity(DataRow dr)
{
if (dr != null)
{
Model.SHMoney model = new Model.SHMoney();
model.MAgencyType = dr["MAgencyType"].ToString();
model.MColor = dr["MColor"].ToString();
if (!string.IsNullOrEmpty(dr["ViewLevel"].ToString()))
{
model.ViewLevel = int.Parse(dr["ViewLevel"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJCount"].ToString()))
{
model.TJCount = int.Parse(dr["TJCount"].ToString());
}
model.TJAgency = dr["TJAgency"].ToString();
if (!string.IsNullOrEmpty(dr["TemaCount"].ToString()))
{
model.TemaCount = int.Parse(dr["TemaCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["DTopMoney"].ToString()))
{
model.DTopMoney = decimal.Parse(dr["DTopMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["SQHelpCount"].ToString()))
{
model.SQHelpCount = int.Parse(dr["SQHelpCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["XYLastMemberCount"].ToString()))
{
model.XYLastMemberCount = int.Parse(dr["XYLastMemberCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["XFMouthMinHelpMoney"].ToString()))
{
model.XFMouthMinHelpMoney = decimal.Parse(dr["XFMouthMinHelpMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["XFMounthMoney"].ToString()))
{
model.XFMounthMoney = decimal.Parse(dr["XFMounthMoney"].ToString());
}
model.MAgencyName = dr["MAgencyName"].ToString();
if (!string.IsNullOrEmpty(dr["InitMaxTZ"].ToString()))
{
model.InitMaxTZ = int.Parse(dr["InitMaxTZ"].ToString());
}
if (!string.IsNullOrEmpty(dr["XYFloat"].ToString()))
{
model.XYFloat = decimal.Parse(dr["XYFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["Money"].ToString()))
{
model.Money = int.Parse(dr["Money"].ToString());
}
if (!string.IsNullOrEmpty(dr["BTFloat"].ToString()))
{
model.BTFloat = decimal.Parse(dr["BTFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJFloat"].ToString()))
{
model.TJFloat = decimal.Parse(dr["TJFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["TXFloat"].ToString()))
{
model.TXFloat = decimal.Parse(dr["TXFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["TakeOffFloat"].ToString()))
{
model.TakeOffFloat = decimal.Parse(dr["TakeOffFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["ReBuyFloat"].ToString()))
{
model.ReBuyFloat = decimal.Parse(dr["ReBuyFloat"].ToString());
}
if (!string.IsNullOrEmpty(dr["MCWFloat"].ToString()))
{
model.MCWFloat = decimal.Parse(dr["MCWFloat"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public static string UpMAgencyType(Model.SHMoney shmoney, string mid, string moneyType, Model.Member shmodel, decimal appendMoney, Hashtable MyHs)
{
Model.Member model = DAL.Member.GetModel(mid);
if (model == null)
{
return("升级会员不存在");
}
if (string.IsNullOrEmpty(model.MTJ))
{
return("请联系管理员设置您的推荐人");
}
decimal sjmoney = appendMoney;
lock (DAL.Member.tempMemberList)
{
DAL.Member.tempMemberList.Clear();
DAL.Member.tempMemberAdd(model);
DAL.Member._CPList.Clear();
if (!BLL.ChangeMoney.EnoughChange(shmodel.MID, sjmoney, moneyType))
{
return("您的" + BLL.Reward.List[moneyType].RewardName + "不足");
}
if (BLL.ChangeMoney.HBChangeTran(sjmoney, shmodel.MID, ManageMember.TModel.MID, "SH", model, moneyType, model.MAgencyType._MAgencyName + " -> " + shmoney._MAgencyName, MyHs) > 0)
{
model.MConfig.YJMoney += (int)sjmoney;
DAL.MemberConfig.UpdateConfigTran(model.MID, "YJMoney", sjmoney.ToString(), model, false, SqlDbType.Int, MyHs);
model.SHMoney += (int)sjmoney;
string PCode = "005";//升级
if (!model.MState)
{
string error = Validation2(model, shmoney);
if (!string.IsNullOrEmpty(error))
{
return(error);
}
PCode = "001";//激活升级
model.MConfig.YJCount += 1;
DAL.MemberConfig.UpdateConfigTran(model.MID, "YJCount", "1", model, false, SqlDbType.Int, MyHs);
model.MConfig.JTFHState = true;
DAL.MemberConfig.UpdateConfigTran(model.MID, "JTFHState", "1", model, true, SqlDbType.Bit, MyHs);
model.MConfig.DTFHState = true;
DAL.MemberConfig.UpdateConfigTran(model.MID, "DTFHState", "1", model, true, SqlDbType.Bit, MyHs);
model.MConfig.UpSumMoney += (int)sjmoney;
DAL.MemberConfig.UpdateConfigTran(model.MID, "UpSumMoney", sjmoney.ToString(), model, false, SqlDbType.Int, MyHs);
model.RoleCode = "Nomal";
model.Role = BLL.Roles.RolsList["Nomal"];
model.MDate = DateTime.Now;
model.MState = true;
model.FHState = false;
model.ValidTime = DateTime.Now;
}
if (shmoney != null)
{
// 二次升级的奖金按照升级之前的级别拿比例
model.AgencyCode = shmoney.MAgencyType;
model.MAgencyType = shmoney;
if (model.AgencyCode == "004")
{
model.RoleCode = "VIP";
}
}
DAL.Member.UpdateRole(model, MyHs);
Model.Accounts account = new Model.Accounts()
{
AccountsDate = DateTime.MaxValue,
ACode = model.MID + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"),
CreateDate = DateTime.Now,
IfAccount = false,
IsAuto = true,
PCode = PCode,
TotalFHMoney = 0,
FHCount = 0,
ARemark = model.MID
};
BLL.Accounts.BDInsert(account, MyHs);
if (DAL.CommonBase.RunHashtable(MyHs))
{
DAL.Member.tempMemberList.Clear(); //清空临时字典
DAL.BMember.tempBMemberList.Clear(); //清空临时字典
DAL.Member._CPList.Clear();
return("恭喜您升级成功，本次消耗" + sjmoney.ToString("F2"));
}
}
}
return("");
}
public string UpMAgencyTypeJZZ(Model.SHMoney shmoney, string mid, Model.Member shmodel, int appendMoney)
{
Hashtable MyHs = new Hashtable();
Model.Member model = DAL.Member.GetModel(mid);
string agencyCode = model.AgencyCode;
if (model == null)
{
return("升级会员不存在");
}
if (string.IsNullOrEmpty(model.MTJ))
{
return("请联系管理员设置您的推荐人");
}
int sjmoney = shmoney.Money - model.MAgencyType.Money;
lock (DAL.Member.tempMemberList)
{
//DAL.Member.tempMemberList.Clear();
//DAL.Member.tempMemberAdd(model);
//if (!BLL.ChangeMoney.EnoughChange(shmodel.MID, BLL.Configuration.Model.JTFHMoney, "MCW"))
// return "您的金种子积分不足，不能激活金种子会员";
//if (BLL.ChangeMoney.HBChangeTran(BLL.Configuration.Model.JTFHMoney, shmodel.MID, ManageMember.TModel.MID, "SH", model, "MCW", model.MAgencyType.MAgencyName + "->" + shmoney.MAgencyName, MyHs) > 0)
//{
// model.MConfig.YJMoney += sjmoney;
// DAL.MemberConfig.UpdateConfigTran(model.MID, "YJMoney", sjmoney.ToString(), model, false, SqlDbType.Int, MyHs);
// model.SHMoney += sjmoney;
// string PCode = "005";//升级
// if (!model.MState)
// {
// PCode = "001";//激活升级
// model.MSH = shmodel.MID;
// string error = Validation2(model);
// if (!string.IsNullOrEmpty(error))
// {
// return error;
// }
// model.MConfig.YJCount += 1;
// DAL.MemberConfig.UpdateConfigTran(model.MID, "YJCount", "1", model, false, SqlDbType.Int, MyHs);
// model.MConfig.JTFHState = true;
// DAL.MemberConfig.UpdateConfigTran(model.MID, "JTFHState", "1", model, true, SqlDbType.Bit, MyHs);
// model.MConfig.DTFHState = false;
// DAL.MemberConfig.UpdateConfigTran(model.MID, "DTFHState", "0", model, true, SqlDbType.Bit, MyHs);
// model.MConfig.UpSumMoney += 1;
// DAL.MemberConfig.UpdateConfigTran(model.MID, "UpSumMoney", "1", model, false, SqlDbType.Int, MyHs);
// model.RoleCode = "Nomal";
// model.Role = BLL.Roles.RolsList["Nomal"];
// model.MDate = DateTime.Now;
// model.MState = true;
// model.FHState = true;
// model.ValidTime = DateTime.Now;
// }
// // 二次升级的奖金按照升级之前的级别拿比例
// model.AgencyCode = shmoney.MAgencyType;
// model.MAgencyType = shmoney;
// model.MSH = shmodel.MID;
// DAL.Member.UpdateRole(model, MyHs);
// Model.Accounts account = new Model.Accounts()
// {
// AccountsDate = DateTime.MaxValue,
// ACode = model.MID + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"),
// CreateDate = DateTime.Now,
// IfAccount = false,
// IsAuto = true,
// PCode = PCode,
// TotalFHMoney = 0,
// FHCount = 0,
// ARemark = model.MID
// };
// if (model.MSH != shmodel.MID)
// account.ID = -1;
// BLL.Accounts.BDInsert(account, MyHs, false);
// if (DAL.CommonBase.RunHashtable(MyHs))
// {
// DAL.Member.tempMemberList.Clear();//清空临时字典
// return "恭喜您成功升级至" + shmoney.MAgencyName + "，本次消耗" + sjmoney;
// }
//}
}
return("升级失败");
}