Exemple #1
0
        public void CreateSybaseSystemTable(IDbCommand command)
        {
            frmCreateDB cdb = new frmCreateDB();
            cdb.ShowDialog();

            if (cdb.DialogResult == DialogResult.OK)
            {
                string result = "";

                if (cdb.x == radioType.simplified || cdb.x == radioType.typical)
                {
                    #region Simplifield
                    command.CommandText = "CREATE TABLE COLDEF"
                                                     + "("
                                                     + "TABLE_NAME nvarchar(20) NOT NULL, "
                                                     + "FIELD_NAME nvarchar(20) NOT NULL, "
                                                     + "SEQ NUMERIC(12,0) NULL, "
                                                     + "FIELD_TYPE nvarchar(20) NULL, "
                                                     + "IS_KEY nvarchar(1) NOT NULL, "
                                                     + "FIELD_LENGTH NUMERIC(12,0) NULL, "
                                                     + "CAPTION nvarchar(40) NULL, "
                                                     + "EDITMASK nvarchar(10) NULL, "
                                                     + "NEEDBOX nvarchar(13) NULL, "
                                                     + "CANREPORT nvarchar(1) NULL, "
                                                     + "EXT_MENUID nvarchar(20) NULL, "
                                                     + "FIELD_SCALE NUMERIC(12,0) NULL, "
                                                     + "DD_NAME nvarchar(40) NULL, "
                                                     + "DEFAULT_VALUE nvarchar(100) NULL, "
                                                     + "CHECK_NULL nvarchar(1) NULL, "
                                                     + "QUERYMODE nvarchar(20) NULL, "
                                                     + "CAPTION1 nvarchar(40) NULL, "
                                                     + "CAPTION2 nvarchar(40) NULL, "
                                                     + "CAPTION3 nvarchar(40) NULL, "
                                                     + "CAPTION4 nvarchar(40) NULL, "
                                                     + "CAPTION5 nvarchar(40) NULL, "
                                                     + "CAPTION6 nvarchar(40) NULL, "
                                                     + "CAPTION7 nvarchar(40) NULL, "
                                                     + "CAPTION8 nvarchar(40) NULL, "
                                                     + "PRIMARY KEY(TABLE_NAME,FIELD_NAME)"
                                                     + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create COLDEF table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX TABLENAME ON COLDEF (TABLE_NAME,FIELD_NAME)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX TABLENAME on table COLDEF .\n\r";
                    }

                    command.CommandText = "CREATE TABLE SYSAUTONUM "
                                            + "("
                                            + "AUTOID VARCHAR(20) NOT NULL, "
                                            + "FIXED VARCHAR(20) NOT NULL, "
                                            + "CURRNUM NUMERIC(10,0) NULL, "
                                            + "DESCRIPTION VARCHAR(50) NULL, "
                                            + "PRIMARY KEY (AUTOID,FIXED)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYSAUTONUM table.\n\r";
                    }
                    #endregion

                    #region Typical
                    if (cdb.x == radioType.typical)
                    {
                        //// Create GROUPFORMS
                        //command.CommandText = "CREATE TABLE GROUPFORMS ("
                        //    + "GROUPID nvarchar (20) NOT NULL ,"
                        //    + "PACKAGE_NAME nvarchar (50) NOT NULL ,"
                        //    + "FORM_NAME nvarchar (50) NULL ,"
                        //    + "PARENT_MENU nvarchar (50) NULL "
                        //    + ")";
                        //try
                        //{
                        //    command.ExecuteNonQuery();
                        //}
                        //catch
                        //{
                        //    result += "Can not create GROUPFORMS table.\n\r";
                        //}

                        // Create GROUPMENUS
                        command.CommandText = "CREATE TABLE GROUPMENUS ("
                            + "GROUPID varchar (20) NOT NULL ,"
                            + "MENUID nvarchar (30) NOT NULL, "
                            + "PRIMARY KEY(GROUPID,MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUS table.\n\r";
                        }

                        // Create USERMENUS
                        command.CommandText = "CREATE TABLE USERMENUS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "MENUID nvarchar (30) NOT NULL, "
                            + "PRIMARY KEY(USERID,MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUS table.\n\r";
                        }

                        // Create GROUPS
                        command.CommandText = "CREATE TABLE GROUPS ("
                            + "GROUPID varchar (20) NOT NULL ,"
                            + "GROUPNAME nvarchar (50) NULL ,"
                            + "DESCRIPTION nvarchar (100) NULL ,"
                            + "MSAD nvarchar (1) NULL, "
                            + "ISROLE char(1) NULL,"
                            + "PRIMARY KEY(GROUPID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('00', 'EveryOne', 'N')";
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('01', 'DEPARTMENT1', 'N')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPS table.\n\r";
                        }

                        // Create MENUITEMTYPE
                        command.CommandText = "CREATE TABLE MENUITEMTYPE ("
                            + "ITEMTYPE nvarchar (20) NOT NULL ,"
                            + "ITEMNAME nvarchar (20) NULL, "
                            + "DBALIAS nvarchar (50) NULL,"
                            + "PRIMARY KEY(ITEMTYPE)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUITEMTYPE(ITEMTYPE, ITEMNAME) VALUES('SOLUTION1', 'DEFAULT SOLUTION')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUITEMTYPE table.\n\r";
                        }

                        // Create MENUTABLE
                        command.CommandText = "CREATE TABLE MENUTABLE ("
                            + "MENUID nvarchar (30) NOT NULL ,"
                            + "CAPTION nvarchar (50) NOT NULL ,"
                            + "PARENT nvarchar (20) NULL ,"
                            + "PACKAGE nvarchar (60) NULL ,"
                            + "MODULETYPE nvarchar (1) NULL ,"
                            + "ITEMPARAM nvarchar (200) NULL ,"
                            + "FORM nvarchar (32) NULL ,"
                            + "ISSHOWMODAL nvarchar (1) NULL ,"
                            + "ITEMTYPE nvarchar (20) NULL ,"
                            + "SEQ_NO nvarchar (4) NULL,"
                            + "PACKAGEDATE DateTime NULL,"
                            + "IMAGE image NULL,"
                            + "OWNER nvarchar(20) NULL,"
                            + "ISSERVER nvarchar(1) NULL,"
                            + "VERSIONNO nvarchar(20) NULL,"
                            + "CHECKOUT nvarchar(20) NULL,"
                            + "CHECKOUTDATE datetime NULL,"
                            + "CAPTION0 nvarchar(50) NULL,"
                            + "CAPTION1 nvarchar(50) NULL,"
                            + "CAPTION2 nvarchar(50) NULL,"
                            + "CAPTION3 nvarchar(50) NULL,"
                            + "CAPTION4 nvarchar(50) NULL,"
                            + "CAPTION5 nvarchar(50) NULL,"
                            + "CAPTION6 nvarchar(50) NULL,"
                            + "CAPTION7 nvarchar(50) NULL,"
                            + "IMAGEURL nvarchar(100) NULL, "
                            + "PRIMARY KEY(MENUID)"
                            + ") ";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUTABLE(MENUID, CAPTION, ITEMTYPE, MODULETYPE) VALUES('0', 'ROOT', 'SOLUTION1', 'F')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLE table.\n\r";
                        }

                        // Create USERGROUPS
                        command.CommandText = "CREATE TABLE USERGROUPS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "GROUPID varchar (20) NOT NULL, "
                            + "PRIMARY KEY(USERID,GROUPID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERGROUPS(USERID, GROUPID) VALUES('001', '01')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERGROUPS table.\n\r";
                        }

                        // Create USERS
                        command.CommandText = "CREATE TABLE USERS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "USERNAME nvarchar (30) NULL ,"
                            + "AGENT nvarchar (20) NULL ,"
                            + "PWD nvarchar (10) NULL ,"
                            + "CREATEDATE nvarchar (8) NULL ,"
                            + "CREATER nvarchar (20) NULL ,"
                            + "DESCRIPTION nvarchar (100) NULL ,"
                            + "EMAIL nvarchar (40) NULL ,"
                            + "LASTTIME nvarchar (8) NULL ,"
                            + "AUTOLOGIN nvarchar (1) NULL,"
                            + "LASTDATE nvarchar (8) NULL ,"
                            + "SIGNATURE nvarchar (30) NULL ,"
                            + "MSAD nvarchar (1) NULL, "
                            + "PRIMARY KEY(USERID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERS(USERID, USERNAME, PWD, MSAD, AUTOLOGIN) VALUES('001', 'TEST', '', 'N','S')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERS table.\n\r";
                        }

                        // Create MENUTABLELOG
                        command.CommandText = "CREATE TABLE MENUTABLELOG"
                            + "("
                            + "LOGID numeric(8,0) IDENTITY,"
                            + "MENUID nvarchar(30) not null,"
                            + "PACKAGE nvarchar(20) not null,"
                            + "PACKAGEDATE DATETIME,"
                            + "LASTDATE DATETIME,"
                            + "OWNER nvarchar(20),"
                            + "OLDVERSION IMAGE,"
                            + "OLDDATE nvarchar(20), "
                            + "PRIMARY KEY(LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLELOG table.\n\r";
                        }

                        // Create MENUCHECKLOG
                        command.CommandText = "CREATE TABLE MENUCHECKLOG"
                            + "("
                            + "LOGID numeric(8,0) IDENTITY,"
                            + "ITEMTYPE nvarchar(20) not null,"
                            + "PACKAGE nvarchar(50) not null,"
                            + "PACKAGEDATE DateTime,"
                            + "FILETYPE nvarchar(10),"
                            + "FILENAME nvarchar(60),"
                            + "FILEDATE DateTime,"
                            + "FILECONTENT IMAGE, "
                            + "PRIMARY KEY(LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUCHECKLOG table.\n\r";
                        }

                        // Create SYSEEPLOG
                        command.CommandText = "CREATE TABLE SYSEEPLOG"
                            + "("
                            + "CONNID nvarchar(20) NOT NULL,"
                            + "LOGID numeric(8,0) IDENTITY,"
                            + "LOGSTYLE nvarchar(1) NOT NULL,"
                            + "LOGDATETIME DATETIME NOT NULL,"
                            + "DOMAINID nvarchar(30) NULL,"
                            + "USERID varchar(20) NULL,"
                            + "LOGTYPE nvarchar(1) NULL,"
                            + "TITLE nvarchar(64) NULL,"
                            + "DESCRIPTION nvarchar(128) NULL,"
                            + "COMPUTERIP nvarchar(16) NULL,"
                            + "COMPUTERNAME nvarchar(64) NULL,"
                            + "EXECUTIONTIME INT NULL, "
                            + "PRIMARY KEY(CONNID,LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSEEPLOG table.\n\r";
                        }

                        // Create SYSSQLLOG
                        command.CommandText = "CREATE TABLE SYSSQLLOG("
                             + "LOGSTYLE nvarchar(1),"
                             + "LOGDATETIME datetime,"
                             + "USERID varchar(20),"
                             + "DEVELOPERID varchar(20),"
                             + "DESCRIPTION text,"
                             + "SQLSENTENCE nvarchar(max)"
                             + ");";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSSQLLOG table.\n\r";
                        }

                        // Create SYSERRLOG
                        command.CommandText = "CREATE TABLE SYSERRLOG"
                            + "("
                            + "ERRID numeric(8,0) IDENTITY,"
                            + "USERID varchar(20), "
                            + "MODULENAME nvarchar(30),"
                            + "ERRMESSAGE nvarchar(255),"
                            + "ERRSTACK text,"
                            + "ERRDESCRIP nvarchar(255),"
                            + "ERRDATE DateTime,"
                            + "ERRSCREEN Image,"
                            + "OWNER nvarchar(20),"
                            + "PROCESSDATE DateTime,"
                            + "PRODESCRIP nvarchar(255),"
                            + "STATUS nvarchar(2), "
                            + "PRIMARY KEY(ERRID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSERRLOG table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_LANGUAGE"
                            + "("
                            + "ID numeric(8,0) IDENTITY,"
                            + "IDENTIFICATION nvarchar(80),"
                            + "KEYS nvarchar(80),"
                            + "EN nvarchar(80),"
                            + "CHT nvarchar(80),"
                            + "CHS nvarchar(80),"
                            + "HK nvarchar(80),"
                            + "JA nvarchar(80),"
                            + "KO nvarchar(80),"
                            + "LAN1 nvarchar(80),"
                            + "LAN2 nvarchar(80),"
                            + "PRIMARY KEY(ID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_LANGUAGE table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_MESSENGER"
                            + "("
                            + "USERID varchar(20) NOT NULL,"
                            + "MESSAGE nvarchar(255),"
                            + "PARAS nvarchar(255),"
                            + "SENDTIME nvarchar(14),"
                            + "SENDERID nvarchar(20),"
                            + "RECTIME nvarchar(14),"
                            + "STATUS char(1)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_MESSENGER table.\n\r";
                        }

                        //CreateMenuTableControl
                        command.CommandText = "CREATE TABLE MENUTABLECONTROL"
                                                + "("
                                                + "MENUID varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "DESCRIPTION Varchar (50) NULL, "
                                                + "TYPE Varchar (20) NULL, "
                                                + "PRIMARY KEY(MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLECONTROL table.\n\r";
                        }

                        //CreateGroupMenuControl
                        command.CommandText = "CREATE TABLE GROUPMENUCONTROL"
                                                + "("
                                                + "GROUPID Varchar (20) NOT NULL, "
                                                + "MENUID Varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "TYPE Varchar (20) NULL, "
                                                + "ENABLED CHAR (1) NULL, "
                                                + "VISIBLE CHAR (1) NULL, "
                                                + "ALLOWADD CHAR (1) NULL, "
                                                + "ALLOWUPDATE CHAR (1) NULL, "
                                                + "ALLOWDELETE CHAR (1) NULL, "
                                                + "ALLOWPRINT CHAR (1) NULL, "
                                                + "PRIMARY KEY(GROUPID,MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUCONTROL table.\n\r";
                        }

                        //CreateUserMenuControl
                        command.CommandText = "CREATE TABLE USERMENUCONTROL"
                                                + "("
                                                + "USERID Varchar (20) NOT NULL, "
                                                + "MENUID Varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "TYPE Varchar (20) NULL, "
                                                + "ENABLED CHAR (1) NULL, "
                                                + "VISIBLE CHAR (1) NULL, "
                                                + "ALLOWADD CHAR (1) NULL, "
                                                + "ALLOWUPDATE CHAR (1) NULL, "
                                                + "ALLOWDELETE CHAR (1) NULL, "
                                                + "ALLOWPRINT CHAR (1) NULL, "
                                                + "PRIMARY KEY(USERID,MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUCONTROL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL"
                                            + "("
                                            + "REFVAL_NO Varchar(100) NOT NULL, "
                                            + "DESCRIPTION Varchar(250), "
                                            + "TABLE_NAME Varchar(100), "
                                            + "CAPTION Varchar(100), "
                                            + "DISPLAY_MEMBER Varchar(100), "
                                            + "SELECT_ALIAS Varchar(250), "
                                            + "SELECT_COMMAND Varchar(250), "
                                            + "VALUE_MEMBER Varchar(100), "
                                            + "PRIMARY KEY(REFVAL_NO) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL_D1"
                                            + "("
                                            + "REFVAL_NO Varchar(30) NOT NULL, "
                                            + "FIELD_NAME Varchar(30) NOT NULL, "
                                            + "HEADER_TEXT Varchar(20), "
                                            + "WIDTH numeric(4,0), "
                                            + "PRIMARY KEY(REFVAL_NO, FIELD_NAME) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL_D1 table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE MENUFAVOR"
                                            + "("
                                            + "MENUID nVarchar(30) NOT NULL, "
                                            + "CAPTION nVarchar(50) NOT NULL, "
                                            + "USERID Varchar(20) NOT NULL, "
                                            + "ITEMTYPE nVarchar(20), "
                                            + "GROUPNAME nVarChar(20), "
                                            + "PRIMARY Key (MENUID,USERID)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUFAVOR table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_ANYQUERY"
                                            + "("
                                            + "QUERYID Varchar(20) NOT NULL, "
                                            + "USERID Varchar(20) NOT NULL, "
                                            + "TEMPLATEID Varchar(20) NOT NULL, "
                                            + "TABLENAME Varchar(50), "
                                            + "LASTDATE datetime, "
                                            + "CONTENT text, "
                                            + "PRIMARY Key (QUERYID,USERID,TEMPLATEID)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_ANYQUERY table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REPORT"
                                            + "("
                                            + "REPORTID nVarchar(50) NOT NULL, "
                                            + "FILENAME nVarchar(50) NOT NULL, "
                                            + "REPORTNAME nVarchar(50), "
                                            + "DESCRIPTION nVarchar(50), "
                                            + "FILEPATH nVarchar(50), "
                                            + "OUTPUTMODE nVarchar(20), "
                                            + "HEADERREPEAT nVarchar(5), "
                                            + "HEADERFONT image, "
                                            + "HEADERITEMS image, "
                                            + "FOOTERFONT image, "
                                            + "FOOTERITEMS image, "
                                            + "FIELDFONT image, "
                                            + "FIELDITEMS image, "
                                            + "SETTING image, "
                                            + "FORMAT image, "
                                            + "PARAMETERS image, "
                                            + "IMAGES image, "
                                            + "MAILSETTING image, "
                                            + "DATASOURCE_PROVIDER nVarchar(50),"
                                            + "DATASOURCES image,"
                                            + "CLIENT_QUERY image,"
                                            + "REPORT_TYPE nVarchar(1),"
                                            + "TEMPLATE_DESC nVarchar(50),"
                                            + "PRIMARY Key (REPORTID,FILENAME)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REPORT table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_PERSONAL"
                                           + "("
                                           + "FORMNAME NVARCHAR(60) NOT NULL,"
                                           + "COMPNAME NVARCHAR(30) NOT NULL,"
                                           + "USERID NVARCHAR(20) NOT NULL,"
                                           + "REMARK NVARCHAR(30),"
                                           + "PROPCONTENT TEXT,"
                                           + "CREATEDATE DATETIME,"
                                           + "PRIMARY KEY (FORMNAME,COMPNAME,USERID)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_PERSONAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_EEP_USERS"
                                           + "("
                                           + "USERID NVARCHAR(50) NOT NULL,"
                                           + "USERNAME NVARCHAR(50) NULL,"
                                           + "COMPUTER NVARCHAR(50) NOT NULL,"
                                           + "LOGINTIME NVARCHAR(50),"
                                           + "LASTACTIVETIME NVARCHAR(50),"
                                           + "LOGINCOUNT INT,"
                                           + "PRIMARY KEY (USERID,COMPUTER)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_EEP_USERS table.\n\r";
                        }
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP7m)
                {
                    #region EEP7m
                    command.CommandText = "Alter Table COLDEF add "
                                                      + "DEFAULT_VALUE NVARCHAR(100) NULL, "
                                                      + "CHECK_NULL NVARCHAR(1) NULL, "
                                                      + "QUERYMODE NVARCHAR(20) NULL, "
                                                      + "CAPTION1 NVARCHAR (40), "
                                                      + "CAPTION2 NVARCHAR (40), "
                                                      + "CAPTION3 NVARCHAR (40), "
                                                      + "CAPTION4 NVARCHAR (40), "
                                                      + "CAPTION5 NVARCHAR (40), "
                                                      + "CAPTION6 NVARCHAR (40), "
                                                      + "CAPTION7 NVARCHAR (40), "
                                                      + "CAPTION8 NVARCHAR (40)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPMENUS alter column MENUID nvarchar (30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table GROUPS add MSAD NVARCHAR (1)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS alter column GROUPNAME nvarchar (50)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS alter column DESCRIPTION nvarchar (200)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table MENUTABLE add "
                                           + "MODULETYPE NVARCHAR(1), "
                                           + "PACKAGEDATE DATETIME, "
                                           + "IMAGE IMAGE, "
                                           + "OWNER NVARCHAR(20), "
                                           + "ISSERVER NVARCHAR(1), "
                                           + "VERSIONNO NVARCHAR(20), "
                                           + "CHECKOUT NVARCHAR(20), "
                                           + "CHECKOUTDATE DATETIME, "
                                           + "CAPTION0 NVARCHAR(50), "
                                           + "CAPTION1 NVARCHAR(50), "
                                           + "CAPTION2 NVARCHAR(50), "
                                           + "CAPTION3 NVARCHAR(50), "
                                           + "CAPTION4 NVARCHAR(50), "
                                           + "CAPTION5 NVARCHAR(50), "
                                           + "CAPTION6 NVARCHAR(50), "
                                           + "CAPTION7 NVARCHAR(50), "
                                           + "IMAGEURL NVARCHAR(100)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE alter column MENUID nvarchar(30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE alter column ITEMTYPE nvarchar(20)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table USERMENUS alter column MENUID nvarchar(30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table USERS add "
                                           + "EMAIL NVARCHAR(40), "
                                           + "LASTTIME NVARCHAR(8), "
                                           + "AUTOLOGIN NVARCHAR(1), "
                                           + "LASTDATE NVARCHAR(8), "
                                           + "SIGNATURE NVARCHAR(30), "
                                           + "MSAD NVARCHAR(1)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP2006m)
                {
                    #region EEP2006m
                    command.CommandText = "if exists (select * from sysobjects where id = object_id(N'[MENUFAVOR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)"
                                            + "Alter Table MENUFAVOR ADD GROUPNAME NVARCHAR(20)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "if exists (select * from sysobjects where id = object_id(N'[SYS_ORGLEVEL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)"
                                            + "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "if exists (select * from sysobjects where id = object_id(N'[SYS_TODOLIST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)"
                                            + "ALTER table SYS_TODOLIST  ADD  ATTACHMENTS nVarchar(255)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "if exists (select * from sysobjects where id = object_id(N'[SYS_TODOHIS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)"
                                            + "ALTER table SYS_TODOHIS  ADD  ATTACHMENTS nVarchar(255)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.WorkFlow)
                {
                    #region WorkFlow
                    //GROUPS
                    command.CommandText = "ALTER TABLE GROUPS ADD ISROLE CHAR(1) NULL";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not add ISROLE column to GROUPS table.\n\r";
                    }

                    // SYS_ORG
                    command.CommandText = "CREATE TABLE SYS_ORG(" +
                                        "ORG_NO nvarchar(8) NOT NULL," +
                                        "ORG_DESC nvarchar(40) NOT NULL," +
                                        "ORG_KIND nvarchar(4) NOT NULL," +
                                        "UPPER_ORG nvarchar(8) NULL," +
                                        "ORG_MAN nvarchar(20) NOT NULL," +
                                        "LEVEL_NO nvarchar(6) NOT NULL," +
                                        "ORG_TREE nvarchar(40) NULL," +
                                        "END_ORG nvarchar(4) NULL," +
                                        "ORG_FULLNAME nvarchar(254) NULL," +
                                        "PRIMARY KEY(ORG_NO)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORG(ORG_NO,ORG_DESC,ORG_KIND,ORG_MAN,LEVEL_NO) Values ('1','總公司','0','001','9')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORG table.\n\r";
                    }

                    // SYS_ORGKIND
                    command.CommandText = "CREATE TABLE SYS_ORGKIND(" +
                                        "ORG_KIND nvarchar(4) NOT NULL," +
                                        "KIND_DESC nvarchar(40) NOT NULL," +
                                        "PRIMARY KEY(ORG_KIND)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORGKIND(ORG_KIND,KIND_DESC) Values ('0','公司組織')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGKIND table.\n\r";
                    }

                    // SYS_ORGLEVEL
                    command.CommandText = "CREATE TABLE SYS_ORGLEVEL(" +
                                        "LEVEL_NO nvarchar(6) NOT NULL," +
                                        "LEVEL_DESC nvarchar(40) NOT NULL," +
                                        "PRIMARY KEY(LEVEL_NO)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('1','主任/課長/副理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('2','經理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('3','副總')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('9','總經理')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGLEVEL table.\n\r";
                    }

                    // SYS_ORGROLES
                    command.CommandText = "CREATE TABLE SYS_ORGROLES(" +
                                        "ORG_NO nvarchar(8) NOT NULL," +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "ORG_KIND nvarchar(4) NULL," +
                                        "PRIMARY KEY(ORG_NO,ROLE_ID)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGROLES table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ORGNO ON SYS_ORGROLES (ORG_NO, ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX ORGNO on table SYS_ORGROLES .\n\r";
                    }

                    // SYS_ROLES_AGENT
                    command.CommandText = "CREATE TABLE SYS_ROLES_AGENT(" +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "AGENT nvarchar(20) NOT NULL," +
                                        "FLOW_DESC nvarchar(40) NOT NULL," +
                                        "START_DATE nvarchar(8) NOT NULL," +
                                        "START_TIME nvarchar(6) NULL," +
                                        "END_DATE nvarchar(8) NOT NULL," +
                                        "END_TIME nvarchar(6) NULL," +
                                        "PAR_AGENT nvarchar(4) NOT NULL," +
                                        "REMARK nvarchar(254) NULL," +
                                        "PRIMARY KEY(ROLE_ID,AGENT)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ROLES_AGENT table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ROLEID ON SYS_ROLES_AGENT (ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX ROLEID on table SYS_ROLES_AGENT .\n\r";
                    }

                    // SYS_TODOHIS
                    command.CommandText = "CREATE TABLE SYS_TODOHIS(" +
                                        "LISTID nvarchar(40) NOT NULL," +
                                        "FLOW_ID nvarchar(40) NOT NULL," +
                                        "FLOW_DESC nvarchar(40) NULL," +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "S_ROLE_ID varchar(20) NOT NULL," +
                                        "S_STEP_ID nvarchar(20) NOT NULL," +
                                        "D_STEP_ID nvarchar(20) NOT NULL," +
                                        "S_STEP_DESC nvarchar(64) NULL," +
                                        "S_USER_ID nvarchar(20) NOT NULL," +
                                        "USER_ID nvarchar(20) NOT NULL," +
                                        "USERNAME nvarchar(30) NULL," +
                                        "FORM_NAME nvarchar(30) NULL," +
                                        "WEBFORM_NAME nvarchar(50) NOT NULL," +
                                        "S_USERNAME nvarchar(30) NULL," +
                                        "NAVIGATOR_MODE nvarchar(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE nvarchar(2) NOT NULL," +
                                        "PARAMETERS nvarchar(254) NULL," +
                                        "STATUS nvarchar(4) NULL," +
                                        "PROC_TIME decimal(8, 2) NOT NULL," +
                                        "EXP_TIME decimal(8, 2) NOT NULL," +
                                        "TIME_UNIT nvarchar(4) NOT NULL," +
                                        "FLOWIMPORTANT varchar(1) NOT NULL," +
                                        "FLOWURGENT varchar(1) NOT NULL," +
                                        "FORM_TABLE nvarchar(30) NULL," +
                                        "FORM_KEYS nvarchar(254) NULL," +
                                        "FORM_PRESENTATION nvarchar(254) NULL," +
                                        "REMARK nvarchar(254) NULL," +
                                        "VERSION nvarchar(2) NULL," +
                                        "VDSNAME nvarchar(40) NULL," +
                                        "SENDBACKSTEP nvarchar(2) NULL," +
                                        "LEVEL_NO nvarchar(6) NULL," +
                                        "UPDATE_DATE nvarchar(10) NULL," +
                                        "UPDATE_TIME nvarchar(8) NULL," +
                                        "FORM_PRESENT_CT nvarchar(254) NULL," +
                                        "ATTACHMENTS nvarchar(255) NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOHIS table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOHIS (LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX LISTID on table SYS_TODOHIS.\n\r";
                    }

                    command.CommandText = "CREATE INDEX USERID ON SYS_TODOHIS (USER_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX USERID on table SYS_TODOHIS.\n\r";
                    }

                    // SYS_TODOLIST
                    command.CommandText = "CREATE TABLE SYS_TODOLIST(" +
                                        "LISTID nvarchar(40) NOT NULL," +
                                        "FLOW_ID nvarchar(40) NOT NULL," +
                                        "FLOW_DESC nvarchar(40) NULL," +
                                        "APPLICANT nvarchar(20) NOT NULL," +
                                        "S_USER_ID nvarchar(20) NOT NULL," +
                                        "S_STEP_ID nvarchar(20) NOT NULL," +
                                        "S_STEP_DESC nvarchar(64) NULL," +
                                        "D_STEP_ID nvarchar(20) NOT NULL," +
                                        "D_STEP_DESC nvarchar(64) NULL," +
                                        "EXP_TIME decimal(8, 2) NOT NULL," +
                                        "URGENT_TIME decimal(8, 2) NOT NULL," +
                                        "TIME_UNIT nvarchar(4) NOT NULL," +
                                        "USERNAME nvarchar(30) NULL," +
                                        "FORM_NAME nvarchar(30) NULL," +
                                        "NAVIGATOR_MODE nvarchar(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE nvarchar(2) NOT NULL," +
                                        "PARAMETERS nvarchar(254) NULL," +
                                        "SENDTO_KIND nvarchar(4) NOT NULL," +
                                        "SENDTO_ID nvarchar(20) NOT NULL," +
                                        "FLOWIMPORTANT varchar(1) NOT NULL," +
                                        "FLOWURGENT nvarchar(1) NOT NULL," +
                                        "STATUS nvarchar(4) NULL," +
                                        "FORM_TABLE nvarchar(30) NULL," +
                                        "FORM_KEYS nvarchar(254) NULL," +
                                        "FORM_PRESENTATION nvarchar(254) NULL," +
                                        "FORM_PRESENT_CT nvarchar(254) NOT NULL," +
                                        "REMARK nvarchar(254) NULL," +
                                        "PROVIDER_NAME nvarchar(254) NULL," +
                                        "VERSION nvarchar(2) NULL," +
                                        "EMAIL_ADD nvarchar(40) NULL," +
                                        "EMAIL_STATUS varchar(1) NULL," +
                                        "VDSNAME nvarchar(40) NULL," +
                                        "SENDBACKSTEP nvarchar(2) NULL," +
                                        "LEVEL_NO nvarchar(6) NULL," +
                                        "WEBFORM_NAME nvarchar(50) NOT NULL," +
                                        "UPDATE_DATE nvarchar(10) NULL," +
                                        "UPDATE_TIME nvarchar(8) NULL," +
                                        "FLOWPATH nvarchar(100) NOT NULL," +
                                        "PLUSAPPROVE varchar(1) NOT NULL," +
                                        "PLUSROLES nvarchar(254) NOT NULL," +
                                        "MULTISTEPRETURN varchar(1) NULL," +
                                        "SENDTO_NAME nvarchar(30) NULL," +
                                        "ATTACHMENTS nvarchar(255) NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOLIST table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOLIST (LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX LISTID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX SENDTOID ON SYS_TODOLIST (SENDTO_ID, SENDTO_KIND)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX SENDTOID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX FLOWDESC ON SYS_TODOLIST (FLOW_DESC)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX FLOWDESC on table SYS_TODOLIST.\n\r";
                    }

                    // SYS_FLDefinition
                    command.CommandText = "CREATE TABLE SYS_FLDEFINITION"
                                            + "("
                                            + "FLTYPEID nvarchar(50) NOT NULL, "
                                            + "FLTYPENAME nvarchar(200) NOT NULL, "
                                            + "FLDEFINITION text NOT NULL, "
                                            + "VERSION int NULL, "
                                            + "PRIMARY KEY(FLTYPEID) "
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLDEFINITION table.\n\r";
                    }

                    // SYS_FLInstanceState
                    command.CommandText = "CREATE TABLE SYS_FLINSTANCESTATE"
                                            + "("
                                            + "FLINSTANCEID nvarchar(50) NOT NULL, "
                                            + "STATE image NOT NULL, "
                                            + "STATUS int NULL, "
                                            + "INFO nvarchar(200) NULL,"
                                            + "PRIMARY KEY(FLINSTANCEID)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLINSTANCESTATE table.\n\r";
                    }

                    // Sys_ExtApprove
                    command.CommandText = "CREATE TABLE SYS_EXTAPPROVE"
                                            + "("
                                            + "APPROVEID nvarchar(50) NULL, "
                                            + "GROUPID nvarchar(50) NULL, "
                                            + "MINIMUM nvarchar(50) NULL, "
                                            + "MAXIMUM nvarchar(50) NULL,"
                                            + "ROLEID nvarchar(50) NULL"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_EXTAPPROVE table.\n\r";
                    }

                    #endregion
                }

                if (result != "")
                    MessageBox.Show(result);
                else if (cdb.x == radioType.typical)
                    MessageBox.Show("Create all System Tables successfully.");
                else if (cdb.x == radioType.simplified)
                    MessageBox.Show("Create table COLDEF table and table SYSAUTONUM successfully.");
                else if (cdb.x == radioType.EEP7m)
                    MessageBox.Show("Alter successfully.");
                else if (cdb.x == radioType.EEP2006m)
                    MessageBox.Show("EEP 2006 2.1.0.1(SP2) Migration success");
                else if (cdb.x == radioType.WorkFlow)
                    MessageBox.Show("Create WorkFlow Tables successfully.");
            }
        }
Exemple #2
0
        public void CreateDB2SystemTable(IDbCommand command)
        {
            frmCreateDB cdb = new frmCreateDB();
            cdb.ShowDialog();

            if (cdb.DialogResult == DialogResult.OK)
            {
                string result = "";

                if (cdb.x == radioType.simplified || cdb.x == radioType.typical)
                {
                    #region Simplifield
                    command.CommandText = "CREATE TABLE COLDEF"
                                                     + "("
                                                     + "TABLE_NAME varchar(20) NOT NULL, "
                                                     + "FIELD_NAME varchar(20) NOT NULL, "
                                                     + "SEQ decimal(12,0), "
                                                     + "FIELD_TYPE varchar(20), "
                                                     + "IS_KEY varchar(1) NOT NULL, "
                                                     + "FIELD_LENGTH decimal(12,0), "
                                                     + "CAPTION varchar(40), "
                                                     + "EDITMASK varchar(10), "
                                                     + "NEEDBOX varchar(13), "
                                                     + "CANREPORT varchar(1), "
                                                     + "EXT_MENUID varchar(20), "
                                                     + "FIELD_SCALE decimal(12,0), "
                                                     + "DD_NAME varchar(40), "
                                                     + "DEFAULT_VALUE varchar(100), "
                                                     + "CHECK_NULL varchar(1), "
                                                     + "QUERYMODE varchar(20), "
                                                     + "CAPTION1 varchar(40), "
                                                     + "CAPTION2 varchar(40), "
                                                     + "CAPTION3 varchar(40), "
                                                     + "CAPTION4 varchar(40), "
                                                     + "CAPTION5 varchar(40), "
                                                     + "CAPTION6 varchar(40), "
                                                     + "CAPTION7 varchar(40), "
                                                     + "CAPTION8 varchar(40) "
                                                     + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create COLDEF table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX TABLENAME ON COLDEF (TABLE_NAME,FIELD_NAME)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX TABLENAME on table COLDEF .\n\r";
                    }

                    command.CommandText = "CREATE TABLE SYSAUTONUM "
                                            + "("
                                            + "AUTOID VARCHAR(20) NOT NULL, "
                                            + "FIXED VARCHAR(20) NOT NULL, "
                                            + "CURRNUM decimal(10,0), "
                                            + "DESCRIPTION VARCHAR(50),"
                                            + "PRIMARY KEY (AUTOID, FIXED)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYSAUTONUM table.\n\r";
                    }
                    #endregion

                    #region Typical
                    if (cdb.x == radioType.typical)
                    {
                        //// Create GROUPFORMS
                        //command.CommandText = "CREATE TABLE GROUPFORMS ("
                        //    + "GROUPID nvarchar (20) NOT NULL ,"
                        //    + "PACKAGE_NAME nvarchar (50) NOT NULL ,"
                        //    + "FORM_NAME nvarchar (50) NULL ,"
                        //    + "PARENT_MENU nvarchar (50) NULL "
                        //    + ")";
                        //try
                        //{
                        //    command.ExecuteNonQuery();
                        //}
                        //catch
                        //{
                        //    result += "Can not create GROUPFORMS table.\n\r";
                        //}

                        // Create GROUPMENUS
                        command.CommandText = "CREATE TABLE GROUPMENUS ("
                            + "GROUPID varchar (20) NOT NULL ,"
                            + "MENUID varchar (30) NOT NULL ,"
                            + "PRIMARY KEY (GROUPID, MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUS table.\n\r";
                        }

                        // Create USERMENUS
                        command.CommandText = "CREATE TABLE USERMENUS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "MENUID varchar (30) NOT NULL "
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUS table.\n\r";
                        }

                        // Create GROUPS
                        command.CommandText = "CREATE TABLE GROUPS ("
                            + "GROUPID varchar (20) NOT NULL ,"
                            + "GROUPNAME varchar (50),"
                            + "DESCRIPTION varchar (100),"
                            + "MSAD varchar (1),"
                            + "ISROLE char(1) ,"
                            + "PRIMARY KEY (GROUPID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('00', 'EveryOne', 'N')";
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('01', 'DEPARTMENT1', 'N')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPS table.\n\r";
                        }

                        // Create MENUITEMTYPE
                        command.CommandText = "CREATE TABLE MENUITEMTYPE ("
                            + "ITEMTYPE varchar (20) NOT NULL ,"
                            + "ITEMNAME varchar (20),"
                            + "DBALIAS varchar (50) "
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUITEMTYPE(ITEMTYPE, ITEMNAME) VALUES('SOLUTION1', 'DEFAULT SOLUTION')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUITEMTYPE table.\n\r";
                        }

                        // Create MENUTABLE
                        command.CommandText = "CREATE TABLE MENUTABLE ("
                            + "MENUID varchar (30) NOT NULL ,"
                            + "CAPTION varchar (50) NOT NULL ,"
                            + "PARENT varchar (20) ,"
                            + "PACKAGE varchar (60),"
                            + "MODULETYPE varchar (1),"
                            + "ITEMPARAM varchar (200),"
                            + "FORM varchar (32),"
                            + "ISSHOWMODAL varchar (1),"
                            + "ITEMTYPE varchar (20),"
                            + "SEQ_NO varchar (4),"
                            + "PACKAGEDATE Date,"
                            + "IMAGE GRAPHIC,"
                            + "OWNER varchar(20),"
                            + "ISSERVER varchar(1),"
                            + "VERSIONNO varchar(20),"
                            + "CHECKOUT varchar(20),"
                            + "CHECKOUTDATE date,"
                            + "CAPTION0 varchar(50),"
                            + "CAPTION1 varchar(50),"
                            + "CAPTION2 varchar(50),"
                            + "CAPTION3 varchar(50),"
                            + "CAPTION4 varchar(50),"
                            + "CAPTION5 varchar(50),"
                            + "CAPTION6 varchar(50),"
                            + "CAPTION7 varchar(50),"
                            + "IMAGEURL varchar(100), "
                            + "PRIMARY KEY (MENUID)"
                            + ") ";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUTABLE(MENUID, CAPTION, ITEMTYPE, MODULETYPE) VALUES('0', 'ROOT', 'SOLUTION1', 'F')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLE table.\n\r";
                        }

                        // Create USERGROUPS
                        command.CommandText = "CREATE TABLE USERGROUPS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "GROUPID varchar (20) NOT NULL "
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERGROUPS(USERID, GROUPID) VALUES('001', '01')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERGROUPS table.\n\r";
                        }

                        // Create USERS
                        command.CommandText = "CREATE TABLE USERS ("
                            + "USERID varchar (20) NOT NULL ,"
                            + "USERNAME varchar (30),"
                            + "AGENT varchar (20),"
                            + "PWD varchar (10),"
                            + "CREATEDATE varchar (8),"
                            + "CREATER varchar (20),"
                            + "DESCRIPTION varchar (100),"
                            + "EMAIL varchar (40),"
                            + "LASTTIME varchar (8),"
                            + "AUTOLOGIN varchar (1),"
                            + "LASTDATE varchar (8),"
                            + "SIGNATURE varchar (30),"
                            + "MSAD varchar (1) "
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERS(USERID, USERNAME, PWD, MSAD,AUTOLOGIN) VALUES('001', 'TEST', '', 'N','S')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERS table.\n\r";
                        }

                        // Create MENUTABLELOG
                        command.CommandText = "CREATE TABLE MENUTABLELOG"
                            + "("
                            + "LOGID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),"
                            + "MENUID varchar(30) not null,"
                            + "PACKAGE varchar(20) not null,"
                            + "PACKAGEDATE DATE,"
                            + "LASTDATE DATE,"
                            + "OWNER varchar(20),"
                            + "OLDVERSION BLOB,"
                            + "OLDDATE varchar(20), "
                            + "PRIMARY KEY (LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLELOG table.\n\r";
                        }

                        // Create MENUCHECKLOG
                        command.CommandText = "CREATE TABLE MENUCHECKLOG"
                            + "("
                            + "LOGID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) ,"
                            + "ITEMTYPE varchar(20) not null,"
                            + "PACKAGE varchar(50) not null,"
                            + "PACKAGEDATE Date,"
                            + "FILETYPE varchar(10),"
                            + "FILENAME varchar(60),"
                            + "FILEDATE Date,"
                            + "FILECONTENT BLOB, "
                            + "PRIMARY KEY (LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUCHECKLOG table.\n\r";
                        }

                        // Create SYSEEPLOG
                        command.CommandText = "CREATE TABLE SYSEEPLOG"
                            + "("
                            + "CONNID varchar(20) NOT NULL,"
                            + "LOGID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),"
                            + "LOGSTYLE varchar(1) NOT NULL,"
                            + "LOGDATETIME DATE NOT NULL,"
                            + "DOMAINID varchar(30),"
                            + "USERID varchar(20),"
                            + "LOGTYPE varchar(1),"
                            + "TITLE varchar(64),"
                            + "DESCRIPTION varchar(128),"
                            + "COMPUTERIP varchar(16),"
                            + "COMPUTERNAME varchar(64),"
                            + "EXECUTIONTIME integer"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSEEPLOG table.\n\r";
                        }

                        // Create SYSSQLLOG
                        command.CommandText = "CREATE TABLE SYSSQLLOG("
                             + "LOGSTYLE nvarchar(1),"
                             + "LOGDATETIME Date,"
                             + "USERID varchar(20),"
                             + "DEVELOPERID varchar(20),"
                             + "DESCRIPTION CLOB,"
                             + "SQLSENTENCE nvarchar(max)"
                             + ");";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSSQLLOG table.\n\r";
                        }

                        // Create SYSERRLOG
                        command.CommandText = "CREATE TABLE SYSERRLOG"
                            + "("
                            + "ERRID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),"
                            + "USERID varchar(20), "
                            + "MODULENAME varchar(30),"
                            + "ERRMESSAGE varchar(255),"
                            + "ERRSTACK CLOB,"
                            + "ERRDESCRIP varchar(255),"
                            + "ERRDATE Date,"
                            + "ERRSCREEN BLOB,"
                            + "OWNER varchar(20),"
                            + "PROCESSDATE Date,"
                            + "PROCDESCRIP varchar(255),"
                            + "STATUS varchar(2) ,"
                            + "PRIMARY KEY (ERRID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSERRLOG table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_LANGUAGE"
                            + "("
                            + "ID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),"
                            + "IDENTIFICATION varchar(80),"
                            + "KEYS varchar(80),"
                            + "EN varchar(80),"
                            + "CHT varchar(80),"
                            + "CHS varchar(80),"
                            + "HK varchar(80),"
                            + "JA varchar(80),"
                            + "KO varchar(80),"
                            + "LAN1 varchar(80),"
                            + "LAN2 varchar(80) "
                            + ")";

                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_LANGUAGE table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_MESSENGER"
                            + "("
                            + "USERID varchar(20) NOT NULL,"
                            + "MESSAGE varchar(255),"
                            + "PARAS varchar(255),"
                            + "SENDTIME varchar(14),"
                            + "SENDERID varchar(20),"
                            + "RECTIME varchar(14),"
                            + "STATUS char(1)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_MESSENGER table.\n\r";
                        }

                        //CreateMenuTableControl
                        command.CommandText = "CREATE TABLE MENUTABLECONTROL"
                                                + "("
                                                + "MENUID varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "DESCRIPTION Varchar (50), "
                                                + "TYPE Varchar (20) ,"
                                                + "PRIMARY KEY (MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLECONTROL table.\n\r";
                        }

                        //CreateGroupMenuControl
                        command.CommandText = "CREATE TABLE GROUPMENUCONTROL"
                                                + "("
                                                + "GROUPID Varchar (20) NOT NULL, "
                                                + "MENUID Varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "TYPE Varchar (20), "
                                                + "ENABLED CHAR (1), "
                                                + "VISIBLE CHAR (1), "
                                                + "ALLOWADD CHAR (1), "
                                                + "ALLOWUPDATE CHAR (1), "
                                                + "ALLOWDELETE CHAR (1), "
                                                + "ALLOWPRINT CHAR (1), "
                                                + "PRIMARY KEY (GROUPID, MENUID, CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUCONTROL table.\n\r";
                        }

                        //CreateUserMenuControl
                        command.CommandText = "CREATE TABLE USERMENUCONTROL"
                                                + "("
                                                + "USERID Varchar (20) NOT NULL, "
                                                + "MENUID Varchar (30) NOT NULL, "
                                                + "CONTROLNAME Varchar (50) NOT NULL, "
                                                + "TYPE Varchar (20), "
                                                + "ENABLED CHAR (1), "
                                                + "VISIBLE CHAR (1), "
                                                + "ALLOWADD CHAR (1), "
                                                + "ALLOWUPDATE CHAR (1), "
                                                + "ALLOWDELETE CHAR (1), "
                                                + "ALLOWPRINT CHAR (1) "
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUCONTROL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL"
                                            + "("
                                            + "REFVAL_NO Varchar(100) Not NULL, "
                                            + "DESCRIPTION Varchar(250), "
                                            + "TABLE_NAME Varchar(100), "
                                            + "CAPTION Varchar(100), "
                                            + "DISPLAY_MEMBER Varchar(100), "
                                            + "SELECT_ALIAS Varchar(250), "
                                            + "SELECT_COMMAND Varchar(250), "
                                            + "VALUE_MEMBER Varchar(100) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL_D1"
                                            + "("
                                            + "REFVAL_NO Varchar(30) Not NULL, "
                                            + "FIELD_NAME Varchar(30) Not NULL, "
                                            + "HEADER_TEXT Varchar(20), "
                                            + "WIDTH integer "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL_D1 table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE MENUFAVOR"
                                            + "("
                                            + "MENUID Varchar(30) Not NULL, "
                                            + "CAPTION Varchar(50) Not NULL, "
                                            + "USERID Varchar(20) not null, "
                                            + "ITEMTYPE Varchar(20), "
                                            + "GROUPNAME VarChar(20) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUFAVOR table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_ANYQUERY"
                                            + "("
                                            + "QUERYID Varchar(20) Not NULL, "
                                            + "USERID Varchar(20) Not NULL, "
                                            + "TEMPLATEID Varchar(20), "
                                            + "TABLENAME Varchar(50), "
                                            + "LASTDATE Date, "
                                            + "CONTENT CLOB, "
                                            + "PRIMARY Key (QUERYID,USERID,TEMPLATEID)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_ANYQUERY table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REPORT"
                                           + "("
                                           + "REPORTID varchar(50) Not NULL, "
                                           + "FILENAME varchar(50) Not NULL, "
                                           + "REPORTNAME varchar(255), "
                                           + "DESCRIPTION varchar(255), "
                                           + "FILEPATH varchar(255), "
                                           + "OUTPUTMODE varchar(20), "
                                           + "HEADERREPEAT varchar(5), "
                                           + "HEADERFONT BLOB, "
                                           + "HEADERITEMS BLOB, "
                                           + "FOOTERFONT BLOB, "
                                           + "FOOTERITEMS BLOB, "
                                           + "FIELDFONT BLOB, "
                                           + "FIELDITEMS BLOB, "
                                           + "SETTING BLOB, "
                                           + "FORMAT BLOB, "
                                           + "PARAMETERS BLOB, "
                                           + "IMAGES BLOB, "
                                           + "MAILSETTING BLOB, "
                                           + "DATASOURCE_PROVIDER varchar(50),"
                                           + "DATASOURCES BLOB,"
                                           + "CLIENT_QUERY BLOB,"
                                           + "REPORT_TYPE varchar(1),"
                                           + "TEMPLATE_DESC varchar(50),"
                                           + "PRIMARY Key (REPORTID,FILENAME)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REPORT table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_PERSONAL"
                                           + "("
                                           + "FORMNAME varchar(60) NOT NULL,"
                                           + "COMPNAME varchar(30) NOT NULL,"
                                           + "USERID varchar(20) NOT NULL,"
                                           + "REMARK varchar(30),"
                                           + "PROPCONTENT CLOB,"
                                           + "CREATEDATE DATE,"
                                           + "PRIMARY KEY (FORMNAME,COMPNAME,USERID)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_PERSONAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_EEP_USERS"
                                           + "("
                                           + "USERID varchar(50) NOT NULL,"
                                           + "USERNAME varchar(50),"
                                           + "COMPUTER varchar(50) NOT NULL,"
                                           + "LOGINTIME varchar(50),"
                                           + "LASTACTIVETIME varchar(50),"
                                           + "LOGINCOUNT integer,"
                                           + "PRIMARY KEY (USERID,COMPUTER)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_EEP_USERS table.\n\r";
                        }
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP7m)
                {
                    #region EEP7m
                    command.CommandText = "Alter Table COLDEF add "
                                                      + "DEFAULT_VALUE varchar(100), "
                                                      + "CHECK_NULL varchar(1), "
                                                      + "QUERYMODE varchar(20), "
                                                      + "CAPTION1 varchar (40), "
                                                      + "CAPTION2 varchar (40), "
                                                      + "CAPTION3 varchar (40), "
                                                      + "CAPTION4 varchar (40), "
                                                      + "CAPTION5 varchar (40), "
                                                      + "CAPTION6 varchar (40), "
                                                      + "CAPTION7 varchar (40), "
                                                      + "CAPTION8 varchar (40)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPMENUS alter column MENUID varchar (30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table GROUPS add MSAD varchar (1)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS alter column GROUPNAME varchar (50)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS alter column DESCRIPTION varchar (200)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table MENUTABLE add "
                                           + "MODULETYPE varchar(1), "
                                           + "PACKAGEDATE DATE, "
                                           + "IMAGE BLOB, "
                                           + "OWNER varchar(20), "
                                           + "ISSERVER varchar(1), "
                                           + "VERSIONNO varchar(20), "
                                           + "CHECKOUT varchar(20), "
                                           + "CHECKOUTDATE DATE, "
                                           + "CAPTION0 varchar(50), "
                                           + "CAPTION1 varchar(50), "
                                           + "CAPTION2 varchar(50), "
                                           + "CAPTION3 varchar(50), "
                                           + "CAPTION4 varchar(50), "
                                           + "CAPTION5 varchar(50), "
                                           + "CAPTION6 varchar(50), "
                                           + "CAPTION7 varchar(50), "
                                           + "IMAGEURL varchar(100)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE alter column MENUID varchar(30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE alter column ITEMTYPE varchar(20)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table USERMENUS alter column MENUID varchar(30)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table USERS add "
                                           + "EMAIL varchar(40), "
                                           + "LASTTIME varchar(8), "
                                           + "AUTOLOGIN varchar(1), "
                                           + "LASTDATE varchar(8), "
                                           + "SIGNATURE varchar(30), "
                                           + "MSAD varchar(1)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP2006m)
                {
                    #region EEP2006m
                    command.CommandText = "Alter Table MENUFAVOR ADD GROUPNAME varchar(20)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table SYS_TODOLIST  ADD  ATTACHMENTS varchar(255)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "Alter table SYS_TODOHIS  ADD  ATTACHMENTS varchar(255)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                //odbc未测试
                else if (cdb.x == radioType.WorkFlow)
                {
                    #region WorkFlow
                    //GROUPS
                    command.CommandText = "ALTER TABLE GROUPS ADD ISROLE CHAR(1)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not add ISROLE column to GROUPS table.\n\r";
                    }
                    // SYS_ORG
                    command.CommandText = "CREATE TABLE SYS_ORG(" +
                                        "ORG_NO varchar(8) NOT NULL," +
                                        "ORG_DESC varchar(40) NOT NULL," +
                                        "ORG_KIND varchar(4) NOT NULL," +
                                        "UPPER_ORG varchar(8)," +
                                        "ORG_MAN varchar(20) NOT NULL," +
                                        "LEVEL_NO varchar(6) NOT NULL," +
                                        "ORG_TREE varchar(40)," +
                                        "END_ORG varchar(4)," +
                                        "ORG_FULLNAME varchar(254)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORG(ORG_NO,ORG_DESC,ORG_KIND,ORG_MAN,LEVEL_NO) Values ('1','總公司','0','001','9')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORG table.\n\r";
                    }

                    // SYS_ORGKIND
                    command.CommandText = "CREATE TABLE SYS_ORGKIND(" +
                                        "ORG_KIND varchar(4) NOT NULL," +
                                        "KIND_DESC varchar(40) NOT NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORGKIND(ORG_KIND,KIND_DESC) Values ('0','公司組織')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGKIND table.\n\r";
                    }

                    // SYS_ORGLEVEL
                    command.CommandText = "CREATE TABLE SYS_ORGLEVEL(" +
                                        "LEVEL_NO varchar(6) NOT NULL," +
                                        "LEVEL_DESC varchar(40) NOT NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('1','主任/課長/副理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('2','經理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('3','副總')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('9','總經理')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGLEVEL table.\n\r";
                    }

                    // SYS_ORGROLES
                    command.CommandText = "CREATE TABLE SYS_ORGROLES(" +
                                        "ORG_NO varchar(8) NOT NULL," +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "ORG_KIND varchar(4)," +
                                        "PRIMARY KEY(ORG_NO,ROLE_ID)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGROLES table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ORGNO ON SYS_ORGROLES (ORG_NO, ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX ORGNO on table SYS_ORGROLES .\n\r";
                    }

                    // SYS_ROLES_AGENT
                    command.CommandText = "CREATE TABLE SYS_ROLES_AGENT(" +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "AGENT varchar(20) NOT NULL," +
                                        "FLOW_DESC varchar(40) NOT NULL," +
                                        "START_DATE varchar(8) NOT NULL," +
                                        "START_TIME varchar(6)," +
                                        "END_DATE varchar(8) NOT NULL," +
                                        "END_TIME varchar(6)," +
                                        "PAR_AGENT varchar(4) NOT NULL," +
                                        "REMARK varchar(254)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ROLES_AGENT table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ROLEID ON SYS_ROLES_AGENT (ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX ROLEID on table SYS_ROLES_AGENT .\n\r";
                    }

                    // SYS_TODOHIS
                    command.CommandText = "CREATE TABLE SYS_TODOHIS(" +
                                        "LISTID varchar(40) NOT NULL," +
                                        "FLOW_ID varchar(40) NOT NULL," +
                                        "FLOW_DESC varchar(40)," +
                                        "ROLE_ID varchar(20) NOT NULL," +
                                        "S_ROLE_ID varchar(20) NOT NULL," +
                                        "S_STEP_ID varchar(20) NOT NULL," +
                                        "D_STEP_ID varchar(20) NOT NULL," +
                                        "S_STEP_DESC varchar(64)," +
                                        "S_USER_ID varchar(20) NOT NULL," +
                                        "USER_ID varchar(20) NOT NULL," +
                                        "USERNAME varchar(30)," +
                                        "FORM_NAME varchar(30)," +
                                        "WEBFORM_NAME varchar(50) NOT NULL," +
                                        "S_USERNAME varchar(30)," +
                                        "NAVIGATOR_MODE varchar(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE varchar(2) NOT NULL," +
                                        "PARAMETERS varchar(254)," +
                                        "STATUS varchar(4)," +
                                        "PROC_TIME decimal(8, 2) NOT NULL," +
                                        "EXP_TIME decimal(8, 2) NOT NULL," +
                                        "TIME_UNIT varchar(4) NOT NULL," +
                                        "FLOWIMPORTANT varchar(1) NOT NULL," +
                                        "FLOWURGENT varchar(1) NOT NULL," +
                                        "FORM_TABLE varchar(30)," +
                                        "FORM_KEYS varchar(254)," +
                                        "FORM_PRESENTATION varchar(254)," +
                                        "REMARK varchar(254)," +
                                        "VERSION varchar(2)," +
                                        "VDSNAME varchar(40)," +
                                        "SENDBACKSTEP varchar(2)," +
                                        "LEVEL_NO varchar(6)," +
                                        "UPDATE_DATE varchar(10)," +
                                        "UPDATE_TIME varchar(8)," +
                                        "FORM_PRESENT_CT varchar(254)," +
                                        "ATTACHMENTS varchar(255)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOHIS table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOHIS (LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX LISTID on table SYS_TODOHIS.\n\r";
                    }

                    command.CommandText = "CREATE INDEX USERID ON SYS_TODOHIS (USER_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX USERID on table SYS_TODOHIS.\n\r";
                    }

                    // SYS_TODOLIST
                    command.CommandText = "CREATE TABLE SYS_TODOLIST(" +
                                        "LISTID varchar(40) NOT NULL," +
                                        "FLOW_ID varchar(40) NOT NULL," +
                                        "FLOW_DESC varchar(40)," +
                                        "APPLICANT varchar(20) NOT NULL," +
                                        "S_USER_ID varchar(20) NOT NULL," +
                                        "S_STEP_ID varchar(20) NOT NULL," +
                                        "S_STEP_DESC varchar(64)," +
                                        "D_STEP_ID varchar(20) NOT NULL," +
                                        "D_STEP_DESC varchar(64)," +
                                        "EXP_TIME decimal(8, 2) NOT NULL," +
                                        "URGENT_TIME decimal(8, 2) NOT NULL," +
                                        "TIME_UNIT varchar(4) NOT NULL," +
                                        "USERNAME varchar(30)," +
                                        "FORM_NAME varchar(30)," +
                                        "NAVIGATOR_MODE varchar(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE varchar(2) NOT NULL," +
                                        "PARAMETERS varchar(254)," +
                                        "SENDTO_KIND varchar(4) NOT NULL," +
                                        "SENDTO_ID varchar(20) NOT NULL," +
                                        "FLOWIMPORTANT varchar(1) NOT NULL," +
                                        "FLOWURGENT varchar(1) NOT NULL," +
                                        "STATUS varchar(4)," +
                                        "FORM_TABLE varchar(30)," +
                                        "FORM_KEYS varchar(254)," +
                                        "FORM_PRESENTATION varchar(254)," +
                                        "FORM_PRESENT_CT varchar(254) NOT NULL," +
                                        "REMARK varchar(254)," +
                                        "PROVIDER_NAME varchar(254)," +
                                        "VERSION varchar(2)," +
                                        "EMAIL_ADD varchar(40)," +
                                        "EMAIL_STATUS varchar(1)," +
                                        "VDSNAME varchar(40)," +
                                        "SENDBACKSTEP varchar(2)," +
                                        "LEVEL_NO varchar(6)," +
                                        "WEBFORM_NAME varchar(50) NOT NULL," +
                                        "UPDATE_DATE varchar(10)," +
                                        "UPDATE_TIME varchar(8)," +
                                        "FLOWPATH varchar(100) NOT NULL," +
                                        "PLUSAPPROVE varchar(1) NOT NULL," +
                                        "PLUSROLES varchar(254) NOT NULL," +
                                        "MULTISTEPRETURN varchar(1)," +
                                        "SENDTO_NAME varchar(30)," +
                                        "ATTACHMENTS varchar(255)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOLIST table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOLIST (LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX LISTID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX SENDTOID ON SYS_TODOLIST (SENDTO_ID, SENDTO_KIND)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX SENDTOID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX FLOWDESC ON SYS_TODOLIST (FLOW_DESC)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create INDEX FLOWDESC on table SYS_TODOLIST.\n\r";
                    }

                    // SYS_FLDefinition
                    command.CommandText = "CREATE TABLE SYS_FLDEFINITION"
                                            + "("
                                            + "FLTYPEID varchar(50) NOT NULL, "
                                            + "FLTYPENAME varchar(200) NOT NULL, "
                                            + "FLDEFINITION CLOB NOT NULL, "
                                            + "VERSION integer, "
                                            + "PRIMARY KEY(FLTYPEID) "
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLDEFINITION table.\n\r";
                    }

                    // SYS_FLInstanceState
                    command.CommandText = "CREATE TABLE SYS_FLINSTANCESTATE"
                                            + "("
                                            + "FLINSTANCEID varchar(50) NOT NULL, "
                                            + "STATE BLOB NOT NULL, "
                                            + "STATUS integer, "
                                            + "INFO varchar(200)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLINSTANCESTATE table.\n\r";
                    }

                    // Sys_ExtApprove
                    command.CommandText = "CREATE TABLE SYS_EXTAPPROVE"
                                            + "("
                                            + "APPROVEID varchavarcharULL, "
                                            + "GROUPID varchavarcharULL, "
                                            + "MINIMUM varchavarcharULL, "
                                            + "MAXIMUM varchavarcharULL,"
                                            + "ROLEID varchavarcharULL"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_EXTAPPROVE table.\n\r";
                    }
                    #endregion
                }

                if (result != "")
                    MessageBox.Show(result);
                else if (cdb.x == radioType.typical)
                    MessageBox.Show("Create all System Tables successfully.");
                else if (cdb.x == radioType.simplified)
                    MessageBox.Show("Create table COLDEF table and table SYSAUTONUM successfully.");
                else if (cdb.x == radioType.EEP7m)
                    MessageBox.Show("Alter successfully.");
                else if (cdb.x == radioType.EEP2006m)
                    MessageBox.Show("EEP 2006 2.1.0.1(SP2) Migration success");
                else if (cdb.x == radioType.WorkFlow)
                    MessageBox.Show("Create WorkFlow Tables successfully.");
            }
        }
Exemple #3
0
        public void CreateOracleSystemTable(IDbCommand command)
        {
            frmCreateDB cdb = new frmCreateDB();
            cdb.ShowDialog();

            if (cdb.DialogResult == DialogResult.OK)
            {
                string result = "";

                if (cdb.x == radioType.simplified || cdb.x == radioType.typical)
                {
                    #region Simplified
                    command.CommandText = "CREATE TABLE COLDEF"
                                  + "("
                                  + "TABLE_NAME varchar2(20) NOT NULL, "
                                  + "FIELD_NAME varchar2(20) NOT NULL, "
                                  + "SEQ NUMERIC(12,0) NULL, "
                                  + "FIELD_TYPE varchar2(20) NULL, "
                                  + "IS_KEY varchar2(1) NOT NULL, "
                                  + "FIELD_LENGTH NUMERIC(12,0) NULL, "
                                  + "CAPTION varchar2(40) NULL, "
                                  + "EDITMASK varchar2(10) NULL, "
                                  + "NEEDBOX varchar2(13) NULL, "
                                  + "CANREPORT varchar2(1) NULL, "
                                  + "EXT_MENUID varchar2(20) NULL, "
                                  + "FIELD_SCALE NUMERIC(12,0) NULL, "
                                  + "DD_NAME varchar2(40) NULL, "
                                  + "DEFAULT_VALUE varchar2(100) NULL, "
                                  + "CHECK_NULL varchar2(1) NULL, "
                                  + "QUERYMODE varchar2(20) NULL, "
                                  + "CAPTION1 varchar2(40) NULL, "
                                  + "CAPTION2 varchar2(40) NULL, "
                                  + "CAPTION3 varchar2(40) NULL, "
                                  + "CAPTION4 varchar2(40) NULL, "
                                  + "CAPTION5 varchar2(40) NULL, "
                                  + "CAPTION6 varchar2(40) NULL, "
                                  + "CAPTION7 varchar2(40) NULL, "
                                  + "CAPTION8 varchar2(40) NULL, "
                                  + "PRIMARY KEY(TABLE_NAME,FIELD_NAME)"
                                  + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create COLDEF table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX TABLENAME ON COLDEF(TABLE_NAME,FIELD_NAME)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX TABLENAME on table COLDEF .\n\r";
                    }

                    command.CommandText = "CREATE TABLE SYSAUTONUM "
                                            + "("
                                            + "AUTOID VARCHAR2(20) NOT NULL, "
                                            + "FIXED VARCHAR2(20) NOT NULL, "
                                            + "CURRNUM NUMERIC(10,0) NULL, "
                                            + "DESCRIPTION VARCHAR2(50) NULL, "
                                            + "PRIMARY KEY (AUTOID, FIXED)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYSAUTONUM table.\n\r";
                    }
                    #endregion

                    #region Typical
                    if (cdb.x == radioType.typical)
                    {
                        //// Create GROUPFORMS
                        //command.CommandText = "CREATE TABLE GROUPFORMS ("
                        //    + "GROUPID nvarchar (20) NOT NULL ,"
                        //    + "PACKAGE_NAME nvarchar (50) NOT NULL ,"
                        //    + "FORM_NAME nvarchar (50) NULL ,"
                        //    + "PARENT_MENU nvarchar (50) NULL "
                        //    + ")";
                        //try
                        //{
                        //    command.ExecuteNonQuery();
                        //}
                        //catch
                        //{
                        //    result += "Can not create GROUPFORMS table.\n\r";
                        //}

                        // Create GROUPMENUS
                        command.CommandText = "CREATE TABLE GROUPMENUS ("
                            + "GROUPID varchar2 (20) NOT NULL ,"
                            + "MENUID varchar2 (30) NOT NULL, "
                            + "PRIMARY KEY(GROUPID,MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUS table.\n\r";
                        }

                        // Create USERMENUS
                        command.CommandText = "CREATE TABLE USERMENUS ("
                            + "USERID varchar2 (20) NOT NULL ,"
                            + "MENUID varchar2 (30) NOT NULL, "
                            + "PRIMARY KEY(USERID,MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUS table.\n\r";
                        }

                        // Create GROUPS
                        command.CommandText = "CREATE TABLE GROUPS ("
                            + "GROUPID varchar2 (20) NOT NULL ,"
                            + "GROUPNAME varchar2 (50) NULL ,"
                            + "DESCRIPTION varchar2 (100) NULL ,"
                            + "MSAD varchar2 (1) NULL, "
                            + "ISROLE char(1) NULL ,"
                            + "PRIMARY KEY(GROUPID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('00', 'EveryOne', 'N')";
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO GROUPS(GROUPID, GROUPNAME, MSAD) VALUES('01', 'DEPARTMENT1', 'N')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPS table.\n\r";
                        }

                        // Create MENUITEMTYPE
                        command.CommandText = "CREATE TABLE MENUITEMTYPE ("
                            + "ITEMTYPE varchar2 (20) NOT NULL ,"
                            + "ITEMNAME varchar2 (20) NULL, "
                            + "DBALIAS varchar2(50) NULL, "
                            + "PRIMARY KEY(ITEMTYPE)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUITEMTYPE(ITEMTYPE, ITEMNAME) VALUES('SOLUTION1', 'DEFAULT SOLUTION')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUITEMTYPE table.\n\r";
                        }

                        // Create MENUTABLE
                        command.CommandText = "CREATE TABLE MENUTABLE ("
                            + "MENUID nvarchar2 (30) NOT NULL ,"
                            + "CAPTION nvarchar2 (50) NOT NULL ,"
                            + "PARENT nvarchar2 (20) NULL ,"
                            + "PACKAGE nvarchar2 (60) NULL ,"
                            + "MODULETYPE nvarchar2 (1) NULL ,"
                            + "ITEMPARAM nvarchar2 (200) NULL ,"
                            + "FORM nvarchar2 (32) NULL ,"
                            + "ISSHOWMODAL nvarchar2 (1) NULL ,"
                            + "ITEMTYPE nvarchar2 (20) NULL ,"
                            + "SEQ_NO nvarchar2 (4) NULL,"
                            + "PACKAGEDATE Date,"
                            + "ISSERVER nvarchar2(1),"
                            + "VERSIONNO nvarchar2(20),"
                            + "CHECKOUT nvarchar2(20),"
                            + "CHECKOUTDATE date,"
                            + "CAPTION0 nvarchar2(50) NULL,"
                            + "CAPTION1 nvarchar2(50) NULL,"
                            + "CAPTION2 nvarchar2(50) NULL,"
                            + "CAPTION3 nvarchar2(50) NULL,"
                            + "CAPTION4 nvarchar2(50) NULL,"
                            + "CAPTION5 nvarchar2(50) NULL,"
                            + "CAPTION6 nvarchar2(50) NULL,"
                            + "CAPTION7 nvarchar2(50) NULL,"
                            + "IMAGE blob NULL,"
                            + "IMAGEURL varchar2(100) NULL, "
                            + "OWNER varchar2(20),"
                            + "PRIMARY KEY(MENUID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO MENUTABLE(MENUID, CAPTION, ITEMTYPE, MODULETYPE) VALUES('0', 'ROOT', 'SOLUTION1', 'F')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLE table.\n\r";
                        }

                        // Create USERGROUPS
                        command.CommandText = "CREATE TABLE USERGROUPS ("
                            + "USERID varchar2 (20) NOT NULL ,"
                            + "GROUPID varchar2 (20) NOT NULL, "
                            + "PRIMARY KEY(USERID,GROUPID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERGROUPS(USERID, GROUPID) VALUES('001', '01')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERGROUPS table.\n\r";
                        }

                        // Create USERS
                        command.CommandText = "CREATE TABLE USERS ("
                            + "USERID varchar2 (20) NOT NULL ,"
                            + "USERNAME varchar2 (30) NULL ,"
                            + "AGENT varchar2 (20) NULL ,"
                            + "PWD varchar2 (10) NULL ,"
                            + "CREATEDATE varchar2 (8) NULL ,"
                            + "CREATER varchar2 (20) NULL ,"
                            + "DESCRIPTION varchar2 (100) NULL ,"
                            + "EMAIL varchar2 (40) NULL ,"
                            + "LASTTIME varchar2 (8) NULL ,"
                            + "AUTOLOGIN varchar2 (1),"
                            + "LASTDATE varchar2 (8) NULL ,"
                            + "SIGNATURE varchar2 (30) NULL ,"
                            + "MSAD varchar2 (1) NULL, "
                            + "PRIMARY KEY(USERID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "INSERT INTO USERS(USERID, USERNAME, PWD, MSAD,AUTOLOGIN) VALUES('001', 'TEST', '', 'N','S')";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERS table.\n\r";
                        }

                        // Create MENUTABLELOG
                        command.CommandText = "CREATE TABLE MENUTABLELOG"
                            + "("
                            + "LOGID number(10),"
                            + "MENUID varchar2(30) not null,"
                            + "PACKAGE varchar2(20) not null,"
                            + "PACKAGEDATE DATE,"
                            + "LASTDATE DATE,"
                            + "OWNER varchar2(20),"
                            + "OLDVERSION blob,"
                            + "OLDDATE varchar2(20), "
                            + "PRIMARY KEY(LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE SEQUENCE MENUTABLELOG_LODID_SEQ " +
                                                    "START WITH 1 " +
                                                    "MAXVALUE 9999999999 " +
                                                    "MINVALUE 1 " +
                                                    "NOCYCLE " +
                                                    "NOCACHE " +
                                                    "NOORDER";
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE OR REPLACE TRIGGER MENUTABLELOG_LODID" +
                                        " BEFORE INSERT" +
                                        " ON MENUTABLELOG" +
                                        " FOR EACH ROW" +
                                        " DECLARE" +
                                        " NEXT_ID NUMBER;" +
                                        " BEGIN" +
                                        " SELECT MENUTABLELOG_LODID_SEQ.NEXTVAL INTO NEXT_ID FROM dual;" +
                                        " :NEW.LOGID := NEXT_ID;" +
                                        " END;";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLELOG table.\n\r";
                        }

                        // Create MENUCHECKLOG
                        command.CommandText = "CREATE TABLE MENUCHECKLOG"
                            + "("
                            + "LOGID number(10),"
                            + "ITEMTYPE varchar2(20) not null,"
                            + "PACKAGE varchar2(50) not null,"
                            + "PACKAGEDATE Date,"
                            + "FILETYPE varchar2(10),"
                            + "FILENAME varchar2(60),"
                            + "FILEDATE Date,"
                            + "FILECONTENT blob, "
                            + "PRIMARY KEY(LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE SEQUENCE MENUCHECKLOG_LODID_SEQ " +
                                                    "START WITH 1 " +
                                                    "MAXVALUE 9999999999 " +
                                                    "MINVALUE 1 " +
                                                    "NOCYCLE " +
                                                    "NOCACHE " +
                                                    "NOORDER";
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE OR REPLACE TRIGGER MENUCHECKLOG_LODID" +
                                                    " BEFORE INSERT" +
                                                    " ON MENUCHECKLOG" +
                                                    " FOR EACH ROW" +
                                                    " DECLARE" +
                                                    " NEXT_ID NUMBER;" +
                                                    " BEGIN" +
                                                    " SELECT MENUCHECKLOG_LODID_SEQ.NEXTVAL INTO NEXT_ID FROM dual;" +
                                                    " :NEW.LOGID := NEXT_ID;" +
                                                    " END;";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUCHECKLOG table.\n\r";
                        }

                        // Create SYSEEPLOG
                        command.CommandText = "CREATE TABLE SYSEEPLOG"
                            + "("
                            + "CONNID varchar2(20) NOT NULL,"
                            + "LOGID number(10) NOT NULL,"
                            + "LOGSTYLE varchar2(1) NOT NULL,"
                            + "LOGDATETIME DATE NOT NULL,"
                            + "DOMAINID varchar2(30) NULL,"
                            + "USERID varchar2(20) NULL,"
                            + "LOGTYPE varchar2(1) NULL,"
                            + "TITLE varchar2(64) NULL,"
                            + "DESCRIPTION LONG NULL,"
                            + "COMPUTERIP varchar2(16) NULL,"
                            + "COMPUTERNAME varchar2(64) NULL,"
                            + "EXECUTIONTIME INT NULL,"
                            + "PRIMARY KEY(CONNID,LOGID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE SEQUENCE SYSEEPLOG_LOGID_SEQ " +
                                                    "START WITH 1 " +
                                                    "MAXVALUE 9999999999 " +
                                                    "MINVALUE 1 " +
                                                    "CYCLE " +
                                                    "NOCACHE " +
                                                    "NOORDER";
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE OR REPLACE TRIGGER SYSEEPLOG_LOGID" +
                                                    " BEFORE INSERT" +
                                                    " ON SYSEEPLOG" +
                                                    " FOR EACH ROW" +
                                                    " DECLARE" +
                                                    " NEXT_ID NUMBER;" +
                                                    " BEGIN" +
                                                    " SELECT SYSEEPLOG_LOGID_SEQ.NEXTVAL INTO NEXT_ID FROM dual;" +
                                                    " :NEW.LOGID := NEXT_ID;" +
                                                    " END;";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSEEPLOG table.\n\r";
                        }

                        // Create SYSSQLLOG
                        command.CommandText = "CREATE TABLE SYSSQLLOG("
                             + "LOGSTYLE varchar2(1),"
                             + "LOGDATETIME Date,"
                             + "USERID varchar2(20),"
                             + "DEVELOPERID varchar2(20),"
                             + "DESCRIPTION blob,"
                             + "SQLSENTENCE varchar2(max)"
                             + ");";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSSQLLOG table.\n\r";
                        }

                        // Create SYSERRLOG
                        command.CommandText = "CREATE TABLE SYSERRLOG"
                            + "("
                            + "ERRID number(10),"
                            + "USERID varchar2(20), "
                            + "MODULENAME varchar2(30),"
                            + "ERRMESSAGE varchar2(255),"
                            + "ERRSTACK varchar2(255),"
                            + "ERRDESCRIP varchar2(255),"
                            + "ERRDATE Date,"
                            + "ERRSCREEN blob,"
                            + "OWNER varchar2(20),"
                            + "PROCESSDATE Date,"
                            + "PROCDESCRIP varchar2(255),"
                            + "STATUS varchar2(2), "
                            + "PRIMARY KEY(ERRID)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE SEQUENCE SYSERRLOG_ErrID_SEQ " +
                                                    "START WITH 1 " +
                                                    "MAXVALUE 9999999999 " +
                                                    "MINVALUE 1 " +
                                                    "NOCYCLE " +
                                                    "NOCACHE " +
                                                    "NOORDER";
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE OR REPLACE TRIGGER SYSERRLOG_ErrID" +
                                                    " BEFORE INSERT" +
                                                    " ON SYSERRLOG" +
                                                    " FOR EACH ROW" +
                                                    " DECLARE" +
                                                    " NEXT_ID NUMBER;" +
                                                    " BEGIN" +
                                                    " SELECT SYSERRLOG_ErrID_SEQ.NEXTVAL INTO NEXT_ID FROM dual;" +
                                                    " :NEW.ErrID := NEXT_ID;" +
                                                    " END;";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYSERRLOG table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_LANGUAGE"
                            + "("
                            + "ID number(10) NOT NULL,"
                            + "IDENTIFICATION varchar2(80),"
                            + "KEYS varchar2(80),"
                            + "EN varchar2(80),"
                            + "CHT varchar2(80),"
                            + "CHS varchar2(80),"
                            + "HK varchar2(80),"
                            + "JA varchar2(80),"
                            + "KO varchar2(80),"
                            + "LAN1 varchar2(80),"
                            + "LAN2 varchar2(80), "
                            + "PRIMARY KEY(ID)"
                            + ")";

                        try
                        {
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE SEQUENCE SYS_LANGUAGE_ID_SEQ " +
                                                    "START WITH 1 " +
                                                    "MAXVALUE 9999999999 " +
                                                    "MINVALUE 1 " +
                                                    "NOCYCLE " +
                                                    "NOCACHE " +
                                                    "NOORDER";
                            command.ExecuteNonQuery();

                            command.CommandText = "CREATE OR REPLACE TRIGGER SYS_LANGUAGE_ID" +
                                                    " BEFORE INSERT" +
                                                    " ON SYS_LANGUAGE" +
                                                    " FOR EACH ROW" +
                                                    " DECLARE" +
                                                    " NEXT_ID NUMBER;" +
                                                    " BEGIN" +
                                                    " SELECT SYS_LANGUAGE_ID_SEQ.NEXTVAL INTO NEXT_ID FROM dual;" +
                                                    " :NEW.ID := NEXT_ID;" +
                                                    " END;";
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_LANGUAGE table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_MESSENGER"
                            + "("
                            + "USERID varchar2(20) NOT NULL,"
                            + "MESSAGE varchar2(255),"
                            + "PARAS varchar2(255),"
                            + "SENDTIME varchar2(14),"
                            + "SENDERID varchar2(20),"
                            + "RECTIME varchar2(14),"
                            + "STATUS char(1)"
                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_MESSENGER table.\n\r";
                        }

                        //CreateMenuTableControl
                        command.CommandText = "CREATE TABLE MENUTABLECONTROL"
                                                + "("
                                                + "MENUID varchar2 (30) NOT NULL, "
                                                + "CONTROLNAME Varchar2 (50) NOT NULL, "
                                                + "DESCRIPTION Varchar2 (50) NULL, "
                                                + "TYPE Varchar (20) NULL, "
                                                + "PRIMARY KEY(MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUTABLECONTROL table.\n\r";
                        }

                        //CreateGroupMenuControl
                        command.CommandText = "CREATE TABLE GROUPMENUCONTROL"
                                                + "("
                                                + "GROUPID Varchar2 (20) NOT NULL, "
                                                + "MENUID Varchar2 (30) NOT NULL, "
                                                + "CONTROLNAME Varchar2 (50) NOT NULL, "
                                                + "TYPE Varchar2 (20) NULL, "
                                                + "ENABLED CHAR (1) NULL, "
                                                + "VISIBLE CHAR (1) NULL, "
                                                + "ALLOWADD CHAR (1) NULL, "
                                                + "ALLOWUPDATE CHAR (1) NULL, "
                                                + "ALLOWDELETE CHAR (1) NULL, "
                                                + "ALLOWPRINT CHAR (1) NULL, "
                                                + "PRIMARY KEY(GROUPID,MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create GROUPMENUCONTROL table.\n\r";
                        }

                        //CreateUserMenuControl
                        command.CommandText = "CREATE TABLE USERMENUCONTROL"
                                                + "("
                                                + "USERID Varchar2 (20) NOT NULL, "
                                                + "MENUID Varchar2 (30) NOT NULL, "
                                                + "CONTROLNAME Varchar2 (50) NOT NULL, "
                                                + "TYPE Varchar2 (20) NULL, "
                                                + "ENABLED CHAR (1) NULL, "
                                                + "VISIBLE CHAR (1) NULL, "
                                                + "ALLOWADD CHAR (1) NULL, "
                                                + "ALLOWUPDATE CHAR (1) NULL, "
                                                + "ALLOWDELETE CHAR (1) NULL, "
                                                + "ALLOWPRINT CHAR (1) NULL, "
                                                + "PRIMARY KEY(USERID,MENUID,CONTROLNAME)"
                                                + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create USERMENUCONTROL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL"
                                            + "("
                                            + "REFVAL_NO Varchar2(100) Not NULL, "
                                            + "DESCRIPTION Varchar2(250), "
                                            + "TABLE_NAME Varchar2(100), "
                                            + "CAPTION Varchar2(100), "
                                            + "DISPLAY_MEMBER Varchar2(100), "
                                            + "SELECT_ALIAS Varchar2(250), "
                                            + "SELECT_COMMAND Varchar2(250), "
                                            + "VALUE_MEMBER Varchar2(100), "
                                            + "CONSTRAINT PK_SYS_REFVAL PRIMARY KEY(REFVAL_NO) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REFVAL_D1"
                                            + "("
                                            + "REFVAL_NO Varchar2(30) NOT NULL, "
                                            + "FIELD_NAME Varchar2(30) NOT NULL, "
                                            + "HEADER_TEXT Varchar2(20), "
                                            + "WIDTH INT, "
                                            + "CONSTRAINT PK_SYS_REFVAL_D1 PRIMARY KEY(REFVAL_NO, FIELD_NAME) "
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REFVAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE MENUFAVOR"
                                            + "("
                                            + "MENUID Varchar2(30) NOT NULL, "
                                            + "CAPTION Varchar2(50) NOT NULL, "
                                            + "USERID Varchar2(20) NOT NULL, "
                                            + "ITEMTYPE Varchar(20), "
                                            + "GROUPNAME VarChar(20), "
                                            + "PRIMARY KEY (MENUID,USERID)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create MENUFAVOR table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_ANYQUERY"
                                            + "("
                                            + "QUERYID Varchar2(20) Not NULL, "
                                            + "USERID Varchar2(20) Not NULL, "
                                            + "TEMPLATEID Varchar2(20), "
                                            + "TABLENAME Varchar2(50), "
                                            + "LASTDATE date, "
                                            + "CONTENT blob, "
                                            + "PRIMARY Key (QUERYID,USERID,TEMPLATEID)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_ANYQUERY table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_REPORT"
                                            + "("
                                            + "REPORTID nVarchar2(50) Not NULL, "
                                            + "FILENAME nVarchar2(50) Not NULL, "
                                            + "REPORTNAME nVarchar2(255), "
                                            + "DESCRIPTION nVarchar2(255), "
                                            + "FILEPATH nVarchar2(255), "
                                            + "OUTPUTMODE nVarchar2(20), "
                                            + "HEADERREPEAT nVarchar2(5), "
                                            + "HEADERFONT blob, "
                                            + "HEADERITEMS blob, "
                                            + "FOOTERFONT blob, "
                                            + "FOOTERITEMS blob, "
                                            + "FIELDFONT blob, "
                                            + "FIELDITEMS blob, "
                                            + "SETTING blob, "
                                            + "FORMAT blob, "
                                            + "PARAMETERS blob, "
                                            + "IMAGES blob, "
                                            + "MAILSETTING blob, "
                                            + "DATASOURCE_PROVIDER nVarchar2(50),"
                                           + "DATASOURCES blob,"
                                           + "CLIENT_QUERY blob,"
                                           + "REPORT_TYPE nVarchar2(1),"
                                           + "TEMPLATE_DESC nVarchar2(50),"
                                            + "PRIMARY Key (REPORTID,FILENAME)"
                                            + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_REPORT table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_PERSONAL"
                                           + "("
                                           + "FORMNAME NVARCHAR2(60) NOT NULL,"
                                           + "COMPNAME NVARCHAR2(30) NOT NULL,"
                                           + "USERID NVARCHAR2(20) NOT NULL,"
                                           + "REMARK NVARCHAR2(30),"
                                           + "PROPCONTENT LONG,"
                                           + "CREATEDATE DATE,"
                                           + "PRIMARY KEY (FORMNAME,COMPNAME,USERID)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_PERSONAL table.\n\r";
                        }

                        command.CommandText = "CREATE TABLE SYS_EEP_USERS"
                                           + "("
                                           + "USERID NVARCHAR2(50) NOT NULL,"
                                           + "USERNAME NVARCHAR2(50) NULL,"
                                           + "COMPUTER NVARCHAR2(50) NOT NULL,"
                                           + "LOGINTIME NVARCHAR2(50),"
                                           + "LASTACTIVETIME NVARCHAR2(50),"
                                           + "LOGINCOUNT INT,"
                                           + "PRIMARY KEY (USERID,COMPUTER)"
                                           + ")";
                        try
                        {
                            command.ExecuteNonQuery();
                        }
                        catch
                        {
                            result += "Can not create SYS_EEP_USERS table.\n\r";
                        }
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP7m)
                {
                    #region EEP7m
                    command.CommandText = "Alter Table COLDEF add ("
                                                       + "DEFAULT_VALUE VARCHAR2(100) NULL, "
                                                       + "CHECK_NULL VARCHAR2(1) NULL, "
                                                       + "QUERYMODE VARCHAR2(20), "
                                                       + "CAPTION1 VARCHAR2 (40), "
                                                       + "CAPTION2 VARCHAR2 (40), "
                                                       + "CAPTION3 VARCHAR2 (40), "
                                                       + "CAPTION4 VARCHAR2 (40), "
                                                       + "CAPTION5 VARCHAR2 (40), "
                                                       + "CAPTION6 VARCHAR2 (40), "
                                                       + "CAPTION7 VARCHAR2 (40), "
                                                       + "CAPTION8 VARCHAR2 (40))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPMENUS modify (MENUID varchar2 (30))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table GROUPS add (MSAD VARCHAR2 (1))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS modify (GROUPNAME varchar2 (50))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table GROUPS modify (DESCRIPTION varchar2 (200))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table MENUTABLE add("
                                           + "MODULETYPE VARCHAR2(1), "
                                           + "PACKAGEDATE DATE, "
                                           + "IMAGE blob, "
                                           + "OWNER VARCHAR2(20), "
                                           + "ISSERVER VARCHAR2(1), "
                                           + "VERSIONNO VARCHAR2(20), "
                                           + "CHECKOUT VARCHAR2(20), "
                                           + "CHECKOUTDATE DATE, "
                                           + "CAPTION0 VARCHAR2(50), "
                                           + "CAPTION1 VARCHAR2(50), "
                                           + "CAPTION2 VARCHAR2(50), "
                                           + "CAPTION3 VARCHAR2(50), "
                                           + "CAPTION4 VARCHAR2(50), "
                                           + "CAPTION5 VARCHAR2(50), "
                                           + "CAPTION6 VARCHAR2(50), "
                                           + "CAPTION7 VARCHAR2(50), "
                                           + "IMAGEURL VARCHAR2(100))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE modify (MENUID varchar2(30))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table MENUTABLE modify (ITEMTYPE varchar2(20))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter table USERMENUS modify (MENUID varchar2(30))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table USERS add("
                                           + "EMAIL VARCHAR2(40), "
                                           + "LASTTIME VARCHAR2(8), "
                                           + "AUTOLOGIN VARCHAR2(1), "
                                           + "LASTDATE VARCHAR2(8), "
                                           + "SIGNATURE VARCHAR2(30), "
                                           + "MSAD VARCHAR2(1))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEP2006m)
                {
                    #region EEP2006m
                    command.CommandText = "Alter Table MENUFAVOR add (GROUPNAME VARCHAR2(20))";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    command.CommandText = "Alter Table SYS_TODOLIST add (ATTACHMENTS VARCHAR2(255) NULL)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }

                    command.CommandText = "Alter Table SYS_TODOHIS add (ATTACHMENTS VARCHAR2(255) NULL)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        result += e.Message + "\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.WorkFlow)
                {
                    #region WorkFlow
                    //GROUPS
                    command.CommandText = "ALTER TABLE GROUPS ADD ISROLE CHAR(1) NULL";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not add ISROLE column to GROUPS table.\n\r";
                    }
                    // SYS_ORG
                    command.CommandText = "CREATE TABLE SYS_ORG(" +
                                        "ORG_NO varchar2(8) NOT NULL," +
                                        "ORG_DESC varchar2(40) NOT NULL," +
                                        "ORG_KIND varchar2(4) NOT NULL," +
                                        "UPPER_ORG varchar2(8) NULL," +
                                        "ORG_MAN varchar2(20) NOT NULL," +
                                        "LEVEL_NO varchar2(6) NOT NULL," +
                                        "ORG_TREE varchar2(40) NULL," +
                                        "END_ORG varchar2(4) NULL," +
                                        "ORG_FULLNAME varchar2(254) NULL," +
                                        "PRIMARY KEY(ORG_NO)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORG(ORG_NO,ORG_DESC,ORG_KIND,ORG_MAN,LEVEL_NO) Values ('1','總公司','0','001','9')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORG table.\n\r";
                    }

                    // SYS_ORGKIND
                    command.CommandText = "CREATE TABLE SYS_ORGKIND(" +
                                        "ORG_KIND varchar2(4) NOT NULL," +
                                        "KIND_DESC varchar2(40) NOT NULL," +
                                        "PRIMARY KEY(ORG_KIND)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "INSERT INTO SYS_ORGKIND(ORG_KIND,KIND_DESC) Values ('0','公司組織')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGKIND table.\n\r";
                    }

                    // SYS_ORGLEVEL
                    command.CommandText = "CREATE TABLE SYS_ORGLEVEL(" +
                                        "LEVEL_NO varchar2(6) NOT NULL," +
                                        "LEVEL_DESC varchar2(40) NOT NULL," +
                                        "PRIMARY KEY(LEVEL_NO)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('0','直屬主管')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('1','主任/課長/副理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('2','經理')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('3','副總')";
                        command.ExecuteNonQuery();
                        command.CommandText = "INSERT INTO SYS_ORGLEVEL(LEVEL_NO,LEVEL_DESC) Values ('9','總經理')";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGLEVEL table.\n\r";
                    }

                    // SYS_ORGROLES
                    command.CommandText = "CREATE TABLE SYS_ORGROLES(" +
                                        "ORG_NO varchar2(8) NOT NULL," +
                                        "ROLE_ID varchar2(20) NOT NULL," +
                                        "ORG_KIND varchar2(4) NULL," +
                                        "PRIMARY KEY(ORG_NO,ROLE_ID)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ORGROLES table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ORGNO ON SYS_ORGROLES(ORG_NO, ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX ORGNO on table SYS_ORGROLES .\n\r";
                    }

                    // SYS_ROLES_AGENT
                    command.CommandText = "CREATE TABLE SYS_ROLES_AGENT(" +
                                        "ROLE_ID varchar2(20) NULL," +
                                        "AGENT varchar2(20) NOT NULL," +
                                        "FLOW_DESC varchar2(40) NOT NULL," +
                                        "START_DATE varchar2(8) NOT NULL," +
                                        "START_TIME varchar2(6) NULL," +
                                        "END_DATE varchar2(8) NOT NULL," +
                                        "END_TIME varchar2(6) NULL," +
                                        "PAR_AGENT varchar2(4) NOT NULL," +
                                        "REMARK varchar2(254) NULL," +
                                        "PRIMARY KEY(ROLE_ID,AGENT)" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_ROLES_AGENT table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX ROLEID ON SYS_ROLES_AGENT(ROLE_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX ROLEID on table SYS_ROLES_AGENT .\n\r";
                    }

                    // SYS_TODOHIS
                    command.CommandText = "CREATE TABLE SYS_TODOHIS(" +
                                        "LISTID varchar2(40) NOT NULL," +
                                        "FLOW_ID varchar2(40) NOT NULL," +
                                        "FLOW_DESC varchar2(40) NULL," +
                                        "ROLE_ID varchar2(20) NULL," +
                                        "S_ROLE_ID varchar2(20) NULL," +
                                        "S_STEP_ID varchar2(20) NULL," +
                                        "D_STEP_ID varchar2(20) NULL," +
                                        "S_STEP_DESC varchar2(64) NULL," +
                                        "S_USER_ID varchar2(20) NULL," +
                                        "USER_ID varchar2(20) NOT NULL," +
                                        "USERNAME varchar2(30) NULL," +
                                        "FORM_NAME varchar2(30) NULL," +
                                        "WEBFORM_NAME varchar2(50) NULL," +
                                        "S_USERNAME varchar2(30) NULL," +
                                        "NAVIGATOR_MODE varchar2(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE varchar2(2) NOT NULL," +
                                        "PARAMETERS varchar2(254) NULL," +
                                        "STATUS varchar2(4) NULL," +
                                        "PROC_TIME number(8, 2) NOT NULL," +
                                        "EXP_TIME number(8, 2) NOT NULL," +
                                        "TIME_UNIT varchar2(4) NOT NULL," +
                                        "FLOWIMPORTANT varchar2(1) NOT NULL," +
                                        "FLOWURGENT varchar2(1) NOT NULL," +
                                        "FORM_TABLE varchar2(30) NULL," +
                                        "FORM_KEYS varchar2(254) NULL," +
                                        "FORM_PRESENTATION varchar2(254) NULL," +
                                        "REMARK varchar2(254) NULL," +
                                        "VERSION varchar2(2) NULL," +
                                        "VDSNAME varchar2(40) NULL," +
                                        "SENDBACKSTEP varchar2(2) NULL," +
                                        "LEVEL_NO varchar2(6) NULL," +
                                        "UPDATE_DATE varchar2(10) NULL," +
                                        "UPDATE_TIME varchar2(8) NULL," +
                                        "FORM_PRESENT_CT varchar2(254) NULL," +
                                        "ATTACHMENTS varchar2(255) NULL," +
                                        "CREATE_TIME varchar2(50) NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOHIS table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOHIS(LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX LISTID on table SYS_TODOHIS.\n\r";
                    }

                    command.CommandText = "CREATE INDEX USERID ON SYS_TODOHIS(USER_ID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX USERID on table SYS_TODOHIS.\n\r";
                    }

                    // SYS_TODOLIST
                    command.CommandText = "CREATE TABLE SYS_TODOLIST(" +
                                        "LISTID varchar2(40) NOT NULL," +
                                        "FLOW_ID varchar2(40) NOT NULL," +
                                        "FLOW_DESC varchar2(40) NULL," +
                                        "APPLICANT varchar2(20) NOT NULL," +
                                        "S_USER_ID varchar2(20) NULL," +
                                        "S_STEP_ID varchar2(20) NULL," +
                                        "S_STEP_DESC varchar2(64) NULL," +
                                        "D_STEP_ID varchar2(20) NULL," +
                                        "D_STEP_DESC varchar2(64) NULL," +
                                        "EXP_TIME number(8, 2) NOT NULL," +
                                        "URGENT_TIME number(8, 2) NOT NULL," +
                                        "TIME_UNIT varchar2(4) NOT NULL," +
                                        "USERNAME varchar2(30) NULL," +
                                        "FORM_NAME varchar2(30) NULL," +
                                        "NAVIGATOR_MODE varchar2(2) NOT NULL," +
                                        "FLNAVIGATOR_MODE varchar2(2) NOT NULL," +
                                        "PARAMETERS varchar2(254) NULL," +
                                        "SENDTO_KIND varchar2(4) NOT NULL," +
                                        "SENDTO_ID varchar2(20) NOT NULL," +
                                        "FLOWIMPORTANT varchar2(1) NOT NULL," +
                                        "FLOWURGENT varchar2(1) NOT NULL," +
                                        "STATUS varchar2(4) NULL," +
                                        "FORM_TABLE varchar2(30) NULL," +
                                        "FORM_KEYS varchar2(254) NULL," +
                                        "FORM_PRESENTATION varchar2(254) NULL," +
                                        "FORM_PRESENT_CT varchar2(254) NOT NULL," +
                                        "REMARK varchar2(254) NULL," +
                                        "PROVIDER_NAME varchar2(254) NULL," +
                                        "VERSION varchar2(2) NULL," +
                                        "EMAIL_ADD varchar2(40) NULL," +
                                        "EMAIL_STATUS varchar2(1) NULL," +
                                        "VDSNAME varchar2(40) NULL," +
                                        "SENDBACKSTEP varchar2(2) NULL," +
                                        "LEVEL_NO varchar2(6) NULL," +
                                        "WEBFORM_NAME varchar2(50) NULL," +
                                        "UPDATE_DATE varchar2(10) NULL," +
                                        "UPDATE_TIME varchar2(8) NULL," +
                                        "FLOWPATH varchar2(100) NOT NULL," +
                                        "PLUSAPPROVE varchar2(1) NOT NULL," +
                                        "PLUSROLES varchar2(254) NULL," +
                                        "MULTISTEPRETURN varchar2(1) NULL," +
                                        "SENDTO_NAME varchar2(30) NULL," +
                                        "ATTACHMENTS varchar2(255) NULL," +
                                        "CREATE_TIME varchar2(50) NULL" +
                                        ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_TODOLIST table.\n\r";
                    }

                    command.CommandText = "CREATE INDEX LISTID ON SYS_TODOLIST(LISTID)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX LISTID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX SENDTOID ON SYS_TODOLIST(SENDTO_ID, SENDTO_KIND)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX SENDTOID on table SYS_TODOLIST.\n\r";
                    }

                    command.CommandText = "CREATE INDEX FLOWDESC ON SYS_TODOLIST(FLOW_DESC)";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        //result += "Can not create INDEX FLOWDESC on table SYS_TODOLIST.\n\r";
                    }

                    // SYS_FLDefinition
                    command.CommandText = "CREATE TABLE SYS_FLDEFINITION"
                                            + "("
                                            + "FLTYPEID varchar2(50) NOT NULL, "
                                            + "FLTYPENAME varchar2(200) NOT NULL, "
                                            + "FLDEFINITION blob NOT NULL, "
                                            + "VERSION int NULL,"
                                            + "PRIMARY KEY(FLTYPEID)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLDEFINITION table.\n\r";
                    }

                    // SYS_FLInstanceState
                    command.CommandText = "CREATE TABLE SYS_FLINSTANCESTATE"
                                            + "("
                                            + "FLINSTANCEID varchar2(50) NOT NULL, "
                                            + "STATE blob NOT NULL, "
                                            + "STATUS int NULL, "
                                            + "INFO varchar2(200) NULL,"
                                            + "PRIMARY KEY(FLINSTANCEID)"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_FLINSTANCESTATE table.\n\r";
                    }

                    // Sys_ExtApprove
                    command.CommandText = "CREATE TABLE SYS_EXTAPPROVE"
                                            + "("
                                            + "APPROVEID varchar2(50) NULL, "
                                            + "GROUPID varchar2(50) NULL, "
                                            + "MINIMUM varchar2(50) NULL, "
                                            + "MAXIMUM varchar2(50) NULL,"
                                            + "ROLEID varchar2(50) NULL"
                                            + ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_EXTAPPROVE table.\n\r";
                    }
                    #endregion
                }
                else if (cdb.x == radioType.EEPCloud)
                {
                    #region EEPCloud
                    //[SYS_SDALIAS]
                    command.CommandText = "CREATE TABLE SYS_SDALIAS(" +
                                           "    USERID varchar2(20) NOT NULL,    " +
                                           "    ALIASNAME varchar2(30) NOT NULL, " +
                                           "    SYSTEMALIAS varchar2(30) NULL,   " +
                                           "    DBNAME varchar2(25) NOT NULL,    " +
                                           "    SPLIT number NULL,                 " +
                                           " CONSTRAINT PK_SYS_SDALIAS PRIMARY KEY " +
                                           "(                                                  " +
                                           "    USERID ,                                  " +
                                           "    ALIASNAME ,                               " +
                                           "    DBNAME                                    " +
                                           ")" +
                                           ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDALIAS table.\n\r";
                    }

                    //[SYS_SDGROUPS]
                    command.CommandText = "CREATE TABLE SYS_SDGROUPS(" +
                                          "    GROUPID varchar2(20) NOT NULL,               " +
                                          "    GROUPNAME varchar2(30) NULL,                 " +
                                          " CONSTRAINT PK_SYS_SDGROUPS PRIMARY KEY " +
                                          "(                                                   " +
                                          "    GROUPID                                   " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDGROUPS table.\n\r";
                    }

                    //[SYS_SDQUEUE]
                    command.CommandText = "CREATE TABLE SYS_SDQUEUE(" +
                                          "    ID int NOT NULL,                           " +
                                          "    USERID varchar2(30) NOT NULL,               " +
                                          "    PAGETYPE char(1) NOT NULL,                 " +
                                          "    CREATETIME date NULL,                  " +
                                          "    FINISHTIME date NULL,                  " +
                                          "    FINISHFLAG number NOT NULL,                   " +
                                          "    DOCUMENT blob NULL,              " +
                                          "    FILENAME varchar2(40) NULL,                 " +
                                          "    PRINTSETTING varchar2(40) NULL,             " +
                                          " CONSTRAINT PK_SYS_SDQUEUE PRIMARY KEY " +
                                          "(                                                  " +
                                          "    ID                                       " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDQUEUE table.\n\r";
                    }

                    //[SYS_SDQUEUEPAGE]
                    command.CommandText = "CREATE TABLE SYS_SDQUEUEPAGE(" +
                                          "    ID int NOT NULL,                                  " +
                                          "    DOCUMENT blob NOT NULL,                 " +
                                          "    PHOTO blob NULL,                        " +
                                          "    PAGENAME varchar2(30) NOT NULL,                    " +
                                          "    CONSTRAINT PK_SYS_SDQUEUEPAGE PRIMARY KEY " +
                                          "(                                                         " +
                                          "    ID ,                                             " +
                                          "    PAGENAME                                         " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();

                        command.CommandText = "ALTER TABLE SYS_SDQUEUEPAGE  WITH CHECK ADD  CONSTRAINT FK_SYS_SDQUEUEPAGE_SYS_SDQUEUE FOREIGN KEY(ID) " +
                                              "REFERENCES SYS_SDQUEUE (ID)";
                        command.ExecuteNonQuery();

                        command.CommandText = "ALTER TABLE SYS_SDQUEUEPAGE CHECK CONSTRAINT FK_SYS_SDQUEUEPAGE_SYS_SDQUEUE";
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDQUEUEPAGE table.\n\r";
                    }

                    //[SYS_SDSOLUTIONS]
                    command.CommandText = "CREATE TABLE SYS_SDSOLUTIONS(" +
                                          "    USERID varchar2(20) NOT NULL,                   " +
                                          "    SOLUTIONID varchar2(30) NOT NULL,               " +
                                          "    SOLUTIONNAME nvarchar2(30) NULL,                " +
                                          "    MOUDLEXMLTEXT nvarchar2(max) NOT NULL,          " +
                                          "    SETTING blob NULL,                   " +
                                          "    ALIASOPTIONS varchar2(250) NULL,                " +
                                          "    LOGONIMAGE blob NULL,                " +
                                          "    BGSTARTCOLOR varchar2(9) NULL,                  " +
                                          "    BGENDCOLOR varchar2(9) NULL,                    " +
                                          "    THEME varchar2(20) NULL,                        " +
                                          "    COMPANY nvarchar2(30) NULL,                     " +
                                          "    PAGESAVEOPTION int NULL,                       " +
                                          " CONSTRAINT PK_SYS_SDSOLUTIONS PRIMARY KEY " +
                                          "(                                                      " +
                                          "    USERID ,                                      " +
                                          "    SOLUTIONID                                    " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDSOLUTIONS table.\n\r";
                    }

                    //[SYS_SDUSERS]
                    command.CommandText = "CREATE TABLE SYS_SDUSERS(" +
                                          "    USERID varchar2(20) NOT NULL,               " +
                                          "    USERNAME nvarchar2(30) NULL,                " +
                                          "    PASSWORD varchar2(20) NULL,                 " +
                                          "    GROUPID varchar2(20) NULL,                  " +
                                          "    LASTDATE date NULL,                    " +
                                          "    EMAIL nvarchar2(50) NULL,                   " +
                                          "    SYSTYPE nvarchar2(1) NULL,                  " +
                                          " CONSTRAINT PK_SYS_SDUSERS PRIMARY KEY " +
                                          "(                                                  " +
                                          "    USERID                                    " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDUSERS table.\n\r";
                    }

                    //[SYS_SDUSERS_LOG] iii
                    command.CommandText = "CREATE TABLE SYS_SDUSERS_LOG(" +
                                          "    ID int NOT NULL,                 " +
                                          "    USERID varchar2(20) NOT NULL,                   " +
                                          "    IPADDRESS varchar2(20) NOT NULL,                " +
                                          "    LOGINTIME date NOT NULL,                   " +
                                          "    LOGOUTTIME date NOT NULL,                  " +
                                          " CONSTRAINT PK_SYS_SDUSERS_LOG PRIMARY KEY " +
                                          "(                                                      " +
                                          "    ID                                            " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_SDUSERS_LOG table.\n\r";
                    }

                    //[SYS_WEBPAGES]
                    command.CommandText = "CREATE TABLE SYS_WEBPAGES(" +
                                          "    PAGENAME varchar2(30) NOT NULL,              " +
                                          "    PAGETYPE char(1) NOT NULL,                  " +
                                          "    DESCRIPTION varchar2(60) NULL,               " +
                                          "    CONTENT blob NULL,                " +
                                          "    USERID varchar2(20) NOT NULL,                " +
                                          "    SOLUTIONID varchar2(30) NOT NULL,            " +
                                          "    SERVERDLL blob NULL,              " +
                                          "    CHECKOUT number NULL,                          " +
                                          "    CHECKOUTDATE date NULL,                 " +
                                          "    CHECKOUTUSER varchar2(20) NULL,              " +
                                          " CONSTRAINT PK_SYS_WEBPAGES PRIMARY KEY " +
                                          "(                                                   " +
                                          "    PAGENAME ,                                 " +
                                          "    PAGETYPE ,                                 " +
                                          "    USERID ,                                   " +
                                          "    SOLUTIONID                                 " +
                                          ")" +
                                          ") ";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_WEBPAGES table.\n\r";
                    }

                    //[SYS_WEBPAGES_LOG] iii
                    command.CommandText = "CREATE TABLE SYS_WEBPAGES_LOG(" +
                                          "    PAGENAME varchar2(30) NOT NULL,                  " +
                                          "    PAGETYPE char(1) NOT NULL,                      " +
                                          "    DESCRIPTION varchar2(60) NULL,                   " +
                                          "    CONTENT blob NULL,                    " +
                                          "    USERID varchar2(20) NOT NULL,                    " +
                                          "    SOLUTIONID varchar2(30) NOT NULL,                " +
                                          "    SERVERDLL blob NULL,                  " +
                                          "    CHECKINDATE date NOT NULL,                  " +
                                          "    ID int NOT NULL,                  " +
                                          "    CHECKINUSER varchar2(20) NULL,                   " +
                                          "    CHECKINDESCRIPTION varchar2(255) NULL,           " +
                                          " CONSTRAINT PK_SYS_WEBPAGES_LOG PRIMARY KEY " +
                                          "(                                                       " +
                                          "    ID                                             " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_WEBPAGES_LOG table.\n\r";
                    }

                    //[SYS_WEBRUNTIME]
                    command.CommandText = "CREATE TABLE SYS_WEBRUNTIME(" +
                                          "    PAGENAME varchar2(30) NOT NULL,                " +
                                          "    PAGETYPE char(1) NOT NULL,                    " +
                                          "    CONTENT blob NULL,                  " +
                                          "    USERID varchar2(20) NOT NULL,                  " +
                                          "    SOLUTIONID varchar2(30) NOT NULL,              " +
                                          " CONSTRAINT PK_SYS_WEBRUNTIME PRIMARY KEY " +
                                          "(                                                     " +
                                          "    PAGENAME ,                                   " +
                                          "    PAGETYPE ,                                   " +
                                          "    USERID ,                                     " +
                                          "    SOLUTIONID                                   " +
                                          ")" +
                                          ")";
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch
                    {
                        result += "Can not create SYS_WEBRUNTIME table.\n\r";
                    }
                    #endregion

                }

                if (result != "")
                    MessageBox.Show(result);
                else if (cdb.x == radioType.typical)
                    MessageBox.Show("Create all System Tables successfully.");
                else if (cdb.x == radioType.simplified)
                    MessageBox.Show("Create table COLDEF table and table SYSAUTONUM successfully.");
                else if (cdb.x == radioType.EEP7m)
                    MessageBox.Show("Alter successfully.");
                else if (cdb.x == radioType.EEP2006m)
                    MessageBox.Show("EEP 2006 2.1.0.1(SP2) Migration success");
                else if (cdb.x == radioType.WorkFlow)
                    MessageBox.Show("Create WorkFlow Tables successfully.");
                else if (cdb.x == radioType.EEPCloud)
                    MessageBox.Show("Create EEPCloud system tables successfully.");
            }
        }