public static List <viewPageViewCount> SelectWhere(Columns.ColumnNames Column, Equals Equals, Object Value) { string strSQL = "SELECT [PageID], [SumOfViewCount] FROM [viewPageViewCount]"; strSQL += " WHERE "; if (Equals == Equals.EqualTo) { strSQL += Columns.GetColumnName(Column); } if (Equals == Equals.NotEquals) { strSQL += "NOT " + Columns.GetColumnName(Column); } if (Value.GetType() == typeof(string)) { Value.ToString().Replace("*", "%"); strSQL += " LIKE "; } else { strSQL += " = "; } strSQL += "@SearchValue1"; Dictionary <Columns.ColumnNames, Object> Parameters = new Dictionary <Columns.ColumnNames, Object>(); Parameters.Add(Column, Value); return(SelectRows(strSQL, Parameters)); }
public static List <viewPageViewCount> SelectWhere(Columns.ColumnNames Column, Equals Equals, Object Value, Columns.ColumnNames Column2, Equals Equals2, Object Value2, Columns.ColumnNames SortByColumn, Sorting SortOrder) { string strSQL = "SELECT [PageID], [SumOfViewCount] FROM [viewPageViewCount]"; strSQL += " WHERE "; if (Equals == Equals.EqualTo) { strSQL += Columns.GetColumnName(Column); } if (Equals == Equals.NotEquals) { strSQL += "NOT " + Columns.GetColumnName(Column); } if (Value.GetType() == typeof(string)) { Value.ToString().Replace("*", "%"); strSQL += " LIKE "; } else { strSQL += " = "; } strSQL += "@SearchValue1"; strSQL += " AND "; if (Equals2 == Equals.EqualTo) { strSQL += Columns.GetColumnName(Column2); } if (Equals2 == Equals.NotEquals) { strSQL += "NOT " + Columns.GetColumnName(Column2); } if (Value.GetType() == typeof(string)) { Value2.ToString().Replace("*", "%"); strSQL += " LIKE "; } else { strSQL += " = "; } strSQL += "@SearchValue2"; strSQL += " ORDER BY " + SortByColumn; if (SortOrder == Sorting.Ascending) { strSQL += " ASC"; } if (SortOrder == Sorting.Descending) { strSQL += " DESC"; } Dictionary <Columns.ColumnNames, Object> Parameters = new Dictionary <Columns.ColumnNames, Object>(); Parameters.Add(Column, Value); Parameters.Add(Column2, Value2); ; return(SelectRows(strSQL, Parameters)); }
public static List <viewPageViewCount> SelectAll(Columns.ColumnNames Column, Sorting SortOrder) { string strSQL = SelectBaseSQL(); strSQL += " ORDER BY " + Column; if (SortOrder == Sorting.Ascending) { strSQL += " ASC"; } if (SortOrder == Sorting.Descending) { strSQL += " DESC"; } return(SelectRows(strSQL, null)); }