public M_User_UnitWeek GetModelFromReader(DbDataReader rdr) { M_User_UnitWeek model = new M_User_UnitWeek(); model.ID = Convert.ToInt32(rdr["ID"]); model.ChildAMount = ConvertToInt(rdr["ChildAMount"]); model.RealUnit0 = ConverToDouble(rdr["RealUnit0"]); model.RealUnit10 = ConverToDouble(rdr["RealUnit10"]); model.RealUnit20 = ConverToDouble(rdr["RealUnit20"]); model.RealUnit30 = ConverToDouble(rdr["RealUnit30"]); model.UserID = ConvertToInt(rdr["UserID"]); model.PUserID = ConvertToInt(rdr["PUserID"]); model.CDate = ConvertToDate(rdr["CDate"]); model.Remind = ConverToStr(rdr["Remind"]); model.ChildIDS = ConverToStr(rdr["ChildIDS"]); model.State = ConvertToInt(rdr["State"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_User_UnitWeek model = this; if (CDate <= DateTime.MinValue) { CDate = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.ChildAMount; sp[2].Value = model.RealUnit; sp[3].Value = model.RealUnit0; sp[4].Value = model.RealUnit10; sp[5].Value = model.RealUnit20; sp[6].Value = model.RealUnit30; sp[7].Value = model.UserID; sp[8].Value = model.PUserID; sp[9].Value = model.CDate; sp[10].Value = model.Remind; sp[11].Value = model.ChildIDS; sp[12].Value = model.State; return(sp); }