/// <summary>
/// 根据编号获取关键字/tag对象
/// </summary>
/// <param name="id">编号</param>
/// <param name="cate">类别</param>
/// <returns></returns>
public EyouSoft.Model.NewsStructure.TagKeyInfo GetModel(int id, EyouSoft.Model.NewsStructure.ItemCategory cate)
{
DbCommand comm = this._db.GetSqlStringCommand(SQL_TagKeyInfo_Select);
this._db.AddInParameter(comm, "@id", DbType.Int32, id);
this._db.AddInParameter(comm, "@cate", DbType.Int32, (int)cate);
using (IDataReader dr = DbHelper.ExecuteReader(comm, this._db))
{
if (dr.Read())
{
EyouSoft.Model.NewsStructure.TagKeyInfo model = new EyouSoft.Model.NewsStructure.TagKeyInfo();
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
model.Category = (EyouSoft.Model.NewsStructure.ItemCategory) int.Parse(dr[dr.GetOrdinal("Category")].ToString());
model.ItemName = dr.IsDBNull(dr.GetOrdinal("ItemName")) ? string.Empty : dr[dr.GetOrdinal("ItemName")].ToString();
model.ItemUrl = dr.IsDBNull(dr.GetOrdinal("ItemUrl")) ? string.Empty : dr[dr.GetOrdinal("ItemUrl")].ToString();
model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
return(model);
}
}
return(null);
}
/// <summary>
/// 是否存在同名项目
/// </summary>
/// <param name="ItemName">项目名称</param>
/// <param name="Id">主键编号</param>
/// <param name="Category">类别</param>
/// <returns>true:存在 false:不存在</returns>
public bool IsExists(string ItemName, int Id, EyouSoft.Model.NewsStructure.ItemCategory Category)
{
StringBuilder strSql = new StringBuilder(SQL_TagKeyInfo_Exists);
if (!string.IsNullOrEmpty(ItemName))
{
strSql.AppendFormat(" and ItemName='{0}' ", ItemName);
}
strSql.AppendFormat(" and Id<>{0} ", Id);
strSql.AppendFormat(" and Category={0} ", (int)Category);
DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString());
return(DbHelper.Exists(dc, this._db));
}
/// <summary>
/// 根据编号获取关键字/tag对象
/// </summary>
/// <param name="id">编号</param>
/// <param name="cate">类别</param>
/// <returns></returns>
public EyouSoft.Model.NewsStructure.TagKeyInfo GetModel(int id, EyouSoft.Model.NewsStructure.ItemCategory cate)
{
return(dal.GetModel(id, cate));
}
