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