public string Select(string sql)
{
JsonResponse resp = new JsonResponse();
try
{
if (string.IsNullOrEmpty(sql))
{
throw new Exception("SQL语句为空");
}
DataTable result = DataHelper.GetDataTableBySql(sql);
if (result.Rows.Count == 0)
{
throw new Exception("未查询到记录");
}
SimpleDataTable table = new SimpleDataTable(result);
resp.Result = true;
resp.Message = "查询成功";
resp.Data = table;
}
catch (Exception ex)
{
resp.Result = false;
resp.Message = ex.Message;
}
return(JsonConvert.SerializeObject(resp));
}
public SimpleDataTable Range(int startRecord, int pageSize)
{
SimpleDataTable result = new SimpleDataTable(columnNames);
for (int i = startRecord; i < (startRecord + pageSize); ++i)
{
result.AppendRow(rows[i]);
}
return(result);
}
public SimpleDataTable Where(Predicate <object[]> func)
{
if (func == null)
{
return(null);
}
SimpleDataTable result = new SimpleDataTable(columnNames);
foreach (object[] objs in rows)
{
if (func(objs))
{
result.AppendRow(objs);
}
}
return(result);
}
public string ShowTableList()
{
JsonResponse resp = new JsonResponse();
try
{
DataTable result = DataHelper.GetDataTableBySql("select name from sqlite_master where type='table' and name<>'sqlite_sequence'");
if (result.Rows.Count == 0)
{
throw new Exception("未查询到记录");
}
SimpleDataTable table = new SimpleDataTable(result);
resp.Result = true;
resp.Message = "查询成功";
resp.Data = table;
}
catch (Exception ex)
{
resp.Result = false;
resp.Message = ex.Message;
}
return(JsonConvert.SerializeObject(resp));
}
