public async Task <List <T> > FindListBySql <T>(string sql)
{
var dataSet = await dbHelper.Query(sql);
var dataTable = dataSet.Tables[0];
var model = DataTableToEntityHelper.ToEntityList <T>(dataTable);
return(model);
}
public async Task <T> GetBySql <T>(string sql) where T : class, new()
{
var dataSet = await dbHelper.Query(sql);
var dataTable = dataSet.Tables[0];
var model = DataTableToEntityHelper.ToEntity <T>(dataTable);
return(model);
}
public async Task <T> Find <T>(string where)
{
var sql = EntityToSql.SelectSql <TEntity>(where);
var dataSet = await dbHelper.Query(sql);
var dataTable = dataSet.Tables[0];
var model = DataTableToEntityHelper.ToEntity <T>(dataTable);
return(model);
}
public async Task <JqGridModel <T> > FindListPager <T>(string str, JqgridParam param)
{
JqGridModel <T> resultModel = new JqGridModel <T>();
var skip = (param.page - 1) * param.rows;
string sql = string.Format(SqlPagerTempalte(str, skip, param.rows));
var ds = await dbHelper.Query(sql);
var dt = ds.Tables[0];
var entities = DataTableToEntityHelper.ToEntityList <T>(dt);
string countSql = string.Format(TotalCountSqlTemplate(), str);
resultModel.records = int.Parse((await dbHelper.GetSingle(countSql)).ToString());
resultModel.total = resultModel.records % param.rows == 0 ? resultModel.records / param.rows : resultModel.records / param.rows + 1;
resultModel.rows = entities.ToList();
resultModel.page = param.page;
return(resultModel);
}
