public override SqlParameter[] GetParameters()
{
M_User_Consume model = this;
if (CDate <= DateTime.MinValue)
{
CDate = DateTime.Now;
}
if (UserID == PUserID)
{
PUserID = 0; //不允许让自己成为推荐人
}
if (UserID == 0)
{
throw new Exception("异常,未记录到用户信息");
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.UserID;
sp[2].Value = model.PUserID;
sp[3].Value = model.MType;
sp[4].Value = model.AMount;
sp[5].Value = model.CDate;
sp[6].Value = model.UnitPercent;
sp[7].Value = model.UnitAmount;
sp[8].Value = model.State;
sp[9].Value = model.Remind;
sp[10].Value = model.Detail;
sp[11].Value = model.BindID;
return(sp);
}
public M_User_Consume GetModelFromReader(DbDataReader rdr)
{
M_User_Consume model = new M_User_Consume();
model.ID = Convert.ToInt32(rdr["ID"]);
model.UserID = Convert.ToInt32(rdr["UserID"]);
model.PUserID = Convert.ToInt32(rdr["PUserID"]);
model.MType = ConvertToInt(rdr["MType"]);
model.AMount = Convert.ToDouble(rdr["AMount"]);
model.CDate = ConvertToDate(rdr["CDate"]);
model.UnitPercent = ConverToStr(rdr["UnitPercent"]);
model.UnitAmount = ConverToDouble(rdr["UnitAmount"]);
model.State = ConvertToInt(rdr["State"]);
model.Remind = ConverToStr(rdr["Remind"]);
model.Detail = ConverToStr(rdr["Detail"]);
model.BindID = Convert.ToInt32(rdr["BindID"]);
rdr.Close();
return(model);
}
