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