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