public List <Local> GetLocals() { var query = "select * from Locals"; var res = queryExecutor.Execute(query); var ret = new List <Local>(); for (int i = 0; i < res.Count; i++) { var record = res[i] as Hashtable; var toAdd = new Local(record); ret.Add(toAdd); } return(ret); }
public List <ExportData> GetExportData(ReportFilterModel reportFilterModel) { var ret = new List <ExportData>(); var fromStr = reportFilterModel.From.ToString("dd/MM/yyyy"); var toStr = reportFilterModel.To.ToString("dd/MM/yyyy"); var query = $@"set dateformat dmy select ed.Id, ed.ExportName, ed.ExportDate, ed.UserFullName, l.Name from ExportData ed left join Locals l on ed.LocalId = l.Id where l.Id = {reportFilterModel.LocalId} and ed.ExportDate between '{fromStr}' and '{toStr}'"; var res = DbExecutor.Execute(query); for (int i = 0; i < res.Count; i++) { var ht = res[i] as Hashtable; var toAdd = new ExportData(ht); ret.Add(toAdd); } return(ret); }