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); }