private bool InEntityTransactionTest(string mainId,string detailId)
{
    //可以支持任意流行數(shù)據(jù)庫類型，指定相關(guān)的數(shù)據(jù)庫提供者即可（OracleProvider、SqlProvider、SqLiteProvider、MySqlProvider、DB2Provider、OleDbProvider）
    IDbProvider dbProvider = new OracleProvider(SystemInfo.BusinessDbConnectionString);
    bool result = true;
    try
    {
        dbProvider.BeginTransaction();
        //主表
        CASE_PRODUCTIN_MAINManager manager = new CASE_PRODUCTIN_MAINManager(dbProvider, Utils.UserInfo);
        CASE_PRODUCTIN_MAINEntity mainEntity = manager.GetEntity(dbProvider.SqlSafe(mainId));
        manager.Delete(mainEntity);
        //子表
        CASE_PRODUCTIN_DETAILManager detailManager = new CASE_PRODUCTIN_DETAILManager(dbProvider, Utils.UserInfo);
        CASE_PRODUCTIN_DETAILEntity detailEntity = detailManager.GetEntity(dbProvider.SqlSafe(detailId));
        detailManager.Delete(detailEntity);
        //事務(wù)提交　
        dbProvider.CommitTransaction();
    }
    catch (Exception ex)
    {
        //事務(wù)回滾
        dbProvider.RollbackTransaction();
        result = false;
    }
    return result;
}

private bool InSqlTransactionTest(string mainId, string detailId)
        {
            //可以支持任意流行數(shù)據(jù)庫類型，指定相關(guān)的數(shù)據(jù)庫提供者即可（OracleProvider、SqlProvider、SqLiteProvider、MySqlProvider、DB2Provider、OleDbProvider）

            IDbProvider dbProvider = new SqlProvider(SystemInfo.BusinessDbConnectionString);
            bool result = true;
            try
            {
                dbProvider.BeginTransaction();
                //主表
                string sqlMain = string.Format("DELETE FROM CASE_PRODUCTIN_MAIN WHERE ID = {0}", mainId);
                dbProvider.ExecuteNonQuery(sqlMain);
                //子表
                string sqlDetail = string.Format("DELETE FROM CASE_PRODUCTIN_DETAIL WHERE ID = {0}", detailId);
                dbProvider.ExecuteNonQuery(sqlMain);
                //事務(wù)提交　
                dbProvider.CommitTransaction();
            }
            catch (Exception ex)
            {
                //事務(wù)回滾
                dbProvider.RollbackTransaction();
                result = false;
            }
            return result;
        }