public M_PageReg GetModelFromReader(DbDataReader rdr) { M_PageReg model = new M_PageReg(); model.ID = Convert.ToInt32(rdr["ID"]); model.CompanyName = rdr["CompanyName"].ToString(); model.PageTitle = rdr["PageTitle"].ToString(); model.Keyword = rdr["Keyword"].ToString(); model.Description = rdr["Description"].ToString(); model.LOGO = rdr["LOGO"].ToString(); model.Domain = rdr["Domain"].ToString(); model.Style = Convert.ToInt32(rdr["Style"].ToString()); model.NodeStyle = Convert.ToInt32(rdr["NodeStyle"].ToString()); model.NavHeight = rdr["NavHeight"].ToString(); model.NavColor = rdr["NavColor"].ToString(); model.NavBackground = rdr["NavBackground"].ToString(); model.TableName = rdr["TableName"].ToString(); model.Hits = Convert.ToInt32(rdr["Hits"].ToString()); model.InfoID = Convert.ToInt32(rdr["InfoID"].ToString()); model.Recommendation = rdr["Recommendation"].ToString(); model.Status = Convert.ToInt32(rdr["Status"].ToString()); model.UserID = Convert.ToInt32(rdr["UserID"].ToString()); model.UserName = rdr["UserName"].ToString(); model.ParentPageID = Convert.ToInt32(rdr["ParentPageID"].ToString()); model.ParentPageUserID = Convert.ToInt32(rdr["ParentPageUserID"].ToString()); model.PageInfo = rdr["PageInfo"].ToString(); model.TopWords = rdr["TopWords"].ToString(); model.BottonWords = rdr["BottonWords"].ToString(); model.CreationTime = Convert.ToDateTime(rdr["CreationTime"]); model.UpdateTime = Convert.ToDateTime(rdr["UpdateTime"]); model.Template = rdr["Template"].ToString(); model.ModelID = Convert.ToInt32(rdr["ModelID"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_PageReg model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.CompanyName; sp[2].Value = model.PageTitle; sp[3].Value = model.Keyword; sp[4].Value = model.Description; sp[5].Value = model.LOGO; sp[6].Value = model.Domain; sp[7].Value = model.Style; sp[8].Value = model.NodeStyle; sp[9].Value = model.NavHeight; sp[10].Value = model.NavColor; sp[11].Value = model.NavBackground; sp[12].Value = model.TableName; sp[13].Value = model.Hits; sp[14].Value = model.InfoID; sp[15].Value = model.Recommendation; sp[16].Value = model.Status; sp[17].Value = model.UserID; sp[18].Value = model.UserName; sp[19].Value = model.ParentPageID; sp[20].Value = model.ParentPageUserID; sp[21].Value = model.PageInfo; sp[22].Value = model.TopWords; sp[23].Value = model.BottonWords; sp[24].Value = model.CreationTime; sp[25].Value = model.UpdateTime; sp[26].Value = model.Template; sp[27].Value = model.ModelID; return(sp); }