/// <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(); 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(); }