/// <summary>
/// 获取推广类型实体
/// </summary>
/// <param name="id">主键ID</param>
/// <returns>推广类型实体</returns>
public virtual EyouSoft.Model.CompanyStructure.TourStateBase GetModel(int id)
{
EyouSoft.Model.CompanyStructure.TourStateBase model = null;
string strSql = SQL_TourStateBase_SELECT;
if (id > 0)
{
strSql += " WHERE ID=@ID";
}
DbCommand dc = this._database.GetSqlStringCommand(strSql);
this._database.AddInParameter(dc, "ID", DbType.Int32, id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.CompanyStructure.TourStateBase();
model.ID = dr.GetInt32(0);
model.CompanyID = dr.GetString(1);
model.TypeID = dr.GetByte(2);
model.PromoText = dr.GetString(3);
model.PromoTextHTML = string.Format("<a href=\"javascript:void(0)\" class=\"state{0}\"><nobr>{1}</nobr></a>", (int)model.TypeID, model.PromoText);
}
}
return(model);
}
/// <summary>
/// 获取指定公司的所有推广类型
/// </summary>
/// <param name="CompanyID">公司编号</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CompanyStructure.TourStateBase> GetList(string CompanyID)
{
IList <EyouSoft.Model.CompanyStructure.TourStateBase> list = new List <EyouSoft.Model.CompanyStructure.TourStateBase>();
string strSql = SQL_TourStateBase_SELECT;
if (!string.IsNullOrEmpty(CompanyID))
{
strSql += " WHERE CompanyID=@CompanyID";
}
DbCommand dc = this._database.GetSqlStringCommand(strSql);
this._database.AddInParameter(dc, "CompanyID", DbType.String, CompanyID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.CompanyStructure.TourStateBase model = new EyouSoft.Model.CompanyStructure.TourStateBase();
model.ID = dr.GetInt32(0);
model.CompanyID = dr.GetString(1);
model.TypeID = dr.GetByte(2);
model.PromoText = dr.GetString(3);
model.PromoTextHTML = string.Format("<a href=\"javascript:void(0)\" class=\"state{0}\"><nobr>{1}</nobr></a>", (int)model.TypeID, model.PromoText);
list.Add(model);
model = null;
}
}
return(list);
}
