/// <summary>
/// 根据应用实例获取个人任务SQL
/// </summary>
/// <param name="sql">SQL</param>
/// <returns>SQL</returns>
public static string GetSqlTaskOfMineByAppInstance(string sql)
{
IWfDataProvider dataProvider = DataProviderFactory.GetProvider();
if (dataProvider != null)
{
return(dataProvider.GetSqlTaskOfMineByAppInstance(sql));
}
else
{
return(sql);
}
}
/// <summary>
/// 任务分页SQL语句
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>SQL语句</returns>
public static string GetSqlTaskPaged(string sql)
{
IWfDataProvider dataProvider = DataProviderFactory.GetProvider();
if (dataProvider != null)
{
return(dataProvider.GetSqlTaskPaged(sql));
}
else
{
return(sql);
}
}
/// <summary>
/// 设置数据库类型变量
/// </summary>
/// <param name="type">数据库类型</param>
/// <param name="provider">数据提供者</param>
public static void SetDBType(DBTypeEnum type, IWfDataProvider provider = null)
{
dbType = type;
wfDataProvider = provider;
if (type == DBTypeEnum.SQLSERVER)
{
//默认实现为SQLSERVER
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.SqlServerDialect();
}
else if (type == DBTypeEnum.ORACLE)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.OracleSqlDialect();
}
else if (type == DBTypeEnum.MYSQL)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.MySqlDialect();
}
else if (type == DBTypeEnum.KINGBASE)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.KingbaseSqlDialect();
}
}
/// <summary>
/// 设置数据库类型变量
/// </summary>
/// <param name="type"></param>
/// <param name="provider"></param>
public static void SetDBType(DBTypeEnum type, IWfDataProvider provider)
{
dbType = type;
wfDataProvider = provider;
}
