private String SortByExpired(string query) { //TODO join item table to get item name and sort by name string datenow = new LimitC().DatePastMonth(); return("select * from episode where " + query + " and " + EXPIRE + " <= '" + datenow + "' order by " + EXPIRE); }
private string SortThreeMonths(string qeury) { LimitC lim = new LimitC(); return(string.Format("select * from episode where {0} and expire >= '{1}' and expire <= '{2}' order by {3}", qeury, lim.DateNow(), lim.Date3Month(), EXPIRE)); }