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