public SqlParameter[] GetParameters(M_Manufacturers model)
{
string[,] strArr = FieldList();
SqlParameter[] sp = new SqlParameter[strArr.Length];
for (int i = 0; i < strArr.GetLength(0); i++)
{
sp[i] = new SqlParameter("@" + strArr[i, 0], (SqlDbType)Enum.Parse(typeof(SqlDbType), strArr[i, 1]), Convert.ToInt32(strArr[i, 2]));
}
sp[0].Value = model.id;
sp[1].Value = model.Producername;
sp[2].Value = model.Smallname;
sp[3].Value = model.CreateTime;
sp[4].Value = model.Coadd;
sp[5].Value = model.Telpho;
sp[6].Value = model.FaxCode;
sp[7].Value = model.PostCode;
sp[8].Value = model.CoWebsite;
sp[9].Value = model.Email;
sp[10].Value = model.CoClass;
sp[11].Value = model.CoPhoto;
sp[12].Value = model.Content;
sp[13].Value = model.Istop;
sp[14].Value = model.Disable;
sp[15].Value = model.Isbest;
return(sp);
}
public M_Manufacturers GetModelFromReader(DbDataReader rdr)
{
M_Manufacturers model = new M_Manufacturers();
model.id = Convert.ToInt32(rdr["id"]);
model.Producername = rdr["Producername"].ToString();
model.Smallname = rdr["Smallname"].ToString();
model.CreateTime = Convert.ToDateTime(rdr["CreateTime"]);
model.Coadd = rdr["Coadd"].ToString();
model.Telpho = rdr["Telpho"].ToString();
model.FaxCode = rdr["FaxCode"].ToString();
model.PostCode = rdr["PostCode"].ToString();
model.CoWebsite = rdr["CoWebsite"].ToString();
model.Email = rdr["Email"].ToString();
model.CoClass = rdr["CoClass"].ToString();
model.CoPhoto = rdr["CoPhoto"].ToString();
model.Content = rdr["Content"].ToString();
model.Istop = Convert.ToInt32(rdr["Istop"]);
model.Disable = Convert.ToInt32(rdr["Disable"]);
model.Isbest = Convert.ToInt32(rdr["Isbest"]);
rdr.Close();
rdr.Dispose();
return(model);
}
