public static Hashtable Insert(Model.MemberConfig model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberConfig(");
strSql.Append("MID,TakeOffMoney,ReBuyMoney,TotalTXMoney,JJTypeList,MHB,MJB,MCW,MGP,DTFHState,JTFHState,SHMoney,TotalDFHMoney,TotalZFHMoney,TotalYFHMoney,StockCount,TotalFHCount,TXStatus,ZZStatus,YJCount,EPTimeOutCount,EPXingCount,FDTrade,TJLDLevel,ReadNoticeID,GLMoneyDate,GLMoney,YJMoney,TJCount,TJMoney,UpSumMoney,TotalMoney,RealMoney,TotalLDMoney,OfferQuota,SQCount,TotalHLMoney,HLMoneyState,PPLeavel,NomalTotalThaw,VIPTotalThaw,MJBF");
strSql.Append(") values (");
strSql.Append("@MID,@TakeOffMoney,@ReBuyMoney,@TotalTXMoney,@JJTypeList,@MHB,@MJB,@MCW,@MGP,@DTFHState,@JTFHState,@SHMoney,@TotalDFHMoney,@TotalZFHMoney,@TotalYFHMoney,@StockCount,@TotalFHCount,@TXStatus,@ZZStatus,@YJCount,@EPTimeOutCount,@EPXingCount,@FDTrade,@TJLDLevel,@ReadNoticeID,@GLMoneyDate,@GLMoney,@YJMoney,@TJCount,@TJMoney,@UpSumMoney,@TotalMoney,@RealMoney,@TotalLDMoney,@OfferQuota,@SQCount,@TotalHLMoney,@HLMoneyState,@PPLeavel,@NomalTotalThaw,@VIPTotalThaw,@MJBF");
strSql.Append(") ");
strSql.AppendFormat(";select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalTXMoney", SqlDbType.Decimal, 9),
new SqlParameter("@JJTypeList", SqlDbType.VarChar, 300),
new SqlParameter("@MHB", SqlDbType.Decimal, 9),
new SqlParameter("@MJB", SqlDbType.Decimal, 9),
new SqlParameter("@MCW", SqlDbType.Decimal, 9),
new SqlParameter("@MGP", SqlDbType.Decimal, 9),
new SqlParameter("@DTFHState", SqlDbType.Bit, 1),
new SqlParameter("@JTFHState", SqlDbType.Bit, 1),
new SqlParameter("@SHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalDFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalZFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalYFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@StockCount", SqlDbType.Int, 4),
new SqlParameter("@TotalFHCount", SqlDbType.Int, 4),
new SqlParameter("@TXStatus", SqlDbType.Bit, 1),
new SqlParameter("@ZZStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Int, 4),
new SqlParameter("@EPTimeOutCount", SqlDbType.Int, 4),
new SqlParameter("@EPXingCount", SqlDbType.Int, 4),
new SqlParameter("@FDTrade", SqlDbType.VarChar, 30),
new SqlParameter("@TJLDLevel", SqlDbType.Int, 4),
new SqlParameter("@ReadNoticeID", SqlDbType.Int, 4),
new SqlParameter("@GLMoneyDate", SqlDbType.DateTime),
new SqlParameter("@GLMoney", SqlDbType.Decimal, 9),
new SqlParameter("@YJMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@TJMoney", SqlDbType.Decimal, 9),
new SqlParameter("@UpSumMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RealMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalLDMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OfferQuota", SqlDbType.Decimal, 9),
new SqlParameter("@SQCount", SqlDbType.Int, 4),
new SqlParameter("@TotalHLMoney", SqlDbType.Decimal, 9),
new SqlParameter("@HLMoneyState", SqlDbType.Bit, 1),
new SqlParameter("@PPLeavel", SqlDbType.Int, 4),
new SqlParameter("@NomalTotalThaw", SqlDbType.Decimal, 9),
new SqlParameter("@VIPTotalThaw", SqlDbType.Decimal, 9),
new SqlParameter("@MJBF", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TakeOffMoney;
parameters[2].Value = model.ReBuyMoney;
parameters[3].Value = model.TotalTXMoney;
parameters[4].Value = model.JJTypeList;
parameters[5].Value = model.MHB;
parameters[6].Value = model.MJB;
parameters[7].Value = model.MCW;
parameters[8].Value = model.MGP;
parameters[9].Value = model.DTFHState;
parameters[10].Value = model.JTFHState;
parameters[11].Value = model.SHMoney;
parameters[12].Value = model.TotalDFHMoney;
parameters[13].Value = model.TotalZFHMoney;
parameters[14].Value = model.TotalYFHMoney;
parameters[15].Value = model.StockCount;
parameters[16].Value = model.TotalFHCount;
parameters[17].Value = model.TXStatus;
parameters[18].Value = model.ZZStatus;
parameters[19].Value = model.YJCount;
parameters[20].Value = model.EPTimeOutCount;
parameters[21].Value = model.EPXingCount;
parameters[22].Value = model.FDTrade;
parameters[23].Value = model.TJLDLevel;
parameters[24].Value = model.ReadNoticeID;
parameters[25].Value = model.GLMoneyDate;
parameters[26].Value = model.GLMoney;
parameters[27].Value = model.YJMoney;
parameters[28].Value = model.TJCount;
parameters[29].Value = model.TJMoney;
parameters[30].Value = model.UpSumMoney;
parameters[31].Value = model.TotalMoney;
parameters[32].Value = model.RealMoney;
parameters[33].Value = model.TotalLDMoney;
parameters[34].Value = model.OfferQuota;
parameters[35].Value = model.SQCount;
parameters[36].Value = model.TotalHLMoney;
parameters[37].Value = model.HLMoneyState;
parameters[38].Value = model.PPLeavel;
parameters[39].Value = model.NomalTotalThaw;
parameters[40].Value = model.VIPTotalThaw;
parameters[41].Value = model.MJBF;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 实体转换
/// </summary>
/// <param name="dr"></param>
/// <param name="mhb"></param>
/// <returns></returns>
public static Model.MemberConfig TranEntity(DataRow dr, Model.Member member)
{
Model.MemberConfig model = new Model.MemberConfig();
model.MID = dr["MID"].ToString();
if (member != null)
{
model.Member = member;
}
else
{
model.Member = DAL.Member.GetModel(model.MID);
}
if (!string.IsNullOrEmpty(dr["TakeOffMoney"].ToString()))
{
model.TakeOffMoney = decimal.Parse(dr["TakeOffMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["ReBuyMoney"].ToString()))
{
model.ReBuyMoney = decimal.Parse(dr["ReBuyMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["OfferQuota"].ToString()))
{
model.OfferQuota = decimal.Parse(dr["OfferQuota"].ToString());
}
if (!string.IsNullOrEmpty(dr["SQCount"].ToString()))
{
model.SQCount = int.Parse(dr["SQCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalTXMoney"].ToString()))
{
model.TotalTXMoney = decimal.Parse(dr["TotalTXMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalHLMoney"].ToString()))
{
model.TotalHLMoney = decimal.Parse(dr["TotalHLMoney"].ToString());
}
model.JJTypeList = dr["JJTypeList"].ToString();
if (!string.IsNullOrEmpty(dr["MHB"].ToString()))
{
model.MHB = decimal.Parse(dr["MHB"].ToString());
//update by zhuxy 暂时没有冻结资金
//model.MHBFreeze =model.Member.MAgencyType.GLMoney + DAL.Configuration.TModel.YLMoney + DAL.ChangeMoney.GetAllTx(model.MID);
//model.MHBFreeze = model.Member.MAgencyType.GLMoney + DAL.Configuration.TModel.YLMoney + DAL.ChangeMoney.GetAllTx(model.MID);
//if (model.Member.MState)
//{
// model.MHBFreeze += +DAL.Configuration.TModel.GLMoney;
// DateTime time = member.MDate;
// while ((time = time.AddMonths(1)) < DateTime.Now)
// {
// model.MHBFreeze += DAL.Configuration.TModel.GLMoney;
// }
//}
model.MJJ = model.MHB - model.MHBFreeze;
if (model.MJJ < 0)
{
model.MJJ = 0;
}
}
if (!string.IsNullOrEmpty(dr["MJB"].ToString()))
{
model.MJB = decimal.Parse(dr["MJB"].ToString());
}
if (!string.IsNullOrEmpty(dr["MJBF"].ToString()))
{
model.MJBF = decimal.Parse(dr["MJBF"].ToString());
}
if (!string.IsNullOrEmpty(dr["MCW"].ToString()))
{
//model.MCW = decimal.Parse(DAL.MGP_BuyRecord.CountTotalMCW(model.MID));
model.MCW = decimal.Parse(dr["MCW"].ToString());
}
if (!string.IsNullOrEmpty(dr["MGP"].ToString()))
{
model.MGP = decimal.Parse(dr["MGP"].ToString());
}
if (!string.IsNullOrEmpty(dr["DTFHState"].ToString()))
{
model.DTFHState = bool.Parse(dr["DTFHState"].ToString());
}
if (!string.IsNullOrEmpty(dr["JTFHState"].ToString()))
{
model.JTFHState = bool.Parse(dr["JTFHState"].ToString());
}
if (!string.IsNullOrEmpty(dr["HLMoneyState"].ToString()))
{
model.HLMoneyState = bool.Parse(dr["HLMoneyState"].ToString());
}
if (!string.IsNullOrEmpty(dr["SHMoney"].ToString()))
{
model.SHMoney = decimal.Parse(dr["SHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["YJCount"].ToString()))
{
model.YJCount = int.Parse(dr["YJCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["YJMoney"].ToString()))
{
model.YJMoney = decimal.Parse(dr["YJMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJCount"].ToString()))
{
model.TJCount = int.Parse(dr["TJCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJMoney"].ToString()))
{
model.TJMoney = decimal.Parse(dr["TJMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["UpSumMoney"].ToString()))
{
model.UpSumMoney = int.Parse(dr["UpSumMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalMoney"].ToString()))
{
model.TotalMoney = decimal.Parse(dr["TotalMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["RealMoney"].ToString()))
{
model.RealMoney = decimal.Parse(dr["RealMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalDFHMoney"].ToString()))
{
model.TotalDFHMoney = decimal.Parse(dr["TotalDFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalZFHMoney"].ToString()))
{
model.TotalZFHMoney = decimal.Parse(dr["TotalZFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalYFHMoney"].ToString()))
{
model.TotalYFHMoney = decimal.Parse(dr["TotalYFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["StockCount"].ToString()))
{
model.StockCount = int.Parse(dr["StockCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalFHCount"].ToString()))
{
model.TotalFHCount = int.Parse(dr["TotalFHCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TXStatus"].ToString()))
{
model.TXStatus = bool.Parse(dr["TXStatus"].ToString());
}
if (!string.IsNullOrEmpty(dr["ZZStatus"].ToString()))
{
model.ZZStatus = bool.Parse(dr["ZZStatus"].ToString());
}
if (!string.IsNullOrEmpty(dr["ReadNoticeID"].ToString()))
{
model.ReadNoticeID = int.Parse(dr["ReadNoticeID"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJLDLevel"].ToString()))
{
model.TJLDLevel = int.Parse(dr["TJLDLevel"].ToString());
}
if (!string.IsNullOrEmpty(dr["GLMoneyDate"].ToString()))
{
model.GLMoneyDate = DateTime.Parse(dr["GLMoneyDate"].ToString());
}
if (dr["EPTimeOutCount"] != null && dr["EPTimeOutCount"].ToString() != "")
{
model.EPTimeOutCount = int.Parse(dr["EPTimeOutCount"].ToString());
}
if (dr["EPXingCount"] != null && dr["EPXingCount"].ToString() != "")
{
model.EPXingCount = int.Parse(dr["EPXingCount"].ToString());
}
if (dr["FDTrade"] != null && dr["FDTrade"].ToString() != "")
{
model.FDTrade = dr["FDTrade"].ToString();
}
if (!string.IsNullOrEmpty(dr["GLMoney"].ToString()))
{
model.GLMoney = decimal.Parse(dr["GLMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalLDMoney"].ToString()))
{
model.TotalLDMoney = decimal.Parse(dr["TotalLDMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["PPLeavel"].ToString()))
{
model.PPLeavel = int.Parse(dr["PPLeavel"].ToString());
}
if (!string.IsNullOrEmpty(dr["VIPTotalThaw"].ToString()))
{
model.VIPTotalThaw = decimal.Parse(dr["VIPTotalThaw"].ToString());
}
if (!string.IsNullOrEmpty(dr["NomalTotalThaw"].ToString()))
{
model.NomalTotalThaw = decimal.Parse(dr["NomalTotalThaw"].ToString());
}
return(model);
}
public static Hashtable Update(Model.MemberConfig model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberConfig set ");
strSql.Append(" MID = @MID , ");
strSql.Append(" TakeOffMoney = @TakeOffMoney , ");
strSql.Append(" ReBuyMoney = @ReBuyMoney , ");
strSql.Append(" TotalTXMoney = @TotalTXMoney , ");
strSql.Append(" JJTypeList = @JJTypeList , ");
strSql.Append(" MHB = @MHB , ");
strSql.Append(" MJB = @MJB , ");
strSql.Append(" MCW = @MCW , ");
strSql.Append(" MGP = @MGP , ");
strSql.Append(" DTFHState = @DTFHState , ");
strSql.Append(" JTFHState = @JTFHState , ");
strSql.Append(" SHMoney = @SHMoney , ");
strSql.Append(" TotalDFHMoney = @TotalDFHMoney , ");
strSql.Append(" TotalZFHMoney = @TotalZFHMoney , ");
strSql.Append(" TotalYFHMoney = @TotalYFHMoney , ");
strSql.Append(" StockCount = @StockCount , ");
strSql.Append(" TotalFHCount = @TotalFHCount , ");
strSql.Append(" TXStatus = @TXStatus , ");
strSql.Append(" ZZStatus = @ZZStatus , ");
strSql.Append(" YJCount = @YJCount , ");
strSql.Append(" EPTimeOutCount = @EPTimeOutCount , ");
strSql.Append(" EPXingCount = @EPXingCount , ");
strSql.Append(" FDTrade = @FDTrade , ");
strSql.Append(" TJLDLevel = @TJLDLevel , ");
strSql.Append(" ReadNoticeID = @ReadNoticeID , ");
strSql.Append(" GLMoneyDate = @GLMoneyDate , ");
strSql.Append(" GLMoney = @GLMoney , ");
strSql.Append(" YJMoney = @YJMoney , ");
strSql.Append(" TJCount = @TJCount , ");
strSql.Append(" TJMoney = @TJMoney , ");
strSql.Append(" UpSumMoney = @UpSumMoney , ");
strSql.Append(" TotalMoney = @TotalMoney , ");
strSql.Append(" RealMoney = @RealMoney, ");
strSql.Append(" TotalLDMoney = @TotalLDMoney , ");
strSql.Append(" OfferQuota = @OfferQuota, ");
strSql.Append(" SQCount = @SQCount, ");
strSql.Append(" TotalHLMoney = @TotalHLMoney, ");
strSql.Append(" HLMoneyState = @HLMoneyState, ");
strSql.Append(" PPLeavel = @PPLeavel , ");
strSql.Append(" NomalTotalThaw = @NomalTotalThaw, ");
strSql.Append(" MJBF = @MJBF, ");
strSql.Append(" VIPTotalThaw = @VIPTotalThaw ");
strSql.Append(" where MID=@MID ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalTXMoney", SqlDbType.Decimal, 9),
new SqlParameter("@JJTypeList", SqlDbType.VarChar, 300),
new SqlParameter("@MHB", SqlDbType.Decimal, 9),
new SqlParameter("@MJB", SqlDbType.Decimal, 9),
new SqlParameter("@MCW", SqlDbType.Decimal, 9),
new SqlParameter("@MGP", SqlDbType.Decimal, 9),
new SqlParameter("@DTFHState", SqlDbType.Bit, 1),
new SqlParameter("@JTFHState", SqlDbType.Bit, 1),
new SqlParameter("@SHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalDFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalZFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalYFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@StockCount", SqlDbType.Int, 4),
new SqlParameter("@TotalFHCount", SqlDbType.Int, 4),
new SqlParameter("@TXStatus", SqlDbType.Bit, 1),
new SqlParameter("@ZZStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Int, 4),
new SqlParameter("@EPTimeOutCount", SqlDbType.Int, 4),
new SqlParameter("@EPXingCount", SqlDbType.Int, 4),
new SqlParameter("@FDTrade", SqlDbType.VarChar, 30),
new SqlParameter("@TJLDLevel", SqlDbType.Int, 4),
new SqlParameter("@ReadNoticeID", SqlDbType.Int, 4),
new SqlParameter("@GLMoneyDate", SqlDbType.DateTime),
new SqlParameter("@GLMoney", SqlDbType.Decimal, 9),
new SqlParameter("@YJMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@TJMoney", SqlDbType.Decimal, 9),
new SqlParameter("@UpSumMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RealMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalLDMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OfferQuota", SqlDbType.Decimal, 9),
new SqlParameter("@SQCount", SqlDbType.Int, 4),
new SqlParameter("@TotalHLMoney", SqlDbType.Decimal, 9),
new SqlParameter("@HLMoneyState", SqlDbType.Bit, 1),
new SqlParameter("@PPLeavel", SqlDbType.Int, 4),
new SqlParameter("@NomalTotalThaw", SqlDbType.Decimal, 9),
new SqlParameter("@VIPTotalThaw", SqlDbType.Decimal, 9),
new SqlParameter("@MJBF", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TakeOffMoney;
parameters[2].Value = model.ReBuyMoney;
parameters[3].Value = model.TotalTXMoney;
parameters[4].Value = model.JJTypeList;
parameters[5].Value = model.MHB;
parameters[6].Value = model.MJB;
parameters[7].Value = model.MCW;
parameters[8].Value = model.MGP;
parameters[9].Value = model.DTFHState;
parameters[10].Value = model.JTFHState;
parameters[11].Value = model.SHMoney;
parameters[12].Value = model.TotalDFHMoney;
parameters[13].Value = model.TotalZFHMoney;
parameters[14].Value = model.TotalYFHMoney;
parameters[15].Value = model.StockCount;
parameters[16].Value = model.TotalFHCount;
parameters[17].Value = model.TXStatus;
parameters[18].Value = model.ZZStatus;
parameters[19].Value = model.YJCount;
parameters[20].Value = model.EPTimeOutCount;
parameters[21].Value = model.EPXingCount;
parameters[22].Value = model.FDTrade;
parameters[23].Value = model.TJLDLevel;
parameters[24].Value = model.ReadNoticeID;
parameters[25].Value = DateTime.Now;
parameters[26].Value = model.GLMoney;
parameters[27].Value = model.YJMoney;
parameters[28].Value = model.TJCount;
parameters[29].Value = model.TJMoney;
parameters[30].Value = model.UpSumMoney;
parameters[31].Value = model.TotalMoney;
parameters[32].Value = model.RealMoney;
parameters[33].Value = model.TotalLDMoney;
parameters[34].Value = model.OfferQuota;
parameters[35].Value = model.SQCount;
parameters[36].Value = model.TotalHLMoney;
parameters[37].Value = model.HLMoneyState;
parameters[38].Value = model.PPLeavel;
parameters[39].Value = model.NomalTotalThaw;
parameters[40].Value = model.VIPTotalThaw;
parameters[41].Value = model.MJBF;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 实体转换
/// </summary>
/// <param name="dr"></param>
/// <param name="mhb"></param>
/// <returns></returns>
public static Model.MemberConfig TranEntity(DataRow dr, Model.Member member)
{
Model.MemberConfig model = new Model.MemberConfig();
model.MID = dr["MID"].ToString();
if (member != null)
{
model.Member = member;
}
else
{
model.Member = DAL.Member.GetModel(model.MID);
}
if (!string.IsNullOrEmpty(dr["TakeOffMoney"].ToString()))
{
model.TakeOffMoney = decimal.Parse(dr["TakeOffMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["ReBuyMoney"].ToString()))
{
model.ReBuyMoney = decimal.Parse(dr["ReBuyMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalTXMoney"].ToString()))
{
model.TotalTXMoney = decimal.Parse(dr["TotalTXMoney"].ToString());
}
model.JJTypeList = dr["JJTypeList"].ToString();
if (!string.IsNullOrEmpty(dr["MHB"].ToString()))
{
model.MHB = decimal.Parse(dr["MHB"].ToString());
//model.MHBFreeze = DAL.Configuration.TModel.YLMoney + DAL.ChangeMoney.GetAllTx(model.MID);
model.MHBFreeze = DAL.Configuration.TModel.B_YLMoney;
model.MJJ = model.MHB - model.MHBFreeze;
if (model.MJJ < 0)
{
model.MJJ = 0;
}
}
if (!string.IsNullOrEmpty(dr["MJB"].ToString()))
{
model.MJB = decimal.Parse(dr["MJB"].ToString());
}
if (!string.IsNullOrEmpty(dr["MCW"].ToString()))
{
//model.MCW = decimal.Parse(DAl.MGP_BuyRecord.CountTotalMCW(model.MID));
model.MCW = decimal.Parse(dr["MCW"].ToString());
}
//if (!string.IsNullOrEmpty(dr["MGP"].ToString()))
{
model.MGP = DAL.StockRight.GetSellCount(string.Format(" and MID = '{0}' and IsValid = 1 ", model.MID));
//model.MGP = decimal.Parse(dr["MGP"].ToString());
}
if (!string.IsNullOrEmpty(dr["DTFHState"].ToString()))
{
model.DTFHState = bool.Parse(dr["DTFHState"].ToString());
}
if (!string.IsNullOrEmpty(dr["JTFHState"].ToString()))
{
model.JTFHState = bool.Parse(dr["JTFHState"].ToString());
}
if (!string.IsNullOrEmpty(dr["SHMoney"].ToString()))
{
model.SHMoney = int.Parse(dr["SHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["YJCount"].ToString()))
{
model.YJCount = int.Parse(dr["YJCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["YJMoney"].ToString()))
{
model.YJMoney = int.Parse(dr["YJMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJCount"].ToString()))
{
model.TJCount = int.Parse(dr["TJCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJMoney"].ToString()))
{
model.TJMoney = int.Parse(dr["TJMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["UpSumMoney"].ToString()))
{
model.UpSumMoney = int.Parse(dr["UpSumMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalMoney"].ToString()))
{
model.TotalMoney = decimal.Parse(dr["TotalMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["RealMoney"].ToString()))
{
model.RealMoney = decimal.Parse(dr["RealMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalDFHMoney"].ToString()))
{
model.TotalDFHMoney = decimal.Parse(dr["TotalDFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalZFHMoney"].ToString()))
{
model.TotalZFHMoney = decimal.Parse(dr["TotalZFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["TotalYFHMoney"].ToString()))
{
model.TotalYFHMoney = decimal.Parse(dr["TotalYFHMoney"].ToString());
}
if (!string.IsNullOrEmpty(dr["GQCount"].ToString()))
{
model.GQCount = int.Parse(dr["GQCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["HLGQCount"].ToString()))
{
model.HLGQCount = int.Parse(dr["HLGQCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TXStatus"].ToString()))
{
model.TXStatus = bool.Parse(dr["TXStatus"].ToString());
}
if (!string.IsNullOrEmpty(dr["ZZStatus"].ToString()))
{
model.ZZStatus = bool.Parse(dr["ZZStatus"].ToString());
}
if (!string.IsNullOrEmpty(dr["EPXingCount"].ToString()))
{
model.EPXingCount = int.Parse(dr["EPXingCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["EPTimeOutCount"].ToString()))
{
model.EPTimeOutCount = int.Parse(dr["EPTimeOutCount"].ToString());
}
if (!string.IsNullOrEmpty(dr["TJFloat"].ToString()))
{
model.TJFloat = decimal.Parse(dr["TJFloat"].ToString());
}
return(model);
}
public static Hashtable Update(Model.MemberConfig model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberConfig set ");
strSql.Append(" MID = @MID , ");
strSql.Append(" TakeOffMoney = @TakeOffMoney , ");
strSql.Append(" ReBuyMoney = @ReBuyMoney , ");
strSql.Append(" TotalTXMoney = @TotalTXMoney , ");
strSql.Append(" JJTypeList = @JJTypeList , ");
strSql.Append(" MHB = @MHB , ");
strSql.Append(" MJB = @MJB , ");
strSql.Append(" MCW = @MCW , ");
strSql.Append(" MGP = @MGP , ");
strSql.Append(" DTFHState = @DTFHState , ");
strSql.Append(" JTFHState = @JTFHState , ");
strSql.Append(" SHMoney = @SHMoney , ");
strSql.Append(" TotalDFHMoney = @TotalDFHMoney , ");
strSql.Append(" TotalZFHMoney = @TotalZFHMoney , ");
strSql.Append(" TotalYFHMoney = @TotalYFHMoney , ");
strSql.Append(" HLGQCount = @HLGQCount , ");
strSql.Append(" GQCount = @GQCount , ");
strSql.Append(" TXStatus = @TXStatus , ");
strSql.Append(" YJCount = @YJCount , ");
strSql.Append(" ZZStatus = @ZZStatus , ");
strSql.Append(" YJMoney = @YJMoney , ");
strSql.Append(" TJCount = @TJCount , ");
strSql.Append(" TJMoney = @TJMoney , ");
strSql.Append(" UpSumMoney = @UpSumMoney , ");
strSql.Append(" TotalMoney = @TotalMoney , ");
strSql.Append(" TJFloat = @TJFloat , ");
strSql.Append(" EPXingCount = @EPXingCount , ");
strSql.Append(" EPTimeOutCount = @EPTimeOutCount , ");
strSql.Append(" RealMoney = @RealMoney ");
strSql.Append(" where MID=@MID ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalTXMoney", SqlDbType.Decimal, 9),
new SqlParameter("@JJTypeList", SqlDbType.VarChar, 300),
new SqlParameter("@MHB", SqlDbType.Decimal, 9),
new SqlParameter("@MJB", SqlDbType.Decimal, 9),
new SqlParameter("@MCW", SqlDbType.Decimal, 9),
new SqlParameter("@MGP", SqlDbType.Decimal, 9),
new SqlParameter("@DTFHState", SqlDbType.Bit, 1),
new SqlParameter("@JTFHState", SqlDbType.Bit, 1),
new SqlParameter("@SHMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalDFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalZFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalYFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@HLGQCount", SqlDbType.Int, 4),
new SqlParameter("@GQCount", SqlDbType.Int, 4),
new SqlParameter("@TXStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Int, 4),
new SqlParameter("@ZZStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJMoney", SqlDbType.Int, 4),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@TJMoney", SqlDbType.Int, 4),
new SqlParameter("@UpSumMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RealMoney", SqlDbType.Decimal, 9),
new SqlParameter("@EPTimeOutCount", SqlDbType.Int, 4),
new SqlParameter("@EPXingCount", SqlDbType.Int, 4),
new SqlParameter("@TJFloat", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TakeOffMoney;
parameters[2].Value = model.ReBuyMoney;
parameters[3].Value = model.TotalTXMoney;
parameters[4].Value = model.JJTypeList;
parameters[5].Value = model.MHB;
parameters[6].Value = model.MJB;
parameters[7].Value = model.MCW;
parameters[8].Value = model.MGP;
parameters[9].Value = model.DTFHState;
parameters[10].Value = model.JTFHState;
parameters[11].Value = model.SHMoney;
parameters[12].Value = model.TotalDFHMoney;
parameters[13].Value = model.TotalZFHMoney;
parameters[14].Value = model.TotalYFHMoney;
parameters[15].Value = model.HLGQCount;
parameters[16].Value = model.GQCount;
parameters[17].Value = model.TXStatus;
parameters[18].Value = model.YJCount;
parameters[19].Value = model.ZZStatus;
parameters[20].Value = model.YJMoney;
parameters[21].Value = model.TJCount;
parameters[22].Value = model.TJMoney;
parameters[23].Value = model.UpSumMoney;
parameters[24].Value = model.TotalMoney;
parameters[25].Value = model.RealMoney;
parameters[26].Value = model.EPTimeOutCount;
parameters[27].Value = model.EPXingCount;
parameters[28].Value = model.TJFloat;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static Hashtable Insert(Model.MemberConfig model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberConfig(");
strSql.Append("MID,TakeOffMoney,ReBuyMoney,TotalTXMoney,JJTypeList,MHB,MJB,MCW,MGP,DTFHState,JTFHState,SHMoney,TotalDFHMoney,TotalZFHMoney,TotalYFHMoney,HLGQCount,GQCount,TXStatus,YJCount,ZZStatus,YJMoney,TJCount,TJMoney,UpSumMoney,TotalMoney,RealMoney,EPXingCount,EPTimeOutCount,TJFloat");
strSql.Append(") values (");
strSql.Append("@MID,@TakeOffMoney,@ReBuyMoney,@TotalTXMoney,@JJTypeList,@MHB,@MJB,@MCW,@MGP,@DTFHState,@JTFHState,@SHMoney,@TotalDFHMoney,@TotalZFHMoney,@TotalYFHMoney,@HLGQCount,@GQCount,@TXStatus,@YJCount,@ZZStatus,@YJMoney,@TJCount,@TJMoney,@UpSumMoney,@TotalMoney,@RealMoney,@EPXingCount,@EPTimeOutCount,@TJFloat");
strSql.Append(") ");
strSql.AppendFormat(";select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalTXMoney", SqlDbType.Decimal, 9),
new SqlParameter("@JJTypeList", SqlDbType.VarChar, 300),
new SqlParameter("@MHB", SqlDbType.Decimal, 9),
new SqlParameter("@MJB", SqlDbType.Decimal, 9),
new SqlParameter("@MCW", SqlDbType.Decimal, 9),
new SqlParameter("@MGP", SqlDbType.Decimal, 9),
new SqlParameter("@DTFHState", SqlDbType.Bit, 1),
new SqlParameter("@JTFHState", SqlDbType.Bit, 1),
new SqlParameter("@SHMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalDFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalZFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@TotalYFHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@HLGQCount", SqlDbType.Int, 4),
new SqlParameter("@GQCount", SqlDbType.Int, 4),
new SqlParameter("@TXStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJCount", SqlDbType.Int, 4),
new SqlParameter("@ZZStatus", SqlDbType.Bit, 1),
new SqlParameter("@YJMoney", SqlDbType.Int, 4),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@TJMoney", SqlDbType.Int, 4),
new SqlParameter("@UpSumMoney", SqlDbType.Int, 4),
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RealMoney", SqlDbType.Decimal, 9),
new SqlParameter("@EPTimeOutCount", SqlDbType.Int, 4),
new SqlParameter("@EPXingCount", SqlDbType.Int, 4),
new SqlParameter("@TJFloat", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TakeOffMoney;
parameters[2].Value = model.ReBuyMoney;
parameters[3].Value = model.TotalTXMoney;
parameters[4].Value = model.JJTypeList;
parameters[5].Value = model.MHB;
parameters[6].Value = model.MJB;
parameters[7].Value = model.MCW;
parameters[8].Value = model.MGP;
parameters[9].Value = model.DTFHState;
parameters[10].Value = model.JTFHState;
parameters[11].Value = model.SHMoney;
parameters[12].Value = model.TotalDFHMoney;
parameters[13].Value = model.TotalZFHMoney;
parameters[14].Value = model.TotalYFHMoney;
parameters[15].Value = model.HLGQCount;
parameters[16].Value = model.GQCount;
parameters[17].Value = model.TXStatus;
parameters[18].Value = model.YJCount;
parameters[19].Value = model.ZZStatus;
parameters[20].Value = model.YJMoney;
parameters[21].Value = model.TJCount;
parameters[22].Value = model.TJMoney;
parameters[23].Value = model.UpSumMoney;
parameters[24].Value = model.TotalMoney;
parameters[25].Value = model.RealMoney;
parameters[26].Value = model.EPTimeOutCount;
parameters[27].Value = model.EPXingCount;
parameters[28].Value = model.TJFloat;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
