/// <summary> /// Get statics /// </summary> /// <param name="Tag"></param> /// <param name="osb"></param> /// <returns></returns> private DataSet _GetStatics(string Tag, OrderStaticsBy osb) { StringBuilder str = new StringBuilder(); str.Append("SELECT *"); str.Append(" FROM [tbl_static]"); str.Append(" WHERE [tag] = '" + Tag + "'"); switch (osb) { case OrderStaticsBy.Undefined: str.Append(" ORDER BY [value] ASC"); break; case OrderStaticsBy.ValueASC: str.Append(" ORDER BY [value] ASC"); break; case OrderStaticsBy.ValueDESC: str.Append(" ORDER BY [value] DESC"); break; case OrderStaticsBy.ContentASC: str.Append(" ORDER BY [content] ASC"); break; case OrderStaticsBy.ContentDESC: str.Append(" ORDER BY [content] DESC"); break; } return(this._db.ExecuteQuery(str.ToString())); }
/// <summary> /// Get a arraylist of static items /// </summary> /// <param name="Tag"></param> /// <param name="osb"></param> /// <returns></returns> public List <Static> GetStaticItemList(string Tag, OrderStaticsBy osb) { List <Static> arr = new List <Static>(); DataSet dsData = this._GetStatics(Tag, osb); if (dsData.Tables[0].Rows.Count > 0) { DataTableReader oDT = dsData.CreateDataReader(); while (oDT.Read()) { Static stc = this._FillStaticFromTableReader(oDT); arr.Add(stc); } } return(arr); }
/// <summary> /// Get statics /// </summary> /// <param name="Tag"></param> /// <param name="osb"></param> /// <returns></returns> private DataSet _GetStatics(string Tag, OrderStaticsBy osb) { StringBuilder str = new StringBuilder(); str.Append("SELECT *"); str.Append(" FROM [tbl_static]"); str.Append(" WHERE [tag] = '" + Tag + "'"); switch(osb) { case OrderStaticsBy.Undefined: str.Append(" ORDER BY [value] ASC"); break; case OrderStaticsBy.ValueASC: str.Append(" ORDER BY [value] ASC"); break; case OrderStaticsBy.ValueDESC: str.Append(" ORDER BY [value] DESC"); break; case OrderStaticsBy.ContentASC: str.Append(" ORDER BY [content] ASC"); break; case OrderStaticsBy.ContentDESC: str.Append(" ORDER BY [content] DESC"); break; } return this._db.ExecuteQuery(str.ToString()); }
/// <summary> /// Get a arraylist of static items /// </summary> /// <param name="Tag"></param> /// <param name="osb"></param> /// <returns></returns> public List<Static> GetStaticItemList(string Tag, OrderStaticsBy osb) { List<Static> arr = new List<Static>(); DataSet dsData = this._GetStatics(Tag, osb); if(dsData.Tables[0].Rows.Count > 0) { DataTableReader oDT = dsData.CreateDataReader(); while(oDT.Read()) { Static stc = this._FillStaticFromTableReader(oDT); arr.Add(stc); } } return arr; }