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; }
public InfoTransactionEditorKeyFieldsDialog(Transaction trans, UpdateComponent uc, string destablename, string srctablename) { transaction = trans; uctran = uc; _conn = FindConnection(uctran); strDesTable = destablename; strSrcTable = srctablename; InitializeComponent(); }
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; }
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; }
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; }
/// <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(); }
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(); } } }
/// <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(); }
public SQLBuilder(UpdateComponent updateComponent, DataRow row, DataTable schema) { _updateComonent = updateComponent; _row = row; _schema = schema; }