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); }