public static List <TRRec> EnumPersonal(int id, DateTime start, int days, string text)
{
List <TRRec> ls = new List <TRRec>();
DateTime end = (new DateTime(start.Year, start.Month, start.Day)).AddDays(days);
string textflt = "";
if (!string.IsNullOrEmpty(text))
{
textflt = string.Format(" AND CONTAINS({0}, '{1}')", _done, text);
}
string where = string.Format(" WHERE [{0}] = '{1}' AND [{2}] >= '{3}' AND [{2}] <= '{4}' {5} ORDER BY {2} DESC",
_perid,
id,
_dat,
start.ToString(DBHelper.SQLDateFormat),
end.ToString(DBHelper.SQLDateFormat),
textflt);
foreach (DataRow r in (new TRRec()).GetRecords(where))
{
TRRec rec = new TRRec();
rec.Load(r);
ls.Add(rec);
}
return(ls);
}
public static List <TRRec> Enum(DateTime[] d)
{
List <TRRec> ls = new List <TRRec>();
if (d.Length < 1)
{
return(ls);
}
string where = "";
foreach (var date in d)
{
if (!string.IsNullOrEmpty(where))
{
where += " OR ";
}
else
{
where = " WHERE ";
}
where += string.Format(" [{0}] = '{1}' ", _dat, date.ToString(DBHelper.SQLDateFormat));
}
foreach (DataRow r in (new TRRec()).GetRecords(where))
{
TRRec rec = new TRRec();
rec.Load(r);
ls.Add(rec);
}
return(ls);
}