/*
* 创建人:李要南
* 创建时间:2008-12-5 19:18
* 说明:新闻类别表操作类
* 版权所有:李要南
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
/// <summary>
/// 新闻类别表操作类
/// </summary>
public class CategoryDAL
{
private SQLHelper sqlhelper = null;
public CategoryDAL()
{
sqlhelper = new SQLHelper();
}
#region 取出当前所有新闻分类
/// <summary>
/// 取出当前所有新闻分类
/// </summary>
/// <returns></returns>
public DataTable SelectAll()
{
DataTable dt = new DataTable();
string sql = "select * from category";
dt = sqlhelper.ExecuteReader(sql, CommandType.Text);
return dt;
}
#endregion
#region 增加类别
/// <summary>
/// 增加类别
/// </summary>
/// <param name="caName">类别名称</param>
/// <returns></returns>
public bool Insert(string caName)
{
bool flag = false;
string sql = "insert into category values(@caName)";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@caName", caName) };
int res = sqlhelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (res > 0)
{
flag = true;
}
return flag;
}
#endregion
#region 修改类别
/// <summary>
/// 修改类别
/// </summary>
/// <param name="ca"></param>
/// <returns></returns>
public bool Update(Category ca)
{
bool flag = false;
string sql = "update category set [name]=@caName where id=@id";
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@caName", ca.Name),
new SqlParameter("@id",ca.Id)
};
int res = sqlhelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (res > 0)
{
flag = true;
}
return flag;
}
#endregion
#region 删除类别
/// <summary>
/// 删除类别
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Delete(string id)
{
//bool flag = false;
//string cmdText = "news_delete";
//SqlParameter[] para = new SqlParameter[] {
// new SqlParameter("@id",id)};
//int res = new SQLHelper().ExecuteNonQuery(cmdText, para, CommandType.StoredProcedure);
//if (res > 0)
//{
// flag = true;
//}
//return flag;
bool flag = false;
string sql = "delete category where id=@id";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@id",id)
};
int res = sqlhelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (res > 0)
{
flag = true;
}
return flag;
}
#endregion
#region 判断类别名称是否已存在
/// <summary>
/// 判断类别名称是否已存在
/// </summary>
/// <param name="caName">类别名称</param>
/// <returns></returns>
public bool IsExists(string caName)
{
bool flag = false;
string sql = "select * from category where [name]='" + caName + "'";
DataTable dt = sqlhelper.ExecuteReader(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
flag = true;
}
return flag;
}
#endregion
}
}