public override SqlParameter[] GetParameters() { M_UserCourse model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.CourseID; sp[2].Value = model.ClassID; sp[3].Value = model.UserID; sp[4].Value = model.CurrCoureHour; sp[5].Value = model.State; sp[6].Value = model.AddTime; sp[7].Value = model.PayMent; sp[8].Value = model.OrderID; sp[9].Value = model.Aunit; sp[10].Value = model.Remark; return(sp); }
public M_UserCourse GetModelFromReader(DbDataReader rdr) { M_UserCourse model = new M_UserCourse(); model.ID = Convert.ToInt32(rdr["ID"]); model.CourseID = ConvertToInt(rdr["CourseID"]); model.ClassID = ConvertToInt(rdr["ClassID"]); model.UserID = ConvertToInt(rdr["UserID"]); model.CurrCoureHour = Convert.ToInt64(rdr["CurrCoureHour"]); model.State = ConvertToInt(rdr["State"]); model.AddTime = ConvertToDate(rdr["AddTime"]); model.PayMent = ConvertToInt(rdr["PayMent"]); model.OrderID = ConverToStr(rdr["OrderID"]); model.Aunit = ConvertToInt(rdr["Aunit"]); model.Remark = ConverToStr(rdr["Remark"]); rdr.Close(); rdr.Dispose(); return(model); }