public M_ClassRoom GetModelFromReader(DbDataReader rdr) { M_ClassRoom model = new M_ClassRoom(); model.RoomID = Convert.ToInt32(rdr["RoomID"]); model.RoomName = ConverToStr(rdr["RoomName"]); model.SchoolID = ConvertToInt(rdr["SchoolID"]); model.ClassName = ConverToStr(rdr["ClassName"]); model.Room = ConverToStr(rdr["Room"]); model.Teacher = ConverToStr(rdr["Teacher"]); model.Adviser = ConverToStr(rdr["Adviser"]); model.Monitor = ConverToStr(rdr["Monitor"]); model.Creation = ConvertToDate(rdr["Creation"]); model.CreateUser = ConvertToInt(rdr["CreateUser"]); model.Integral = ConvertToInt(rdr["Integral"]); model.Classinfo = ConverToStr(rdr["Classinfo"]); model.Grade = ConvertToInt(rdr["Grade"]); model.IsTrue = ConvertToInt(rdr["IsTrue"]); model.ClassStar = ConvertToInt(rdr["ClassStar"]); model.IsDone = ConvertToInt(rdr["IsDone"]); rdr.Dispose(); return(model); }
public override SqlParameter[] GetParameters() { M_ClassRoom model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.RoomID; sp[1].Value = model.RoomName; sp[2].Value = model.SchoolID; sp[3].Value = model.ClassName; sp[4].Value = model.Room; sp[5].Value = model.Teacher; sp[6].Value = model.Adviser; sp[7].Value = model.Monitor; sp[8].Value = model.Creation; sp[9].Value = model.CreateUser; sp[10].Value = model.Integral; sp[11].Value = model.Classinfo; sp[12].Value = model.Grade; sp[13].Value = model.IsTrue; sp[14].Value = model.ClassStar; sp[15].Value = model.IsDone; return(sp); }