public bool CategorysInfo_Update(CategorysInfo data) { using (SqlCommand dbCmd = new SqlCommand("Banner_Update", GetConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@CategoryID", data.CategoryID)); dbCmd.Parameters.Add(new SqlParameter("@Tag", data.Tag)); dbCmd.Parameters.Add(new SqlParameter("@Name", data.Name)); dbCmd.Parameters.Add(new SqlParameter("@Content", data.Content)); dbCmd.Parameters.Add(new SqlParameter("@Level", data.Level)); dbCmd.Parameters.Add(new SqlParameter("@Priority", data.Priority)); dbCmd.Parameters.Add(new SqlParameter("@Index", data.Index)); dbCmd.Parameters.Add(new SqlParameter("@Title", data.Title)); dbCmd.Parameters.Add(new SqlParameter("@Description", data.Description)); dbCmd.Parameters.Add(new SqlParameter("@Keyword", data.Keyword)); dbCmd.Parameters.Add(new SqlParameter("@Active", data.Active)); dbCmd.Parameters.Add(new SqlParameter("@Ord", data.Ord)); dbCmd.Parameters.Add(new SqlParameter("@Lang", data.Lang)); dbCmd.Parameters.Add(new SqlParameter("@Image", data.Image)); dbCmd.Parameters.Add(new SqlParameter("@Image2", data.Image2)); dbCmd.ExecuteNonQuery(); } //Clear cache System.Web.HttpContext.Current.Cache.Remove("CategorysInfo"); return(true); }
public CategorysInfo CategorysInfoIDataReader(IDataReader dr) { CategorysInfo obj = new CategorysInfo(); obj.CategoryID = (dr["CategoryID"] is DBNull) ? string.Empty : dr["CategoryID"].ToString(); obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString(); obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString(); obj.Index = (dr["Index"] is DBNull) ? string.Empty : dr["Index"].ToString(); obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.Keyword = (dr["Keyword"] is DBNull) ? string.Empty : dr["Keyword"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.Image2 = (dr["Image2"] is DBNull) ? string.Empty : dr["Image2"].ToString(); return(obj); }