/// <summary>
/// 获取栏目信息
/// </summary>
/// <param name="id">栏目Id</param>
/// <returns>栏目数据对象</returns>
public Model.User.UserNewsTitleInfo GetItem(int Id)
{
XYECOM.Model.User.UserNewsTitleInfo info = new Model.User.UserNewsTitleInfo();
SqlParameter[] parame = new SqlParameter[]
{
new SqlParameter("@Id",Id)
};
string sql = "select * from XY_UserNewsTitleInfo where Id = @Id";
using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, parame))
{
if (reader.Read())
{
info.Id = Core.MyConvert.GetInt32(reader["Id"].ToString());
info.Name = reader["Name"].ToString();
info.UserId = reader["UserId"].ToString();
info.OrderId = Core.MyConvert.GetInt32(reader["OrderId"].ToString());
info.ParentId = Core.MyConvert.GetInt32(reader["ParentId"].ToString());
}
}
return info;
}
/// <summary>
/// 获取多条记录
/// </summary>
/// <returns>多条记录</returns>
public List<Model.User.UserNewsTitleInfo> SelectPId()
{
XYECOM.Model.User.UserNewsTitleInfo info = new Model.User.UserNewsTitleInfo();
List<Model.User.UserNewsTitleInfo> infos = new List<Model.User.UserNewsTitleInfo>();
string sql = "select * from XY_UserNewsTitleInfo where ParentId = '0'";
DataTable Table = SqlHelper.ExecuteTable(sql);
DataRow[] rows = Table.Select();
foreach (DataRow row in rows)
{
info.Id = Core.MyConvert.GetInt32(row["Id"].ToString());
info.Name = row["Name"].ToString();
info.UserId = row["UserId"].ToString();
info.OrderId = Core.MyConvert.GetInt32(row["OrderId"].ToString());
info.ParentId = Core.MyConvert.GetInt32(row["ParentId"].ToString());
infos.Add(info);
}
return infos;
}
