/// <summary>
/// 定义仓储（基础库）
/// </summary>
/// <returns></returns>
public IRepository <T> BaseRepository(DatabaseLinksEnum links = DatabaseLinksEnum.Base)
{
switch (links)
{
case DatabaseLinksEnum.Base:
return(new Repository <T>(DbFactory.Base()));
case DatabaseLinksEnum.InformationBase:
return(new Repository <T>(DbFactory.Base(GlobalStaticConstant.DB_LINK_INFORMATION_BASE, DatabaseType.SqlServer)));
case DatabaseLinksEnum.GalleryBase:
return(new Repository <T>(DbFactory.Base(GlobalStaticConstant.DB_LINK_GALLERY_BASE, DatabaseType.SqlServer)));
case DatabaseLinksEnum.CP55128:
return(new Repository <T>(DbFactory.Base(GlobalStaticConstant.DB_LINK_CP55128_BASE, DatabaseType.SqlServer)));
case DatabaseLinksEnum.CB55128:
return(new Repository <T>(DbFactory.Base(GlobalStaticConstant.DB_LINK_CB55128_BASE, DatabaseType.SqlServer)));
case DatabaseLinksEnum.LotteryNumber:
return(new Repository <T>(DbFactory.Base(GlobalStaticConstant.DB_LINK_LOTTERY_NUMBER_BASE, DatabaseType.SqlServer)));
default:
return(new Repository <T>(DbFactory.Base()));
}
}
/// <summary>
/// 定义仓储（基础库）
/// </summary>
/// <returns></returns>
protected IRepository BaseRepository(DatabaseLinksEnum link = DatabaseLinksEnum.Base)
{
switch (link)
{
case DatabaseLinksEnum.Base:
return(new Repository(DbFactory.Base()));
default:
return(new Repository(DbFactory.Base()));
}
}
private Bill.Repository.IRepository.IRepository BaseRepository(DatabaseLinksEnum link = DatabaseLinksEnum.SqlService)
{
switch (link)
{
case DatabaseLinksEnum.SqlService:
return(new Repository(DbFactory.Base()));
default:
return(Nested.sqlRepository);
}
}
/// <summary>
/// 定义仓储（基础库）
/// </summary>
/// <returns></returns>
public IRepository <T> BaseRepository(DatabaseLinksEnum link = DatabaseLinksEnum.Base)
{
switch (link)
{
case DatabaseLinksEnum.Base:
return(new Repository <T>(DbFactory.Base()));
default:
return(new Repository <T>(DbFactory.Base()));
}
}
/// <summary>
/// 获取分页DataTable
/// </summary>
/// <param name="strSql">T-SQL语句</param>
/// <param name="orderField">排序字段</param>
/// <param name="isAsc">是否升序</param>
/// <param name="pageSize">每页条数</param>
/// <param name="pageIndex">索引</param>
/// <param name="total">总记录</param>
/// <returns></returns>
public DataTable FindTable(string strSql, string orderField, bool isAsc, int pageSize, int pageIndex, out int total, DatabaseLinksEnum links = DatabaseLinksEnum.LotteryNumber)
{
DataTable data = this.BaseRepository(links).FindTable(strSql, orderField, isAsc, pageSize, pageIndex, out int totalRows);
total = totalRows;
return(data);
}
/// <summary>
/// 执行SQL
/// </summary>
/// <param name="sql"></param>
/// <param name="links">使用哪一个数据库</param>
/// <returns></returns>
public DataTable ExcuteSqlDataTable(string sql, DatabaseLinksEnum links = DatabaseLinksEnum.LotteryNumber, params DbParameter[] dbParameter)
{
return(this.BaseRepository(links).FindTable(sql, dbParameter));
}
/// <summary>
/// 获取分页DataTable
/// </summary>
/// <param name="strSql">T-SQL语句</param>
/// <param name="orderField">排序字段</param>
/// <param name="isAsc">是否升序</param>
/// <param name="pageSize">每页条数</param>
/// <param name="pageIndex">索引</param>
/// <param name="total">总记录</param>
/// <returns></returns>
public DataTable FindPageDataTable(string strSql, string orderField, bool isAsc, int pageSize, int pageIndex, out int total, DatabaseLinksEnum links = DatabaseLinksEnum.LotteryNumber)
{
DataTable data = commonService.FindTable(strSql, orderField, isAsc, pageSize, pageIndex, out int totalRows, links);
total = totalRows;
return(data);
}
/// <summary>
/// 执行SQL
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public DataTable ExcuteSqlDataTable(string sql, DatabaseLinksEnum links = DatabaseLinksEnum.LotteryNumber, params DbParameter[] dbParameter)
{
return(commonService.ExcuteSqlDataTable(sql, links, dbParameter));
}
