/// <summary> /// /// </summary> /// <param name="sql"></param> /// <returns></returns> public ResponseSet <UploadFile> GetList(string sql) { Response <DataTable> result = SqLiteHelper.ExecuteDataTable(sql); if (!result.Success) { return(new ResponseSet <UploadFile> { Errors = result.Errors }); } if (result.Data == null || result.Data.Rows.Count <= 0) { return(new ResponseSet <UploadFile> { Errors = "No Data" }); } ObservableCollection <UploadFile> datas = new ObservableCollection <UploadFile>(); result.Data.Rows.Cast <DataRow>().ToList().ForEach(x => datas.Add(x)); return(new ResponseSet <UploadFile> { Datas = datas }); }
/// <summary> /// /// </summary> /// <param name="sql"></param> /// <returns></returns> public Response <UploadFile> SingleOrDefault(string sql) { Response <DataTable> result = SqLiteHelper.ExecuteDataTable(sql); if (!result.Success) { return(new Response <UploadFile> { Errors = result.Errors }); } if (result.Data == null || result.Data.Rows.Count <= 0) { return(new Response <UploadFile> { Errors = "No Data" }); } return(new Response <UploadFile> { Data = result.Data.Rows.Cast <DataRow>().FirstOrDefault() }); }