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); }