public SqlParameter[] GetParameters(M_School model)
{
string[,] strArr = FieldList();
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.SchoolName;
sp[2].Value = model.Country;
sp[3].Value = model.Province;
sp[4].Value = model.SchoolType;
sp[5].Value = model.Visage;
sp[6].Value = model.Addtime;
sp[7].Value = model.SchoolInfo;
sp[8].Value = model.City;
sp[9].Value = model.County;
return(sp);
}
public M_School GetModelFromReader(DbDataReader rdr)
{
M_School model = new M_School();
model.ID = Convert.ToInt32(rdr["ID"]);
model.SchoolName = ConverToStr(rdr["SchoolName"]);
model.Country = ConverToStr(rdr["Country"]);
model.Province = ConverToStr(rdr["Province"]);
model.SchoolType = ConvertToInt(rdr["SchoolType"]);
model.Visage = ConvertToInt(rdr["Visage"]);
model.Addtime = ConvertToDate(rdr["Addtime"]);
model.SchoolInfo = ConverToStr(rdr["SchoolInfo"]);
model.City = ConverToStr(rdr["City"]);
model.County = ConverToStr(rdr["County"]);
rdr.Close();
return(model);
}
