public IList<CategoryInfo> GetCategory(CategoryType categoryType, int categoryID)
{
SqlHelper objSqlHelper = new SqlHelper();
List<CategoryInfo> categorys = new List<CategoryInfo>();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@categoryType", SqlDbType.Int, 4);
objParams[1] = new SqlParameter("@categoryID", SqlDbType.Int, 4);
objParams[0].Value = (int)categoryType;
objParams[1].Value = categoryID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Cat_GetCategory", objParams); ;
while (reader.Read())
{
CategoryInfo item = new CategoryInfo();
item.CategoryID = reader.GetInt32(reader.GetOrdinal("categoryID"));
item.CategoryName = reader.GetString(reader.GetOrdinal("categoryName"));
item.ParentID = reader.GetInt32(reader.GetOrdinal("parentID"));
item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain"));
categorys.Add(item);
}
reader.Close();
objSqlHelper.close();
return categorys;
}
public void InsertCategory(CategoryInfo category)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@categoryName", category.CategoryName);
objParams[1] = new SqlParameter("@parentID", category.ParentID);
objParams[2] = new SqlParameter("@IsMain", category.IsMain);
objSqlHelper.ExecuteNonQuery("je_Cat_InsertCategory", objParams);
}
public int UpdateCategory(CategoryInfo category)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@categoryName", category.CategoryName);
objParams[1] = new SqlParameter("@parentID", category.ParentID);
objParams[2] = new SqlParameter("@IsMain", category.IsMain);
objParams[3] = new SqlParameter("@categoryID", category.CategoryID);
return objSqlHelper.ExecuteNonQuery("je_Cat_UpdateCategory", objParams);
}
public CategoryInfo GetCategoryByID(int categoryID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@categoryID", SqlDbType.Int, 4);
objParams[0].Value = categoryID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Cat_GetCategoryByID", objParams);
CategoryInfo item = new CategoryInfo();
while (reader.Read())
{
item.CategoryID = reader.GetInt32(reader.GetOrdinal("categoryID"));
item.CategoryName = reader.GetString(reader.GetOrdinal("categoryName"));
item.ParentID = reader.GetInt32(reader.GetOrdinal("parentID"));
item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain"));
}
reader.Close();
return item;
}
/// <summary>
/// 更新分类
/// </summary>
/// <param name="category"></param>
public static int UpdateCategory(CategoryInfo category)
{
return categorys.UpdateCategory(category);
}
/// <summary>
/// 新增分类
/// </summary>
/// <param name="category"></param>
public static void InsertCategory(CategoryInfo category)
{
categorys.InsertCategory(category);
}
