Пример #1
0
        /// <summary>
        /// 插入新分类
        /// </summary>
        /// <param name="category">分类</param>
        /// <returns></returns>
        public int Insert(Category category)
        {
            int count = 0;

            string sql = "insert from tbCategory where categoryid = @CategoryId";

            SqlParameter[] sqlParams = new SqlParameter[] { };

            count = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlParams);

            return count;
        }
Пример #2
0
        /// <summary>
        /// 查询分类
        /// </summary>
        /// <param name="categoryName">分类名称关键字</param>
        /// <returns>分类集合</returns>
        public IList<Category> Select(string categoryName)
        {
            StringBuilder sqlBuilder = new StringBuilder("select * from tbCategory");
            SqlParameter[] sqlParams = null;

            if (!string.IsNullOrEmpty(categoryName))
            {
                sqlBuilder.Append(" where categoryname like @CategoryName");
                sqlParams = new SqlParameter[] {
                                                new SqlParameter("@CategoryName", "%%" + categoryName + "%%")
                };
            }

            SqlDataReader reader = SqlHelper.ExecuteGetReader(CommandType.Text, sqlBuilder.ToString(), sqlParams);

            IList<Category> categories = new List<Category>();
            Category category = null;

            while (reader.Read())
            {
                category = new Category { CategoryId = Convert.ToInt32(reader["categoryid"]), CategoryName = Convert.ToString(reader["categoryname"]), CategoryAlias = Convert.ToString(reader["categoryalias"]), CategoryTaxis = Convert.ToInt32(reader["categorytaxis"]) };

                categories.Add(category);
            }

            return categories;
        }
Пример #3
0
        /// <summary>
        /// 更新分类
        /// </summary>
        /// <param name="category">分类</param>
        /// <returns></returns>
        public int Update(Category category)
        {
            int count = 0;
            StringBuilder sqlBuilder = new StringBuilder("update tbCategory set ");

            string sql = "update tbCategory set categoryname = @CategoryName, categoryalias = @CategoryAlias, categorytaxis = @CategoryTaxis where categoryid = @CategoryId";

            SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@CategoryId", category.CategoryId) };

            count = SqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlParams);

            return count;
        }
Пример #4
0
        /// <summary>
        /// 获取指定编号的分类 
        /// </summary>
        /// <param name="categoryId">分类编号</param>
        /// <returns>分类信息</returns>
        public Category Select(int categoryId)
        {
            Category category = null;

            string sql = "select * from tbCategory where categoryid = @CategoryId";

            SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@CategoryId", categoryId) };

            using (SqlDataReader reader = SqlHelper.ExecuteGetReader(CommandType.Text, sql, sqlParams))
            {
                while (reader.Read())
                {
                    category = new Category { CategoryId = Convert.ToInt32(reader["categoryid"]), CategoryName = Convert.ToString(reader["categoryname"]), CategoryAlias = Convert.ToString(reader["categoryalias"]), CategoryTaxis = Convert.ToInt32(reader["categorytaxis"]) };
                }
            }

            return category;
        }