/// <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.FieldAttr fieldAttr1 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr2 = new Srvtools.FieldAttr(); Srvtools.KeyItem keyItem2 = new Srvtools.KeyItem(); this.serviceManager1 = new Srvtools.ServiceManager(this.components); this.InfoConnection1 = new Srvtools.InfoConnection(this.components); this.T_ZT = new Srvtools.InfoCommand(this.components); this.ucT_ZT = new Srvtools.UpdateComponent(this.components); this.View_T_ZT = new Srvtools.InfoCommand(this.components); ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.T_ZT)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_ZT)).BeginInit(); // // InfoConnection1 // this.InfoConnection1.EEPAlias = "LingYi"; // // T_ZT // this.T_ZT.CacheConnection = false; this.T_ZT.CommandText = "SELECT dbo.[T_ZT].* FROM dbo.[T_ZT]"; this.T_ZT.CommandTimeout = 30; this.T_ZT.CommandType = System.Data.CommandType.Text; this.T_ZT.DynamicTableName = false; this.T_ZT.EEPAlias = null; this.T_ZT.EncodingAfter = null; this.T_ZT.EncodingBefore = "Windows-1252"; this.T_ZT.InfoConnection = this.InfoConnection1; keyItem1.KeyName = "ZTDH"; this.T_ZT.KeyFields.Add(keyItem1); this.T_ZT.MultiSetWhere = false; this.T_ZT.Name = "T_ZT"; this.T_ZT.NotificationAutoEnlist = false; this.T_ZT.SecExcept = null; this.T_ZT.SecFieldName = null; this.T_ZT.SecStyle = Srvtools.SecurityStyle.ssByNone; this.T_ZT.SelectPaging = false; this.T_ZT.SelectTop = 0; this.T_ZT.SiteControl = false; this.T_ZT.SiteFieldName = null; this.T_ZT.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucT_ZT // this.ucT_ZT.AutoTrans = true; this.ucT_ZT.ExceptJoin = false; fieldAttr1.CheckNull = false; fieldAttr1.DataField = "ZTDH"; fieldAttr1.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr1.DefaultValue = null; fieldAttr1.TrimLength = 0; fieldAttr1.UpdateEnable = true; fieldAttr1.WhereMode = true; fieldAttr2.CheckNull = false; fieldAttr2.DataField = "ZT"; fieldAttr2.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr2.DefaultValue = null; fieldAttr2.TrimLength = 0; fieldAttr2.UpdateEnable = true; fieldAttr2.WhereMode = true; this.ucT_ZT.FieldAttrs.Add(fieldAttr1); this.ucT_ZT.FieldAttrs.Add(fieldAttr2); this.ucT_ZT.LogInfo = null; this.ucT_ZT.Name = null; this.ucT_ZT.RowAffectsCheck = true; this.ucT_ZT.SelectCmd = this.T_ZT; this.ucT_ZT.SelectCmdForUpdate = null; this.ucT_ZT.ServerModify = true; this.ucT_ZT.ServerModifyGetMax = false; this.ucT_ZT.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucT_ZT.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucT_ZT.UseTranscationScope = false; this.ucT_ZT.WhereMode = Srvtools.WhereModeType.Keyfields; // // View_T_ZT // this.View_T_ZT.CacheConnection = false; this.View_T_ZT.CommandText = "SELECT * FROM dbo.[T_ZT]"; this.View_T_ZT.CommandTimeout = 30; this.View_T_ZT.CommandType = System.Data.CommandType.Text; this.View_T_ZT.DynamicTableName = false; this.View_T_ZT.EEPAlias = null; this.View_T_ZT.EncodingAfter = null; this.View_T_ZT.EncodingBefore = "Windows-1252"; this.View_T_ZT.InfoConnection = this.InfoConnection1; keyItem2.KeyName = "ZTDH"; this.View_T_ZT.KeyFields.Add(keyItem2); this.View_T_ZT.MultiSetWhere = false; this.View_T_ZT.Name = "View_T_ZT"; this.View_T_ZT.NotificationAutoEnlist = false; this.View_T_ZT.SecExcept = null; this.View_T_ZT.SecFieldName = null; this.View_T_ZT.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_T_ZT.SelectPaging = false; this.View_T_ZT.SelectTop = 0; this.View_T_ZT.SiteControl = false; this.View_T_ZT.SiteFieldName = null; this.View_T_ZT.UpdatedRowSource = System.Data.UpdateRowSource.None; ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.T_ZT)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_ZT)).EndInit(); }
/// <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.FieldAttr fieldAttr1 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr2 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr3 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr4 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr5 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr6 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr7 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr8 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr9 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr10 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr11 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr12 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr13 = new Srvtools.FieldAttr(); Srvtools.KeyItem keyItem2 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem3 = new Srvtools.KeyItem(); Srvtools.FieldAttr fieldAttr14 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr15 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr16 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr17 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr18 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr19 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr20 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr21 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr22 = new Srvtools.FieldAttr(); Srvtools.ColumnItem columnItem1 = new Srvtools.ColumnItem(); Srvtools.ColumnItem columnItem2 = new Srvtools.ColumnItem(); Srvtools.KeyItem keyItem4 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem5 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem6 = new Srvtools.KeyItem(); this.serviceManager1 = new Srvtools.ServiceManager(this.components); this.InfoConnection1 = new Srvtools.InfoConnection(this.components); this.T_AJ = new Srvtools.InfoCommand(this.components); this.ucT_AJ = new Srvtools.UpdateComponent(this.components); this.T_AJJD = new Srvtools.InfoCommand(this.components); this.ucT_AJJD = new Srvtools.UpdateComponent(this.components); this.idT_AJ_T_AJJD = new Srvtools.InfoDataSource(this.components); this.View_T_AJ = new Srvtools.InfoCommand(this.components); this.autoNumber1 = new Srvtools.AutoNumber(this.components); this.View_AJJD = new Srvtools.InfoCommand(this.components); this.View_AJJDs = new Srvtools.InfoCommand(this.components); ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.T_AJ)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.T_AJJD)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_AJ)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_AJJD)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_AJJDs)).BeginInit(); // // InfoConnection1 // this.InfoConnection1.EEPAlias = "LingYi"; // // T_AJ // this.T_AJ.CacheConnection = false; this.T_AJ.CommandText = "SELECT dbo.[T_AJ].* FROM dbo.[T_AJ] order by convert(datetime,left(updatedate,CH" + "ARINDEX(\' \',Updatedate))) desc"; this.T_AJ.CommandTimeout = 30; this.T_AJ.CommandType = System.Data.CommandType.Text; this.T_AJ.DynamicTableName = false; this.T_AJ.EEPAlias = null; this.T_AJ.EncodingAfter = null; this.T_AJ.EncodingBefore = "Windows-1252"; this.T_AJ.InfoConnection = this.InfoConnection1; keyItem1.KeyName = "AJBH"; this.T_AJ.KeyFields.Add(keyItem1); this.T_AJ.MultiSetWhere = false; this.T_AJ.Name = "T_AJ"; this.T_AJ.NotificationAutoEnlist = false; this.T_AJ.SecExcept = null; this.T_AJ.SecFieldName = null; this.T_AJ.SecStyle = Srvtools.SecurityStyle.ssByNone; this.T_AJ.SelectPaging = false; this.T_AJ.SelectTop = 0; this.T_AJ.SiteControl = false; this.T_AJ.SiteFieldName = null; this.T_AJ.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucT_AJ // this.ucT_AJ.AutoTrans = true; this.ucT_AJ.ExceptJoin = false; fieldAttr1.CheckNull = false; fieldAttr1.DataField = "AJBH"; fieldAttr1.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr1.DefaultValue = null; fieldAttr1.TrimLength = 0; fieldAttr1.UpdateEnable = true; fieldAttr1.WhereMode = true; fieldAttr2.CheckNull = false; fieldAttr2.DataField = "ZZ"; fieldAttr2.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr2.DefaultValue = null; fieldAttr2.TrimLength = 0; fieldAttr2.UpdateEnable = true; fieldAttr2.WhereMode = true; fieldAttr3.CheckNull = false; fieldAttr3.DataField = "SM"; fieldAttr3.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr3.DefaultValue = null; fieldAttr3.TrimLength = 0; fieldAttr3.UpdateEnable = true; fieldAttr3.WhereMode = true; fieldAttr4.CheckNull = false; fieldAttr4.DataField = "CQDH"; fieldAttr4.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr4.DefaultValue = null; fieldAttr4.TrimLength = 0; fieldAttr4.UpdateEnable = true; fieldAttr4.WhereMode = true; fieldAttr5.CheckNull = false; fieldAttr5.DataField = "ZTDH"; fieldAttr5.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr5.DefaultValue = null; fieldAttr5.TrimLength = 0; fieldAttr5.UpdateEnable = true; fieldAttr5.WhereMode = true; fieldAttr6.CheckNull = false; fieldAttr6.DataField = "FJMC"; fieldAttr6.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr6.DefaultValue = null; fieldAttr6.TrimLength = 0; fieldAttr6.UpdateEnable = true; fieldAttr6.WhereMode = true; fieldAttr7.CheckNull = false; fieldAttr7.DataField = "LARQ"; fieldAttr7.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr7.DefaultValue = null; fieldAttr7.TrimLength = 0; fieldAttr7.UpdateEnable = true; fieldAttr7.WhereMode = true; fieldAttr8.CheckNull = false; fieldAttr8.DataField = "YJWG"; fieldAttr8.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr8.DefaultValue = null; fieldAttr8.TrimLength = 0; fieldAttr8.UpdateEnable = true; fieldAttr8.WhereMode = true; fieldAttr9.CheckNull = false; fieldAttr9.DataField = "JARQ"; fieldAttr9.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr9.DefaultValue = null; fieldAttr9.TrimLength = 0; fieldAttr9.UpdateEnable = true; fieldAttr9.WhereMode = true; fieldAttr10.CheckNull = false; fieldAttr10.DataField = "USERID"; fieldAttr10.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr10.DefaultValue = "_UserCode"; fieldAttr10.TrimLength = 0; fieldAttr10.UpdateEnable = true; fieldAttr10.WhereMode = true; fieldAttr11.CheckNull = false; fieldAttr11.DataField = "CREATEDATE"; fieldAttr11.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr11.DefaultValue = "_sysdate"; fieldAttr11.TrimLength = 0; fieldAttr11.UpdateEnable = true; fieldAttr11.WhereMode = true; fieldAttr12.CheckNull = false; fieldAttr12.DataField = "UPDATEDATE"; fieldAttr12.DefaultMode = Srvtools.DefaultModeType.InsertAndUpdate; fieldAttr12.DefaultValue = "_sysdate"; fieldAttr12.TrimLength = 0; fieldAttr12.UpdateEnable = true; fieldAttr12.WhereMode = true; fieldAttr13.CheckNull = false; fieldAttr13.DataField = "DELETEMARK"; fieldAttr13.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr13.DefaultValue = null; fieldAttr13.TrimLength = 0; fieldAttr13.UpdateEnable = true; fieldAttr13.WhereMode = true; this.ucT_AJ.FieldAttrs.Add(fieldAttr1); this.ucT_AJ.FieldAttrs.Add(fieldAttr2); this.ucT_AJ.FieldAttrs.Add(fieldAttr3); this.ucT_AJ.FieldAttrs.Add(fieldAttr4); this.ucT_AJ.FieldAttrs.Add(fieldAttr5); this.ucT_AJ.FieldAttrs.Add(fieldAttr6); this.ucT_AJ.FieldAttrs.Add(fieldAttr7); this.ucT_AJ.FieldAttrs.Add(fieldAttr8); this.ucT_AJ.FieldAttrs.Add(fieldAttr9); this.ucT_AJ.FieldAttrs.Add(fieldAttr10); this.ucT_AJ.FieldAttrs.Add(fieldAttr11); this.ucT_AJ.FieldAttrs.Add(fieldAttr12); this.ucT_AJ.FieldAttrs.Add(fieldAttr13); this.ucT_AJ.LogInfo = null; this.ucT_AJ.Name = "ucT_AJ"; this.ucT_AJ.RowAffectsCheck = true; this.ucT_AJ.SelectCmd = this.T_AJ; this.ucT_AJ.SelectCmdForUpdate = null; this.ucT_AJ.ServerModify = true; this.ucT_AJ.ServerModifyGetMax = false; this.ucT_AJ.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucT_AJ.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucT_AJ.UseTranscationScope = false; this.ucT_AJ.WhereMode = Srvtools.WhereModeType.Keyfields; // // T_AJJD // this.T_AJJD.CacheConnection = false; this.T_AJJD.CommandText = "SELECT dbo.[T_AJJD].* FROM dbo.[T_AJJD]"; this.T_AJJD.CommandTimeout = 30; this.T_AJJD.CommandType = System.Data.CommandType.Text; this.T_AJJD.DynamicTableName = false; this.T_AJJD.EEPAlias = null; this.T_AJJD.EncodingAfter = null; this.T_AJJD.EncodingBefore = "Windows-1252"; this.T_AJJD.InfoConnection = this.InfoConnection1; keyItem2.KeyName = "AJBH"; keyItem3.KeyName = "seq"; this.T_AJJD.KeyFields.Add(keyItem2); this.T_AJJD.KeyFields.Add(keyItem3); this.T_AJJD.MultiSetWhere = false; this.T_AJJD.Name = "T_AJJD"; this.T_AJJD.NotificationAutoEnlist = false; this.T_AJJD.SecExcept = null; this.T_AJJD.SecFieldName = null; this.T_AJJD.SecStyle = Srvtools.SecurityStyle.ssByNone; this.T_AJJD.SelectPaging = false; this.T_AJJD.SelectTop = 0; this.T_AJJD.SiteControl = false; this.T_AJJD.SiteFieldName = null; this.T_AJJD.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucT_AJJD // this.ucT_AJJD.AutoTrans = true; this.ucT_AJJD.ExceptJoin = false; fieldAttr14.CheckNull = false; fieldAttr14.DataField = "AJBH"; fieldAttr14.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr14.DefaultValue = null; fieldAttr14.TrimLength = 0; fieldAttr14.UpdateEnable = true; fieldAttr14.WhereMode = true; fieldAttr15.CheckNull = false; fieldAttr15.DataField = "seq"; fieldAttr15.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr15.DefaultValue = null; fieldAttr15.TrimLength = 0; fieldAttr15.UpdateEnable = true; fieldAttr15.WhereMode = true; fieldAttr16.CheckNull = false; fieldAttr16.DataField = "JDRQ"; fieldAttr16.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr16.DefaultValue = null; fieldAttr16.TrimLength = 0; fieldAttr16.UpdateEnable = true; fieldAttr16.WhereMode = true; fieldAttr17.CheckNull = false; fieldAttr17.DataField = "JDSM"; fieldAttr17.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr17.DefaultValue = null; fieldAttr17.TrimLength = 0; fieldAttr17.UpdateEnable = true; fieldAttr17.WhereMode = true; fieldAttr18.CheckNull = false; fieldAttr18.DataField = "FJMC"; fieldAttr18.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr18.DefaultValue = null; fieldAttr18.TrimLength = 0; fieldAttr18.UpdateEnable = true; fieldAttr18.WhereMode = true; fieldAttr19.CheckNull = false; fieldAttr19.DataField = "USERID_D"; fieldAttr19.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr19.DefaultValue = "_usercode"; fieldAttr19.TrimLength = 0; fieldAttr19.UpdateEnable = true; fieldAttr19.WhereMode = true; fieldAttr20.CheckNull = false; fieldAttr20.DataField = "CREATEDATE"; fieldAttr20.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr20.DefaultValue = "_sysdate"; fieldAttr20.TrimLength = 0; fieldAttr20.UpdateEnable = true; fieldAttr20.WhereMode = true; fieldAttr21.CheckNull = false; fieldAttr21.DataField = "UPDATEDATE"; fieldAttr21.DefaultMode = Srvtools.DefaultModeType.Update; fieldAttr21.DefaultValue = "_sysdate"; fieldAttr21.TrimLength = 0; fieldAttr21.UpdateEnable = true; fieldAttr21.WhereMode = true; fieldAttr22.CheckNull = false; fieldAttr22.DataField = "DELETEMARK"; fieldAttr22.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr22.DefaultValue = null; fieldAttr22.TrimLength = 0; fieldAttr22.UpdateEnable = true; fieldAttr22.WhereMode = true; this.ucT_AJJD.FieldAttrs.Add(fieldAttr14); this.ucT_AJJD.FieldAttrs.Add(fieldAttr15); this.ucT_AJJD.FieldAttrs.Add(fieldAttr16); this.ucT_AJJD.FieldAttrs.Add(fieldAttr17); this.ucT_AJJD.FieldAttrs.Add(fieldAttr18); this.ucT_AJJD.FieldAttrs.Add(fieldAttr19); this.ucT_AJJD.FieldAttrs.Add(fieldAttr20); this.ucT_AJJD.FieldAttrs.Add(fieldAttr21); this.ucT_AJJD.FieldAttrs.Add(fieldAttr22); this.ucT_AJJD.LogInfo = null; this.ucT_AJJD.Name = "ucT_AJJD"; this.ucT_AJJD.RowAffectsCheck = true; this.ucT_AJJD.SelectCmd = this.T_AJJD; this.ucT_AJJD.SelectCmdForUpdate = null; this.ucT_AJJD.ServerModify = true; this.ucT_AJJD.ServerModifyGetMax = false; this.ucT_AJJD.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucT_AJJD.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucT_AJJD.UseTranscationScope = false; this.ucT_AJJD.WhereMode = Srvtools.WhereModeType.Keyfields; // // idT_AJ_T_AJJD // this.idT_AJ_T_AJJD.Detail = this.T_AJJD; columnItem1.FieldName = "AJBH"; this.idT_AJ_T_AJJD.DetailColumns.Add(columnItem1); this.idT_AJ_T_AJJD.DynamicTableName = false; this.idT_AJ_T_AJJD.Master = this.T_AJ; columnItem2.FieldName = "AJBH"; this.idT_AJ_T_AJJD.MasterColumns.Add(columnItem2); // // View_T_AJ // this.View_T_AJ.CacheConnection = false; this.View_T_AJ.CommandText = "SELECT * FROM dbo.[T_AJ] order by ajbh desc"; this.View_T_AJ.CommandTimeout = 30; this.View_T_AJ.CommandType = System.Data.CommandType.Text; this.View_T_AJ.DynamicTableName = false; this.View_T_AJ.EEPAlias = null; this.View_T_AJ.EncodingAfter = null; this.View_T_AJ.EncodingBefore = "Windows-1252"; this.View_T_AJ.InfoConnection = this.InfoConnection1; keyItem4.KeyName = "AJBH"; this.View_T_AJ.KeyFields.Add(keyItem4); this.View_T_AJ.MultiSetWhere = false; this.View_T_AJ.Name = "View_T_AJ"; this.View_T_AJ.NotificationAutoEnlist = false; this.View_T_AJ.SecExcept = null; this.View_T_AJ.SecFieldName = null; this.View_T_AJ.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_T_AJ.SelectPaging = false; this.View_T_AJ.SelectTop = 0; this.View_T_AJ.SiteControl = false; this.View_T_AJ.SiteFieldName = null; this.View_T_AJ.UpdatedRowSource = System.Data.UpdateRowSource.None; // // autoNumber1 // this.autoNumber1.Active = true; this.autoNumber1.AutoNoID = "T_AJ_AJID"; this.autoNumber1.Description = "單據編號"; this.autoNumber1.GetFixed = "MyFixed()"; this.autoNumber1.isNumFill = false; this.autoNumber1.Name = "autoNumber1"; this.autoNumber1.Number = null; this.autoNumber1.NumDig = 3; this.autoNumber1.OldVersion = false; this.autoNumber1.OverFlow = true; this.autoNumber1.StartValue = 1; this.autoNumber1.Step = 1; this.autoNumber1.TargetColumn = "AJBH"; this.autoNumber1.UpdateComp = this.ucT_AJ; // // View_AJJD // this.View_AJJD.CacheConnection = false; this.View_AJJD.CommandText = "select a.*,b.seq,b.jdrq as jdrq,b.jdsm,b.userid_d from T_AJ a left join View_Las" + "tAJJD b on a.ajbh=b.ajbh order by a.ajbh desc"; this.View_AJJD.CommandTimeout = 30; this.View_AJJD.CommandType = System.Data.CommandType.Text; this.View_AJJD.DynamicTableName = false; this.View_AJJD.EEPAlias = null; this.View_AJJD.EncodingAfter = null; this.View_AJJD.EncodingBefore = "Windows-1252"; this.View_AJJD.InfoConnection = this.InfoConnection1; keyItem5.KeyName = "AJBH"; this.View_AJJD.KeyFields.Add(keyItem5); this.View_AJJD.MultiSetWhere = false; this.View_AJJD.Name = "View_AJJD"; this.View_AJJD.NotificationAutoEnlist = false; this.View_AJJD.SecExcept = null; this.View_AJJD.SecFieldName = null; this.View_AJJD.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_AJJD.SelectPaging = false; this.View_AJJD.SelectTop = 0; this.View_AJJD.SiteControl = false; this.View_AJJD.SiteFieldName = null; this.View_AJJD.UpdatedRowSource = System.Data.UpdateRowSource.None; // // View_AJJDs // this.View_AJJDs.CacheConnection = false; this.View_AJJDs.CommandText = "select View_AJJDs.* from View_AJJDs order by ajbh desc"; this.View_AJJDs.CommandTimeout = 30; this.View_AJJDs.CommandType = System.Data.CommandType.Text; this.View_AJJDs.DynamicTableName = false; this.View_AJJDs.EEPAlias = null; this.View_AJJDs.EncodingAfter = null; this.View_AJJDs.EncodingBefore = "Windows-1252"; this.View_AJJDs.InfoConnection = this.InfoConnection1; keyItem6.KeyName = "AJBH"; this.View_AJJDs.KeyFields.Add(keyItem6); this.View_AJJDs.MultiSetWhere = false; this.View_AJJDs.Name = "View_AJJDs"; this.View_AJJDs.NotificationAutoEnlist = false; this.View_AJJDs.SecExcept = null; this.View_AJJDs.SecFieldName = null; this.View_AJJDs.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_AJJDs.SelectPaging = false; this.View_AJJDs.SelectTop = 0; this.View_AJJDs.SiteControl = false; this.View_AJJDs.SiteFieldName = null; this.View_AJJDs.UpdatedRowSource = System.Data.UpdateRowSource.None; ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.T_AJ)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.T_AJJD)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_AJ)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_AJJD)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_AJJDs)).EndInit(); }
/// <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.FieldAttr fieldAttr1 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr2 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr3 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr4 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr5 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr6 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr7 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr8 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr9 = new Srvtools.FieldAttr(); Srvtools.KeyItem keyItem2 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem3 = new Srvtools.KeyItem(); Srvtools.FieldAttr fieldAttr10 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr11 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr12 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr13 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr14 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr15 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr16 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr17 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr18 = new Srvtools.FieldAttr(); Srvtools.ColumnItem columnItem1 = new Srvtools.ColumnItem(); Srvtools.ColumnItem columnItem2 = new Srvtools.ColumnItem(); Srvtools.KeyItem keyItem4 = new Srvtools.KeyItem(); this.serviceManager1 = new Srvtools.ServiceManager(this.components); this.InfoConnection1 = new Srvtools.InfoConnection(this.components); this.T_KM = new Srvtools.InfoCommand(this.components); this.ucT_KM = new Srvtools.UpdateComponent(this.components); this.T_KMFB = new Srvtools.InfoCommand(this.components); this.ucT_KMFB = new Srvtools.UpdateComponent(this.components); this.idT_KM_T_KMFB = new Srvtools.InfoDataSource(this.components); this.View_T_KM = new Srvtools.InfoCommand(this.components); this.autoNumber1 = new Srvtools.AutoNumber(this.components); ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.T_KM)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.T_KMFB)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_KM)).BeginInit(); // // InfoConnection1 // this.InfoConnection1.EEPAlias = "LingYi"; // // T_KM // this.T_KM.CacheConnection = false; this.T_KM.CommandText = "SELECT dbo.[T_KM].* FROM dbo.[T_KM] order by convert(datetime,left(updatedate,CHA" + "RINDEX(\' \',Updatedate))) desc"; this.T_KM.CommandTimeout = 30; this.T_KM.CommandType = System.Data.CommandType.Text; this.T_KM.DynamicTableName = false; this.T_KM.EEPAlias = null; this.T_KM.EncodingAfter = null; this.T_KM.EncodingBefore = "Windows-1252"; this.T_KM.InfoConnection = this.InfoConnection1; keyItem1.KeyName = "KMBH"; this.T_KM.KeyFields.Add(keyItem1); this.T_KM.MultiSetWhere = false; this.T_KM.Name = "T_KM"; this.T_KM.NotificationAutoEnlist = false; this.T_KM.SecExcept = null; this.T_KM.SecFieldName = null; this.T_KM.SecStyle = Srvtools.SecurityStyle.ssByNone; this.T_KM.SelectPaging = false; this.T_KM.SelectTop = 0; this.T_KM.SiteControl = false; this.T_KM.SiteFieldName = null; this.T_KM.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucT_KM // this.ucT_KM.AutoTrans = true; this.ucT_KM.ExceptJoin = false; fieldAttr1.CheckNull = false; fieldAttr1.DataField = "KMBH"; fieldAttr1.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr1.DefaultValue = null; fieldAttr1.TrimLength = 0; fieldAttr1.UpdateEnable = true; fieldAttr1.WhereMode = true; fieldAttr2.CheckNull = false; fieldAttr2.DataField = "Subject"; fieldAttr2.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr2.DefaultValue = null; fieldAttr2.TrimLength = 0; fieldAttr2.UpdateEnable = true; fieldAttr2.WhereMode = true; fieldAttr3.CheckNull = false; fieldAttr3.DataField = "KM"; fieldAttr3.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr3.DefaultValue = null; fieldAttr3.TrimLength = 0; fieldAttr3.UpdateEnable = true; fieldAttr3.WhereMode = true; fieldAttr4.CheckNull = false; fieldAttr4.DataField = "FJMC"; fieldAttr4.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr4.DefaultValue = null; fieldAttr4.TrimLength = 0; fieldAttr4.UpdateEnable = true; fieldAttr4.WhereMode = true; fieldAttr5.CheckNull = false; fieldAttr5.DataField = "Keyword"; fieldAttr5.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr5.DefaultValue = null; fieldAttr5.TrimLength = 0; fieldAttr5.UpdateEnable = true; fieldAttr5.WhereMode = true; fieldAttr6.CheckNull = false; fieldAttr6.DataField = "USERID"; fieldAttr6.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr6.DefaultValue = "_usercode"; fieldAttr6.TrimLength = 0; fieldAttr6.UpdateEnable = true; fieldAttr6.WhereMode = true; fieldAttr7.CheckNull = false; fieldAttr7.DataField = "CREATEDATE"; fieldAttr7.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr7.DefaultValue = "_sysdate"; fieldAttr7.TrimLength = 0; fieldAttr7.UpdateEnable = true; fieldAttr7.WhereMode = true; fieldAttr8.CheckNull = false; fieldAttr8.DataField = "UPDATEDATE"; fieldAttr8.DefaultMode = Srvtools.DefaultModeType.InsertAndUpdate; fieldAttr8.DefaultValue = "_sysdate"; fieldAttr8.TrimLength = 0; fieldAttr8.UpdateEnable = true; fieldAttr8.WhereMode = true; fieldAttr9.CheckNull = false; fieldAttr9.DataField = "DELETEMARK"; fieldAttr9.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr9.DefaultValue = null; fieldAttr9.TrimLength = 0; fieldAttr9.UpdateEnable = true; fieldAttr9.WhereMode = true; this.ucT_KM.FieldAttrs.Add(fieldAttr1); this.ucT_KM.FieldAttrs.Add(fieldAttr2); this.ucT_KM.FieldAttrs.Add(fieldAttr3); this.ucT_KM.FieldAttrs.Add(fieldAttr4); this.ucT_KM.FieldAttrs.Add(fieldAttr5); this.ucT_KM.FieldAttrs.Add(fieldAttr6); this.ucT_KM.FieldAttrs.Add(fieldAttr7); this.ucT_KM.FieldAttrs.Add(fieldAttr8); this.ucT_KM.FieldAttrs.Add(fieldAttr9); this.ucT_KM.LogInfo = null; this.ucT_KM.Name = "ucT_KM"; this.ucT_KM.RowAffectsCheck = true; this.ucT_KM.SelectCmd = this.T_KM; this.ucT_KM.SelectCmdForUpdate = null; this.ucT_KM.ServerModify = true; this.ucT_KM.ServerModifyGetMax = false; this.ucT_KM.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucT_KM.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucT_KM.UseTranscationScope = false; this.ucT_KM.WhereMode = Srvtools.WhereModeType.Keyfields; // // T_KMFB // this.T_KMFB.CacheConnection = false; this.T_KMFB.CommandText = "SELECT dbo.[T_KMFB].* FROM dbo.[T_KMFB]"; this.T_KMFB.CommandTimeout = 30; this.T_KMFB.CommandType = System.Data.CommandType.Text; this.T_KMFB.DynamicTableName = false; this.T_KMFB.EEPAlias = null; this.T_KMFB.EncodingAfter = null; this.T_KMFB.EncodingBefore = "Windows-1252"; this.T_KMFB.InfoConnection = this.InfoConnection1; keyItem2.KeyName = "KMBH"; keyItem3.KeyName = "seq"; this.T_KMFB.KeyFields.Add(keyItem2); this.T_KMFB.KeyFields.Add(keyItem3); this.T_KMFB.MultiSetWhere = false; this.T_KMFB.Name = "T_KMFB"; this.T_KMFB.NotificationAutoEnlist = false; this.T_KMFB.SecExcept = null; this.T_KMFB.SecFieldName = null; this.T_KMFB.SecStyle = Srvtools.SecurityStyle.ssByNone; this.T_KMFB.SelectPaging = false; this.T_KMFB.SelectTop = 0; this.T_KMFB.SiteControl = false; this.T_KMFB.SiteFieldName = null; this.T_KMFB.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucT_KMFB // this.ucT_KMFB.AutoTrans = true; this.ucT_KMFB.ExceptJoin = false; fieldAttr10.CheckNull = false; fieldAttr10.DataField = "KMBH"; fieldAttr10.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr10.DefaultValue = null; fieldAttr10.TrimLength = 0; fieldAttr10.UpdateEnable = true; fieldAttr10.WhereMode = true; fieldAttr11.CheckNull = false; fieldAttr11.DataField = "seq"; fieldAttr11.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr11.DefaultValue = null; fieldAttr11.TrimLength = 0; fieldAttr11.UpdateEnable = true; fieldAttr11.WhereMode = true; fieldAttr12.CheckNull = false; fieldAttr12.DataField = "FBSubject"; fieldAttr12.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr12.DefaultValue = null; fieldAttr12.TrimLength = 0; fieldAttr12.UpdateEnable = true; fieldAttr12.WhereMode = true; fieldAttr13.CheckNull = false; fieldAttr13.DataField = "KM"; fieldAttr13.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr13.DefaultValue = null; fieldAttr13.TrimLength = 0; fieldAttr13.UpdateEnable = true; fieldAttr13.WhereMode = true; fieldAttr14.CheckNull = false; fieldAttr14.DataField = "FJMC"; fieldAttr14.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr14.DefaultValue = null; fieldAttr14.TrimLength = 0; fieldAttr14.UpdateEnable = true; fieldAttr14.WhereMode = true; fieldAttr15.CheckNull = false; fieldAttr15.DataField = "FBUSERID"; fieldAttr15.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr15.DefaultValue = "_UserCode"; fieldAttr15.TrimLength = 0; fieldAttr15.UpdateEnable = true; fieldAttr15.WhereMode = true; fieldAttr16.CheckNull = false; fieldAttr16.DataField = "CREATEDATE"; fieldAttr16.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr16.DefaultValue = "_sysdate"; fieldAttr16.TrimLength = 0; fieldAttr16.UpdateEnable = true; fieldAttr16.WhereMode = true; fieldAttr17.CheckNull = false; fieldAttr17.DataField = "UPDATEDATE"; fieldAttr17.DefaultMode = Srvtools.DefaultModeType.Update; fieldAttr17.DefaultValue = "_sysdate"; fieldAttr17.TrimLength = 0; fieldAttr17.UpdateEnable = true; fieldAttr17.WhereMode = true; fieldAttr18.CheckNull = false; fieldAttr18.DataField = "DELETEMARK"; fieldAttr18.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr18.DefaultValue = null; fieldAttr18.TrimLength = 0; fieldAttr18.UpdateEnable = true; fieldAttr18.WhereMode = true; this.ucT_KMFB.FieldAttrs.Add(fieldAttr10); this.ucT_KMFB.FieldAttrs.Add(fieldAttr11); this.ucT_KMFB.FieldAttrs.Add(fieldAttr12); this.ucT_KMFB.FieldAttrs.Add(fieldAttr13); this.ucT_KMFB.FieldAttrs.Add(fieldAttr14); this.ucT_KMFB.FieldAttrs.Add(fieldAttr15); this.ucT_KMFB.FieldAttrs.Add(fieldAttr16); this.ucT_KMFB.FieldAttrs.Add(fieldAttr17); this.ucT_KMFB.FieldAttrs.Add(fieldAttr18); this.ucT_KMFB.LogInfo = null; this.ucT_KMFB.Name = "ucT_KMFB"; this.ucT_KMFB.RowAffectsCheck = true; this.ucT_KMFB.SelectCmd = this.T_KMFB; this.ucT_KMFB.SelectCmdForUpdate = null; this.ucT_KMFB.ServerModify = true; this.ucT_KMFB.ServerModifyGetMax = false; this.ucT_KMFB.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucT_KMFB.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucT_KMFB.UseTranscationScope = false; this.ucT_KMFB.WhereMode = Srvtools.WhereModeType.Keyfields; // // idT_KM_T_KMFB // this.idT_KM_T_KMFB.Detail = this.T_KMFB; columnItem1.FieldName = "KMBH"; this.idT_KM_T_KMFB.DetailColumns.Add(columnItem1); this.idT_KM_T_KMFB.DynamicTableName = false; this.idT_KM_T_KMFB.Master = this.T_KM; columnItem2.FieldName = "KMBH"; this.idT_KM_T_KMFB.MasterColumns.Add(columnItem2); // // View_T_KM // this.View_T_KM.CacheConnection = false; this.View_T_KM.CommandText = "SELECT * FROM dbo.[T_KM]"; this.View_T_KM.CommandTimeout = 30; this.View_T_KM.CommandType = System.Data.CommandType.Text; this.View_T_KM.DynamicTableName = false; this.View_T_KM.EEPAlias = null; this.View_T_KM.EncodingAfter = null; this.View_T_KM.EncodingBefore = "Windows-1252"; this.View_T_KM.InfoConnection = this.InfoConnection1; keyItem4.KeyName = "KMBH"; this.View_T_KM.KeyFields.Add(keyItem4); this.View_T_KM.MultiSetWhere = false; this.View_T_KM.Name = "View_T_KM"; this.View_T_KM.NotificationAutoEnlist = false; this.View_T_KM.SecExcept = null; this.View_T_KM.SecFieldName = null; this.View_T_KM.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_T_KM.SelectPaging = false; this.View_T_KM.SelectTop = 0; this.View_T_KM.SiteControl = false; this.View_T_KM.SiteFieldName = null; this.View_T_KM.UpdatedRowSource = System.Data.UpdateRowSource.None; // // autoNumber1 // this.autoNumber1.Active = true; this.autoNumber1.AutoNoID = "T_KM"; this.autoNumber1.Description = "知識編號"; this.autoNumber1.GetFixed = "MyFixed()"; this.autoNumber1.isNumFill = false; this.autoNumber1.Name = "autoNumber1"; this.autoNumber1.Number = null; this.autoNumber1.NumDig = 3; this.autoNumber1.OldVersion = false; this.autoNumber1.OverFlow = true; this.autoNumber1.StartValue = 1; this.autoNumber1.Step = 1; this.autoNumber1.TargetColumn = "KMBH"; this.autoNumber1.UpdateComp = this.ucT_KM; ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.T_KM)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.T_KMFB)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_T_KM)).EndInit(); }
/// <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.FieldAttr fieldAttr1 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr2 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr3 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr4 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr5 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr6 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr7 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr8 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr9 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr10 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr11 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr12 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr13 = new Srvtools.FieldAttr(); Srvtools.KeyItem keyItem2 = new Srvtools.KeyItem(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Component)); Srvtools.KeyItem keyItem3 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem4 = new Srvtools.KeyItem(); Srvtools.FieldAttr fieldAttr14 = new Srvtools.FieldAttr(); Srvtools.Transaction transaction1 = new Srvtools.Transaction(); Srvtools.TransField transField1 = new Srvtools.TransField(); Srvtools.TransField transField2 = new Srvtools.TransField(); Srvtools.TransField transField3 = new Srvtools.TransField(); Srvtools.TransField transField4 = new Srvtools.TransField(); Srvtools.TransField transField5 = new Srvtools.TransField(); Srvtools.TransField transField6 = new Srvtools.TransField(); Srvtools.KeyItem keyItem5 = new Srvtools.KeyItem(); Srvtools.KeyItem keyItem6 = new Srvtools.KeyItem(); Srvtools.FieldAttr fieldAttr15 = new Srvtools.FieldAttr(); Srvtools.FieldAttr fieldAttr16 = new Srvtools.FieldAttr(); Srvtools.Transaction transaction2 = new Srvtools.Transaction(); Srvtools.TransField transField7 = new Srvtools.TransField(); Srvtools.TransField transField8 = new Srvtools.TransField(); Srvtools.TransField transField9 = new Srvtools.TransField(); Srvtools.TransField transField10 = new Srvtools.TransField(); Srvtools.TransField transField11 = new Srvtools.TransField(); Srvtools.TransField transField12 = new Srvtools.TransField(); this.serviceManager1 = new Srvtools.ServiceManager(this.components); this.InfoConnection1 = new Srvtools.InfoConnection(this.components); this.USERS = new Srvtools.InfoCommand(this.components); this.ucUSERS = new Srvtools.UpdateComponent(this.components); this.View_USERS = new Srvtools.InfoCommand(this.components); this.infoConnection2 = new Srvtools.InfoConnection(this.components); this.cgzls = new Srvtools.InfoCommand(this.components); this.ucCGZLS = new Srvtools.UpdateComponent(this.components); this.iftCGZLS = new Srvtools.InfoTransaction(this.components); this.ETDApplied = new Srvtools.InfoCommand(this.components); this.ucETDApplied = new Srvtools.UpdateComponent(this.components); this.iftETDApplied = new Srvtools.InfoTransaction(this.components); ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.USERS)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.View_USERS)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.infoConnection2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.cgzls)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ETDApplied)).BeginInit(); // // InfoConnection1 // this.InfoConnection1.EEPAlias = "LingYi"; // // USERS // this.USERS.CacheConnection = false; this.USERS.CommandText = "SELECT dbo.[USERS].* FROM dbo.[USERS]"; this.USERS.CommandTimeout = 30; this.USERS.CommandType = System.Data.CommandType.Text; this.USERS.DynamicTableName = false; this.USERS.EEPAlias = null; this.USERS.EncodingAfter = null; this.USERS.EncodingBefore = "Windows-1252"; this.USERS.InfoConnection = this.InfoConnection1; keyItem1.KeyName = "USERID"; this.USERS.KeyFields.Add(keyItem1); this.USERS.MultiSetWhere = false; this.USERS.Name = "USERS"; this.USERS.NotificationAutoEnlist = false; this.USERS.SecExcept = null; this.USERS.SecFieldName = null; this.USERS.SecStyle = Srvtools.SecurityStyle.ssByNone; this.USERS.SelectPaging = false; this.USERS.SelectTop = 0; this.USERS.SiteControl = false; this.USERS.SiteFieldName = null; this.USERS.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucUSERS // this.ucUSERS.AutoTrans = true; this.ucUSERS.ExceptJoin = false; fieldAttr1.CheckNull = false; fieldAttr1.DataField = "USERID"; fieldAttr1.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr1.DefaultValue = null; fieldAttr1.TrimLength = 0; fieldAttr1.UpdateEnable = true; fieldAttr1.WhereMode = true; fieldAttr2.CheckNull = false; fieldAttr2.DataField = "USERNAME"; fieldAttr2.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr2.DefaultValue = null; fieldAttr2.TrimLength = 0; fieldAttr2.UpdateEnable = true; fieldAttr2.WhereMode = true; fieldAttr3.CheckNull = false; fieldAttr3.DataField = "AGENT"; fieldAttr3.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr3.DefaultValue = null; fieldAttr3.TrimLength = 0; fieldAttr3.UpdateEnable = true; fieldAttr3.WhereMode = true; fieldAttr4.CheckNull = false; fieldAttr4.DataField = "PWD"; fieldAttr4.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr4.DefaultValue = null; fieldAttr4.TrimLength = 0; fieldAttr4.UpdateEnable = true; fieldAttr4.WhereMode = true; fieldAttr5.CheckNull = false; fieldAttr5.DataField = "CREATEDATE"; fieldAttr5.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr5.DefaultValue = null; fieldAttr5.TrimLength = 0; fieldAttr5.UpdateEnable = true; fieldAttr5.WhereMode = true; fieldAttr6.CheckNull = false; fieldAttr6.DataField = "CREATER"; fieldAttr6.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr6.DefaultValue = null; fieldAttr6.TrimLength = 0; fieldAttr6.UpdateEnable = true; fieldAttr6.WhereMode = true; fieldAttr7.CheckNull = false; fieldAttr7.DataField = "DESCRIPTION"; fieldAttr7.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr7.DefaultValue = null; fieldAttr7.TrimLength = 0; fieldAttr7.UpdateEnable = true; fieldAttr7.WhereMode = true; fieldAttr8.CheckNull = false; fieldAttr8.DataField = "EMAIL"; fieldAttr8.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr8.DefaultValue = null; fieldAttr8.TrimLength = 0; fieldAttr8.UpdateEnable = true; fieldAttr8.WhereMode = true; fieldAttr9.CheckNull = false; fieldAttr9.DataField = "LASTTIME"; fieldAttr9.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr9.DefaultValue = null; fieldAttr9.TrimLength = 0; fieldAttr9.UpdateEnable = true; fieldAttr9.WhereMode = true; fieldAttr10.CheckNull = false; fieldAttr10.DataField = "AUTOLOGIN"; fieldAttr10.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr10.DefaultValue = null; fieldAttr10.TrimLength = 0; fieldAttr10.UpdateEnable = true; fieldAttr10.WhereMode = true; fieldAttr11.CheckNull = false; fieldAttr11.DataField = "LASTDATE"; fieldAttr11.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr11.DefaultValue = null; fieldAttr11.TrimLength = 0; fieldAttr11.UpdateEnable = true; fieldAttr11.WhereMode = true; fieldAttr12.CheckNull = false; fieldAttr12.DataField = "SIGNATURE"; fieldAttr12.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr12.DefaultValue = null; fieldAttr12.TrimLength = 0; fieldAttr12.UpdateEnable = true; fieldAttr12.WhereMode = true; fieldAttr13.CheckNull = false; fieldAttr13.DataField = "MSAD"; fieldAttr13.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr13.DefaultValue = null; fieldAttr13.TrimLength = 0; fieldAttr13.UpdateEnable = true; fieldAttr13.WhereMode = true; this.ucUSERS.FieldAttrs.Add(fieldAttr1); this.ucUSERS.FieldAttrs.Add(fieldAttr2); this.ucUSERS.FieldAttrs.Add(fieldAttr3); this.ucUSERS.FieldAttrs.Add(fieldAttr4); this.ucUSERS.FieldAttrs.Add(fieldAttr5); this.ucUSERS.FieldAttrs.Add(fieldAttr6); this.ucUSERS.FieldAttrs.Add(fieldAttr7); this.ucUSERS.FieldAttrs.Add(fieldAttr8); this.ucUSERS.FieldAttrs.Add(fieldAttr9); this.ucUSERS.FieldAttrs.Add(fieldAttr10); this.ucUSERS.FieldAttrs.Add(fieldAttr11); this.ucUSERS.FieldAttrs.Add(fieldAttr12); this.ucUSERS.FieldAttrs.Add(fieldAttr13); this.ucUSERS.LogInfo = null; this.ucUSERS.Name = "ucUSERS"; this.ucUSERS.RowAffectsCheck = true; this.ucUSERS.SelectCmd = this.USERS; this.ucUSERS.SelectCmdForUpdate = null; this.ucUSERS.ServerModify = true; this.ucUSERS.ServerModifyGetMax = false; this.ucUSERS.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucUSERS.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucUSERS.UseTranscationScope = false; this.ucUSERS.WhereMode = Srvtools.WhereModeType.Keyfields; this.ucUSERS.BeforeInsert += new Srvtools.UpdateComponentBeforeInsertEventHandler(this.ucUSERS_BeforeInsert); this.ucUSERS.BeforeModify += new Srvtools.UpdateComponentBeforeModifyEventHandler(this.ucUSERS_BeforeModify); // // View_USERS // this.View_USERS.CacheConnection = false; this.View_USERS.CommandText = "SELECT * FROM dbo.[USERS]"; this.View_USERS.CommandTimeout = 30; this.View_USERS.CommandType = System.Data.CommandType.Text; this.View_USERS.DynamicTableName = false; this.View_USERS.EEPAlias = null; this.View_USERS.EncodingAfter = null; this.View_USERS.EncodingBefore = "Windows-1252"; this.View_USERS.InfoConnection = this.InfoConnection1; keyItem2.KeyName = "USERID"; this.View_USERS.KeyFields.Add(keyItem2); this.View_USERS.MultiSetWhere = false; this.View_USERS.Name = "View_USERS"; this.View_USERS.NotificationAutoEnlist = false; this.View_USERS.SecExcept = null; this.View_USERS.SecFieldName = null; this.View_USERS.SecStyle = Srvtools.SecurityStyle.ssByNone; this.View_USERS.SelectPaging = false; this.View_USERS.SelectTop = 0; this.View_USERS.SiteControl = false; this.View_USERS.SiteFieldName = null; this.View_USERS.UpdatedRowSource = System.Data.UpdateRowSource.None; // // infoConnection2 // this.infoConnection2.EEPAlias = "LYV_1"; // // cgzls // this.cgzls.CacheConnection = false; this.cgzls.CommandText = resources.GetString("cgzls.CommandText"); this.cgzls.CommandTimeout = 30; this.cgzls.CommandType = System.Data.CommandType.Text; this.cgzls.DynamicTableName = false; this.cgzls.EEPAlias = "LYV_1"; this.cgzls.EncodingAfter = null; this.cgzls.EncodingBefore = "Windows-1252"; this.cgzls.InfoConnection = this.infoConnection2; keyItem3.KeyName = "cgno"; keyItem4.KeyName = "clbh"; this.cgzls.KeyFields.Add(keyItem3); this.cgzls.KeyFields.Add(keyItem4); this.cgzls.MultiSetWhere = false; this.cgzls.Name = "cgzls"; this.cgzls.NotificationAutoEnlist = false; this.cgzls.SecExcept = null; this.cgzls.SecFieldName = null; this.cgzls.SecStyle = Srvtools.SecurityStyle.ssByNone; this.cgzls.SelectPaging = false; this.cgzls.SelectTop = 0; this.cgzls.SiteControl = false; this.cgzls.SiteFieldName = null; this.cgzls.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucCGZLS // this.ucCGZLS.AutoTrans = true; this.ucCGZLS.ExceptJoin = false; fieldAttr14.CheckNull = false; fieldAttr14.DataField = "cfmdate"; fieldAttr14.DefaultMode = Srvtools.DefaultModeType.Insert; fieldAttr14.DefaultValue = null; fieldAttr14.TrimLength = 0; fieldAttr14.UpdateEnable = true; fieldAttr14.WhereMode = true; this.ucCGZLS.FieldAttrs.Add(fieldAttr14); this.ucCGZLS.LogInfo = null; this.ucCGZLS.Name = "ucCGZLS"; this.ucCGZLS.RowAffectsCheck = true; this.ucCGZLS.SelectCmd = this.cgzls; this.ucCGZLS.SelectCmdForUpdate = null; this.ucCGZLS.ServerModify = true; this.ucCGZLS.ServerModifyGetMax = false; this.ucCGZLS.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucCGZLS.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucCGZLS.UseTranscationScope = false; this.ucCGZLS.WhereMode = Srvtools.WhereModeType.Keyfields; // // iftCGZLS // this.iftCGZLS.Name = "iftCGZLS"; transaction1.AutoNumber = null; transField1.DesField = "PONO"; transField1.DesValue = null; transField1.FieldType = null; transField1.FieldTypeName = null; transField1.ReadOnly = false; transField1.SrcField = "cgno"; transField1.SrcGetValue = null; transField1.SrcValue = null; transField1.UpdateMode = Srvtools.UpdateMode.Replace; transField2.DesField = "CLBH"; transField2.DesValue = null; transField2.FieldType = null; transField2.FieldTypeName = null; transField2.ReadOnly = false; transField2.SrcField = "clbh"; transField2.SrcGetValue = null; transField2.SrcValue = null; transField2.UpdateMode = Srvtools.UpdateMode.Replace; transField3.DesField = "CfmDate"; transField3.DesValue = null; transField3.FieldType = null; transField3.FieldTypeName = null; transField3.ReadOnly = false; transField3.SrcField = "cfmdate"; transField3.SrcGetValue = null; transField3.SrcValue = null; transField3.UpdateMode = Srvtools.UpdateMode.Replace; transField4.DesField = "UserID"; transField4.DesValue = null; transField4.FieldType = null; transField4.FieldTypeName = null; transField4.ReadOnly = false; transField4.SrcField = null; transField4.SrcGetValue = "GetUserID()"; transField4.SrcValue = null; transField4.UpdateMode = Srvtools.UpdateMode.Replace; transField5.DesField = "IP"; transField5.DesValue = null; transField5.FieldType = null; transField5.FieldTypeName = null; transField5.ReadOnly = false; transField5.SrcField = null; transField5.SrcGetValue = "GetUserIP()"; transField5.SrcValue = null; transField5.UpdateMode = Srvtools.UpdateMode.Replace; transField6.DesField = "UserDate"; transField6.DesValue = null; transField6.FieldType = null; transField6.FieldTypeName = null; transField6.ReadOnly = false; transField6.SrcField = null; transField6.SrcGetValue = "CallTime()"; transField6.SrcValue = null; transField6.UpdateMode = Srvtools.UpdateMode.Replace; transaction1.TransFields.Add(transField1); transaction1.TransFields.Add(transField2); transaction1.TransFields.Add(transField3); transaction1.TransFields.Add(transField4); transaction1.TransFields.Add(transField5); transaction1.TransFields.Add(transField6); transaction1.TransMode = Srvtools.TransMode.AlwaysAppend; transaction1.TransStep = 0; transaction1.TransTableName = "LogsCGZLS"; transaction1.WhenDelete = false; transaction1.WhenInsert = false; transaction1.WhenUpdate = true; this.iftCGZLS.Transactions.Add(transaction1); this.iftCGZLS.UpdateComp = this.ucCGZLS; // // ETDApplied // this.ETDApplied.CacheConnection = false; this.ETDApplied.CommandText = resources.GetString("ETDApplied.CommandText"); this.ETDApplied.CommandTimeout = 30; this.ETDApplied.CommandType = System.Data.CommandType.Text; this.ETDApplied.DynamicTableName = false; this.ETDApplied.EEPAlias = "LYV_1"; this.ETDApplied.EncodingAfter = null; this.ETDApplied.EncodingBefore = "Windows-1252"; this.ETDApplied.InfoConnection = this.infoConnection2; keyItem5.KeyName = "cgno"; keyItem6.KeyName = "clbh"; this.ETDApplied.KeyFields.Add(keyItem5); this.ETDApplied.KeyFields.Add(keyItem6); this.ETDApplied.MultiSetWhere = false; this.ETDApplied.Name = "ETDApplied"; this.ETDApplied.NotificationAutoEnlist = false; this.ETDApplied.SecExcept = null; this.ETDApplied.SecFieldName = null; this.ETDApplied.SecStyle = Srvtools.SecurityStyle.ssByNone; this.ETDApplied.SelectPaging = false; this.ETDApplied.SelectTop = 0; this.ETDApplied.SiteControl = false; this.ETDApplied.SiteFieldName = null; this.ETDApplied.UpdatedRowSource = System.Data.UpdateRowSource.None; // // ucETDApplied // this.ucETDApplied.AutoTrans = true; this.ucETDApplied.ExceptJoin = false; fieldAttr15.CheckNull = false; fieldAttr15.DataField = "userdate"; fieldAttr15.DefaultMode = Srvtools.DefaultModeType.Update; fieldAttr15.DefaultValue = "CallTime()"; fieldAttr15.TrimLength = 0; fieldAttr15.UpdateEnable = true; fieldAttr15.WhereMode = true; fieldAttr16.CheckNull = false; fieldAttr16.DataField = "ApplyDate"; fieldAttr16.DefaultMode = Srvtools.DefaultModeType.Update; fieldAttr16.DefaultValue = null; fieldAttr16.TrimLength = 0; fieldAttr16.UpdateEnable = true; fieldAttr16.WhereMode = true; this.ucETDApplied.FieldAttrs.Add(fieldAttr15); this.ucETDApplied.FieldAttrs.Add(fieldAttr16); this.ucETDApplied.LogInfo = null; this.ucETDApplied.Name = null; this.ucETDApplied.RowAffectsCheck = true; this.ucETDApplied.SelectCmd = this.ETDApplied; this.ucETDApplied.SelectCmdForUpdate = null; this.ucETDApplied.ServerModify = true; this.ucETDApplied.ServerModifyGetMax = false; this.ucETDApplied.TranscationScopeTimeOut = System.TimeSpan.Parse("00:02:00"); this.ucETDApplied.TransIsolationLevel = System.Data.IsolationLevel.ReadCommitted; this.ucETDApplied.UseTranscationScope = false; this.ucETDApplied.WhereMode = Srvtools.WhereModeType.Keyfields; // // iftETDApplied // this.iftETDApplied.Name = "iftETDApplied"; transaction2.AutoNumber = null; transField7.DesField = "PONO"; transField7.DesValue = null; transField7.FieldType = null; transField7.FieldTypeName = null; transField7.ReadOnly = false; transField7.SrcField = "cgno"; transField7.SrcGetValue = null; transField7.SrcValue = null; transField7.UpdateMode = Srvtools.UpdateMode.Replace; transField8.DesField = "CLBH"; transField8.DesValue = null; transField8.FieldType = null; transField8.FieldTypeName = null; transField8.ReadOnly = false; transField8.SrcField = "clbh"; transField8.SrcGetValue = null; transField8.SrcValue = null; transField8.UpdateMode = Srvtools.UpdateMode.Replace; transField9.DesField = "CfmDate"; transField9.DesValue = null; transField9.FieldType = null; transField9.FieldTypeName = null; transField9.ReadOnly = false; transField9.SrcField = "ApplyDate"; transField9.SrcGetValue = null; transField9.SrcValue = null; transField9.UpdateMode = Srvtools.UpdateMode.Replace; transField10.DesField = "UserID"; transField10.DesValue = null; transField10.FieldType = null; transField10.FieldTypeName = null; transField10.ReadOnly = false; transField10.SrcField = null; transField10.SrcGetValue = "GetUserID()"; transField10.SrcValue = null; transField10.UpdateMode = Srvtools.UpdateMode.Replace; transField11.DesField = "IP"; transField11.DesValue = null; transField11.FieldType = null; transField11.FieldTypeName = null; transField11.ReadOnly = false; transField11.SrcField = null; transField11.SrcGetValue = "GetUserIP()"; transField11.SrcValue = null; transField11.UpdateMode = Srvtools.UpdateMode.Replace; transField12.DesField = "UserDate"; transField12.DesValue = null; transField12.FieldType = null; transField12.FieldTypeName = null; transField12.ReadOnly = false; transField12.SrcField = null; transField12.SrcGetValue = "CallTime()"; transField12.SrcValue = null; transField12.UpdateMode = Srvtools.UpdateMode.Replace; transaction2.TransFields.Add(transField7); transaction2.TransFields.Add(transField8); transaction2.TransFields.Add(transField9); transaction2.TransFields.Add(transField10); transaction2.TransFields.Add(transField11); transaction2.TransFields.Add(transField12); transaction2.TransMode = Srvtools.TransMode.AlwaysAppend; transaction2.TransStep = 0; transaction2.TransTableName = "LogsCGZLS"; transaction2.WhenDelete = false; transaction2.WhenInsert = false; transaction2.WhenUpdate = true; this.iftETDApplied.Transactions.Add(transaction2); this.iftETDApplied.UpdateComp = this.ucETDApplied; ((System.ComponentModel.ISupportInitialize)(this.InfoConnection1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.USERS)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.View_USERS)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.infoConnection2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cgzls)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ETDApplied)).EndInit(); }