/// <summary>根据主键ID读取记录
/// 根据主键ID读取记录
/// </summary>
/// <param name="id">表主键</param>
/// <returns>话题类别实体对象</returns>
public TopicCategoryInfo Read(int id)
{
string sql = string.Format("SELECT ID,FatherID,CateName,CateCName,TopicCount,Keywords,Description,OrderID FROM TopicCategory WHERE ID ={0}", id);
TopicCategoryInfo info = new TopicCategoryInfo();
using (SqlDataReader dr = MssqlHandler.ExecuteReader(sql))
{
PrepareSingleModel(dr, info);
}
return info;
}
/// <summary>根据主键ID读取记录
/// 根据主键ID读取记录
/// </summary>
/// <param name="id">表主键</param>
/// <returns>话题类别实体对象</returns>
public TopicCategoryInfo Read(int id)
{
string sql = string.Format("SELECT ID,FatherID,CateName,CateCName,TopicCount,Keywords,Description,OrderID FROM TopicCategory WHERE ID ={0}", id);
TopicCategoryInfo info = new TopicCategoryInfo();
using (SqlDataReader dr = MssqlHandler.ExecuteReader(sql))
{
PrepareSingleModel(dr, info);
}
return(info);
}
public void PrepareSingleModel(SqlDataReader dr, TopicCategoryInfo info)
{
while (dr.Read())
{
info.ID = dr.GetInt32(0);
info.FatherID = dr.GetInt32(1);
info.CateName = dr[2].ToString();
info.CateCName = dr[3].ToString();
info.TopicCount = dr.GetInt32(4);
info.Keywords = dr[5].ToString();
info.Description = dr[6].ToString();
info.OrderID = dr.GetInt32(7);
}
}
public void PrepareSingleModel(SqlDataReader dr, TopicCategoryInfo info)
{
while (dr.Read())
{
info.ID = dr.GetInt32(0);
info.FatherID = dr.GetInt32(1);
info.CateName = dr[2].ToString();
info.CateCName = dr[3].ToString();
info.TopicCount = dr.GetInt32(4);
info.Keywords = dr[5].ToString();
info.Description = dr[6].ToString();
info.OrderID = dr.GetInt32(7);
}
}
/// <summary>插入实体数据
/// 插入实体数据
/// </summary>
/// <param name="info">表实体模型</param>
public void Insert(TopicCategoryInfo info)
{
string sql = "INSERT INTO TopicCategory(FatherID,CateName,CateCName,TopicCount,Keywords,Description,OrderID) values(@FatherID,@CateName,@CateCName,@TopicCount,@Keywords,@Description,@OrderID)";
SqlParameter[] paras = {
new SqlParameter("@FatherID", SqlDbType.Int),
new SqlParameter("@CateName", SqlDbType.NVarChar),
new SqlParameter("@CateCName", SqlDbType.NVarChar),
new SqlParameter("@TopicCount", SqlDbType.Int),
new SqlParameter("@Keywords", SqlDbType.NVarChar),
new SqlParameter("@Description", SqlDbType.NVarChar),
new SqlParameter("@OrderID", SqlDbType.Int)
};
paras[0].Value = info.FatherID;
paras[1].Value = info.CateName;
paras[2].Value = info.CateCName;
paras[3].Value = info.TopicCount;
paras[4].Value = info.Keywords;
paras[5].Value = info.Description;
paras[6].Value = info.OrderID;
MssqlHandler.ExecuteNonQuery(sql, paras);
}
/// <summary>更新实体数据
/// 更新实体数据
/// </summary>
/// <param name="info">表实体模型</param>
public void Update(TopicCategoryInfo info)
{
string sql = string.Format("UPDATE TopicCategory SET FatherID=@FatherID,CateName=@CateName,CateCName=@CateCName,TopicCount=@TopicCount,Keywords=@Keywords,Description=@Description,OrderID=@OrderID where ID={0}", info.ID);
SqlParameter[] paras =
{
new SqlParameter("@FatherID", SqlDbType.Int),
new SqlParameter("@CateName", SqlDbType.NVarChar),
new SqlParameter("@CateCName", SqlDbType.NVarChar),
new SqlParameter("@TopicCount", SqlDbType.Int),
new SqlParameter("@Keywords", SqlDbType.NVarChar),
new SqlParameter("@Description", SqlDbType.NVarChar),
new SqlParameter("@OrderID", SqlDbType.Int)
};
paras[0].Value = info.FatherID;
paras[1].Value = info.CateName;
paras[2].Value = info.CateCName;
paras[3].Value = info.TopicCount;
paras[4].Value = info.Keywords;
paras[5].Value = info.Description;
paras[6].Value = info.OrderID;
MssqlHandler.ExecuteNonQuery(sql, paras);
}
/// <summary>插入实体数据
/// 插入实体数据
/// </summary>
/// <param name="info">表实体模型</param>
public void Insert(TopicCategoryInfo info)
{
string sql = "INSERT INTO TopicCategory(FatherID,CateName,CateCName,TopicCount,Keywords,Description,OrderID) values(@FatherID,@CateName,@CateCName,@TopicCount,@Keywords,@Description,@OrderID)";
SqlParameter[] paras =
{
new SqlParameter("@FatherID", SqlDbType.Int),
new SqlParameter("@CateName", SqlDbType.NVarChar),
new SqlParameter("@CateCName", SqlDbType.NVarChar),
new SqlParameter("@TopicCount", SqlDbType.Int),
new SqlParameter("@Keywords", SqlDbType.NVarChar),
new SqlParameter("@Description", SqlDbType.NVarChar),
new SqlParameter("@OrderID", SqlDbType.Int)
};
paras[0].Value = info.FatherID;
paras[1].Value = info.CateName;
paras[2].Value = info.CateCName;
paras[3].Value = info.TopicCount;
paras[4].Value = info.Keywords;
paras[5].Value = info.Description;
paras[6].Value = info.OrderID;
MssqlHandler.ExecuteNonQuery(sql, paras);
}
/// <summary>更新实体数据
/// 更新实体数据
/// </summary>
/// <param name="info">表实体模型</param>
public void Update(TopicCategoryInfo info)
{
string sql = string.Format("UPDATE TopicCategory SET FatherID=@FatherID,CateName=@CateName,CateCName=@CateCName,TopicCount=@TopicCount,Keywords=@Keywords,Description=@Description,OrderID=@OrderID where ID={0}", info.ID);
SqlParameter[] paras = {
new SqlParameter("@FatherID", SqlDbType.Int),
new SqlParameter("@CateName", SqlDbType.NVarChar),
new SqlParameter("@CateCName", SqlDbType.NVarChar),
new SqlParameter("@TopicCount", SqlDbType.Int),
new SqlParameter("@Keywords", SqlDbType.NVarChar),
new SqlParameter("@Description", SqlDbType.NVarChar),
new SqlParameter("@OrderID", SqlDbType.Int)
};
paras[0].Value = info.FatherID;
paras[1].Value = info.CateName;
paras[2].Value = info.CateCName;
paras[3].Value = info.TopicCount;
paras[4].Value = info.Keywords;
paras[5].Value = info.Description;
paras[6].Value = info.OrderID;
MssqlHandler.ExecuteNonQuery(sql, paras);
}
