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