public PageResult <TReturn> QueryPage <TReturn>(SQLName name, int pageindex, int pageSize, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default) { var(countSql, querySql) = GetPagingSQL(name); return(QueryPage <TReturn>(countSql, querySql, pageindex, pageSize, param, commandTimeout, enableCache, cacheExpire, cacheKey)); }
protected void Page_Load(object sender, EventArgs e) { DataView DataFarm = (DataView)SQLName.Select(DataSourceSelectArguments.Empty); foreach (DataRowView DataFarmSQL in DataFarm) { lblfarm.Text = DataFarmSQL["Farm"].ToString(); } DataView DataDate = (DataView)SQLDate.Select(DataSourceSelectArguments.Empty); foreach (DataRowView DataFarmSQL in DataDate) { lblDate.Text = DataFarmSQL["Date"].ToString(); } DataView DataAssessor = (DataView)SQLAssessor.Select(DataSourceSelectArguments.Empty); foreach (DataRowView DataFarmSQL in DataAssessor) { lblAssessor.Text = DataFarmSQL["Assessor"].ToString(); } DataView DataPage = (DataView)SQLPage.Select(DataSourceSelectArguments.Empty); foreach (DataRowView DataFarmSQL in DataPage) { lblPage.Text = DataFarmSQL["Page"].ToString(); } }
public TReturn ExecuteScalar <TReturn>(SQLName name, object param = null, int?commandTimeout = null, CommandType?commandType = null) { return(ExecuteScalar <TReturn>(GetSQL(name), param, commandTimeout, commandType)); }
public int Execute(SQLName name, object param = null, int?commandTimeout = null, CommandType?commandType = null) { return(Execute(GetSQL(name), param, commandTimeout, commandType)); }
public List <dynamic> QueryPlainPage(SQLName name, int pageindex, int pageSize, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default) { return(QueryPlainPage(GetSQL(name), pageindex, pageSize, pageSize, commandTimeout, enableCache, cacheExpire, cacheKey)); }
public IDataReader ExecuteReader(SQLName name, object param = null, int?commandTimeout = null, CommandType?commandType = null) { return(ExecuteReader(GetSQL(name), param, commandTimeout, commandType)); }
public void QueryMultiple(SQLName name, Action <SqlMapper.GridReader> reader, object param = null, int?commandTimeout = null, CommandType?commandType = null) { QueryMultiple(GetSQL(name), reader, param, commandTimeout, commandType); }
public TReturn QuerySingleOrDefault <TReturn>(SQLName name, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null) { return(QuerySingleOrDefault <TReturn>(GetSQL(name), param, commandTimeout, enableCache, cacheExpire, cacheKey, commandType)); }
public List <dynamic> Query(SQLName name, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null, bool buffered = true) { return(Query(GetSQL(name), param, commandTimeout, enableCache, cacheExpire, cacheKey, commandType, buffered)); }
public List <TReturn> Query <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn>(SQLName name, Func <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn> map, object param = null, string splitOn = "Id", int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null, bool buffered = true) { return(Query(GetSQL(name), map, param, splitOn, commandTimeout, enableCache, cacheExpire, cacheKey, commandType, buffered)); }
public async Task <List <TReturn> > QueryAsync <TFirst, TSecond, TReturn>(SQLName name, Func <TFirst, TSecond, TReturn> map, object param = null, string splitOn = "Id", int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null, bool buffered = true) { return(await QueryAsync(GetSQL(name), map, param, splitOn, commandTimeout, enableCache, cacheExpire, cacheKey, commandType, buffered)); }
public async Task QueryMultipleAsync(SQLName name, Action <SqlMapper.GridReader> reader, object param = null, int?commandTimeout = null, CommandType?commandType = null) { await QueryMultipleAsync(GetSQL(name), reader, param, commandTimeout, commandType); }
public async Task <List <TReturn> > QueryAsync <TReturn>(SQLName name, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null) { return(await QueryAsync <TReturn>(GetSQL(name), param, commandTimeout, enableCache, cacheExpire, cacheKey, commandType)); }
public virtual async Task <dynamic> QuerySingleOrDefaultAsync(SQLName name, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null) { return(await QuerySingleOrDefaultAsync(GetSQL(name), param, commandTimeout, enableCache, cacheExpire, cacheKey, commandType)); }
public virtual dynamic QueryFirstOrDefault(SQLName name, object param = null, int?commandTimeout = null, bool?enableCache = default, TimeSpan?cacheExpire = default, string cacheKey = default, CommandType?commandType = null) { return(QueryFirstOrDefault(GetSQL(name), param, commandTimeout, enableCache, cacheExpire, cacheKey, commandType)); }