- Timestamp:
- 01/08/09 14:33:22 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs
r1005 r1092 2438 2438 private global::System.Data.DataColumn columnParentJobId; 2439 2439 2440 private global::System.Data.DataColumn columnStatus;2441 2442 2440 private global::System.Data.DataColumn columnPermissionOwnerId; 2443 2441 2444 2442 private global::System.Data.DataColumn columnResourceId; 2443 2444 private global::System.Data.DataColumn columnJobState; 2445 2446 private global::System.Data.DataColumn columnPercentage; 2445 2447 2446 2448 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] … … 2489 2491 2490 2492 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2491 public global::System.Data.DataColumn StatusColumn {2492 get {2493 return this.columnStatus;2494 }2495 }2496 2497 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]2498 2493 public global::System.Data.DataColumn PermissionOwnerIdColumn { 2499 2494 get { … … 2506 2501 get { 2507 2502 return this.columnResourceId; 2503 } 2504 } 2505 2506 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2507 public global::System.Data.DataColumn JobStateColumn { 2508 get { 2509 return this.columnJobState; 2510 } 2511 } 2512 2513 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2514 public global::System.Data.DataColumn PercentageColumn { 2515 get { 2516 return this.columnPercentage; 2508 2517 } 2509 2518 } … … 2538 2547 2539 2548 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2540 public JobRow AddJobRow(long ParentJobId, string Status, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21) {2549 public JobRow AddJobRow(long ParentJobId, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21, string JobState, double Percentage) { 2541 2550 JobRow rowJobRow = ((JobRow)(this.NewRow())); 2542 2551 object[] columnValuesArray = new object[] { 2543 2552 null, 2544 2553 ParentJobId, 2545 Status,2546 2554 null, 2547 null}; 2555 null, 2556 JobState, 2557 Percentage}; 2548 2558 if ((parentHiveUserRowByR_35 != null)) { 2549 columnValuesArray[ 3] = parentHiveUserRowByR_35[0];2559 columnValuesArray[2] = parentHiveUserRowByR_35[0]; 2550 2560 } 2551 2561 if ((parentClientRowByR_21 != null)) { 2552 columnValuesArray[ 4] = parentClientRowByR_21[0];2562 columnValuesArray[3] = parentClientRowByR_21[0]; 2553 2563 } 2554 2564 rowJobRow.ItemArray = columnValuesArray; … … 2579 2589 this.columnJobId = base.Columns["JobId"]; 2580 2590 this.columnParentJobId = base.Columns["ParentJobId"]; 2581 this.columnStatus = base.Columns["Status"];2582 2591 this.columnPermissionOwnerId = base.Columns["PermissionOwnerId"]; 2583 2592 this.columnResourceId = base.Columns["ResourceId"]; 2593 this.columnJobState = base.Columns["JobState"]; 2594 this.columnPercentage = base.Columns["Percentage"]; 2584 2595 } 2585 2596 … … 2590 2601 this.columnParentJobId = new global::System.Data.DataColumn("ParentJobId", typeof(long), null, global::System.Data.MappingType.Element); 2591 2602 base.Columns.Add(this.columnParentJobId); 2592 this.columnStatus = new global::System.Data.DataColumn("Status", typeof(string), null, global::System.Data.MappingType.Element);2593 base.Columns.Add(this.columnStatus);2594 2603 this.columnPermissionOwnerId = new global::System.Data.DataColumn("PermissionOwnerId", typeof(long), null, global::System.Data.MappingType.Element); 2595 2604 base.Columns.Add(this.columnPermissionOwnerId); 2596 2605 this.columnResourceId = new global::System.Data.DataColumn("ResourceId", typeof(long), null, global::System.Data.MappingType.Element); 2597 2606 base.Columns.Add(this.columnResourceId); 2607 this.columnJobState = new global::System.Data.DataColumn("JobState", typeof(string), null, global::System.Data.MappingType.Element); 2608 base.Columns.Add(this.columnJobState); 2609 this.columnPercentage = new global::System.Data.DataColumn("Percentage", typeof(double), null, global::System.Data.MappingType.Element); 2610 base.Columns.Add(this.columnPercentage); 2598 2611 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { 2599 2612 this.columnJobId}, true)); … … 2604 2617 this.columnJobId.ReadOnly = true; 2605 2618 this.columnJobId.Unique = true; 2606 this.column Status.MaxLength = 18;2619 this.columnJobState.MaxLength = 18; 2607 2620 } 2608 2621 … … 2992 3005 private global::System.Data.DataColumn columnResourceId; 2993 3006 3007 private global::System.Data.DataColumn columnMessage; 3008 2994 3009 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2995 3010 public JobResultDataTable() { … … 3051 3066 3052 3067 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3068 public global::System.Data.DataColumn MessageColumn { 3069 get { 3070 return this.columnMessage; 3071 } 3072 } 3073 3074 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3053 3075 [global::System.ComponentModel.Browsable(false)] 3054 3076 public int Count { … … 3079 3101 3080 3102 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3081 public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId ) {3103 public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId, string Message) { 3082 3104 JobResultRow rowJobResultRow = ((JobResultRow)(this.NewRow())); 3083 3105 object[] columnValuesArray = new object[] { … … 3085 3107 null, 3086 3108 JobResult, 3087 ResourceId}; 3109 ResourceId, 3110 Message}; 3088 3111 if ((parentJobRowByR_14 != null)) { 3089 3112 columnValuesArray[1] = parentJobRowByR_14[0]; … … 3118 3141 this.columnJobResult = base.Columns["JobResult"]; 3119 3142 this.columnResourceId = base.Columns["ResourceId"]; 3143 this.columnMessage = base.Columns["Message"]; 3120 3144 } 3121 3145 … … 3130 3154 this.columnResourceId = new global::System.Data.DataColumn("ResourceId", typeof(long), null, global::System.Data.MappingType.Element); 3131 3155 base.Columns.Add(this.columnResourceId); 3156 this.columnMessage = new global::System.Data.DataColumn("Message", typeof(string), null, global::System.Data.MappingType.Element); 3157 base.Columns.Add(this.columnMessage); 3132 3158 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { 3133 3159 this.columnJobResultId}, true)); … … 3138 3164 this.columnJobResultId.ReadOnly = true; 3139 3165 this.columnJobResultId.Unique = true; 3166 this.columnMessage.MaxLength = 2147483647; 3140 3167 } 3141 3168 … … 3890 3917 3891 3918 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3892 public string Status {3893 get {3894 try {3895 return ((string)(this[this.tableJob.StatusColumn]));3896 }3897 catch (global::System.InvalidCastException e) {3898 throw new global::System.Data.StrongTypingException("The value for column \'Status\' in table \'Job\' is DBNull.", e);3899 }3900 }3901 set {3902 this[this.tableJob.StatusColumn] = value;3903 }3904 }3905 3906 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]3907 3919 public long PermissionOwnerId { 3908 3920 get { … … 3935 3947 3936 3948 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3949 public string JobState { 3950 get { 3951 try { 3952 return ((string)(this[this.tableJob.JobStateColumn])); 3953 } 3954 catch (global::System.InvalidCastException e) { 3955 throw new global::System.Data.StrongTypingException("The value for column \'JobState\' in table \'Job\' is DBNull.", e); 3956 } 3957 } 3958 set { 3959 this[this.tableJob.JobStateColumn] = value; 3960 } 3961 } 3962 3963 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3964 public double Percentage { 3965 get { 3966 try { 3967 return ((double)(this[this.tableJob.PercentageColumn])); 3968 } 3969 catch (global::System.InvalidCastException e) { 3970 throw new global::System.Data.StrongTypingException("The value for column \'Percentage\' in table \'Job\' is DBNull.", e); 3971 } 3972 } 3973 set { 3974 this[this.tableJob.PercentageColumn] = value; 3975 } 3976 } 3977 3978 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3937 3979 public ClientRow ClientRow { 3938 3980 get { … … 3965 4007 3966 4008 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3967 public bool IsStatusNull() {3968 return this.IsNull(this.tableJob.StatusColumn);3969 }3970 3971 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]3972 public void SetStatusNull() {3973 this[this.tableJob.StatusColumn] = global::System.Convert.DBNull;3974 }3975 3976 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]3977 4009 public bool IsPermissionOwnerIdNull() { 3978 4010 return this.IsNull(this.tableJob.PermissionOwnerIdColumn); … … 3992 4024 public void SetResourceIdNull() { 3993 4025 this[this.tableJob.ResourceIdColumn] = global::System.Convert.DBNull; 4026 } 4027 4028 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4029 public bool IsJobStateNull() { 4030 return this.IsNull(this.tableJob.JobStateColumn); 4031 } 4032 4033 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4034 public void SetJobStateNull() { 4035 this[this.tableJob.JobStateColumn] = global::System.Convert.DBNull; 4036 } 4037 4038 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4039 public bool IsPercentageNull() { 4040 return this.IsNull(this.tableJob.PercentageColumn); 4041 } 4042 4043 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4044 public void SetPercentageNull() { 4045 this[this.tableJob.PercentageColumn] = global::System.Convert.DBNull; 3994 4046 } 3995 4047 … … 4130 4182 4131 4183 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4184 public string Message { 4185 get { 4186 try { 4187 return ((string)(this[this.tableJobResult.MessageColumn])); 4188 } 4189 catch (global::System.InvalidCastException e) { 4190 throw new global::System.Data.StrongTypingException("The value for column \'Message\' in table \'JobResult\' is DBNull.", e); 4191 } 4192 } 4193 set { 4194 this[this.tableJobResult.MessageColumn] = value; 4195 } 4196 } 4197 4198 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4132 4199 public JobRow JobRow { 4133 4200 get { … … 4167 4234 public void SetResourceIdNull() { 4168 4235 this[this.tableJobResult.ResourceIdColumn] = global::System.Convert.DBNull; 4236 } 4237 4238 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4239 public bool IsMessageNull() { 4240 return this.IsNull(this.tableJobResult.MessageColumn); 4241 } 4242 4243 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4244 public void SetMessageNull() { 4245 this[this.tableJobResult.MessageColumn] = global::System.Convert.DBNull; 4169 4246 } 4170 4247 } … … 7399 7476 tableMapping.ColumnMappings.Add("JobId", "JobId"); 7400 7477 tableMapping.ColumnMappings.Add("ParentJobId", "ParentJobId"); 7401 tableMapping.ColumnMappings.Add("Status", "Status");7402 7478 tableMapping.ColumnMappings.Add("PermissionOwnerId", "PermissionOwnerId"); 7403 7479 tableMapping.ColumnMappings.Add("ResourceId", "ResourceId"); 7480 tableMapping.ColumnMappings.Add("JobState", "JobState"); 7481 tableMapping.ColumnMappings.Add("Percentage", "Percentage"); 7404 7482 this._adapter.TableMappings.Add(tableMapping); 7405 7483 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand(); 7406 7484 this._adapter.DeleteCommand.Connection = this.Connection; 7407 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [ dbo].[Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))";7485 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))"; 7408 7486 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; 7409 7487 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7410 7488 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ParentJobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7411 7489 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7412 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ Status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));7413 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));7490 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobState", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7491 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7414 7492 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PermissionOwnerId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7415 7493 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); … … 7418 7496 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand(); 7419 7497 this._adapter.InsertCommand.Connection = this.Connection; 7420 this._adapter.InsertCommand.CommandText = @"INSERT INTO [ dbo].[Job] ([ParentJobId], [Status], [PermissionOwnerId], [ResourceId]) VALUES (@ParentJobId, @Status, @PermissionOwnerId, @ResourceId);7421 SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = SCOPE_IDENTITY())";7498 this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId]) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId); 7499 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = SCOPE_IDENTITY())"; 7422 7500 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; 7423 7501 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7424 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));7502 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7425 7503 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7426 7504 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7427 7505 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand(); 7428 7506 this._adapter.UpdateCommand.Connection = this.Connection; 7429 this._adapter.UpdateCommand.CommandText = @"UPDATE [ dbo].[Job] SET [ParentJobId] = @ParentJobId, [Status] = @Status, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));7430 SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = @JobId)";7507 this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))); 7508 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = @JobId)"; 7431 7509 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; 7432 7510 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7433 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));7511 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7434 7512 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7435 7513 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); … … 7437 7515 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ParentJobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7438 7516 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7439 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ Status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));7440 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));7517 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobState", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7518 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7441 7519 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PermissionOwnerId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7442 7520 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); … … 7457 7535 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 7458 7536 this._commandCollection[0].Connection = this.Connection; 7459 this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM dbo.Job";7537 this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job"; 7460 7538 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; 7461 7539 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 7462 7540 this._commandCollection[1].Connection = this.Connection; 7463 this._commandCollection[1].CommandText = "SELECT * FROM dbo.Job WHERE Status <> \'offline\'"; 7541 this._commandCollection[1].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7542 " (JobState <> \'offline\')"; 7464 7543 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 7465 7544 this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand(); 7466 7545 this._commandCollection[2].Connection = this.Connection; 7467 this._commandCollection[2].CommandText = "SELECT * FROM dbo.Job WHERE ResourceId = @ResourceId"; 7546 this._commandCollection[2].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7547 " (ResourceId = @ResourceId)"; 7468 7548 this._commandCollection[2].CommandType = global::System.Data.CommandType.Text; 7469 7549 this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7470 7550 this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand(); 7471 7551 this._commandCollection[3].Connection = this.Connection; 7472 this._commandCollection[3].CommandText = "SELECT * FROM dbo.Job WHERE JobId = @Id"; 7552 this._commandCollection[3].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7553 " (JobId = @Id)"; 7473 7554 this._commandCollection[3].CommandType = global::System.Data.CommandType.Text; 7474 7555 this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7475 7556 this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand(); 7476 7557 this._commandCollection[4].Connection = this.Connection; 7477 this._commandCollection[4].CommandText = "SELECT * FROM dbo.Job WHERE Status = @State"; 7558 this._commandCollection[4].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7559 " (JobState = @State)"; 7478 7560 this._commandCollection[4].CommandType = global::System.Data.CommandType.Text; 7479 this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, " Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));7561 this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7480 7562 this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand(); 7481 7563 this._commandCollection[5].Connection = this.Connection; 7482 this._commandCollection[5].CommandText = "SELECT * FROM dbo.Job WHERE ParentJobId = @Id"; 7564 this._commandCollection[5].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7565 " (ParentJobId = @Id)"; 7483 7566 this._commandCollection[5].CommandType = global::System.Data.CommandType.Text; 7484 7567 this._commandCollection[5].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7485 7568 this._commandCollection[6] = new global::System.Data.SqlClient.SqlCommand(); 7486 7569 this._commandCollection[6].Connection = this.Connection; 7487 this._commandCollection[6].CommandText = "SELECT * FROM dbo.Job WHERE PermissionOwnerId = @PermissionOwnerId "; 7570 this._commandCollection[6].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" + 7571 " (PermissionOwnerId = @PermissionOwnerId)"; 7488 7572 this._commandCollection[6].CommandType = global::System.Data.CommandType.Text; 7489 7573 this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); … … 7722 7806 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7723 7807 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)] 7724 public virtual int Delete(long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_ Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {7808 public virtual int Delete(long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) { 7725 7809 this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobId)); 7726 7810 if ((Original_ParentJobId.HasValue == true)) { … … 7732 7816 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value; 7733 7817 } 7734 if ((Original_ Status== null)) {7818 if ((Original_JobState == null)) { 7735 7819 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1)); 7736 7820 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value; … … 7738 7822 else { 7739 7823 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0)); 7740 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_ Status));7824 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_JobState)); 7741 7825 } 7742 7826 if ((Original_PermissionOwnerId.HasValue == true)) { … … 7775 7859 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7776 7860 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] 7777 public virtual int Insert(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId) {7861 public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId) { 7778 7862 if ((ParentJobId.HasValue == true)) { 7779 7863 this.Adapter.InsertCommand.Parameters[0].Value = ((long)(ParentJobId.Value)); … … 7782 7866 this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value; 7783 7867 } 7784 if (( Status== null)) {7868 if ((JobState == null)) { 7785 7869 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value; 7786 7870 } 7787 7871 else { 7788 this.Adapter.InsertCommand.Parameters[1].Value = ((string)( Status));7872 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(JobState)); 7789 7873 } 7790 7874 if ((PermissionOwnerId.HasValue == true)) { … … 7819 7903 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7820 7904 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 7821 public virtual int Update(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, long JobId) {7905 public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, long JobId) { 7822 7906 if ((ParentJobId.HasValue == true)) { 7823 7907 this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(ParentJobId.Value)); … … 7826 7910 this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value; 7827 7911 } 7828 if (( Status== null)) {7912 if ((JobState == null)) { 7829 7913 this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value; 7830 7914 } 7831 7915 else { 7832 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)( Status));7916 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(JobState)); 7833 7917 } 7834 7918 if ((PermissionOwnerId.HasValue == true)) { … … 7853 7937 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value; 7854 7938 } 7855 if ((Original_ Status== null)) {7939 if ((Original_JobState == null)) { 7856 7940 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1)); 7857 7941 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value; … … 7859 7943 else { 7860 7944 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0)); 7861 this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(Original_ Status));7945 this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(Original_JobState)); 7862 7946 } 7863 7947 if ((Original_PermissionOwnerId.HasValue == true)) { … … 7897 7981 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7898 7982 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 7899 public virtual int Update(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {7900 return this.Update(ParentJobId, Status, PermissionOwnerId, ResourceId, Original_JobId, Original_ParentJobId, Original_Status, Original_PermissionOwnerId, Original_ResourceId, Original_JobId);7983 public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) { 7984 return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_JobId); 7901 7985 } 7902 7986 } … … 8394 8478 tableMapping.ColumnMappings.Add("JobResult", "JobResult"); 8395 8479 tableMapping.ColumnMappings.Add("ResourceId", "ResourceId"); 8480 tableMapping.ColumnMappings.Add("Message", "Message"); 8396 8481 this._adapter.TableMappings.Add(tableMapping); 8397 8482 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand(); 8398 8483 this._adapter.DeleteCommand.Connection = this.Connection; 8399 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))"; 8484 this._adapter.DeleteCommand.CommandText = "DELETE FROM [JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsN" + 8485 "ull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull" + 8486 "_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceI" + 8487 "d)))"; 8400 8488 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; 8401 8489 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResultId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8402 8490 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8403 8491 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8404 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobResult", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));8405 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));8406 8492 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ResourceId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8407 8493 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8408 8494 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand(); 8409 8495 this._adapter.InsertCommand.Connection = this.Connection; 8410 this._adapter.InsertCommand.CommandText = "INSERT INTO [ dbo].[JobResult] ([JobId], [JobResult], [ResourceId]) VALUES (@JobId" +8411 " , @JobResult, @ResourceId);\r\nSELECT JobResultId, JobId, JobResult, ResourceId FR" +8412 " OM JobResult WHERE (JobResultId = SCOPE_IDENTITY())";8496 this._adapter.InsertCommand.CommandText = "INSERT INTO [JobResult] ([JobId], [JobResult], [ResourceId], [Message]) VALUES (@" + 8497 "JobId, @JobResult, @ResourceId, @Message);\r\nSELECT JobResultId, JobId, JobResult" + 8498 ", ResourceId, Message FROM JobResult WHERE (JobResultId = SCOPE_IDENTITY())"; 8413 8499 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; 8414 8500 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8415 8501 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8416 8502 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8503 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Message", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Message", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8417 8504 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand(); 8418 8505 this._adapter.UpdateCommand.Connection = this.Connection; 8419 this._adapter.UpdateCommand.CommandText = @"UPDATE [ dbo].[JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));8420 SELECT JobResultId, JobId, JobResult, ResourceId FROM JobResult WHERE (JobResultId = @JobResultId)";8506 this._adapter.UpdateCommand.CommandText = @"UPDATE [JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId, [Message] = @Message WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId))); 8507 SELECT JobResultId, JobId, JobResult, ResourceId, Message FROM JobResult WHERE (JobResultId = @JobResultId)"; 8421 8508 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; 8422 8509 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8423 8510 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8424 8511 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8512 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Message", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Message", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8425 8513 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResultId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8426 8514 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8427 8515 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8428 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobResult", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));8429 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));8430 8516 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ResourceId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8431 8517 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); … … 8444 8530 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 8445 8531 this._commandCollection[0].Connection = this.Connection; 8446 this._commandCollection[0].CommandText = "SELECT JobResultId, JobId, JobResult, ResourceId FROM dbo.JobResult"; 8532 this._commandCollection[0].CommandText = "SELECT JobResultId, JobId, JobResult, ResourceId, Message\r\nFROM JobRe" + 8533 "sult"; 8447 8534 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; 8448 8535 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 8449 8536 this._commandCollection[1].Connection = this.Connection; 8450 this._commandCollection[1].CommandText = "SELECT * FROM dbo.JobResult WHERE JobResultId = @Id"; 8537 this._commandCollection[1].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" + 8538 "obResultId = @Id)"; 8451 8539 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 8452 8540 this._commandCollection[1].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8453 8541 this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand(); 8454 8542 this._commandCollection[2].Connection = this.Connection; 8455 this._commandCollection[2].CommandText = "SELECT * FROM dbo.JobResult WHERE JobId = @JobId"; 8543 this._commandCollection[2].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" + 8544 "obId = @JobId)"; 8456 8545 this._commandCollection[2].CommandType = global::System.Data.CommandType.Text; 8457 8546 this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); … … 8566 8655 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8567 8656 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)] 8568 public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult,global::System.Nullable<long> Original_ResourceId) {8657 public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId) { 8569 8658 this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobResultId)); 8570 8659 if ((Original_JobId.HasValue == true)) { … … 8576 8665 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value; 8577 8666 } 8578 if ((Original_JobResult == null)) { 8667 if ((Original_ResourceId.HasValue == true)) { 8668 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0)); 8669 this.Adapter.DeleteCommand.Parameters[4].Value = ((long)(Original_ResourceId.Value)); 8670 } 8671 else { 8579 8672 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1)); 8580 8673 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value; 8581 }8582 else {8583 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));8584 this.Adapter.DeleteCommand.Parameters[4].Value = ((byte[])(Original_JobResult));8585 }8586 if ((Original_ResourceId.HasValue == true)) {8587 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));8588 this.Adapter.DeleteCommand.Parameters[6].Value = ((long)(Original_ResourceId.Value));8589 }8590 else {8591 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));8592 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;8593 8674 } 8594 8675 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State; … … 8611 8692 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8612 8693 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] 8613 public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId ) {8694 public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message) { 8614 8695 if ((JobId.HasValue == true)) { 8615 8696 this.Adapter.InsertCommand.Parameters[0].Value = ((long)(JobId.Value)); … … 8629 8710 else { 8630 8711 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value; 8712 } 8713 if ((Message == null)) { 8714 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value; 8715 } 8716 else { 8717 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Message)); 8631 8718 } 8632 8719 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State; … … 8649 8736 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8650 8737 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8651 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult, global::System.Nullable<long> Original_ResourceId, long JobResultId) {8738 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId, long JobResultId) { 8652 8739 if ((JobId.HasValue == true)) { 8653 8740 this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(JobId.Value)); … … 8668 8755 this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value; 8669 8756 } 8670 this.Adapter.UpdateCommand.Parameters[3].Value = ((long)(Original_JobResultId)); 8757 if ((Message == null)) { 8758 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value; 8759 } 8760 else { 8761 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Message)); 8762 } 8763 this.Adapter.UpdateCommand.Parameters[4].Value = ((long)(Original_JobResultId)); 8671 8764 if ((Original_JobId.HasValue == true)) { 8672 this.Adapter.UpdateCommand.Parameters[ 4].Value = ((object)(0));8673 this.Adapter.UpdateCommand.Parameters[ 5].Value = ((long)(Original_JobId.Value));8765 this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(0)); 8766 this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobId.Value)); 8674 8767 } 8675 8768 else { 8676 this.Adapter.UpdateCommand.Parameters[ 4].Value = ((object)(1));8677 this.Adapter.UpdateCommand.Parameters[ 5].Value = global::System.DBNull.Value;8678 } 8679 if ((Original_ JobResult == null)) {8680 this.Adapter.UpdateCommand.Parameters[ 6].Value = ((object)(1));8681 this.Adapter.UpdateCommand.Parameters[ 7].Value = global::System.DBNull.Value;8769 this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(1)); 8770 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value; 8771 } 8772 if ((Original_ResourceId.HasValue == true)) { 8773 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0)); 8774 this.Adapter.UpdateCommand.Parameters[8].Value = ((long)(Original_ResourceId.Value)); 8682 8775 } 8683 8776 else { 8684 this.Adapter.UpdateCommand.Parameters[6].Value = ((object)(0)); 8685 this.Adapter.UpdateCommand.Parameters[7].Value = ((byte[])(Original_JobResult)); 8686 } 8687 if ((Original_ResourceId.HasValue == true)) { 8688 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0)); 8689 this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(Original_ResourceId.Value)); 8690 } 8691 else { 8692 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1)); 8693 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value; 8694 } 8695 this.Adapter.UpdateCommand.Parameters[10].Value = ((long)(JobResultId)); 8777 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1)); 8778 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value; 8779 } 8780 this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(JobResultId)); 8696 8781 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State; 8697 8782 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open) … … 8713 8798 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8714 8799 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8715 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult, global::System.Nullable<long> Original_ResourceId) {8716 return this.Update(JobId, JobResult, ResourceId, Original_JobResultId, Original_JobId, Original_JobResult, Original_ResourceId, Original_JobResultId);8800 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId) { 8801 return this.Update(JobId, JobResult, ResourceId, Message, Original_JobResultId, Original_JobId, Original_ResourceId, Original_JobResultId); 8717 8802 } 8718 8803 }
Note: See TracChangeset
for help on using the changeset viewer.