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