/// <summary>
/// 实体转换
/// <summary>
private static Model.MMMConfig TranEntity(DataRow row)
{
if (row != null)
{
Model.MMMConfig model = new Model.MMMConfig();
if (row["ActiveCodePrice"] != null && row["ActiveCodePrice"].ToString() != "")
{
model.ActiveCodePrice = decimal.Parse(row["ActiveCodePrice"].ToString());
}
if (row["MCWPrice"] != null && row["MCWPrice"].ToString() != "")
{
model.MCWPrice = decimal.Parse(row["MCWPrice"].ToString());
}
if (row["MOfferNeedMCW"] != null && row["MOfferNeedMCW"].ToString() != "")
{
model.MOfferNeedMCW = decimal.Parse(row["MOfferNeedMCW"].ToString());
}
if (row["OfferHelpMin"] != null && row["OfferHelpMin"].ToString() != "")
{
model.OfferHelpMin = decimal.Parse(row["OfferHelpMin"].ToString());
}
if (row["OfferHelpMax"] != null && row["OfferHelpMax"].ToString() != "")
{
model.OfferHelpMax = decimal.Parse(row["OfferHelpMax"].ToString());
}
if (row["OfferHelpBase"] != null && row["OfferHelpBase"].ToString() != "")
{
model.OfferHelpBase = decimal.Parse(row["OfferHelpBase"].ToString());
}
if (row["OfferHelpRangeTimes"] != null && row["OfferHelpRangeTimes"].ToString() != "")
{
model.OfferHelpRangeTimes = int.Parse(row["OfferHelpRangeTimes"].ToString());
}
if (row["OfferHelpRangeCount"] != null && row["OfferHelpRangeCount"].ToString() != "")
{
model.OfferHelpRangeCount = int.Parse(row["OfferHelpRangeCount"].ToString());
}
if (row["OfferHelpNeedComplete"] != null && row["OfferHelpNeedComplete"].ToString() != "")
{
if ((row["OfferHelpNeedComplete"].ToString() == "1") || (row["OfferHelpNeedComplete"].ToString().ToLower() == "true"))
{
model.OfferHelpNeedComplete = true;
}
else
{
model.OfferHelpNeedComplete = false;
}
}
if (row["OfferHelpDayTotalMoney"] != null && row["OfferHelpDayTotalMoney"].ToString() != "")
{
model.OfferHelpDayTotalMoney = decimal.Parse(row["OfferHelpDayTotalMoney"].ToString());
}
if (row["OfferHelpTimes"] != null)
{
model.OfferHelpTimes = row["OfferHelpTimes"].ToString();
}
if (row["OfferHelpSwitch"] != null && row["OfferHelpSwitch"].ToString() != "")
{
if ((row["OfferHelpSwitch"].ToString() == "1") || (row["OfferHelpSwitch"].ToString().ToLower() == "true"))
{
model.OfferHelpSwitch = true;
}
else
{
model.OfferHelpSwitch = false;
}
}
if (row["GetHelpMin"] != null && row["GetHelpMin"].ToString() != "")
{
model.GetHelpMin = decimal.Parse(row["GetHelpMin"].ToString());
}
if (row["GetHelpMax"] != null && row["GetHelpMax"].ToString() != "")
{
model.GetHelpMax = decimal.Parse(row["GetHelpMax"].ToString());
}
if (row["GetHelpBase"] != null && row["GetHelpBase"].ToString() != "")
{
model.GetHelpBase = decimal.Parse(row["GetHelpBase"].ToString());
}
if (row["GetHelpRangeTimes"] != null && row["GetHelpRangeTimes"].ToString() != "")
{
model.GetHelpRangeTimes = int.Parse(row["GetHelpRangeTimes"].ToString());
}
if (row["GetHelpRangeCount"] != null && row["GetHelpRangeCount"].ToString() != "")
{
model.GetHelpRangeCount = int.Parse(row["GetHelpRangeCount"].ToString());
}
if (row["GetHelpNeedComplete"] != null && row["GetHelpNeedComplete"].ToString() != "")
{
if ((row["GetHelpNeedComplete"].ToString() == "1") || (row["GetHelpNeedComplete"].ToString().ToLower() == "true"))
{
model.GetHelpNeedComplete = true;
}
else
{
model.GetHelpNeedComplete = false;
}
}
if (row["GetHelpDayTotalMoney"] != null && row["GetHelpDayTotalMoney"].ToString() != "")
{
model.GetHelpDayTotalMoney = decimal.Parse(row["GetHelpDayTotalMoney"].ToString());
}
if (row["GetHelpTimes"] != null)
{
model.GetHelpTimes = row["GetHelpTimes"].ToString();
}
if (row["GetHelpSwitch"] != null && row["GetHelpSwitch"].ToString() != "")
{
if ((row["GetHelpSwitch"].ToString() == "1") || (row["GetHelpSwitch"].ToString().ToLower() == "true"))
{
model.GetHelpSwitch = true;
}
else
{
model.GetHelpSwitch = false;
}
}
if (row["LineTimes"] != null && row["LineTimes"].ToString() != "")
{
model.LineTimes = int.Parse(row["LineTimes"].ToString());
}
if (row["FreezeTimes"] != null && row["FreezeTimes"].ToString() != "")
{
model.FreezeTimes = int.Parse(row["FreezeTimes"].ToString());
}
if (row["OutTimes"] != null && row["OutTimes"].ToString() != "")
{
model.OutTimes = int.Parse(row["OutTimes"].ToString());
}
if (row["InterestPer"] != null && row["InterestPer"].ToString() != "")
{
model.InterestPer = decimal.Parse(row["InterestPer"].ToString());
}
if (row["LiXi1"] != null && row["LiXi1"].ToString() != "")
{
model.LiXi1 = decimal.Parse(row["LiXi1"].ToString());
}
if (row["LiXi2"] != null && row["LiXi2"].ToString() != "")
{
model.LiXi2 = decimal.Parse(row["LiXi2"].ToString());
}
if (row["PayLimitTimes"] != null && row["PayLimitTimes"].ToString() != "")
{
model.PayLimitTimes = int.Parse(row["PayLimitTimes"].ToString());
}
if (row["ConfirmLimitTimes"] != null && row["ConfirmLimitTimes"].ToString() != "")
{
model.ConfirmLimitTimes = int.Parse(row["ConfirmLimitTimes"].ToString());
}
if (row["OfferHelpFloat"] != null && row["OfferHelpFloat"].ToString() != "")
{
model.OfferHelpFloat = decimal.Parse(row["OfferHelpFloat"].ToString());
}
if (row["GetHelpFloat"] != null && row["GetHelpFloat"].ToString() != "")
{
model.GetHelpFloat = decimal.Parse(row["GetHelpFloat"].ToString());
}
if (row["NoLineTimesMoneyFloat"] != null && row["NoLineTimesMoneyFloat"].ToString() != "")
{
model.NoLineTimesMoneyFloat = decimal.Parse(row["NoLineTimesMoneyFloat"].ToString());
}
if (row["HonestTimes"] != null && row["HonestTimes"].ToString() != "")
{
model.HonestTimes = int.Parse(row["HonestTimes"].ToString());
}
if (row["HonestFloat"] != null && row["HonestFloat"].ToString() != "")
{
model.HonestFloat = decimal.Parse(row["HonestFloat"].ToString());
}
if (row["PayLimitTimesPre"] != null && row["PayLimitTimesPre"].ToString() != "")
{
model.PayLimitTimesPre = int.Parse(row["PayLimitTimesPre"].ToString());
}
if (row["ConfirmLimitTimesPre"] != null && row["ConfirmLimitTimesPre"].ToString() != "")
{
model.ConfirmLimitTimesPre = int.Parse(row["ConfirmLimitTimesPre"].ToString());
}
if (row["LastProportion"] != null && row["LastProportion"].ToString() != "")
{
model.LastProportion = decimal.Parse(row["LastProportion"].ToString());
}
if (row["OfferTJKF"] != null && row["OfferTJKF"].ToString() != "")
{
model.OfferTJKF = decimal.Parse(row["OfferTJKF"].ToString());
}
if (row["GetTJKF"] != null && row["GetTJKF"].ToString() != "")
{
model.GetTJKF = decimal.Parse(row["GetTJKF"].ToString());
}
if (row["ReleasePer"] != null && row["ReleasePer"].ToString() != "")
{
model.ReleasePer = decimal.Parse(row["ReleasePer"].ToString());
}
if (row["ReleaseConditionCount"] != null && row["ReleaseConditionCount"].ToString() != "")
{
model.ReleaseConditionCount = int.Parse(row["ReleaseConditionCount"].ToString());
}
if (row["GLRewardFreezeTimes"] != null && row["GLRewardFreezeTimes"].ToString() != "")
{
model.GLRewardFreezeTimes = int.Parse(row["GLRewardFreezeTimes"].ToString());
}
if (row["MacthTimesRange"] != null)
{
model.MacthTimesRange = row["MacthTimesRange"].ToString();
}
if (row["MacthSwitch"] != null && row["MacthSwitch"].ToString() != "")
{
if ((row["MacthSwitch"].ToString() == "1") || (row["MacthSwitch"].ToString().ToLower() == "true"))
{
model.MacthSwitch = true;
}
else
{
model.MacthSwitch = false;
}
}
if (row["MHBBase"] != null && row["MHBBase"].ToString() != "")
{
model.MHBBase = int.Parse(row["MHBBase"].ToString());
}
if (row["MHBRangeTimes"] != null && row["MHBRangeTimes"].ToString() != "")
{
model.MHBRangeTimes = int.Parse(row["MHBRangeTimes"].ToString());
}
if (row["MCWBase"] != null && row["MCWBase"].ToString() != "")
{
model.MCWBase = int.Parse(row["MCWBase"].ToString());
}
if (row["MCWRangeTimes"] != null && row["MCWRangeTimes"].ToString() != "")
{
model.MCWRangeTimes = int.Parse(row["MCWRangeTimes"].ToString());
}
if (row["MJBBase"] != null && row["MJBBase"].ToString() != "")
{
model.MJBBase = int.Parse(row["MJBBase"].ToString());
}
if (row["MJBRangeTimes"] != null && row["MJBRangeTimes"].ToString() != "")
{
model.MJBRangeTimes = int.Parse(row["MJBRangeTimes"].ToString());
}
if (row["FreezeTimesOfRegister"] != null && row["FreezeTimesOfRegister"].ToString() != "")
{
model.FreezeTimesOfRegister = int.Parse(row["FreezeTimesOfRegister"].ToString());
}
if (row["FreezeTimesOfOffer"] != null && row["FreezeTimesOfOffer"].ToString() != "")
{
model.FreezeTimesOfOffer = int.Parse(row["FreezeTimesOfOffer"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(Model.MMMConfig model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MMMConfig(");
strSql.Append("ActiveCodePrice,MCWPrice,MOfferNeedMCW,OfferHelpMin,OfferHelpMax,OfferHelpBase,OfferHelpRangeTimes,OfferHelpRangeCount,OfferHelpNeedComplete,OfferHelpDayTotalMoney,OfferHelpTimes,OfferHelpSwitch,GetHelpMin,GetHelpMax,GetHelpBase,GetHelpRangeTimes,GetHelpRangeCount,GetHelpNeedComplete,GetHelpDayTotalMoney,GetHelpTimes,GetHelpSwitch,LineTimes,FreezeTimes,OutTimes,InterestPer,LiXi1,LiXi2,PayLimitTimes,ConfirmLimitTimes,OfferHelpFloat,GetHelpFloat,NoLineTimesMoneyFloat,HonestTimes,HonestFloat,PayLimitTimesPre,ConfirmLimitTimesPre,LastProportion,OfferTJKF,GetTJKF,ReleasePer,ReleaseConditionCount,GLRewardFreezeTimes,MacthTimesRange,MacthSwitch,MHBBase,MHBRangeTimes,MCWBase,MCWRangeTimes,MJBBase,MJBRangeTimes,FreezeTimesOfRegister,FreezeTimesOfOffer)");
strSql.Append(" values (");
strSql.Append("@ActiveCodePrice,@MCWPrice,@MOfferNeedMCW,@OfferHelpMin,@OfferHelpMax,@OfferHelpBase,@OfferHelpRangeTimes,@OfferHelpRangeCount,@OfferHelpNeedComplete,@OfferHelpDayTotalMoney,@OfferHelpTimes,@OfferHelpSwitch,@GetHelpMin,@GetHelpMax,@GetHelpBase,@GetHelpRangeTimes,@GetHelpRangeCount,@GetHelpNeedComplete,@GetHelpDayTotalMoney,@GetHelpTimes,@GetHelpSwitch,@LineTimes,@FreezeTimes,@OutTimes,@InterestPer,@LiXi1,@LiXi2,@PayLimitTimes,@ConfirmLimitTimes,@OfferHelpFloat,@GetHelpFloat,@NoLineTimesMoneyFloat,@HonestTimes,@HonestFloat,@PayLimitTimesPre,@ConfirmLimitTimesPre,@LastProportion,@OfferTJKF,@GetTJKF,@ReleasePer,@ReleaseConditionCount,@GLRewardFreezeTimes,@MacthTimesRange,@MacthSwitch,@MHBBase,@MHBRangeTimes,@MCWBase,@MCWRangeTimes,@MJBBase,@MJBRangeTimes,@FreezeTimesOfRegister,@FreezeTimesOfOffer)");
SqlParameter[] parameters =
{
new SqlParameter("@ActiveCodePrice", SqlDbType.Decimal, 9),
new SqlParameter("@MCWPrice", SqlDbType.Decimal, 9),
new SqlParameter("@MOfferNeedMCW", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpMin", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpMax", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpBase", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpRangeCount", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpNeedComplete", SqlDbType.Bit, 1),
new SqlParameter("@OfferHelpDayTotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpTimes", SqlDbType.VarChar, 100),
new SqlParameter("@OfferHelpSwitch", SqlDbType.Bit, 1),
new SqlParameter("@GetHelpMin", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpMax", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpBase", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@GetHelpRangeCount", SqlDbType.Int, 4),
new SqlParameter("@GetHelpNeedComplete", SqlDbType.Bit, 1),
new SqlParameter("@GetHelpDayTotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpTimes", SqlDbType.VarChar, 100),
new SqlParameter("@GetHelpSwitch", SqlDbType.Bit, 1),
new SqlParameter("@LineTimes", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimes", SqlDbType.Int, 4),
new SqlParameter("@OutTimes", SqlDbType.Int, 4),
new SqlParameter("@InterestPer", SqlDbType.Decimal, 9),
new SqlParameter("@LiXi1", SqlDbType.Decimal, 9),
new SqlParameter("@LiXi2", SqlDbType.Decimal, 9),
new SqlParameter("@PayLimitTimes", SqlDbType.Int, 4),
new SqlParameter("@ConfirmLimitTimes", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpFloat", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpFloat", SqlDbType.Decimal, 9),
new SqlParameter("@NoLineTimesMoneyFloat", SqlDbType.Decimal, 9),
new SqlParameter("@HonestTimes", SqlDbType.Int, 4),
new SqlParameter("@HonestFloat", SqlDbType.Decimal, 9),
new SqlParameter("@PayLimitTimesPre", SqlDbType.Int, 4),
new SqlParameter("@ConfirmLimitTimesPre", SqlDbType.Int, 4),
new SqlParameter("@LastProportion", SqlDbType.Decimal, 9),
new SqlParameter("@OfferTJKF", SqlDbType.Decimal, 9),
new SqlParameter("@GetTJKF", SqlDbType.Decimal, 9),
new SqlParameter("@ReleasePer", SqlDbType.Decimal, 9),
new SqlParameter("@ReleaseConditionCount", SqlDbType.Int, 4),
new SqlParameter("@GLRewardFreezeTimes", SqlDbType.Int, 4),
new SqlParameter("@MacthTimesRange", SqlDbType.VarChar, 100),
new SqlParameter("@MacthSwitch", SqlDbType.Bit, 1),
new SqlParameter("@MHBBase", SqlDbType.Int, 4),
new SqlParameter("@MHBRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@MCWBase", SqlDbType.Int, 4),
new SqlParameter("@MCWRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@MJBBase", SqlDbType.Int, 4),
new SqlParameter("@MJBRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimesOfRegister", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimesOfOffer", SqlDbType.Int, 4)
};
parameters[0].Value = model.ActiveCodePrice;
parameters[1].Value = model.MCWPrice;
parameters[2].Value = model.MOfferNeedMCW;
parameters[3].Value = model.OfferHelpMin;
parameters[4].Value = model.OfferHelpMax;
parameters[5].Value = model.OfferHelpBase;
parameters[6].Value = model.OfferHelpRangeTimes;
parameters[7].Value = model.OfferHelpRangeCount;
parameters[8].Value = model.OfferHelpNeedComplete;
parameters[9].Value = model.OfferHelpDayTotalMoney;
parameters[10].Value = model.OfferHelpTimes;
parameters[11].Value = model.OfferHelpSwitch;
parameters[12].Value = model.GetHelpMin;
parameters[13].Value = model.GetHelpMax;
parameters[14].Value = model.GetHelpBase;
parameters[15].Value = model.GetHelpRangeTimes;
parameters[16].Value = model.GetHelpRangeCount;
parameters[17].Value = model.GetHelpNeedComplete;
parameters[18].Value = model.GetHelpDayTotalMoney;
parameters[19].Value = model.GetHelpTimes;
parameters[20].Value = model.GetHelpSwitch;
parameters[21].Value = model.LineTimes;
parameters[22].Value = model.FreezeTimes;
parameters[23].Value = model.OutTimes;
parameters[24].Value = model.InterestPer;
parameters[25].Value = model.LiXi1;
parameters[26].Value = model.LiXi2;
parameters[27].Value = model.PayLimitTimes;
parameters[28].Value = model.ConfirmLimitTimes;
parameters[29].Value = model.OfferHelpFloat;
parameters[30].Value = model.GetHelpFloat;
parameters[31].Value = model.NoLineTimesMoneyFloat;
parameters[32].Value = model.HonestTimes;
parameters[33].Value = model.HonestFloat;
parameters[34].Value = model.PayLimitTimesPre;
parameters[35].Value = model.ConfirmLimitTimesPre;
parameters[36].Value = model.LastProportion;
parameters[37].Value = model.OfferTJKF;
parameters[38].Value = model.GetTJKF;
parameters[39].Value = model.ReleasePer;
parameters[40].Value = model.ReleaseConditionCount;
parameters[41].Value = model.GLRewardFreezeTimes;
parameters[42].Value = model.MacthTimesRange;
parameters[43].Value = model.MacthSwitch;
parameters[44].Value = model.MHBBase;
parameters[45].Value = model.MHBRangeTimes;
parameters[46].Value = model.MCWBase;
parameters[47].Value = model.MCWRangeTimes;
parameters[48].Value = model.MJBBase;
parameters[49].Value = model.MJBRangeTimes;
parameters[50].Value = model.FreezeTimesOfRegister;
parameters[51].Value = model.FreezeTimesOfOffer;
string guid = Guid.NewGuid().ToString();
strSql.AppendFormat(";select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(Model.MMMConfig model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MMMConfig set ");
strSql.Append("ActiveCodePrice=@ActiveCodePrice,");
strSql.Append("MCWPrice=@MCWPrice,");
strSql.Append("MOfferNeedMCW=@MOfferNeedMCW,");
strSql.Append("OfferHelpMin=@OfferHelpMin,");
strSql.Append("OfferHelpMax=@OfferHelpMax,");
strSql.Append("OfferHelpBase=@OfferHelpBase,");
strSql.Append("OfferHelpRangeTimes=@OfferHelpRangeTimes,");
strSql.Append("OfferHelpRangeCount=@OfferHelpRangeCount,");
strSql.Append("OfferHelpNeedComplete=@OfferHelpNeedComplete,");
strSql.Append("OfferHelpDayTotalMoney=@OfferHelpDayTotalMoney,");
strSql.Append("OfferHelpTimes=@OfferHelpTimes,");
strSql.Append("OfferHelpSwitch=@OfferHelpSwitch,");
strSql.Append("GetHelpMin=@GetHelpMin,");
strSql.Append("GetHelpMax=@GetHelpMax,");
strSql.Append("GetHelpBase=@GetHelpBase,");
strSql.Append("GetHelpRangeTimes=@GetHelpRangeTimes,");
strSql.Append("GetHelpRangeCount=@GetHelpRangeCount,");
strSql.Append("GetHelpNeedComplete=@GetHelpNeedComplete,");
strSql.Append("GetHelpDayTotalMoney=@GetHelpDayTotalMoney,");
strSql.Append("GetHelpTimes=@GetHelpTimes,");
strSql.Append("GetHelpSwitch=@GetHelpSwitch,");
strSql.Append("LineTimes=@LineTimes,");
strSql.Append("FreezeTimes=@FreezeTimes,");
strSql.Append("OutTimes=@OutTimes,");
strSql.Append("InterestPer=@InterestPer,");
strSql.Append("LiXi1=@LiXi1,");
strSql.Append("LiXi2=@LiXi2,");
strSql.Append("PayLimitTimes=@PayLimitTimes,");
strSql.Append("ConfirmLimitTimes=@ConfirmLimitTimes,");
strSql.Append("OfferHelpFloat=@OfferHelpFloat,");
strSql.Append("GetHelpFloat=@GetHelpFloat,");
strSql.Append("NoLineTimesMoneyFloat=@NoLineTimesMoneyFloat,");
strSql.Append("HonestTimes=@HonestTimes,");
strSql.Append("HonestFloat=@HonestFloat,");
strSql.Append("PayLimitTimesPre=@PayLimitTimesPre,");
strSql.Append("ConfirmLimitTimesPre=@ConfirmLimitTimesPre,");
strSql.Append("LastProportion=@LastProportion,");
strSql.Append("OfferTJKF=@OfferTJKF,");
strSql.Append("GetTJKF=@GetTJKF,");
strSql.Append("ReleasePer=@ReleasePer,");
strSql.Append("ReleaseConditionCount=@ReleaseConditionCount,");
strSql.Append("GLRewardFreezeTimes=@GLRewardFreezeTimes,");
strSql.Append("MacthTimesRange=@MacthTimesRange,");
strSql.Append("MacthSwitch=@MacthSwitch,");
strSql.Append("MHBBase=@MHBBase,");
strSql.Append("MHBRangeTimes=@MHBRangeTimes,");
strSql.Append("MCWBase=@MCWBase,");
strSql.Append("MCWRangeTimes=@MCWRangeTimes,");
strSql.Append("MJBBase=@MJBBase,");
strSql.Append("MJBRangeTimes=@MJBRangeTimes,");
strSql.Append("FreezeTimesOfRegister=@FreezeTimesOfRegister,");
strSql.Append("FreezeTimesOfOffer=@FreezeTimesOfOffer");
SqlParameter[] parameters =
{
new SqlParameter("@ActiveCodePrice", SqlDbType.Decimal, 9),
new SqlParameter("@MCWPrice", SqlDbType.Decimal, 9),
new SqlParameter("@MOfferNeedMCW", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpMin", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpMax", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpBase", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpRangeCount", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpNeedComplete", SqlDbType.Bit, 1),
new SqlParameter("@OfferHelpDayTotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OfferHelpTimes", SqlDbType.VarChar, 100),
new SqlParameter("@OfferHelpSwitch", SqlDbType.Bit, 1),
new SqlParameter("@GetHelpMin", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpMax", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpBase", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@GetHelpRangeCount", SqlDbType.Int, 4),
new SqlParameter("@GetHelpNeedComplete", SqlDbType.Bit, 1),
new SqlParameter("@GetHelpDayTotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpTimes", SqlDbType.VarChar, 100),
new SqlParameter("@GetHelpSwitch", SqlDbType.Bit, 1),
new SqlParameter("@LineTimes", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimes", SqlDbType.Int, 4),
new SqlParameter("@OutTimes", SqlDbType.Int, 4),
new SqlParameter("@InterestPer", SqlDbType.Decimal, 9),
new SqlParameter("@LiXi1", SqlDbType.Decimal, 9),
new SqlParameter("@LiXi2", SqlDbType.Decimal, 9),
new SqlParameter("@PayLimitTimes", SqlDbType.Int, 4),
new SqlParameter("@ConfirmLimitTimes", SqlDbType.Int, 4),
new SqlParameter("@OfferHelpFloat", SqlDbType.Decimal, 9),
new SqlParameter("@GetHelpFloat", SqlDbType.Decimal, 9),
new SqlParameter("@NoLineTimesMoneyFloat", SqlDbType.Decimal, 9),
new SqlParameter("@HonestTimes", SqlDbType.Int, 4),
new SqlParameter("@HonestFloat", SqlDbType.Decimal, 9),
new SqlParameter("@PayLimitTimesPre", SqlDbType.Int, 4),
new SqlParameter("@ConfirmLimitTimesPre", SqlDbType.Int, 4),
new SqlParameter("@LastProportion", SqlDbType.Decimal, 9),
new SqlParameter("@OfferTJKF", SqlDbType.Decimal, 9),
new SqlParameter("@GetTJKF", SqlDbType.Decimal, 9),
new SqlParameter("@ReleasePer", SqlDbType.Decimal, 9),
new SqlParameter("@ReleaseConditionCount", SqlDbType.Int, 4),
new SqlParameter("@GLRewardFreezeTimes", SqlDbType.Int, 4),
new SqlParameter("@MacthTimesRange", SqlDbType.VarChar, 100),
new SqlParameter("@MacthSwitch", SqlDbType.Bit, 1),
new SqlParameter("@MHBBase", SqlDbType.Int, 4),
new SqlParameter("@MHBRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@MCWBase", SqlDbType.Int, 4),
new SqlParameter("@MCWRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@MJBBase", SqlDbType.Int, 4),
new SqlParameter("@MJBRangeTimes", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimesOfRegister", SqlDbType.Int, 4),
new SqlParameter("@FreezeTimesOfOffer", SqlDbType.Int, 4)
};
parameters[0].Value = model.ActiveCodePrice;
parameters[1].Value = model.MCWPrice;
parameters[2].Value = model.MOfferNeedMCW;
parameters[3].Value = model.OfferHelpMin;
parameters[4].Value = model.OfferHelpMax;
parameters[5].Value = model.OfferHelpBase;
parameters[6].Value = model.OfferHelpRangeTimes;
parameters[7].Value = model.OfferHelpRangeCount;
parameters[8].Value = model.OfferHelpNeedComplete;
parameters[9].Value = model.OfferHelpDayTotalMoney;
parameters[10].Value = model.OfferHelpTimes;
parameters[11].Value = model.OfferHelpSwitch;
parameters[12].Value = model.GetHelpMin;
parameters[13].Value = model.GetHelpMax;
parameters[14].Value = model.GetHelpBase;
parameters[15].Value = model.GetHelpRangeTimes;
parameters[16].Value = model.GetHelpRangeCount;
parameters[17].Value = model.GetHelpNeedComplete;
parameters[18].Value = model.GetHelpDayTotalMoney;
parameters[19].Value = model.GetHelpTimes;
parameters[20].Value = model.GetHelpSwitch;
parameters[21].Value = model.LineTimes;
parameters[22].Value = model.FreezeTimes;
parameters[23].Value = model.OutTimes;
parameters[24].Value = model.InterestPer;
parameters[25].Value = model.LiXi1;
parameters[26].Value = model.LiXi2;
parameters[27].Value = model.PayLimitTimes;
parameters[28].Value = model.ConfirmLimitTimes;
parameters[29].Value = model.OfferHelpFloat;
parameters[30].Value = model.GetHelpFloat;
parameters[31].Value = model.NoLineTimesMoneyFloat;
parameters[32].Value = model.HonestTimes;
parameters[33].Value = model.HonestFloat;
parameters[34].Value = model.PayLimitTimesPre;
parameters[35].Value = model.ConfirmLimitTimesPre;
parameters[36].Value = model.LastProportion;
parameters[37].Value = model.OfferTJKF;
parameters[38].Value = model.GetTJKF;
parameters[39].Value = model.ReleasePer;
parameters[40].Value = model.ReleaseConditionCount;
parameters[41].Value = model.GLRewardFreezeTimes;
parameters[42].Value = model.MacthTimesRange;
parameters[43].Value = model.MacthSwitch;
parameters[44].Value = model.MHBBase;
parameters[45].Value = model.MHBRangeTimes;
parameters[46].Value = model.MCWBase;
parameters[47].Value = model.MCWRangeTimes;
parameters[48].Value = model.MJBBase;
parameters[49].Value = model.MJBRangeTimes;
parameters[50].Value = model.FreezeTimesOfRegister;
parameters[51].Value = model.FreezeTimesOfOffer;
string guid = Guid.NewGuid().ToString();
strSql.AppendFormat(" ;select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
DAL.MMMConfig.TModel = null;
return(MyHs);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Model.MMMConfig model)
{
return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable())));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Insert(Model.MMMConfig model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable())));
}
public static bool Update(Model.MMMConfig model)
{
return(WE_Project.DAL.MMMConfig.Update(model));
}
public static Hashtable Update(Model.MMMConfig model, Hashtable MyHs)
{
return(WE_Project.DAL.MMMConfig.Update(model, MyHs));
}
public static bool Insert(Model.MMMConfig model)
{
return(WE_Project.DAL.MMMConfig.Insert(model));
}
public static Hashtable Insert(Model.MMMConfig model, Hashtable MyHs)
{
return(WE_Project.DAL.MMMConfig.Insert(model, MyHs));
}
