コード例 #1
0
 public InfoTransactionEditorTTransactionDialog(Transaction trans, IDesignerHost host, string srctablename)
 {
     transaction = trans;
     DesignerHost = host;
     uctran = (this.transaction.Owner as InfoTransaction).UpdateComp;
     _conn = FindConnection(uctran);
     InitializeComponent();
     this.SrcTableName = srctablename;
 }
コード例 #2
0
 public InfoTransactionEditorKeyFieldsDialog(Transaction trans, UpdateComponent uc, string destablename, string srctablename)
 {
     transaction = trans;
     uctran = uc;
     _conn = FindConnection(uctran);
     strDesTable = destablename;
     strSrcTable = srctablename;
     InitializeComponent();
 }
コード例 #3
0
ファイル: InfoTransaction.cs プロジェクト: san90279/UK_OAS
        public InfoTransaction(System.ComponentModel.IContainer container)
        {
            ///
            /// Required for Windows.Forms Class Composition Designer support
            ///
            container.Add(this);
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
            // _timing = Timing.Insert;
            // _timing = new TimingType[] {TimingType.OnInsert, TimingType.OnUpdate, TimingType.OnDelete };
            _transactions = new TransactionCollection(this, typeof(Transaction));
            _updateComp = null;
        }
コード例 #4
0
ファイル: InfoTransaction.cs プロジェクト: san90279/UK_OAS
        public InfoTransaction()
        {
            ///
            /// This call is required by the Windows.Forms Designer.
            ///
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
            // _timing = Timing.Insert;
            // _timing = new TimingType[] { TimingType.OnInsert, TimingType.OnUpdate, TimingType.OnDelete };
            _transactions = new TransactionCollection(this, typeof(Transaction));
            _updateComp = null;
        }
コード例 #5
0
        private IDbConnection FindConnection(UpdateComponent uc)
        {
            IDbConnection idbcon = null;

            if (uc == null)
            {
                return null;
            }
            else if (uc.SelectCmd == null)
            {
                return null;
            }
            else if (uc.SelectCmd.InfoConnection == null)
            {
                return null;
            }
            else
            {
                idbcon = uc.SelectCmd.InfoConnection;
            }
            return idbcon;
        }
コード例 #6
0
ファイル: Component.cs プロジェクト: san90279/UK_OAS
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     this.ucMaster = new Srvtools.UpdateComponent(this.components);
     this.Master = new Srvtools.InfoCommand(this.components);
     this.infoConnection = new Srvtools.InfoConnection();
     this.serviceManager = new Srvtools.ServiceManager(this.components);
     this.Detail = new Srvtools.InfoCommand(this.components);
     this.idsRelation = new Srvtools.InfoDataSource(this.components);
     this.ucDetail = new Srvtools.UpdateComponent(this.components);
     ((System.ComponentModel.ISupportInitialize)(this.Master)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.Detail)).BeginInit();
     //
     // ucMaster
     //
     this.ucMaster.AutoTrans = true;
     this.ucMaster.ExceptJoin = false;
     this.ucMaster.LogInfo = null;
     this.ucMaster.Name = "ucMaster";
     this.ucMaster.SelectCmd = this.Master;
     this.ucMaster.ServerModify = true;
     this.ucMaster.ServerModifyGetMax = false;
     this.ucMaster.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucMaster.WhereMode = Srvtools.WhereModeType.Keyfields;
     //
     // Master
     //
     this.Master.CommandText = "";
     this.Master.CommandTimeout = 30;
     this.Master.CommandType = System.Data.CommandType.Text;
     this.Master.EEPAlias = null;
     this.Master.InfoConnection = this.infoConnection;
     this.Master.Name = "Master";
     this.Master.NotificationAutoEnlist = false;
     this.Master.SecExcept = null;
     this.Master.SecFieldName = "";
     this.Master.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.Master.SelectTop = 0;
     this.Master.SiteControl = false;
     this.Master.SiteFieldName = "";
     this.Master.Transaction = null;
     this.Master.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // infoConnection
     //
     this.infoConnection.ConnectionType = Srvtools.ConnectionType.SqlClient;
     //
     // Detail
     //
     this.Detail.CommandText = "";
     this.Detail.CommandTimeout = 30;
     this.Detail.CommandType = System.Data.CommandType.Text;
     this.Detail.EEPAlias = null;
     this.Detail.InfoConnection = this.infoConnection;
     this.Detail.Name = "Detail";
     this.Detail.NotificationAutoEnlist = false;
     this.Detail.SecExcept = null;
     this.Detail.SecFieldName = "";
     this.Detail.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.Detail.SelectTop = 0;
     this.Detail.SiteControl = false;
     this.Detail.SiteFieldName = "";
     this.Detail.Transaction = null;
     this.Detail.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // idsRelation
     //
     this.idsRelation.Detail = this.Detail;
     this.idsRelation.Master = this.Master;
     //
     // ucDetail
     //
     this.ucDetail.AutoTrans = true;
     this.ucDetail.ExceptJoin = false;
     this.ucDetail.LogInfo = null;
     this.ucDetail.Name = "ucDetail";
     this.ucDetail.SelectCmd = this.Detail;
     this.ucDetail.ServerModify = true;
     this.ucDetail.ServerModifyGetMax = false;
     this.ucDetail.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucDetail.WhereMode = Srvtools.WhereModeType.Keyfields;
     ((System.ComponentModel.ISupportInitialize)(this.Master)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.Detail)).EndInit();
 }
コード例 #7
0
ファイル: InfoDataModule.cs プロジェクト: san90279/UK_OAS
        private void UpdateDataSet(string sSqlCommand, DataSet custDS, bool designMode, string alias, IDbCommand cmd, UpdateComponent uc, List<string> sqlSentences, IDbConnection conn)
        {
            IDbTransaction dbTrans = null;
            Boolean b = false;

            // q 表示master是否有更改。
            bool q = false;
            try
            {
                if (!uc.UseTranscationScope)
                {
                    if (cmd.Connection is OdbcConnection)
                    {
                        uc.AutoTrans = false;
                    }

                    if (uc.AutoTrans)
                    {
                        dbTrans = cmd.Connection.BeginTransaction(uc.TransIsolationLevel);
                        uc.SetTransaction(dbTrans);
                    }
                }

                // ------------------------------------------------------------------------------------
                // Delete先做Details,再做Master。
                DataSet setQ = custDS.GetChanges(DataRowState.Deleted);
                if (setQ != null)
                {
                    ArrayList mySDC = new ArrayList();
                    ArrayList mySDC1 = new ArrayList();

                    ArrayList myDC = GetDetailCommandUp(cmd, mySDC);
                    ArrayList myDC1 = GetDetailCommandUp(cmd, mySDC1, true);

                    for (int i = 0; i < myDC.Count; i++)
                    {
                        sqlSentences.AddRange(_UpdateDataSet(conn, (IDbCommand)myDC[i], custDS, (string)mySDC[i], dbTrans, 1));
                    }

                    for (int i = 0; i < myDC1.Count; i++)
                    {
                        sqlSentences.AddRange(_UpdateDataSet(conn, (IDbCommand)myDC1[i], custDS, (string)mySDC1[i], dbTrans, true, 1));
                    }

                    DataTable tableQ = custDS.Tables[sSqlCommand].GetChanges(DataRowState.Deleted);
                    if (tableQ != null)
                    {
                        //q = true;
                        string tablename = this.GetTableName(cmd, false);
                        string replaceCmd = (string)((object[])ClientInfo)[1];
                        if (conn is OdbcConnection || conn is OleDbConnection)
                            sqlSentences.AddRange(uc.Update(custDS, sSqlCommand, false, replaceCmd, 1, tablename));
                        else
                            sqlSentences.AddRange(uc.Update(custDS, sSqlCommand, replaceCmd, 1));
                    }
                }

                // ------------------------------------------------------------------------------------
                setQ = custDS.GetChanges(DataRowState.Added | DataRowState.Modified);
                if (setQ != null)
                {
                    DataTable tableQ = custDS.Tables[sSqlCommand].GetChanges(DataRowState.Added | DataRowState.Modified);
                    if (tableQ != null)
                    {
                        q = custDS.Tables[sSqlCommand].GetChanges(DataRowState.Added) != null;
                        string replaceCmd = (string)((object[])ClientInfo)[1];
                        string tablename = this.GetTableName(cmd, false);
                        if (conn is OdbcConnection || conn is OleDbConnection || conn.GetType().Name == "IfxConnection")
                            sqlSentences.AddRange(uc.Update(custDS, sSqlCommand, false, replaceCmd, 2, tablename));
                        else
                            sqlSentences.AddRange(uc.Update(custDS, sSqlCommand, replaceCmd, 2));
                    }

                    ArrayList mySDC = new ArrayList();
                    ArrayList mySDC1 = new ArrayList();

                    ArrayList myDC = GetDetailCommandDown(cmd, mySDC);
                    ArrayList myDC1 = GetDetailCommandDown(cmd, mySDC1, true);
                    for (int i = 0; i < myDC.Count; i++)
                    {
                        sqlSentences.AddRange(_UpdateDataSet(conn, (IDbCommand)myDC[i], custDS, (string)mySDC[i], dbTrans, 2));
                    }

                    for (int i = 0; i < myDC1.Count; i++)
                    {
                        sqlSentences.AddRange(_UpdateDataSet(conn, (IDbCommand)myDC1[i], custDS, (string)mySDC1[i], dbTrans, true, 2));
                    }
                }
            }
            catch
            {
                if (!uc.UseTranscationScope)
                {
                    if (uc.AutoTrans)
                    {
                        b = true;
                        dbTrans.Rollback();
                    }
                }
                throw;
            }
            finally
            {
                if (!uc.UseTranscationScope)
                {
                    if (uc.AutoTrans && !b)
                    {
                        dbTrans.Commit();
                    }
                }
                uc.OnAfterApplied(new EventArgs());
                // 同步identity字段
                // Added by yangdong.
                if (q && uc.ServerModify)
                {
                    string tablename = this.GetTableName(cmd, false);
                    if (conn is OdbcConnection || conn is OleDbConnection || conn.GetType().Name == "IfxConnection")
                        uc.IdentitySync(custDS, sSqlCommand, tablename);
                    else
                        uc.IdentitySync(custDS, sSqlCommand);
                }
                if (!designMode)
                {
                    ReleaseConnection(alias, cmd.Connection);
                }
                else
                {
                    cmd.Connection.Close();
                }

            }
        }
コード例 #8
0
ファイル: Component.cs プロジェクト: san90279/UK_OAS
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     Srvtools.KeyItem keyItem1 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem2 = new Srvtools.KeyItem();
     Srvtools.ColumnItem columnItem1 = new Srvtools.ColumnItem();
     Srvtools.ColumnItem columnItem2 = new Srvtools.ColumnItem();
     Srvtools.ColumnItem columnItem3 = new Srvtools.ColumnItem();
     Srvtools.ColumnItem columnItem4 = new Srvtools.ColumnItem();
     Srvtools.KeyItem keyItem3 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem4 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem5 = new Srvtools.KeyItem();
     Srvtools.FieldAttr fieldAttr1 = new Srvtools.FieldAttr();
     Srvtools.FieldAttr fieldAttr2 = new Srvtools.FieldAttr();
     Srvtools.KeyItem keyItem6 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem7 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem8 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem9 = new Srvtools.KeyItem();
     Srvtools.ColumnItem columnItem5 = new Srvtools.ColumnItem();
     Srvtools.ColumnItem columnItem6 = new Srvtools.ColumnItem();
     Srvtools.KeyItem keyItem10 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem11 = new Srvtools.KeyItem();
     Srvtools.FieldAttr fieldAttr3 = new Srvtools.FieldAttr();
     Srvtools.KeyItem keyItem12 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem13 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem14 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem15 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem16 = new Srvtools.KeyItem();
     Srvtools.Service service1 = new Srvtools.Service();
     Srvtools.Service service2 = new Srvtools.Service();
     Srvtools.Service service3 = new Srvtools.Service();
     Srvtools.Service service4 = new Srvtools.Service();
     Srvtools.Service service5 = new Srvtools.Service();
     Srvtools.Service service6 = new Srvtools.Service();
     Srvtools.Service service7 = new Srvtools.Service();
     Srvtools.Service service8 = new Srvtools.Service();
     Srvtools.Service service9 = new Srvtools.Service();
     Srvtools.Service service10 = new Srvtools.Service();
     Srvtools.Service service11 = new Srvtools.Service();
     Srvtools.Service service12 = new Srvtools.Service();
     Srvtools.Service service13 = new Srvtools.Service();
     Srvtools.Service service14 = new Srvtools.Service();
     Srvtools.Service service15 = new Srvtools.Service();
     Srvtools.Service service16 = new Srvtools.Service();
     Srvtools.Service service17 = new Srvtools.Service();
     Srvtools.Service service18 = new Srvtools.Service();
     Srvtools.Service service19 = new Srvtools.Service();
     Srvtools.Service service20 = new Srvtools.Service();
     Srvtools.Service service21 = new Srvtools.Service();
     Srvtools.Service service22 = new Srvtools.Service();
     Srvtools.Service service23 = new Srvtools.Service();
     Srvtools.Service service24 = new Srvtools.Service();
     Srvtools.Service service25 = new Srvtools.Service();
     Srvtools.Service service26 = new Srvtools.Service();
     Srvtools.Service service27 = new Srvtools.Service();
     Srvtools.Service service28 = new Srvtools.Service();
     Srvtools.Service service29 = new Srvtools.Service();
     Srvtools.Service service30 = new Srvtools.Service();
     Srvtools.Service service31 = new Srvtools.Service();
     Srvtools.Service service32 = new Srvtools.Service();
     Srvtools.Service service33 = new Srvtools.Service();
     Srvtools.Service service34 = new Srvtools.Service();
     Srvtools.Service service35 = new Srvtools.Service();
     Srvtools.Service service36 = new Srvtools.Service();
     Srvtools.Service service37 = new Srvtools.Service();
     Srvtools.Service service38 = new Srvtools.Service();
     Srvtools.Service service39 = new Srvtools.Service();
     Srvtools.Service service40 = new Srvtools.Service();
     Srvtools.Service service41 = new Srvtools.Service();
     Srvtools.Service service42 = new Srvtools.Service();
     Srvtools.Service service43 = new Srvtools.Service();
     Srvtools.Service service44 = new Srvtools.Service();
     Srvtools.Service service45 = new Srvtools.Service();
     Srvtools.Service service46 = new Srvtools.Service();
     Srvtools.Service service47 = new Srvtools.Service();
     Srvtools.Service service48 = new Srvtools.Service();
     Srvtools.Service service49 = new Srvtools.Service();
     Srvtools.Service service50 = new Srvtools.Service();
     Srvtools.Service service51 = new Srvtools.Service();
     Srvtools.Service service52 = new Srvtools.Service();
     Srvtools.Service service53 = new Srvtools.Service();
     Srvtools.Service service54 = new Srvtools.Service();
     Srvtools.Service service55 = new Srvtools.Service();
     Srvtools.Service service56 = new Srvtools.Service();
     Srvtools.Service service57 = new Srvtools.Service();
     Srvtools.Service service58 = new Srvtools.Service();
     Srvtools.Service service59 = new Srvtools.Service();
     Srvtools.Service service60 = new Srvtools.Service();
     Srvtools.Service service61 = new Srvtools.Service();
     Srvtools.Service service62 = new Srvtools.Service();
     Srvtools.Service service63 = new Srvtools.Service();
     Srvtools.Service service64 = new Srvtools.Service();
     Srvtools.Service service65 = new Srvtools.Service();
     Srvtools.Service service66 = new Srvtools.Service();
     Srvtools.Service service67 = new Srvtools.Service();
     Srvtools.Service service68 = new Srvtools.Service();
     Srvtools.Service service69 = new Srvtools.Service();
     Srvtools.Service service70 = new Srvtools.Service();
     Srvtools.Service service71 = new Srvtools.Service();
     Srvtools.Service service72 = new Srvtools.Service();
     Srvtools.Service service73 = new Srvtools.Service();
     Srvtools.Service service74 = new Srvtools.Service();
     Srvtools.Service service75 = new Srvtools.Service();
     Srvtools.Service service76 = new Srvtools.Service();
     Srvtools.Service service77 = new Srvtools.Service();
     Srvtools.Service service78 = new Srvtools.Service();
     Srvtools.Service service79 = new Srvtools.Service();
     Srvtools.Service service80 = new Srvtools.Service();
     Srvtools.Service service81 = new Srvtools.Service();
     Srvtools.Service service82 = new Srvtools.Service();
     Srvtools.Service service83 = new Srvtools.Service();
     Srvtools.Service service84 = new Srvtools.Service();
     Srvtools.Service service85 = new Srvtools.Service();
     Srvtools.Service service86 = new Srvtools.Service();
     Srvtools.Service service87 = new Srvtools.Service();
     Srvtools.Service service88 = new Srvtools.Service();
     Srvtools.Service service89 = new Srvtools.Service();
     Srvtools.Service service90 = new Srvtools.Service();
     Srvtools.Service service91 = new Srvtools.Service();
     Srvtools.Service service92 = new Srvtools.Service();
     Srvtools.Service service93 = new Srvtools.Service();
     Srvtools.Service service94 = new Srvtools.Service();
     Srvtools.Service service95 = new Srvtools.Service();
     Srvtools.Service service96 = new Srvtools.Service();
     Srvtools.Service service97 = new Srvtools.Service();
     Srvtools.Service service98 = new Srvtools.Service();
     Srvtools.Service service99 = new Srvtools.Service();
     Srvtools.Service service100 = new Srvtools.Service();
     Srvtools.Service service101 = new Srvtools.Service();
     Srvtools.Service service102 = new Srvtools.Service();
     Srvtools.Service service103 = new Srvtools.Service();
     Srvtools.Service service104 = new Srvtools.Service();
     Srvtools.Service service105 = new Srvtools.Service();
     Srvtools.Service service106 = new Srvtools.Service();
     Srvtools.Service service107 = new Srvtools.Service();
     Srvtools.Service service108 = new Srvtools.Service();
     Srvtools.Service service109 = new Srvtools.Service();
     Srvtools.Service service110 = new Srvtools.Service();
     Srvtools.Service service111 = new Srvtools.Service();
     Srvtools.Service service112 = new Srvtools.Service();
     Srvtools.Service service113 = new Srvtools.Service();
     Srvtools.Service service114 = new Srvtools.Service();
     Srvtools.Service service115 = new Srvtools.Service();
     Srvtools.Service service116 = new Srvtools.Service();
     Srvtools.Service service117 = new Srvtools.Service();
     Srvtools.Service service118 = new Srvtools.Service();
     Srvtools.Service service119 = new Srvtools.Service();
     Srvtools.KeyItem keyItem17 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem18 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem19 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem20 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem21 = new Srvtools.KeyItem();
     Srvtools.KeyItem keyItem22 = new Srvtools.KeyItem();
     this.userInfo = new Srvtools.InfoCommand(this.components);
     this.groupInfo = new Srvtools.InfoCommand(this.components);
     this.UGInfo = new Srvtools.InfoCommand(this.components);
     this.sqlMGroups = new Srvtools.InfoCommand(this.components);
     this.sqlMGroupMenus = new Srvtools.InfoCommand(this.components);
     this.sqlMenus = new Srvtools.InfoCommand(this.components);
     this.dsUserGroups = new Srvtools.InfoDataSource(this.components);
     this.updateCompGroups = new Srvtools.UpdateComponent(this.components);
     this.updateCompUsers = new Srvtools.UpdateComponent(this.components);
     this.dsGroupMenus = new Srvtools.InfoDataSource(this.components);
     this.packageInfo = new Srvtools.InfoCommand(this.components);
     this.updateCompUGInfo = new Srvtools.UpdateComponent(this.components);
     this.updateCompSolution = new Srvtools.UpdateComponent(this.components);
     this.solutionInfo = new Srvtools.InfoCommand(this.components);
     this.menuTableLogInfo = new Srvtools.InfoCommand(this.components);
     this.updateCompMenuTableLog = new Srvtools.UpdateComponent(this.components);
     this.menuTableLogInfoWithoutBinary = new Srvtools.InfoCommand(this.components);
     this.updateCompMenuTableLogWithoutBinary = new Srvtools.UpdateComponent(this.components);
     this.cmdDBTables = new Srvtools.InfoCommand(this.components);
     this.cmdColDEF = new Srvtools.InfoCommand(this.components);
     this.updateColDEF = new Srvtools.UpdateComponent(this.components);
     this.cmdColDEF_Details = new Srvtools.InfoCommand(this.components);
     this.updateColDEF_Details = new Srvtools.UpdateComponent(this.components);
     this.cmdRefValUse = new Srvtools.InfoCommand(this.components);
     this.cmdERRLOG = new Srvtools.InfoCommand(this.components);
     this.updateERRLOG = new Srvtools.UpdateComponent(this.components);
     this.cmdSYSEEPLOGforDB = new Srvtools.InfoCommand(this.components);
     this.cmdDDUse = new Srvtools.InfoCommand(this.components);
     this.updateCompMGroupMenus = new Srvtools.UpdateComponent(this.components);
     this.userMenus = new Srvtools.InfoCommand(this.components);
     this.updateCompUserMenus = new Srvtools.UpdateComponent(this.components);
     this.packageversion = new Srvtools.InfoCommand(this.components);
     this.cmdSysRefVal = new Srvtools.InfoCommand(this.components);
     this.cmdSysRefVal_D = new Srvtools.InfoCommand(this.components);
     this.updateCompSysRefVal = new Srvtools.UpdateComponent(this.components);
     this.updateCompSysRefVal_D = new Srvtools.UpdateComponent(this.components);
     this.idsRefVal = new Srvtools.InfoDataSource(this.components);
     this.cmdToDoList = new Srvtools.InfoCommand(this.components);
     this.cmdToDoHis = new Srvtools.InfoCommand(this.components);
     this.cmdRoles = new Srvtools.InfoCommand(this.components);
     this.cmdOrgRoles = new Srvtools.InfoCommand(this.components);
     this.ucOrgRoles = new Srvtools.UpdateComponent(this.components);
     this.cmdOrgLevel = new Srvtools.InfoCommand(this.components);
     this.ucOrgLevel = new Srvtools.UpdateComponent(this.components);
     this.cmdOrgKind = new Srvtools.InfoCommand(this.components);
     this.ucOrgKind = new Srvtools.UpdateComponent(this.components);
     this.cmdWorkflow = new Srvtools.InfoCommand(this.components);
     this.cmdRoleAgent = new Srvtools.InfoCommand(this.components);
     this.ucRoleAgent = new Srvtools.UpdateComponent(this.components);
     this.cmdSlSource = new Srvtools.InfoCommand(this.components);
     this.serviceManager1 = new Srvtools.ServiceManager(this.components);
     this.cmdGROUPMENUCONTROL = new Srvtools.InfoCommand(this.components);
     this.cmdUSERMENUCONTROL = new Srvtools.InfoCommand(this.components);
     this.cmdSYS_REPORT = new Srvtools.InfoCommand(this.components);
     ((System.ComponentModel.ISupportInitialize)(this.userInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.groupInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.UGInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMGroups)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMGroupMenus)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMenus)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.packageInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.solutionInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.menuTableLogInfo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.menuTableLogInfoWithoutBinary)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdDBTables)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdColDEF)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdColDEF_Details)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRefValUse)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdERRLOG)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSYSEEPLOGforDB)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdDDUse)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.userMenus)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.packageversion)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSysRefVal)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSysRefVal_D)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdToDoList)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdToDoHis)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRoles)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgRoles)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgLevel)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgKind)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdWorkflow)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRoleAgent)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSlSource)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdGROUPMENUCONTROL)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdUSERMENUCONTROL)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSYS_REPORT)).BeginInit();
     //
     // userInfo
     //
     this.userInfo.CacheConnection = false;
     this.userInfo.CommandText = "select * from USERS order by USERID";
     this.userInfo.CommandTimeout = 0;
     this.userInfo.CommandType = System.Data.CommandType.Text;
     this.userInfo.DynamicTableName = false;
     this.userInfo.EEPAlias = null;
     this.userInfo.EncodingAfter = null;
     this.userInfo.EncodingBefore = "Windows-1252";
     this.userInfo.InfoConnection = null;
     keyItem1.KeyName = "USERID";
     this.userInfo.KeyFields.Add(keyItem1);
     this.userInfo.MultiSetWhere = false;
     this.userInfo.Name = "userInfo";
     this.userInfo.NotificationAutoEnlist = false;
     this.userInfo.SecExcept = "";
     this.userInfo.SecFieldName = null;
     this.userInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.userInfo.SelectPaging = false;
     this.userInfo.SelectTop = 0;
     this.userInfo.SiteControl = false;
     this.userInfo.SiteFieldName = null;
     this.userInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // groupInfo
     //
     this.groupInfo.CacheConnection = false;
     this.groupInfo.CommandText = "select * from GROUPS";
     this.groupInfo.CommandTimeout = 0;
     this.groupInfo.CommandType = System.Data.CommandType.Text;
     this.groupInfo.DynamicTableName = false;
     this.groupInfo.EEPAlias = null;
     this.groupInfo.EncodingAfter = null;
     this.groupInfo.EncodingBefore = "Windows-1252";
     this.groupInfo.InfoConnection = null;
     keyItem2.KeyName = "GROUPID";
     this.groupInfo.KeyFields.Add(keyItem2);
     this.groupInfo.MultiSetWhere = false;
     this.groupInfo.Name = "groupInfo";
     this.groupInfo.NotificationAutoEnlist = false;
     this.groupInfo.SecExcept = "";
     this.groupInfo.SecFieldName = null;
     this.groupInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.groupInfo.SelectPaging = false;
     this.groupInfo.SelectTop = 0;
     this.groupInfo.SiteControl = false;
     this.groupInfo.SiteFieldName = null;
     this.groupInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // UGInfo
     //
     this.UGInfo.CacheConnection = false;
     this.UGInfo.CommandText = "select USERGROUPS.*, USERS.USERNAME from USERGROUPS left join USERS on USERS.USER" +
     "ID = USERGROUPS.USERID";
     this.UGInfo.CommandTimeout = 0;
     this.UGInfo.CommandType = System.Data.CommandType.Text;
     this.UGInfo.DynamicTableName = false;
     this.UGInfo.EEPAlias = null;
     this.UGInfo.EncodingAfter = null;
     this.UGInfo.EncodingBefore = "Windows-1252";
     this.UGInfo.InfoConnection = null;
     this.UGInfo.MultiSetWhere = false;
     this.UGInfo.Name = "UGInfo";
     this.UGInfo.NotificationAutoEnlist = false;
     this.UGInfo.SecExcept = "";
     this.UGInfo.SecFieldName = null;
     this.UGInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.UGInfo.SelectPaging = false;
     this.UGInfo.SelectTop = 0;
     this.UGInfo.SiteControl = false;
     this.UGInfo.SiteFieldName = null;
     this.UGInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // sqlMGroups
     //
     this.sqlMGroups.CacheConnection = false;
     this.sqlMGroups.CommandText = "select * from GROUPS";
     this.sqlMGroups.CommandTimeout = 0;
     this.sqlMGroups.CommandType = System.Data.CommandType.Text;
     this.sqlMGroups.DynamicTableName = false;
     this.sqlMGroups.EEPAlias = null;
     this.sqlMGroups.EncodingAfter = null;
     this.sqlMGroups.EncodingBefore = "Windows-1252";
     this.sqlMGroups.InfoConnection = null;
     this.sqlMGroups.MultiSetWhere = false;
     this.sqlMGroups.Name = "sqlMGroups";
     this.sqlMGroups.NotificationAutoEnlist = false;
     this.sqlMGroups.SecExcept = "";
     this.sqlMGroups.SecFieldName = null;
     this.sqlMGroups.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.sqlMGroups.SelectPaging = false;
     this.sqlMGroups.SelectTop = 0;
     this.sqlMGroups.SiteControl = false;
     this.sqlMGroups.SiteFieldName = null;
     this.sqlMGroups.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // sqlMGroupMenus
     //
     this.sqlMGroupMenus.CacheConnection = false;
     this.sqlMGroupMenus.CommandText = "select * from GROUPMENUS";
     this.sqlMGroupMenus.CommandTimeout = 0;
     this.sqlMGroupMenus.CommandType = System.Data.CommandType.Text;
     this.sqlMGroupMenus.DynamicTableName = false;
     this.sqlMGroupMenus.EEPAlias = null;
     this.sqlMGroupMenus.EncodingAfter = null;
     this.sqlMGroupMenus.EncodingBefore = "Windows-1252";
     this.sqlMGroupMenus.InfoConnection = null;
     this.sqlMGroupMenus.MultiSetWhere = false;
     this.sqlMGroupMenus.Name = "sqlMGroupMenus";
     this.sqlMGroupMenus.NotificationAutoEnlist = false;
     this.sqlMGroupMenus.SecExcept = "";
     this.sqlMGroupMenus.SecFieldName = null;
     this.sqlMGroupMenus.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.sqlMGroupMenus.SelectPaging = false;
     this.sqlMGroupMenus.SelectTop = 0;
     this.sqlMGroupMenus.SiteControl = false;
     this.sqlMGroupMenus.SiteFieldName = null;
     this.sqlMGroupMenus.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // sqlMenus
     //
     this.sqlMenus.CacheConnection = false;
     this.sqlMenus.CommandText = "select * from MENUTABLE order by SEQ_NO,MENUID";
     this.sqlMenus.CommandTimeout = 0;
     this.sqlMenus.CommandType = System.Data.CommandType.Text;
     this.sqlMenus.DynamicTableName = false;
     this.sqlMenus.EEPAlias = null;
     this.sqlMenus.EncodingAfter = null;
     this.sqlMenus.EncodingBefore = "Windows-1252";
     this.sqlMenus.InfoConnection = null;
     this.sqlMenus.MultiSetWhere = false;
     this.sqlMenus.Name = "sqlMenus";
     this.sqlMenus.NotificationAutoEnlist = false;
     this.sqlMenus.SecExcept = "";
     this.sqlMenus.SecFieldName = null;
     this.sqlMenus.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.sqlMenus.SelectPaging = false;
     this.sqlMenus.SelectTop = 0;
     this.sqlMenus.SiteControl = false;
     this.sqlMenus.SiteFieldName = null;
     this.sqlMenus.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // dsUserGroups
     //
     this.dsUserGroups.Detail = this.UGInfo;
     columnItem1.FieldName = "GROUPID";
     this.dsUserGroups.DetailColumns.Add(columnItem1);
     this.dsUserGroups.DynamicTableName = false;
     this.dsUserGroups.Master = this.groupInfo;
     columnItem2.FieldName = "GROUPID";
     this.dsUserGroups.MasterColumns.Add(columnItem2);
     //
     // updateCompGroups
     //
     this.updateCompGroups.AutoTrans = false;
     this.updateCompGroups.ExceptJoin = false;
     this.updateCompGroups.LogInfo = null;
     this.updateCompGroups.Name = "updateCompGroups";
     this.updateCompGroups.RowAffectsCheck = true;
     this.updateCompGroups.SelectCmd = this.groupInfo;
     this.updateCompGroups.SelectCmdForUpdate = null;
     this.updateCompGroups.ServerModify = true;
     this.updateCompGroups.ServerModifyGetMax = false;
     this.updateCompGroups.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompGroups.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompGroups.UseTranscationScope = false;
     this.updateCompGroups.WhereMode = Srvtools.WhereModeType.All;
     //
     // updateCompUsers
     //
     this.updateCompUsers.AutoTrans = false;
     this.updateCompUsers.ExceptJoin = false;
     this.updateCompUsers.LogInfo = null;
     this.updateCompUsers.Name = "updateCompUsers";
     this.updateCompUsers.RowAffectsCheck = true;
     this.updateCompUsers.SelectCmd = this.userInfo;
     this.updateCompUsers.SelectCmdForUpdate = null;
     this.updateCompUsers.ServerModify = true;
     this.updateCompUsers.ServerModifyGetMax = false;
     this.updateCompUsers.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompUsers.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompUsers.UseTranscationScope = false;
     this.updateCompUsers.WhereMode = Srvtools.WhereModeType.Keyfields;
     //
     // dsGroupMenus
     //
     this.dsGroupMenus.Detail = this.sqlMGroupMenus;
     columnItem3.FieldName = "GROUPID";
     this.dsGroupMenus.DetailColumns.Add(columnItem3);
     this.dsGroupMenus.DynamicTableName = false;
     this.dsGroupMenus.Master = this.sqlMGroups;
     columnItem4.FieldName = "GROUPID";
     this.dsGroupMenus.MasterColumns.Add(columnItem4);
     //
     // packageInfo
     //
     this.packageInfo.CacheConnection = false;
     this.packageInfo.CommandText = "SELECT ITEMTYPE, FILENAME, FILEDATE, PACKAGEDATE from MENUCHECKLOG WHERE LOGID IN" +
     "(SELECT MAX(LOGID) FROM MENUCHECKLOG GROUP BY ITEMTYPE,FILENAME ) ORDER BY FILEN" +
     "AME";
     this.packageInfo.CommandTimeout = 0;
     this.packageInfo.CommandType = System.Data.CommandType.Text;
     this.packageInfo.DynamicTableName = false;
     this.packageInfo.EEPAlias = null;
     this.packageInfo.EncodingAfter = null;
     this.packageInfo.EncodingBefore = "Windows-1252";
     this.packageInfo.InfoConnection = null;
     this.packageInfo.MultiSetWhere = false;
     this.packageInfo.Name = "packageInfo";
     this.packageInfo.NotificationAutoEnlist = false;
     this.packageInfo.SecExcept = "";
     this.packageInfo.SecFieldName = null;
     this.packageInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.packageInfo.SelectPaging = false;
     this.packageInfo.SelectTop = 0;
     this.packageInfo.SiteControl = false;
     this.packageInfo.SiteFieldName = null;
     this.packageInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompUGInfo
     //
     this.updateCompUGInfo.AutoTrans = false;
     this.updateCompUGInfo.ExceptJoin = false;
     this.updateCompUGInfo.LogInfo = null;
     this.updateCompUGInfo.Name = "updateCompUGInfo";
     this.updateCompUGInfo.RowAffectsCheck = true;
     this.updateCompUGInfo.SelectCmd = this.UGInfo;
     this.updateCompUGInfo.SelectCmdForUpdate = null;
     this.updateCompUGInfo.ServerModify = true;
     this.updateCompUGInfo.ServerModifyGetMax = false;
     this.updateCompUGInfo.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompUGInfo.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompUGInfo.UseTranscationScope = false;
     this.updateCompUGInfo.WhereMode = Srvtools.WhereModeType.All;
     //
     // updateCompSolution
     //
     this.updateCompSolution.AutoTrans = false;
     this.updateCompSolution.ExceptJoin = false;
     this.updateCompSolution.LogInfo = null;
     this.updateCompSolution.Name = "updateCompSolution";
     this.updateCompSolution.RowAffectsCheck = true;
     this.updateCompSolution.SelectCmd = this.solutionInfo;
     this.updateCompSolution.SelectCmdForUpdate = null;
     this.updateCompSolution.ServerModify = true;
     this.updateCompSolution.ServerModifyGetMax = false;
     this.updateCompSolution.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompSolution.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompSolution.UseTranscationScope = false;
     this.updateCompSolution.WhereMode = Srvtools.WhereModeType.All;
     //
     // solutionInfo
     //
     this.solutionInfo.CacheConnection = false;
     this.solutionInfo.CommandText = "select * from MENUITEMTYPE";
     this.solutionInfo.CommandTimeout = 0;
     this.solutionInfo.CommandType = System.Data.CommandType.Text;
     this.solutionInfo.DynamicTableName = false;
     this.solutionInfo.EEPAlias = null;
     this.solutionInfo.EncodingAfter = null;
     this.solutionInfo.EncodingBefore = "Windows-1252";
     this.solutionInfo.InfoConnection = null;
     this.solutionInfo.MultiSetWhere = false;
     this.solutionInfo.Name = "solutionInfo";
     this.solutionInfo.NotificationAutoEnlist = false;
     this.solutionInfo.SecExcept = "";
     this.solutionInfo.SecFieldName = null;
     this.solutionInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.solutionInfo.SelectPaging = false;
     this.solutionInfo.SelectTop = 0;
     this.solutionInfo.SiteControl = false;
     this.solutionInfo.SiteFieldName = null;
     this.solutionInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // menuTableLogInfo
     //
     this.menuTableLogInfo.CacheConnection = false;
     this.menuTableLogInfo.CommandText = "select * from MENUTABLELOG";
     this.menuTableLogInfo.CommandTimeout = 0;
     this.menuTableLogInfo.CommandType = System.Data.CommandType.Text;
     this.menuTableLogInfo.DynamicTableName = false;
     this.menuTableLogInfo.EEPAlias = null;
     this.menuTableLogInfo.EncodingAfter = null;
     this.menuTableLogInfo.EncodingBefore = "Windows-1252";
     this.menuTableLogInfo.InfoConnection = null;
     this.menuTableLogInfo.MultiSetWhere = false;
     this.menuTableLogInfo.Name = "menuTableLogInfo";
     this.menuTableLogInfo.NotificationAutoEnlist = false;
     this.menuTableLogInfo.SecExcept = "";
     this.menuTableLogInfo.SecFieldName = null;
     this.menuTableLogInfo.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.menuTableLogInfo.SelectPaging = false;
     this.menuTableLogInfo.SelectTop = 0;
     this.menuTableLogInfo.SiteControl = false;
     this.menuTableLogInfo.SiteFieldName = null;
     this.menuTableLogInfo.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompMenuTableLog
     //
     this.updateCompMenuTableLog.AutoTrans = false;
     this.updateCompMenuTableLog.ExceptJoin = false;
     this.updateCompMenuTableLog.LogInfo = null;
     this.updateCompMenuTableLog.Name = "updateCompMenuTableLog";
     this.updateCompMenuTableLog.RowAffectsCheck = true;
     this.updateCompMenuTableLog.SelectCmd = this.menuTableLogInfo;
     this.updateCompMenuTableLog.SelectCmdForUpdate = null;
     this.updateCompMenuTableLog.ServerModify = true;
     this.updateCompMenuTableLog.ServerModifyGetMax = false;
     this.updateCompMenuTableLog.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompMenuTableLog.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompMenuTableLog.UseTranscationScope = false;
     this.updateCompMenuTableLog.WhereMode = Srvtools.WhereModeType.FieldAttrs;
     //
     // menuTableLogInfoWithoutBinary
     //
     this.menuTableLogInfoWithoutBinary.CacheConnection = false;
     this.menuTableLogInfoWithoutBinary.CommandText = "select LOGID, MENUID, PACKAGE, PACKAGEDATE, LASTDATE, OWNER, OLDDATE from MENUTAB" +
     "LELOG";
     this.menuTableLogInfoWithoutBinary.CommandTimeout = 0;
     this.menuTableLogInfoWithoutBinary.CommandType = System.Data.CommandType.Text;
     this.menuTableLogInfoWithoutBinary.DynamicTableName = false;
     this.menuTableLogInfoWithoutBinary.EEPAlias = null;
     this.menuTableLogInfoWithoutBinary.EncodingAfter = null;
     this.menuTableLogInfoWithoutBinary.EncodingBefore = "Windows-1252";
     this.menuTableLogInfoWithoutBinary.InfoConnection = null;
     this.menuTableLogInfoWithoutBinary.MultiSetWhere = false;
     this.menuTableLogInfoWithoutBinary.Name = "menuTableLogInfoWithoutBinary";
     this.menuTableLogInfoWithoutBinary.NotificationAutoEnlist = false;
     this.menuTableLogInfoWithoutBinary.SecExcept = "";
     this.menuTableLogInfoWithoutBinary.SecFieldName = null;
     this.menuTableLogInfoWithoutBinary.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.menuTableLogInfoWithoutBinary.SelectPaging = false;
     this.menuTableLogInfoWithoutBinary.SelectTop = 0;
     this.menuTableLogInfoWithoutBinary.SiteControl = false;
     this.menuTableLogInfoWithoutBinary.SiteFieldName = null;
     this.menuTableLogInfoWithoutBinary.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompMenuTableLogWithoutBinary
     //
     this.updateCompMenuTableLogWithoutBinary.AutoTrans = false;
     this.updateCompMenuTableLogWithoutBinary.ExceptJoin = false;
     this.updateCompMenuTableLogWithoutBinary.LogInfo = null;
     this.updateCompMenuTableLogWithoutBinary.Name = "updateCompMenuTableLogWithoutBinary";
     this.updateCompMenuTableLogWithoutBinary.RowAffectsCheck = true;
     this.updateCompMenuTableLogWithoutBinary.SelectCmd = this.menuTableLogInfoWithoutBinary;
     this.updateCompMenuTableLogWithoutBinary.SelectCmdForUpdate = null;
     this.updateCompMenuTableLogWithoutBinary.ServerModify = true;
     this.updateCompMenuTableLogWithoutBinary.ServerModifyGetMax = false;
     this.updateCompMenuTableLogWithoutBinary.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompMenuTableLogWithoutBinary.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompMenuTableLogWithoutBinary.UseTranscationScope = false;
     this.updateCompMenuTableLogWithoutBinary.WhereMode = Srvtools.WhereModeType.FieldAttrs;
     //
     // cmdDBTables
     //
     this.cmdDBTables.CacheConnection = false;
     this.cmdDBTables.CommandText = "select name from sysobjects where (xtype=\'U\' or xtype =\'V\') order by name";
     this.cmdDBTables.CommandTimeout = 0;
     this.cmdDBTables.CommandType = System.Data.CommandType.Text;
     this.cmdDBTables.DynamicTableName = false;
     this.cmdDBTables.EEPAlias = null;
     this.cmdDBTables.EncodingAfter = null;
     this.cmdDBTables.EncodingBefore = "Windows-1252";
     this.cmdDBTables.InfoConnection = null;
     this.cmdDBTables.MultiSetWhere = false;
     this.cmdDBTables.Name = "cmdDBTables";
     this.cmdDBTables.NotificationAutoEnlist = false;
     this.cmdDBTables.SecExcept = "";
     this.cmdDBTables.SecFieldName = null;
     this.cmdDBTables.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdDBTables.SelectPaging = false;
     this.cmdDBTables.SelectTop = 0;
     this.cmdDBTables.SiteControl = false;
     this.cmdDBTables.SiteFieldName = null;
     this.cmdDBTables.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     this.cmdDBTables.BeforeExecuteSql += new Srvtools.SqlEventHandler(this.cmdDBTables_BeforeExecuteSql);
     //
     // cmdColDEF
     //
     this.cmdColDEF.CacheConnection = false;
     this.cmdColDEF.CommandText = "select distinct TABLE_NAME from COLDEF order by TABLE_NAME";
     this.cmdColDEF.CommandTimeout = 0;
     this.cmdColDEF.CommandType = System.Data.CommandType.Text;
     this.cmdColDEF.DynamicTableName = false;
     this.cmdColDEF.EEPAlias = null;
     this.cmdColDEF.EncodingAfter = null;
     this.cmdColDEF.EncodingBefore = "Windows-1252";
     this.cmdColDEF.InfoConnection = null;
     this.cmdColDEF.MultiSetWhere = false;
     this.cmdColDEF.Name = "cmdColDEF";
     this.cmdColDEF.NotificationAutoEnlist = false;
     this.cmdColDEF.SecExcept = "";
     this.cmdColDEF.SecFieldName = null;
     this.cmdColDEF.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdColDEF.SelectPaging = false;
     this.cmdColDEF.SelectTop = 0;
     this.cmdColDEF.SiteControl = false;
     this.cmdColDEF.SiteFieldName = null;
     this.cmdColDEF.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateColDEF
     //
     this.updateColDEF.AutoTrans = true;
     this.updateColDEF.ExceptJoin = false;
     this.updateColDEF.LogInfo = null;
     this.updateColDEF.Name = "updateColDEF";
     this.updateColDEF.RowAffectsCheck = true;
     this.updateColDEF.SelectCmd = this.cmdColDEF;
     this.updateColDEF.SelectCmdForUpdate = null;
     this.updateColDEF.ServerModify = true;
     this.updateColDEF.ServerModifyGetMax = false;
     this.updateColDEF.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateColDEF.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateColDEF.UseTranscationScope = false;
     this.updateColDEF.WhereMode = Srvtools.WhereModeType.All;
     //
     // cmdColDEF_Details
     //
     this.cmdColDEF_Details.CacheConnection = false;
     this.cmdColDEF_Details.CommandText = "select * from COLDEF  ORDER BY SEQ";
     this.cmdColDEF_Details.CommandTimeout = 0;
     this.cmdColDEF_Details.CommandType = System.Data.CommandType.Text;
     this.cmdColDEF_Details.DynamicTableName = false;
     this.cmdColDEF_Details.EEPAlias = null;
     this.cmdColDEF_Details.EncodingAfter = null;
     this.cmdColDEF_Details.EncodingBefore = "Windows-1252";
     this.cmdColDEF_Details.InfoConnection = null;
     keyItem3.KeyName = "TABLE_NAME";
     keyItem4.KeyName = "FIELD_NAME";
     this.cmdColDEF_Details.KeyFields.Add(keyItem3);
     this.cmdColDEF_Details.KeyFields.Add(keyItem4);
     this.cmdColDEF_Details.MultiSetWhere = false;
     this.cmdColDEF_Details.Name = "cmdColDEF_Details";
     this.cmdColDEF_Details.NotificationAutoEnlist = false;
     this.cmdColDEF_Details.SecExcept = "";
     this.cmdColDEF_Details.SecFieldName = null;
     this.cmdColDEF_Details.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdColDEF_Details.SelectPaging = false;
     this.cmdColDEF_Details.SelectTop = 0;
     this.cmdColDEF_Details.SiteControl = false;
     this.cmdColDEF_Details.SiteFieldName = null;
     this.cmdColDEF_Details.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateColDEF_Details
     //
     this.updateColDEF_Details.AutoTrans = true;
     this.updateColDEF_Details.ExceptJoin = false;
     this.updateColDEF_Details.LogInfo = null;
     this.updateColDEF_Details.Name = "updateColDEF_Details";
     this.updateColDEF_Details.RowAffectsCheck = true;
     this.updateColDEF_Details.SelectCmd = this.cmdColDEF_Details;
     this.updateColDEF_Details.SelectCmdForUpdate = null;
     this.updateColDEF_Details.ServerModify = true;
     this.updateColDEF_Details.ServerModifyGetMax = false;
     this.updateColDEF_Details.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateColDEF_Details.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateColDEF_Details.UseTranscationScope = false;
     this.updateColDEF_Details.WhereMode = Srvtools.WhereModeType.All;
     //
     // cmdRefValUse
     //
     this.cmdRefValUse.CacheConnection = false;
     this.cmdRefValUse.CommandText = "";
     this.cmdRefValUse.CommandTimeout = 0;
     this.cmdRefValUse.CommandType = System.Data.CommandType.Text;
     this.cmdRefValUse.DynamicTableName = false;
     this.cmdRefValUse.EEPAlias = null;
     this.cmdRefValUse.EncodingAfter = null;
     this.cmdRefValUse.EncodingBefore = "Windows-1252";
     this.cmdRefValUse.InfoConnection = null;
     this.cmdRefValUse.MultiSetWhere = false;
     this.cmdRefValUse.Name = "cmdRefValUse";
     this.cmdRefValUse.NotificationAutoEnlist = false;
     this.cmdRefValUse.SecExcept = "";
     this.cmdRefValUse.SecFieldName = null;
     this.cmdRefValUse.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdRefValUse.SelectPaging = false;
     this.cmdRefValUse.SelectTop = 100;
     this.cmdRefValUse.SiteControl = false;
     this.cmdRefValUse.SiteFieldName = null;
     this.cmdRefValUse.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdERRLOG
     //
     this.cmdERRLOG.CacheConnection = false;
     this.cmdERRLOG.CommandText = "select * from SYSERRLOG";
     this.cmdERRLOG.CommandTimeout = 0;
     this.cmdERRLOG.CommandType = System.Data.CommandType.Text;
     this.cmdERRLOG.DynamicTableName = false;
     this.cmdERRLOG.EEPAlias = null;
     this.cmdERRLOG.EncodingAfter = null;
     this.cmdERRLOG.EncodingBefore = "Windows-1252";
     this.cmdERRLOG.InfoConnection = null;
     keyItem5.KeyName = "ERRID";
     this.cmdERRLOG.KeyFields.Add(keyItem5);
     this.cmdERRLOG.MultiSetWhere = false;
     this.cmdERRLOG.Name = "cmdERRLOG";
     this.cmdERRLOG.NotificationAutoEnlist = false;
     this.cmdERRLOG.SecExcept = "";
     this.cmdERRLOG.SecFieldName = null;
     this.cmdERRLOG.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdERRLOG.SelectPaging = false;
     this.cmdERRLOG.SelectTop = 0;
     this.cmdERRLOG.SiteControl = false;
     this.cmdERRLOG.SiteFieldName = null;
     this.cmdERRLOG.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateERRLOG
     //
     this.updateERRLOG.AutoTrans = true;
     this.updateERRLOG.ExceptJoin = false;
     fieldAttr1.CheckNull = false;
     fieldAttr1.DataField = "ERRID";
     fieldAttr1.DefaultMode = Srvtools.DefaultModeType.Update;
     fieldAttr1.DefaultValue = null;
     fieldAttr1.TrimLength = 0;
     fieldAttr1.UpdateEnable = true;
     fieldAttr1.WhereMode = true;
     fieldAttr2.CheckNull = false;
     fieldAttr2.DataField = "ERRSCREEN";
     fieldAttr2.DefaultMode = Srvtools.DefaultModeType.Insert;
     fieldAttr2.DefaultValue = null;
     fieldAttr2.TrimLength = 0;
     fieldAttr2.UpdateEnable = false;
     fieldAttr2.WhereMode = false;
     this.updateERRLOG.FieldAttrs.Add(fieldAttr1);
     this.updateERRLOG.FieldAttrs.Add(fieldAttr2);
     this.updateERRLOG.LogInfo = null;
     this.updateERRLOG.Name = "updateERRLOG";
     this.updateERRLOG.RowAffectsCheck = true;
     this.updateERRLOG.SelectCmd = this.cmdERRLOG;
     this.updateERRLOG.SelectCmdForUpdate = null;
     this.updateERRLOG.ServerModify = true;
     this.updateERRLOG.ServerModifyGetMax = false;
     this.updateERRLOG.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateERRLOG.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateERRLOG.UseTranscationScope = false;
     this.updateERRLOG.WhereMode = Srvtools.WhereModeType.FieldAttrs;
     //
     // cmdSYSEEPLOGforDB
     //
     this.cmdSYSEEPLOGforDB.CacheConnection = false;
     this.cmdSYSEEPLOGforDB.CommandText = "select * from SYSEEPLOG";
     this.cmdSYSEEPLOGforDB.CommandTimeout = 0;
     this.cmdSYSEEPLOGforDB.CommandType = System.Data.CommandType.Text;
     this.cmdSYSEEPLOGforDB.DynamicTableName = false;
     this.cmdSYSEEPLOGforDB.EEPAlias = null;
     this.cmdSYSEEPLOGforDB.EncodingAfter = null;
     this.cmdSYSEEPLOGforDB.EncodingBefore = "Windows-1252";
     this.cmdSYSEEPLOGforDB.InfoConnection = null;
     keyItem6.KeyName = "LOGID";
     this.cmdSYSEEPLOGforDB.KeyFields.Add(keyItem6);
     this.cmdSYSEEPLOGforDB.MultiSetWhere = false;
     this.cmdSYSEEPLOGforDB.Name = "cmdSYSEEPLOGforDB";
     this.cmdSYSEEPLOGforDB.NotificationAutoEnlist = false;
     this.cmdSYSEEPLOGforDB.SecExcept = "";
     this.cmdSYSEEPLOGforDB.SecFieldName = null;
     this.cmdSYSEEPLOGforDB.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdSYSEEPLOGforDB.SelectPaging = false;
     this.cmdSYSEEPLOGforDB.SelectTop = 0;
     this.cmdSYSEEPLOGforDB.SiteControl = false;
     this.cmdSYSEEPLOGforDB.SiteFieldName = null;
     this.cmdSYSEEPLOGforDB.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdDDUse
     //
     this.cmdDDUse.CacheConnection = false;
     this.cmdDDUse.CommandText = "";
     this.cmdDDUse.CommandTimeout = 0;
     this.cmdDDUse.CommandType = System.Data.CommandType.Text;
     this.cmdDDUse.DynamicTableName = false;
     this.cmdDDUse.EEPAlias = null;
     this.cmdDDUse.EncodingAfter = null;
     this.cmdDDUse.EncodingBefore = "Windows-1252";
     this.cmdDDUse.InfoConnection = null;
     this.cmdDDUse.MultiSetWhere = false;
     this.cmdDDUse.Name = "cmdDDUse";
     this.cmdDDUse.NotificationAutoEnlist = false;
     this.cmdDDUse.SecExcept = "";
     this.cmdDDUse.SecFieldName = null;
     this.cmdDDUse.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdDDUse.SelectPaging = false;
     this.cmdDDUse.SelectTop = 0;
     this.cmdDDUse.SiteControl = false;
     this.cmdDDUse.SiteFieldName = null;
     this.cmdDDUse.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompMGroupMenus
     //
     this.updateCompMGroupMenus.AutoTrans = true;
     this.updateCompMGroupMenus.ExceptJoin = false;
     this.updateCompMGroupMenus.LogInfo = null;
     this.updateCompMGroupMenus.Name = "updateCompMGroupMenus";
     this.updateCompMGroupMenus.RowAffectsCheck = true;
     this.updateCompMGroupMenus.SelectCmd = this.sqlMGroupMenus;
     this.updateCompMGroupMenus.SelectCmdForUpdate = null;
     this.updateCompMGroupMenus.ServerModify = true;
     this.updateCompMGroupMenus.ServerModifyGetMax = false;
     this.updateCompMGroupMenus.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompMGroupMenus.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompMGroupMenus.UseTranscationScope = false;
     this.updateCompMGroupMenus.WhereMode = Srvtools.WhereModeType.All;
     //
     // userMenus
     //
     this.userMenus.CacheConnection = false;
     this.userMenus.CommandText = "select * from USERMENUS";
     this.userMenus.CommandTimeout = 0;
     this.userMenus.CommandType = System.Data.CommandType.Text;
     this.userMenus.DynamicTableName = false;
     this.userMenus.EEPAlias = null;
     this.userMenus.EncodingAfter = null;
     this.userMenus.EncodingBefore = "Windows-1252";
     this.userMenus.InfoConnection = null;
     this.userMenus.MultiSetWhere = false;
     this.userMenus.Name = "userMenus";
     this.userMenus.NotificationAutoEnlist = false;
     this.userMenus.SecExcept = "";
     this.userMenus.SecFieldName = null;
     this.userMenus.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.userMenus.SelectPaging = false;
     this.userMenus.SelectTop = 0;
     this.userMenus.SiteControl = false;
     this.userMenus.SiteFieldName = null;
     this.userMenus.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompUserMenus
     //
     this.updateCompUserMenus.AutoTrans = true;
     this.updateCompUserMenus.ExceptJoin = false;
     this.updateCompUserMenus.LogInfo = null;
     this.updateCompUserMenus.Name = "updateCompUserMenus";
     this.updateCompUserMenus.RowAffectsCheck = true;
     this.updateCompUserMenus.SelectCmd = this.userMenus;
     this.updateCompUserMenus.SelectCmdForUpdate = null;
     this.updateCompUserMenus.ServerModify = true;
     this.updateCompUserMenus.ServerModifyGetMax = false;
     this.updateCompUserMenus.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompUserMenus.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompUserMenus.UseTranscationScope = false;
     this.updateCompUserMenus.WhereMode = Srvtools.WhereModeType.All;
     //
     // packageversion
     //
     this.packageversion.CacheConnection = false;
     this.packageversion.CommandText = "SELECT LOGID, ITEMTYPE, PACKAGE, PACKAGEDATE, FILETYPE, FILENAME, FILEDATE FROM M" +
     "ENUCHECKLOG ORDER BY PACKAGEDATE DESC";
     this.packageversion.CommandTimeout = 0;
     this.packageversion.CommandType = System.Data.CommandType.Text;
     this.packageversion.DynamicTableName = false;
     this.packageversion.EEPAlias = null;
     this.packageversion.EncodingAfter = null;
     this.packageversion.EncodingBefore = "Windows-1252";
     this.packageversion.InfoConnection = null;
     this.packageversion.MultiSetWhere = false;
     this.packageversion.Name = "packageversion";
     this.packageversion.NotificationAutoEnlist = false;
     this.packageversion.SecExcept = "";
     this.packageversion.SecFieldName = null;
     this.packageversion.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.packageversion.SelectPaging = false;
     this.packageversion.SelectTop = 0;
     this.packageversion.SiteControl = false;
     this.packageversion.SiteFieldName = null;
     this.packageversion.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdSysRefVal
     //
     this.cmdSysRefVal.CacheConnection = false;
     this.cmdSysRefVal.CommandText = "select * from SYS_REFVAL";
     this.cmdSysRefVal.CommandTimeout = 0;
     this.cmdSysRefVal.CommandType = System.Data.CommandType.Text;
     this.cmdSysRefVal.DynamicTableName = false;
     this.cmdSysRefVal.EEPAlias = null;
     this.cmdSysRefVal.EncodingAfter = null;
     this.cmdSysRefVal.EncodingBefore = "Windows-1252";
     this.cmdSysRefVal.InfoConnection = null;
     keyItem7.KeyName = "REFVAL_NO";
     this.cmdSysRefVal.KeyFields.Add(keyItem7);
     this.cmdSysRefVal.MultiSetWhere = false;
     this.cmdSysRefVal.Name = "cmdSysRefVal";
     this.cmdSysRefVal.NotificationAutoEnlist = false;
     this.cmdSysRefVal.SecExcept = "";
     this.cmdSysRefVal.SecFieldName = null;
     this.cmdSysRefVal.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdSysRefVal.SelectPaging = false;
     this.cmdSysRefVal.SelectTop = 0;
     this.cmdSysRefVal.SiteControl = false;
     this.cmdSysRefVal.SiteFieldName = null;
     this.cmdSysRefVal.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdSysRefVal_D
     //
     this.cmdSysRefVal_D.CacheConnection = false;
     this.cmdSysRefVal_D.CommandText = "Select * from SYS_REFVAL_D1";
     this.cmdSysRefVal_D.CommandTimeout = 0;
     this.cmdSysRefVal_D.CommandType = System.Data.CommandType.Text;
     this.cmdSysRefVal_D.DynamicTableName = false;
     this.cmdSysRefVal_D.EEPAlias = null;
     this.cmdSysRefVal_D.EncodingAfter = null;
     this.cmdSysRefVal_D.EncodingBefore = "Windows-1252";
     this.cmdSysRefVal_D.InfoConnection = null;
     keyItem8.KeyName = "REFVAL_NO";
     keyItem9.KeyName = "FIELD_NAME";
     this.cmdSysRefVal_D.KeyFields.Add(keyItem8);
     this.cmdSysRefVal_D.KeyFields.Add(keyItem9);
     this.cmdSysRefVal_D.MultiSetWhere = false;
     this.cmdSysRefVal_D.Name = "cmdSysRefVal_D";
     this.cmdSysRefVal_D.NotificationAutoEnlist = false;
     this.cmdSysRefVal_D.SecExcept = "";
     this.cmdSysRefVal_D.SecFieldName = null;
     this.cmdSysRefVal_D.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdSysRefVal_D.SelectPaging = false;
     this.cmdSysRefVal_D.SelectTop = 0;
     this.cmdSysRefVal_D.SiteControl = false;
     this.cmdSysRefVal_D.SiteFieldName = null;
     this.cmdSysRefVal_D.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // updateCompSysRefVal
     //
     this.updateCompSysRefVal.AutoTrans = true;
     this.updateCompSysRefVal.ExceptJoin = false;
     this.updateCompSysRefVal.LogInfo = null;
     this.updateCompSysRefVal.Name = "updateCompSysRefVal";
     this.updateCompSysRefVal.RowAffectsCheck = true;
     this.updateCompSysRefVal.SelectCmd = this.cmdSysRefVal;
     this.updateCompSysRefVal.SelectCmdForUpdate = null;
     this.updateCompSysRefVal.ServerModify = true;
     this.updateCompSysRefVal.ServerModifyGetMax = false;
     this.updateCompSysRefVal.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompSysRefVal.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompSysRefVal.UseTranscationScope = false;
     this.updateCompSysRefVal.WhereMode = Srvtools.WhereModeType.Keyfields;
     //
     // updateCompSysRefVal_D
     //
     this.updateCompSysRefVal_D.AutoTrans = true;
     this.updateCompSysRefVal_D.ExceptJoin = false;
     this.updateCompSysRefVal_D.LogInfo = null;
     this.updateCompSysRefVal_D.Name = "updateCompSysRefVal_D";
     this.updateCompSysRefVal_D.RowAffectsCheck = true;
     this.updateCompSysRefVal_D.SelectCmd = this.cmdSysRefVal_D;
     this.updateCompSysRefVal_D.SelectCmdForUpdate = null;
     this.updateCompSysRefVal_D.ServerModify = true;
     this.updateCompSysRefVal_D.ServerModifyGetMax = false;
     this.updateCompSysRefVal_D.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.updateCompSysRefVal_D.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.updateCompSysRefVal_D.UseTranscationScope = false;
     this.updateCompSysRefVal_D.WhereMode = Srvtools.WhereModeType.Keyfields;
     //
     // idsRefVal
     //
     this.idsRefVal.Detail = this.cmdSysRefVal_D;
     columnItem5.FieldName = "REFVAL_NO";
     this.idsRefVal.DetailColumns.Add(columnItem5);
     this.idsRefVal.DynamicTableName = false;
     this.idsRefVal.Master = this.cmdSysRefVal;
     columnItem6.FieldName = "REFVAL_NO";
     this.idsRefVal.MasterColumns.Add(columnItem6);
     //
     // cmdToDoList
     //
     this.cmdToDoList.CacheConnection = false;
     this.cmdToDoList.CommandText = "";
     this.cmdToDoList.CommandTimeout = 0;
     this.cmdToDoList.CommandType = System.Data.CommandType.Text;
     this.cmdToDoList.DynamicTableName = false;
     this.cmdToDoList.EEPAlias = "";
     this.cmdToDoList.EncodingAfter = null;
     this.cmdToDoList.EncodingBefore = "Windows-1252";
     this.cmdToDoList.InfoConnection = null;
     this.cmdToDoList.MultiSetWhere = false;
     this.cmdToDoList.Name = "cmdToDoList";
     this.cmdToDoList.NotificationAutoEnlist = false;
     this.cmdToDoList.SecExcept = "";
     this.cmdToDoList.SecFieldName = null;
     this.cmdToDoList.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdToDoList.SelectPaging = false;
     this.cmdToDoList.SelectTop = 0;
     this.cmdToDoList.SiteControl = false;
     this.cmdToDoList.SiteFieldName = null;
     this.cmdToDoList.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdToDoHis
     //
     this.cmdToDoHis.CacheConnection = false;
     this.cmdToDoHis.CommandText = "";
     this.cmdToDoHis.CommandTimeout = 0;
     this.cmdToDoHis.CommandType = System.Data.CommandType.Text;
     this.cmdToDoHis.DynamicTableName = false;
     this.cmdToDoHis.EEPAlias = null;
     this.cmdToDoHis.EncodingAfter = null;
     this.cmdToDoHis.EncodingBefore = "Windows-1252";
     this.cmdToDoHis.InfoConnection = null;
     this.cmdToDoHis.MultiSetWhere = false;
     this.cmdToDoHis.Name = "cmdToDoHis";
     this.cmdToDoHis.NotificationAutoEnlist = false;
     this.cmdToDoHis.SecExcept = "";
     this.cmdToDoHis.SecFieldName = null;
     this.cmdToDoHis.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdToDoHis.SelectPaging = false;
     this.cmdToDoHis.SelectTop = 0;
     this.cmdToDoHis.SiteControl = false;
     this.cmdToDoHis.SiteFieldName = null;
     this.cmdToDoHis.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdRoles
     //
     this.cmdRoles.CacheConnection = false;
     this.cmdRoles.CommandText = "select * from GROUPS where ISROLE=\'Y\'";
     this.cmdRoles.CommandTimeout = 0;
     this.cmdRoles.CommandType = System.Data.CommandType.Text;
     this.cmdRoles.DynamicTableName = false;
     this.cmdRoles.EEPAlias = null;
     this.cmdRoles.EncodingAfter = null;
     this.cmdRoles.EncodingBefore = "Windows-1252";
     this.cmdRoles.InfoConnection = null;
     this.cmdRoles.MultiSetWhere = false;
     this.cmdRoles.Name = "cmdRoles";
     this.cmdRoles.NotificationAutoEnlist = false;
     this.cmdRoles.SecExcept = "";
     this.cmdRoles.SecFieldName = null;
     this.cmdRoles.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdRoles.SelectPaging = false;
     this.cmdRoles.SelectTop = 0;
     this.cmdRoles.SiteControl = false;
     this.cmdRoles.SiteFieldName = null;
     this.cmdRoles.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdOrgRoles
     //
     this.cmdOrgRoles.CacheConnection = false;
     this.cmdOrgRoles.CommandText = "SELECT SYS_ORGROLES.*,GROUPS.GROUPNAME FROM SYS_ORGROLES\r\n LEFT JOIN GROUPS ON SY" +
     "S_ORGROLES.ROLE_ID=GROUPS.GROUPID";
     this.cmdOrgRoles.CommandTimeout = 0;
     this.cmdOrgRoles.CommandType = System.Data.CommandType.Text;
     this.cmdOrgRoles.DynamicTableName = false;
     this.cmdOrgRoles.EEPAlias = "";
     this.cmdOrgRoles.EncodingAfter = null;
     this.cmdOrgRoles.EncodingBefore = "Windows-1252";
     this.cmdOrgRoles.InfoConnection = null;
     keyItem10.KeyName = "ORG_NO";
     keyItem11.KeyName = "ROLE_ID";
     this.cmdOrgRoles.KeyFields.Add(keyItem10);
     this.cmdOrgRoles.KeyFields.Add(keyItem11);
     this.cmdOrgRoles.MultiSetWhere = false;
     this.cmdOrgRoles.Name = "cmdOrgRoles";
     this.cmdOrgRoles.NotificationAutoEnlist = false;
     this.cmdOrgRoles.SecExcept = "";
     this.cmdOrgRoles.SecFieldName = null;
     this.cmdOrgRoles.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdOrgRoles.SelectPaging = false;
     this.cmdOrgRoles.SelectTop = 0;
     this.cmdOrgRoles.SiteControl = false;
     this.cmdOrgRoles.SiteFieldName = null;
     this.cmdOrgRoles.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // ucOrgRoles
     //
     this.ucOrgRoles.AutoTrans = false;
     this.ucOrgRoles.ExceptJoin = false;
     fieldAttr3.CheckNull = false;
     fieldAttr3.DataField = "GROUPNAME";
     fieldAttr3.DefaultMode = Srvtools.DefaultModeType.Insert;
     fieldAttr3.DefaultValue = null;
     fieldAttr3.TrimLength = 0;
     fieldAttr3.UpdateEnable = false;
     fieldAttr3.WhereMode = true;
     this.ucOrgRoles.FieldAttrs.Add(fieldAttr3);
     this.ucOrgRoles.LogInfo = null;
     this.ucOrgRoles.Name = "ucOrgRoles";
     this.ucOrgRoles.RowAffectsCheck = true;
     this.ucOrgRoles.SelectCmd = this.cmdOrgRoles;
     this.ucOrgRoles.SelectCmdForUpdate = null;
     this.ucOrgRoles.ServerModify = false;
     this.ucOrgRoles.ServerModifyGetMax = false;
     this.ucOrgRoles.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.ucOrgRoles.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucOrgRoles.UseTranscationScope = false;
     this.ucOrgRoles.WhereMode = Srvtools.WhereModeType.Keyfields;
     //
     // cmdOrgLevel
     //
     this.cmdOrgLevel.CacheConnection = false;
     this.cmdOrgLevel.CommandText = "SELECT * FROM SYS_ORGLEVEL";
     this.cmdOrgLevel.CommandTimeout = 0;
     this.cmdOrgLevel.CommandType = System.Data.CommandType.Text;
     this.cmdOrgLevel.DynamicTableName = false;
     this.cmdOrgLevel.EEPAlias = "";
     this.cmdOrgLevel.EncodingAfter = null;
     this.cmdOrgLevel.EncodingBefore = "Windows-1252";
     this.cmdOrgLevel.InfoConnection = null;
     keyItem12.KeyName = "LEVEL_NO";
     this.cmdOrgLevel.KeyFields.Add(keyItem12);
     this.cmdOrgLevel.MultiSetWhere = false;
     this.cmdOrgLevel.Name = "cmdOrgLevel";
     this.cmdOrgLevel.NotificationAutoEnlist = false;
     this.cmdOrgLevel.SecExcept = "";
     this.cmdOrgLevel.SecFieldName = null;
     this.cmdOrgLevel.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdOrgLevel.SelectPaging = false;
     this.cmdOrgLevel.SelectTop = 0;
     this.cmdOrgLevel.SiteControl = false;
     this.cmdOrgLevel.SiteFieldName = null;
     this.cmdOrgLevel.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // ucOrgLevel
     //
     this.ucOrgLevel.AutoTrans = false;
     this.ucOrgLevel.ExceptJoin = false;
     this.ucOrgLevel.LogInfo = null;
     this.ucOrgLevel.Name = "ucOrgLevel";
     this.ucOrgLevel.RowAffectsCheck = true;
     this.ucOrgLevel.SelectCmd = this.cmdOrgLevel;
     this.ucOrgLevel.SelectCmdForUpdate = null;
     this.ucOrgLevel.ServerModify = false;
     this.ucOrgLevel.ServerModifyGetMax = false;
     this.ucOrgLevel.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.ucOrgLevel.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucOrgLevel.UseTranscationScope = false;
     this.ucOrgLevel.WhereMode = Srvtools.WhereModeType.All;
     //
     // cmdOrgKind
     //
     this.cmdOrgKind.CacheConnection = false;
     this.cmdOrgKind.CommandText = "SELECT * FROM SYS_ORGKIND";
     this.cmdOrgKind.CommandTimeout = 0;
     this.cmdOrgKind.CommandType = System.Data.CommandType.Text;
     this.cmdOrgKind.DynamicTableName = false;
     this.cmdOrgKind.EEPAlias = "";
     this.cmdOrgKind.EncodingAfter = null;
     this.cmdOrgKind.EncodingBefore = "Windows-1252";
     this.cmdOrgKind.InfoConnection = null;
     keyItem13.KeyName = "ORG_KIND";
     this.cmdOrgKind.KeyFields.Add(keyItem13);
     this.cmdOrgKind.MultiSetWhere = false;
     this.cmdOrgKind.Name = "cmdOrgKind";
     this.cmdOrgKind.NotificationAutoEnlist = false;
     this.cmdOrgKind.SecExcept = "";
     this.cmdOrgKind.SecFieldName = null;
     this.cmdOrgKind.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdOrgKind.SelectPaging = false;
     this.cmdOrgKind.SelectTop = 0;
     this.cmdOrgKind.SiteControl = false;
     this.cmdOrgKind.SiteFieldName = null;
     this.cmdOrgKind.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // ucOrgKind
     //
     this.ucOrgKind.AutoTrans = false;
     this.ucOrgKind.ExceptJoin = false;
     this.ucOrgKind.LogInfo = null;
     this.ucOrgKind.Name = "ucOrgKind";
     this.ucOrgKind.RowAffectsCheck = true;
     this.ucOrgKind.SelectCmd = this.cmdOrgKind;
     this.ucOrgKind.SelectCmdForUpdate = null;
     this.ucOrgKind.ServerModify = false;
     this.ucOrgKind.ServerModifyGetMax = false;
     this.ucOrgKind.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.ucOrgKind.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucOrgKind.UseTranscationScope = false;
     this.ucOrgKind.WhereMode = Srvtools.WhereModeType.All;
     //
     // cmdWorkflow
     //
     this.cmdWorkflow.CacheConnection = false;
     this.cmdWorkflow.CommandText = "";
     this.cmdWorkflow.CommandTimeout = 0;
     this.cmdWorkflow.CommandType = System.Data.CommandType.Text;
     this.cmdWorkflow.DynamicTableName = false;
     this.cmdWorkflow.EEPAlias = null;
     this.cmdWorkflow.EncodingAfter = null;
     this.cmdWorkflow.EncodingBefore = "Windows-1252";
     this.cmdWorkflow.InfoConnection = null;
     this.cmdWorkflow.MultiSetWhere = false;
     this.cmdWorkflow.Name = "cmdWorkflow";
     this.cmdWorkflow.NotificationAutoEnlist = false;
     this.cmdWorkflow.SecExcept = "";
     this.cmdWorkflow.SecFieldName = null;
     this.cmdWorkflow.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdWorkflow.SelectPaging = false;
     this.cmdWorkflow.SelectTop = 0;
     this.cmdWorkflow.SiteControl = false;
     this.cmdWorkflow.SiteFieldName = null;
     this.cmdWorkflow.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // cmdRoleAgent
     //
     this.cmdRoleAgent.CacheConnection = false;
     this.cmdRoleAgent.CommandText = "select * from SYS_ROLES_AGENT";
     this.cmdRoleAgent.CommandTimeout = 0;
     this.cmdRoleAgent.CommandType = System.Data.CommandType.Text;
     this.cmdRoleAgent.DynamicTableName = false;
     this.cmdRoleAgent.EEPAlias = null;
     this.cmdRoleAgent.EncodingAfter = null;
     this.cmdRoleAgent.EncodingBefore = "Windows-1252";
     this.cmdRoleAgent.InfoConnection = null;
     keyItem14.KeyName = "ROLE_ID";
     keyItem15.KeyName = "AGENT";
     keyItem16.KeyName = "FLOW_DESC";
     this.cmdRoleAgent.KeyFields.Add(keyItem14);
     this.cmdRoleAgent.KeyFields.Add(keyItem15);
     this.cmdRoleAgent.KeyFields.Add(keyItem16);
     this.cmdRoleAgent.MultiSetWhere = false;
     this.cmdRoleAgent.Name = "cmdRoleAgent";
     this.cmdRoleAgent.NotificationAutoEnlist = false;
     this.cmdRoleAgent.SecExcept = "";
     this.cmdRoleAgent.SecFieldName = null;
     this.cmdRoleAgent.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdRoleAgent.SelectPaging = false;
     this.cmdRoleAgent.SelectTop = 0;
     this.cmdRoleAgent.SiteControl = false;
     this.cmdRoleAgent.SiteFieldName = null;
     this.cmdRoleAgent.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // ucRoleAgent
     //
     this.ucRoleAgent.AutoTrans = true;
     this.ucRoleAgent.ExceptJoin = false;
     this.ucRoleAgent.LogInfo = null;
     this.ucRoleAgent.Name = "ucRoleAgent";
     this.ucRoleAgent.RowAffectsCheck = true;
     this.ucRoleAgent.SelectCmd = this.cmdRoleAgent;
     this.ucRoleAgent.SelectCmdForUpdate = null;
     this.ucRoleAgent.ServerModify = true;
     this.ucRoleAgent.ServerModifyGetMax = false;
     this.ucRoleAgent.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00");
     this.ucRoleAgent.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
     this.ucRoleAgent.UseTranscationScope = false;
     this.ucRoleAgent.WhereMode = Srvtools.WhereModeType.All;
     //
     // cmdSlSource
     //
     this.cmdSlSource.CacheConnection = false;
     this.cmdSlSource.CommandText = "";
     this.cmdSlSource.CommandTimeout = 0;
     this.cmdSlSource.CommandType = System.Data.CommandType.Text;
     this.cmdSlSource.DynamicTableName = false;
     this.cmdSlSource.EEPAlias = null;
     this.cmdSlSource.EncodingAfter = null;
     this.cmdSlSource.EncodingBefore = "Windows-1252";
     this.cmdSlSource.InfoConnection = null;
     this.cmdSlSource.MultiSetWhere = false;
     this.cmdSlSource.Name = "cmdSlSource";
     this.cmdSlSource.NotificationAutoEnlist = false;
     this.cmdSlSource.SecExcept = "";
     this.cmdSlSource.SecFieldName = null;
     this.cmdSlSource.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdSlSource.SelectPaging = false;
     this.cmdSlSource.SelectTop = 0;
     this.cmdSlSource.SiteControl = false;
     this.cmdSlSource.SiteFieldName = null;
     this.cmdSlSource.UpdatedRowSource = System.Data.UpdateRowSource.Both;
     //
     // serviceManager1
     //
     service1.DelegateName = "LogOut";
     service1.NonLogin = false;
     service1.ServiceName = "LogOut";
     service2.DelegateName = "CheckUser";
     service2.NonLogin = false;
     service2.ServiceName = "CheckUser";
     service3.DelegateName = "GetUG";
     service3.NonLogin = false;
     service3.ServiceName = "GetUG";
     service4.DelegateName = "FetchMenus";
     service4.NonLogin = false;
     service4.ServiceName = "FetchMenus";
     service5.DelegateName = "GetParam";
     service5.NonLogin = false;
     service5.ServiceName = "GetParam";
     service6.DelegateName = "OPMenu";
     service6.NonLogin = false;
     service6.ServiceName = "OPMenu";
     service7.DelegateName = "LoadGroups";
     service7.NonLogin = false;
     service7.ServiceName = "LoadGroups";
     service8.DelegateName = "setGroups";
     service8.NonLogin = false;
     service8.ServiceName = "setGroups";
     service9.DelegateName = "UpdateNodes";
     service9.NonLogin = false;
     service9.ServiceName = "UpdateNodes";
     service10.DelegateName = "CheckAndDownLoad";
     service10.NonLogin = false;
     service10.ServiceName = "CheckAndDownLoad";
     service11.DelegateName = "LogError";
     service11.NonLogin = false;
     service11.ServiceName = "LogError";
     service12.DelegateName = "GetSolution";
     service12.NonLogin = false;
     service12.ServiceName = "GetSolution";
     service13.DelegateName = "AutoSeqMenuID";
     service13.NonLogin = false;
     service13.ServiceName = "AutoSeqMenuID";
     service14.DelegateName = "SendMessage";
     service14.NonLogin = false;
     service14.ServiceName = "SendMessage";
     service15.DelegateName = "GetMessage";
     service15.NonLogin = false;
     service15.ServiceName = "GetMessage";
     service16.DelegateName = "GetDataDic";
     service16.NonLogin = false;
     service16.ServiceName = "GetDataDic";
     service17.DelegateName = "GetDDColumns";
     service17.NonLogin = false;
     service17.ServiceName = "GetDDColumns";
     service18.DelegateName = "DeleteDDColumns";
     service18.NonLogin = false;
     service18.ServiceName = "DeleteDDColumns";
     service19.DelegateName = "DataDRefresh";
     service19.NonLogin = false;
     service19.ServiceName = "DataDRefresh";
     service20.DelegateName = "GetDB";
     service20.NonLogin = false;
     service20.ServiceName = "GetDB";
     service21.DelegateName = "GetUserName";
     service21.NonLogin = false;
     service21.ServiceName = "GetUserName";
     service22.DelegateName = "GetMenu";
     service22.NonLogin = false;
     service22.ServiceName = "GetMenu";
     service23.DelegateName = "GetMenuID";
     service23.NonLogin = false;
     service23.ServiceName = "GetMenuID";
     service24.DelegateName = "InsertToMenu";
     service24.NonLogin = false;
     service24.ServiceName = "InsertToMenu";
     service25.DelegateName = "GetServerTime";
     service25.NonLogin = false;
     service25.ServiceName = "GetServerTime";
     service26.DelegateName = "GetGroup";
     service26.NonLogin = false;
     service26.ServiceName = "GetGroup";
     service27.DelegateName = "InsertToGroup";
     service27.NonLogin = false;
     service27.ServiceName = "InsertToGroup";
     service28.DelegateName = "GetNewGroup";
     service28.NonLogin = false;
     service28.ServiceName = "GetNewGroup";
     service29.DelegateName = "UpdateGroup";
     service29.NonLogin = false;
     service29.ServiceName = "UpdateGroup";
     service30.DelegateName = "DelMenu";
     service30.NonLogin = false;
     service30.ServiceName = "DelMenu";
     service31.DelegateName = "DelGroup";
     service31.NonLogin = false;
     service31.ServiceName = "DelGroup";
     service32.DelegateName = "GetGroupControl";
     service32.NonLogin = false;
     service32.ServiceName = "GetGroupControl";
     service33.DelegateName = "GetPF";
     service33.NonLogin = false;
     service33.ServiceName = "GetPF";
     service34.DelegateName = "GetLanguage";
     service34.NonLogin = false;
     service34.ServiceName = "GetLanguage";
     service35.DelegateName = "ChangePassword";
     service35.NonLogin = false;
     service35.ServiceName = "ChangePassword";
     service36.DelegateName = "UpdateMenu";
     service36.NonLogin = false;
     service36.ServiceName = "UpdateMenu";
     service37.DelegateName = "GetADUsers";
     service37.NonLogin = false;
     service37.ServiceName = "GetADUsers";
     service38.DelegateName = "GetADUserForGroup";
     service38.NonLogin = false;
     service38.ServiceName = "GetADUserForGroup";
     service39.DelegateName = "GetSysMsgXml";
     service39.NonLogin = false;
     service39.ServiceName = "GetSysMsgXml";
     service40.DelegateName = "GetServerPath";
     service40.NonLogin = false;
     service40.ServiceName = "GetServerPath";
     service41.DelegateName = "LoadUsers";
     service41.NonLogin = false;
     service41.ServiceName = "LoadUsers";
     service42.DelegateName = "SetUsers";
     service42.NonLogin = false;
     service42.ServiceName = "SetUsers";
     service43.DelegateName = "GetUser";
     service43.NonLogin = false;
     service43.ServiceName = "GetUser";
     service44.DelegateName = "DelUser";
     service44.NonLogin = false;
     service44.ServiceName = "DelUser";
     service45.DelegateName = "UpdateUser";
     service45.NonLogin = false;
     service45.ServiceName = "UpdateUser";
     service46.DelegateName = "InsertToUser";
     service46.NonLogin = false;
     service46.ServiceName = "InsertToUser";
     service47.DelegateName = "GetUserControl";
     service47.NonLogin = false;
     service47.ServiceName = "GetUserControl";
     service48.DelegateName = "DownLoadFile";
     service48.NonLogin = false;
     service48.ServiceName = "DownLoadFile";
     service49.DelegateName = "UpLoadFile";
     service49.NonLogin = false;
     service49.ServiceName = "UpLoadFile";
     service50.DelegateName = "DownloadModule";
     service50.NonLogin = false;
     service50.ServiceName = "DownloadModule";
     service51.DelegateName = "GetUserGroup";
     service51.NonLogin = false;
     service51.ServiceName = "GetUserGroup";
     service52.DelegateName = "ListUsers";
     service52.NonLogin = false;
     service52.ServiceName = "ListUsers";
     service53.DelegateName = "SetUserGroups";
     service53.NonLogin = false;
     service53.ServiceName = "SetUserGroups";
     service54.DelegateName = "UpdateMenuTable";
     service54.NonLogin = false;
     service54.ServiceName = "UpdateMenuTable";
     service55.DelegateName = "FetchAllMenus";
     service55.NonLogin = false;
     service55.ServiceName = "FetchAllMenus";
     service56.DelegateName = "SetUserMenus";
     service56.NonLogin = false;
     service56.ServiceName = "SetUserMenus";
     service57.DelegateName = "SetGroupMenus";
     service57.NonLogin = false;
     service57.ServiceName = "SetGroupMenus";
     service58.DelegateName = "GetDataBaseType";
     service58.NonLogin = false;
     service58.ServiceName = "GetDataBaseType";
     service59.DelegateName = "GetSystemDBType";
     service59.NonLogin = false;
     service59.ServiceName = "GetSystemDBType";
     service60.DelegateName = "DoRecordLock";
     service60.NonLogin = false;
     service60.ServiceName = "DoRecordLock";
     service61.DelegateName = "PackageUpload";
     service61.NonLogin = false;
     service61.ServiceName = "PackageUpload";
     service62.DelegateName = "PackageDownLoad";
     service62.NonLogin = false;
     service62.ServiceName = "PackageDownLoad";
     service63.DelegateName = "PackageRollback";
     service63.NonLogin = false;
     service63.ServiceName = "PackageRollback";
     service64.DelegateName = "CheckManagerRight";
     service64.NonLogin = false;
     service64.ServiceName = "CheckManagerRight";
     service65.DelegateName = "GetRolesByUserID";
     service65.NonLogin = false;
     service65.ServiceName = "GetRolesByUserID";
     service66.DelegateName = "GetDDColumnsSchema";
     service66.NonLogin = false;
     service66.ServiceName = "GetDDColumnsSchema";
     service67.DelegateName = "GetProviderName";
     service67.NonLogin = false;
     service67.ServiceName = "GetProviderName";
     service68.DelegateName = "GetDataModule";
     service68.NonLogin = false;
     service68.ServiceName = "GetDataModule";
     service69.DelegateName = "GetFieldCaption";
     service69.NonLogin = false;
     service69.ServiceName = "GetFieldCaption";
     service70.DelegateName = "GetSolutionSecurity";
     service70.NonLogin = false;
     service70.ServiceName = "GetSolutionSecurity";
     service71.DelegateName = "SetSingleSignOnPath";
     service71.NonLogin = false;
     service71.ServiceName = "SetSingleSignOnPath";
     service72.DelegateName = "GetSingleSignOnPath";
     service72.NonLogin = false;
     service72.ServiceName = "GetSingleSignOnPath";
     service73.DelegateName = "FLOvertimeList";
     service73.NonLogin = false;
     service73.ServiceName = "FLOvertimeList";
     service74.DelegateName = "FetchFavorMenus";
     service74.NonLogin = false;
     service74.ServiceName = "FetchFavorMenus";
     service75.DelegateName = "GetFavorMenuID";
     service75.NonLogin = false;
     service75.ServiceName = "GetFavorMenuID";
     service76.DelegateName = "isTableExist";
     service76.NonLogin = false;
     service76.ServiceName = "isTableExist";
     service77.DelegateName = "GetLogDatas";
     service77.NonLogin = false;
     service77.ServiceName = "GetLogDatas";
     service78.DelegateName = "GetPasswordLastDate";
     service78.NonLogin = false;
     service78.ServiceName = "GetPasswordLastDate";
     service79.DelegateName = "UpdatePackage";
     service79.NonLogin = false;
     service79.ServiceName = "UpdatePackage";
     service80.DelegateName = "GetMethodName";
     service80.NonLogin = false;
     service80.ServiceName = "GetMethodName";
     service81.DelegateName = "CheckAndDownLoad";
     service81.NonLogin = false;
     service81.ServiceName = "CheckAndDownLoad";
     service82.DelegateName = "UserDefineLog";
     service82.NonLogin = false;
     service82.ServiceName = "UserDefineLog";
     service83.DelegateName = "GetDBLog";
     service83.NonLogin = false;
     service83.ServiceName = "GetDBLog";
     service84.DelegateName = "GetWebSitePath";
     service84.NonLogin = false;
     service84.ServiceName = "GetWebSitePath";
     service85.DelegateName = "AnyQuerySave";
     service85.NonLogin = false;
     service85.ServiceName = "AnyQuerySave";
     service86.DelegateName = "AnyQueryLoad";
     service86.NonLogin = false;
     service86.ServiceName = "AnyQueryLoad";
     service87.DelegateName = "UpdateFLXoml";
     service87.NonLogin = false;
     service87.ServiceName = "UpdateFLXoml";
     service88.DelegateName = "AnyQueryLoadFile";
     service88.NonLogin = false;
     service88.ServiceName = "AnyQueryLoadFile";
     service89.DelegateName = "AnyQueryDeleteFile";
     service89.NonLogin = false;
     service89.ServiceName = "AnyQueryDeleteFile";
     service90.DelegateName = "ExcuteWorkFlow";
     service90.NonLogin = false;
     service90.ServiceName = "ExcuteWorkFlow";
     service91.DelegateName = "GetSplitSysDB2";
     service91.NonLogin = false;
     service91.ServiceName = "GetSplitSysDB2";
     service92.DelegateName = "GetTableNames";
     service92.NonLogin = false;
     service92.ServiceName = "GetTableNames";
     service93.DelegateName = "GetOrgKinds";
     service93.NonLogin = false;
     service93.ServiceName = "GetOrgKinds";
     service94.DelegateName = "GetRoles";
     service94.NonLogin = false;
     service94.ServiceName = "GetRoles";
     service95.DelegateName = "GetRefRoles";
     service95.NonLogin = false;
     service95.ServiceName = "GetRefRoles";
     service96.DelegateName = "GetOrgLevel";
     service96.NonLogin = false;
     service96.ServiceName = "GetOrgLevel";
     service97.DelegateName = "UpdateWorkFlow";
     service97.NonLogin = false;
     service97.ServiceName = "UpdateWorkFlow";
     service98.DelegateName = "GetUserRole";
     service98.NonLogin = false;
     service98.ServiceName = "GetUserRole";
     service99.DelegateName = "GetSrvoolAssemblyName";
     service99.NonLogin = false;
     service99.ServiceName = "GetSrvoolAssemblyName";
     service100.DelegateName = "GetPasswordPolicy";
     service100.NonLogin = false;
     service100.ServiceName = "GetPasswordPolicy";
     service101.DelegateName = "GetAllUsers";
     service101.NonLogin = false;
     service101.ServiceName = "GetAllUsers";
     service102.DelegateName = "GetAllGroups";
     service102.NonLogin = false;
     service102.ServiceName = "GetAllGroups";
     service103.DelegateName = "GetWebSitePath";
     service103.NonLogin = false;
     service103.ServiceName = "GetWebSitePath";
     service104.DelegateName = "GetWebSiteConfig";
     service104.NonLogin = false;
     service104.ServiceName = "GetWebSiteConfig";
     service105.DelegateName = "UpLoadWorkflowFile";
     service105.NonLogin = false;
     service105.ServiceName = "UpLoadWorkflowFile";
     service106.DelegateName = "DeleteWorkFlowAttachFile";
     service106.NonLogin = false;
     service106.ServiceName = "DeleteWorkFlowAttachFile";
     service107.DelegateName = "SavePersonalSettings";
     service107.NonLogin = false;
     service107.ServiceName = "SavePersonalSettings";
     service108.DelegateName = "LoadPersonalSettings";
     service108.NonLogin = false;
     service108.ServiceName = "LoadPersonalSettings";
     service109.DelegateName = "UpdateADUsers";
     service109.NonLogin = false;
     service109.ServiceName = "UpdateADUsers";
     service110.DelegateName = "UpdateADGroups";
     service110.NonLogin = false;
     service110.ServiceName = "UpdateADGroups";
     service111.DelegateName = "DeleteGroupMenuControls";
     service111.NonLogin = false;
     service111.ServiceName = "DeleteGroupMenuControls";
     service112.DelegateName = "DeleteUserMenuControls";
     service112.NonLogin = false;
     service112.ServiceName = "DeleteUserMenuControls";
     service113.DelegateName = "UpdateRoleAgent";
     service113.NonLogin = false;
     service113.ServiceName = "UpdateRoleAgent";
     service114.DelegateName = "GetSysTableByLoginDB";
     service114.NonLogin = false;
     service114.ServiceName = "GetSysTableByLoginDB";
     service115.DelegateName = "BeginWorkFlowTransaction";
     service115.NonLogin = false;
     service115.ServiceName = "BeginWorkFlowTransaction";
     service116.DelegateName = "ComitWorkFlowTransaction";
     service116.NonLogin = false;
     service116.ServiceName = "ComitWorkFlowTransaction";
     service117.DelegateName = "RollBackWorkFlowTransaction";
     service117.NonLogin = false;
     service117.ServiceName = "RollBackWorkFlowTransaction";
     service118.DelegateName = "SaveFlowXoml";
     service118.NonLogin = false;
     service118.ServiceName = "SaveFlowXoml";
     service119.DelegateName = "GetDataBaseSubType";
     service119.NonLogin = false;
     service119.ServiceName = "GetDataBaseSubType";
     this.serviceManager1.ServiceCollection.Add(service1);
     this.serviceManager1.ServiceCollection.Add(service2);
     this.serviceManager1.ServiceCollection.Add(service3);
     this.serviceManager1.ServiceCollection.Add(service4);
     this.serviceManager1.ServiceCollection.Add(service5);
     this.serviceManager1.ServiceCollection.Add(service6);
     this.serviceManager1.ServiceCollection.Add(service7);
     this.serviceManager1.ServiceCollection.Add(service8);
     this.serviceManager1.ServiceCollection.Add(service9);
     this.serviceManager1.ServiceCollection.Add(service10);
     this.serviceManager1.ServiceCollection.Add(service11);
     this.serviceManager1.ServiceCollection.Add(service12);
     this.serviceManager1.ServiceCollection.Add(service13);
     this.serviceManager1.ServiceCollection.Add(service14);
     this.serviceManager1.ServiceCollection.Add(service15);
     this.serviceManager1.ServiceCollection.Add(service16);
     this.serviceManager1.ServiceCollection.Add(service17);
     this.serviceManager1.ServiceCollection.Add(service18);
     this.serviceManager1.ServiceCollection.Add(service19);
     this.serviceManager1.ServiceCollection.Add(service20);
     this.serviceManager1.ServiceCollection.Add(service21);
     this.serviceManager1.ServiceCollection.Add(service22);
     this.serviceManager1.ServiceCollection.Add(service23);
     this.serviceManager1.ServiceCollection.Add(service24);
     this.serviceManager1.ServiceCollection.Add(service25);
     this.serviceManager1.ServiceCollection.Add(service26);
     this.serviceManager1.ServiceCollection.Add(service27);
     this.serviceManager1.ServiceCollection.Add(service28);
     this.serviceManager1.ServiceCollection.Add(service29);
     this.serviceManager1.ServiceCollection.Add(service30);
     this.serviceManager1.ServiceCollection.Add(service31);
     this.serviceManager1.ServiceCollection.Add(service32);
     this.serviceManager1.ServiceCollection.Add(service33);
     this.serviceManager1.ServiceCollection.Add(service34);
     this.serviceManager1.ServiceCollection.Add(service35);
     this.serviceManager1.ServiceCollection.Add(service36);
     this.serviceManager1.ServiceCollection.Add(service37);
     this.serviceManager1.ServiceCollection.Add(service38);
     this.serviceManager1.ServiceCollection.Add(service39);
     this.serviceManager1.ServiceCollection.Add(service40);
     this.serviceManager1.ServiceCollection.Add(service41);
     this.serviceManager1.ServiceCollection.Add(service42);
     this.serviceManager1.ServiceCollection.Add(service43);
     this.serviceManager1.ServiceCollection.Add(service44);
     this.serviceManager1.ServiceCollection.Add(service45);
     this.serviceManager1.ServiceCollection.Add(service46);
     this.serviceManager1.ServiceCollection.Add(service47);
     this.serviceManager1.ServiceCollection.Add(service48);
     this.serviceManager1.ServiceCollection.Add(service49);
     this.serviceManager1.ServiceCollection.Add(service50);
     this.serviceManager1.ServiceCollection.Add(service51);
     this.serviceManager1.ServiceCollection.Add(service52);
     this.serviceManager1.ServiceCollection.Add(service53);
     this.serviceManager1.ServiceCollection.Add(service54);
     this.serviceManager1.ServiceCollection.Add(service55);
     this.serviceManager1.ServiceCollection.Add(service56);
     this.serviceManager1.ServiceCollection.Add(service57);
     this.serviceManager1.ServiceCollection.Add(service58);
     this.serviceManager1.ServiceCollection.Add(service59);
     this.serviceManager1.ServiceCollection.Add(service60);
     this.serviceManager1.ServiceCollection.Add(service61);
     this.serviceManager1.ServiceCollection.Add(service62);
     this.serviceManager1.ServiceCollection.Add(service63);
     this.serviceManager1.ServiceCollection.Add(service64);
     this.serviceManager1.ServiceCollection.Add(service65);
     this.serviceManager1.ServiceCollection.Add(service66);
     this.serviceManager1.ServiceCollection.Add(service67);
     this.serviceManager1.ServiceCollection.Add(service68);
     this.serviceManager1.ServiceCollection.Add(service69);
     this.serviceManager1.ServiceCollection.Add(service70);
     this.serviceManager1.ServiceCollection.Add(service71);
     this.serviceManager1.ServiceCollection.Add(service72);
     this.serviceManager1.ServiceCollection.Add(service73);
     this.serviceManager1.ServiceCollection.Add(service74);
     this.serviceManager1.ServiceCollection.Add(service75);
     this.serviceManager1.ServiceCollection.Add(service76);
     this.serviceManager1.ServiceCollection.Add(service77);
     this.serviceManager1.ServiceCollection.Add(service78);
     this.serviceManager1.ServiceCollection.Add(service79);
     this.serviceManager1.ServiceCollection.Add(service80);
     this.serviceManager1.ServiceCollection.Add(service81);
     this.serviceManager1.ServiceCollection.Add(service82);
     this.serviceManager1.ServiceCollection.Add(service83);
     this.serviceManager1.ServiceCollection.Add(service84);
     this.serviceManager1.ServiceCollection.Add(service85);
     this.serviceManager1.ServiceCollection.Add(service86);
     this.serviceManager1.ServiceCollection.Add(service87);
     this.serviceManager1.ServiceCollection.Add(service88);
     this.serviceManager1.ServiceCollection.Add(service89);
     this.serviceManager1.ServiceCollection.Add(service90);
     this.serviceManager1.ServiceCollection.Add(service91);
     this.serviceManager1.ServiceCollection.Add(service92);
     this.serviceManager1.ServiceCollection.Add(service93);
     this.serviceManager1.ServiceCollection.Add(service94);
     this.serviceManager1.ServiceCollection.Add(service95);
     this.serviceManager1.ServiceCollection.Add(service96);
     this.serviceManager1.ServiceCollection.Add(service97);
     this.serviceManager1.ServiceCollection.Add(service98);
     this.serviceManager1.ServiceCollection.Add(service99);
     this.serviceManager1.ServiceCollection.Add(service100);
     this.serviceManager1.ServiceCollection.Add(service101);
     this.serviceManager1.ServiceCollection.Add(service102);
     this.serviceManager1.ServiceCollection.Add(service103);
     this.serviceManager1.ServiceCollection.Add(service104);
     this.serviceManager1.ServiceCollection.Add(service105);
     this.serviceManager1.ServiceCollection.Add(service106);
     this.serviceManager1.ServiceCollection.Add(service107);
     this.serviceManager1.ServiceCollection.Add(service108);
     this.serviceManager1.ServiceCollection.Add(service109);
     this.serviceManager1.ServiceCollection.Add(service110);
     this.serviceManager1.ServiceCollection.Add(service111);
     this.serviceManager1.ServiceCollection.Add(service112);
     this.serviceManager1.ServiceCollection.Add(service113);
     this.serviceManager1.ServiceCollection.Add(service114);
     this.serviceManager1.ServiceCollection.Add(service115);
     this.serviceManager1.ServiceCollection.Add(service116);
     this.serviceManager1.ServiceCollection.Add(service117);
     this.serviceManager1.ServiceCollection.Add(service118);
     this.serviceManager1.ServiceCollection.Add(service119);
     //
     // cmdGROUPMENUCONTROL
     //
     this.cmdGROUPMENUCONTROL.CacheConnection = false;
     this.cmdGROUPMENUCONTROL.CommandText = "SELECT * FROM GROUPMENUCONTROL";
     this.cmdGROUPMENUCONTROL.CommandTimeout = 30;
     this.cmdGROUPMENUCONTROL.CommandType = System.Data.CommandType.Text;
     this.cmdGROUPMENUCONTROL.DynamicTableName = false;
     this.cmdGROUPMENUCONTROL.EEPAlias = null;
     this.cmdGROUPMENUCONTROL.EncodingAfter = null;
     this.cmdGROUPMENUCONTROL.EncodingBefore = "Windows-1252";
     this.cmdGROUPMENUCONTROL.InfoConnection = null;
     keyItem17.KeyName = "GROUPID";
     keyItem18.KeyName = "MENUID";
     keyItem19.KeyName = "CONTROLNAME";
     this.cmdGROUPMENUCONTROL.KeyFields.Add(keyItem17);
     this.cmdGROUPMENUCONTROL.KeyFields.Add(keyItem18);
     this.cmdGROUPMENUCONTROL.KeyFields.Add(keyItem19);
     this.cmdGROUPMENUCONTROL.MultiSetWhere = false;
     this.cmdGROUPMENUCONTROL.Name = "cmdGROUPMENUCONTROL";
     this.cmdGROUPMENUCONTROL.NotificationAutoEnlist = false;
     this.cmdGROUPMENUCONTROL.SecExcept = null;
     this.cmdGROUPMENUCONTROL.SecFieldName = null;
     this.cmdGROUPMENUCONTROL.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdGROUPMENUCONTROL.SelectPaging = false;
     this.cmdGROUPMENUCONTROL.SelectTop = 0;
     this.cmdGROUPMENUCONTROL.SiteControl = false;
     this.cmdGROUPMENUCONTROL.SiteFieldName = null;
     this.cmdGROUPMENUCONTROL.UpdatedRowSource = System.Data.UpdateRowSource.None;
     //
     // cmdUSERMENUCONTROL
     //
     this.cmdUSERMENUCONTROL.CacheConnection = false;
     this.cmdUSERMENUCONTROL.CommandText = "SELECT * FROM USERMENUCONTROL";
     this.cmdUSERMENUCONTROL.CommandTimeout = 30;
     this.cmdUSERMENUCONTROL.CommandType = System.Data.CommandType.Text;
     this.cmdUSERMENUCONTROL.DynamicTableName = false;
     this.cmdUSERMENUCONTROL.EEPAlias = null;
     this.cmdUSERMENUCONTROL.EncodingAfter = null;
     this.cmdUSERMENUCONTROL.EncodingBefore = "Windows-1252";
     this.cmdUSERMENUCONTROL.InfoConnection = null;
     keyItem20.KeyName = "USERID";
     keyItem21.KeyName = "MENUID";
     keyItem22.KeyName = "CONTROLNAME";
     this.cmdUSERMENUCONTROL.KeyFields.Add(keyItem20);
     this.cmdUSERMENUCONTROL.KeyFields.Add(keyItem21);
     this.cmdUSERMENUCONTROL.KeyFields.Add(keyItem22);
     this.cmdUSERMENUCONTROL.MultiSetWhere = false;
     this.cmdUSERMENUCONTROL.Name = "cmdUSERMENUCONTROL";
     this.cmdUSERMENUCONTROL.NotificationAutoEnlist = false;
     this.cmdUSERMENUCONTROL.SecExcept = null;
     this.cmdUSERMENUCONTROL.SecFieldName = null;
     this.cmdUSERMENUCONTROL.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdUSERMENUCONTROL.SelectPaging = false;
     this.cmdUSERMENUCONTROL.SelectTop = 0;
     this.cmdUSERMENUCONTROL.SiteControl = false;
     this.cmdUSERMENUCONTROL.SiteFieldName = null;
     this.cmdUSERMENUCONTROL.UpdatedRowSource = System.Data.UpdateRowSource.None;
     //
     // cmdSYS_REPORT
     //
     this.cmdSYS_REPORT.CacheConnection = false;
     this.cmdSYS_REPORT.CommandText = "select * from SYS_REPORT";
     this.cmdSYS_REPORT.CommandTimeout = 30;
     this.cmdSYS_REPORT.CommandType = System.Data.CommandType.Text;
     this.cmdSYS_REPORT.DynamicTableName = false;
     this.cmdSYS_REPORT.EEPAlias = null;
     this.cmdSYS_REPORT.EncodingAfter = null;
     this.cmdSYS_REPORT.EncodingBefore = "Windows-1252";
     this.cmdSYS_REPORT.InfoConnection = null;
     this.cmdSYS_REPORT.MultiSetWhere = false;
     this.cmdSYS_REPORT.Name = "cmdSYS_REPORT";
     this.cmdSYS_REPORT.NotificationAutoEnlist = false;
     this.cmdSYS_REPORT.SecExcept = null;
     this.cmdSYS_REPORT.SecFieldName = null;
     this.cmdSYS_REPORT.SecStyle = Srvtools.SecurityStyle.ssByNone;
     this.cmdSYS_REPORT.SelectPaging = false;
     this.cmdSYS_REPORT.SelectTop = 0;
     this.cmdSYS_REPORT.SiteControl = false;
     this.cmdSYS_REPORT.SiteFieldName = null;
     this.cmdSYS_REPORT.UpdatedRowSource = System.Data.UpdateRowSource.None;
     ((System.ComponentModel.ISupportInitialize)(this.userInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.groupInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.UGInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMGroups)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMGroupMenus)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.sqlMenus)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.packageInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.solutionInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.menuTableLogInfo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.menuTableLogInfoWithoutBinary)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdDBTables)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdColDEF)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdColDEF_Details)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRefValUse)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdERRLOG)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSYSEEPLOGforDB)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdDDUse)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.userMenus)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.packageversion)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSysRefVal)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSysRefVal_D)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdToDoList)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdToDoHis)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRoles)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgRoles)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgLevel)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdOrgKind)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdWorkflow)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdRoleAgent)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSlSource)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdGROUPMENUCONTROL)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdUSERMENUCONTROL)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdSYS_REPORT)).EndInit();
 }
コード例 #9
0
ファイル: SQLBuilder.cs プロジェクト: san90279/UK_OAS
 public SQLBuilder(UpdateComponent updateComponent, DataRow row, DataTable schema)
 {
     _updateComonent = updateComponent;
     _row = row;
     _schema = schema;
 }