Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
01/21/09 18:10:47 (16 years ago)
Author:
svonolfe
Message:

Improved caching mechanism, fixed small bug related to the job data table (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs

    r1120 r1165  
    75227522            this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
    75237523            this._adapter.DeleteCommand.Connection = this.Connection;
    7524             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)))";
     7524            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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)))";
    75257525            this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
    75267526            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, "", "", ""));
    … …  
    75337533            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, "", "", ""));
    75347534            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, "", "", ""));
     7535            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
     7536            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    75357537            this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
    75367538            this._adapter.InsertCommand.Connection = this.Connection;
    7537             this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId], [SerializedJob]) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId, @SerializedJob);
    7538 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob FROM Job WHERE (JobId = SCOPE_IDENTITY())";
     7539            this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId], [SerializedJob], [Percentage]) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId, @SerializedJob, @Percentage);
     7540SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage FROM Job WHERE (JobId = SCOPE_IDENTITY())";
    75397541            this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
    75407542            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, "", "", ""));
    … …  
    75437545            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, "", "", ""));
    75447546            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SerializedJob", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SerializedJob", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7547            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75457548            this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
    75467549            this._adapter.UpdateCommand.Connection = this.Connection;
    7547             this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId, [SerializedJob] = @SerializedJob 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)));
    7548 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob FROM Job WHERE (JobId = @JobId)";
     7550            this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId, [SerializedJob] = @SerializedJob, [Percentage] = @Percentage 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)));
     7551SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage FROM Job WHERE (JobId = @JobId)";
    75497552            this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
    75507553            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, "", "", ""));
    … …  
    75537556            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, "", "", ""));
    75547557            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SerializedJob", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SerializedJob", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7558            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75557559            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, "", "", ""));
    75567560            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, "", "", ""));
    … …  
    75627566            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, "", "", ""));
    75637567            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, "", "", ""));
     7568            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
     7569            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    75647570            this._adapter.UpdateCommand.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, "", "", ""));
    75657571        }
    … …  
    75777583            this._commandCollection[0].Connection = this.Connection;
    75787584            this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob" +
    7579                 " FROM Job";
     7585                ", Percentage FROM Job";
    75807586            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
    75817587            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    75827588            this._commandCollection[1].Connection = this.Connection;
    7583             this._commandCollection[1].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7584                 " FROM Job WHERE (JobState <> \'offline\')";
     7589            this._commandCollection[1].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7590                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobState = \'calculating\') OR\r\n   " +
     7591                "                   (JobState = \'idle\')";
    75857592            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    75867593            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
    75877594            this._commandCollection[2].Connection = this.Connection;
    7588             this._commandCollection[2].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7589                 " FROM Job WHERE (ResourceId = @ResourceId)";
     7595            this._commandCollection[2].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7596                "dJob, Percentage\r\nFROM         Job\r\nWHERE    (ResourceId = @ResourceId)";
    75907597            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
    75917598            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, "", "", ""));
    75927599            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
    75937600            this._commandCollection[3].Connection = this.Connection;
    7594             this._commandCollection[3].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7595                 " FROM Job WHERE (JobId = @Id)";
     7601            this._commandCollection[3].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7602                "dJob, Percentage\r\nFROM         Job\r\nWHERE    (JobId = @Id)";
    75967603            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
    75977604            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, "", "", ""));
    75987605            this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand();
    75997606            this._commandCollection[4].Connection = this.Connection;
    7600             this._commandCollection[4].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7601                 " FROM Job WHERE (JobState = @State)";
     7607            this._commandCollection[4].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7608                "dJob, Percentage\r\nFROM         Job\r\nWHERE    (JobState = @State)";
    76027609            this._commandCollection[4].CommandType = global::System.Data.CommandType.Text;
    76037610            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, "", "", ""));
    76047611            this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand();
    76057612            this._commandCollection[5].Connection = this.Connection;
    7606             this._commandCollection[5].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7607                 " FROM Job WHERE (ParentJobId = @Id)";
     7613            this._commandCollection[5].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7614                "dJob, Percentage\r\nFROM         Job\r\nWHERE    (ParentJobId = @Id)";
    76087615            this._commandCollection[5].CommandType = global::System.Data.CommandType.Text;
    76097616            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, "", "", ""));
    76107617            this._commandCollection[6] = new global::System.Data.SqlClient.SqlCommand();
    76117618            this._commandCollection[6].Connection = this.Connection;
    7612             this._commandCollection[6].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, SerializedJob" +
    7613                 " FROM Job WHERE (PermissionOwnerId = @PermissionOwnerId)";
     7619            this._commandCollection[6].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7620                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (PermissionOwnerId = @PermissionOw" +
     7621                "nerId)";
    76147622            this._commandCollection[6].CommandType = global::System.Data.CommandType.Text;
    76157623            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, "", "", ""));
    … …  
    78487856        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78497857        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
    7850         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) {
     7858        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, global::System.Nullable<double> Original_Percentage) {
    78517859            this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobId));
    78527860            if ((Original_ParentJobId.HasValue == true)) {
    … …  
    78827890                this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
    78837891            }
     7892            if ((Original_Percentage.HasValue == true)) {
     7893                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
     7894                this.Adapter.DeleteCommand.Parameters[10].Value = ((double)(Original_Percentage.Value));
     7895            }
     7896            else {
     7897                this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
     7898                this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
     7899            }
    78847900            global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
    78857901            if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
    … …  
    79017917        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    79027918        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
    7903         public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob) {
     7919        public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage) {
    79047920            if ((ParentJobId.HasValue == true)) {
    79057921                this.Adapter.InsertCommand.Parameters[0].Value = ((long)(ParentJobId.Value));
    … …  
    79317947            else {
    79327948                this.Adapter.InsertCommand.Parameters[4].Value = ((byte[])(SerializedJob));
     7949            }
     7950            if ((Percentage.HasValue == true)) {
     7951                this.Adapter.InsertCommand.Parameters[5].Value = ((double)(Percentage.Value));
     7952            }
     7953            else {
     7954                this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
    79337955            }
    79347956            global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
    … …  
    79517973        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    79527974        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    7953         public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, 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) {
     7975        public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage, long JobId) {
    79547976            if ((ParentJobId.HasValue == true)) {
    79557977                this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(ParentJobId.Value));
    … …  
    79828004                this.Adapter.UpdateCommand.Parameters[4].Value = ((byte[])(SerializedJob));
    79838005            }
    7984             this.Adapter.UpdateCommand.Parameters[5].Value = ((long)(Original_JobId));
     8006            if ((Percentage.HasValue == true)) {
     8007                this.Adapter.UpdateCommand.Parameters[5].Value = ((double)(Percentage.Value));
     8008            }
     8009            else {
     8010                this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
     8011            }
     8012            this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobId));
    79858013            if ((Original_ParentJobId.HasValue == true)) {
    7986                 this.Adapter.UpdateCommand.Parameters[6].Value = ((object)(0));
    7987                 this.Adapter.UpdateCommand.Parameters[7].Value = ((long)(Original_ParentJobId.Value));
     8014                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
     8015                this.Adapter.UpdateCommand.Parameters[8].Value = ((long)(Original_ParentJobId.Value));
    79888016            }
    79898017            else {
    7990                 this.Adapter.UpdateCommand.Parameters[6].Value = ((object)(1));
    7991                 this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
     8018                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
     8019                this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
    79928020            }
    79938021            if ((Original_JobState == null)) {
    7994                 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1));
    7995                 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
     8022                this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1));
     8023                this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
    79968024            }
    79978025            else {
    7998                 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0));
    7999                 this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(Original_JobState));
     8026                this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0));
     8027                this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(Original_JobState));
    80008028            }
    80018029            if ((Original_PermissionOwnerId.HasValue == true)) {
    8002                 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
    8003                 this.Adapter.UpdateCommand.Parameters[11].Value = ((long)(Original_PermissionOwnerId.Value));
     8030                this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0));
     8031                this.Adapter.UpdateCommand.Parameters[12].Value = ((long)(Original_PermissionOwnerId.Value));
    80048032            }
    80058033            else {
    8006                 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
    8007                 this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
     8034                this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1));
     8035                this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
    80088036            }
    80098037            if ((Original_ResourceId.HasValue == true)) {
    8010                 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
    8011                 this.Adapter.UpdateCommand.Parameters[13].Value = ((long)(Original_ResourceId.Value));
     8038                this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0));
     8039                this.Adapter.UpdateCommand.Parameters[14].Value = ((long)(Original_ResourceId.Value));
    80128040            }
    80138041            else {
    8014                 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
    8015                 this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
    8016             }
    8017             this.Adapter.UpdateCommand.Parameters[14].Value = ((long)(JobId));
     8042                this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1));
     8043                this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
     8044            }
     8045            if ((Original_Percentage.HasValue == true)) {
     8046                this.Adapter.UpdateCommand.Parameters[15].Value = ((object)(0));
     8047                this.Adapter.UpdateCommand.Parameters[16].Value = ((double)(Original_Percentage.Value));
     8048            }
     8049            else {
     8050                this.Adapter.UpdateCommand.Parameters[15].Value = ((object)(1));
     8051                this.Adapter.UpdateCommand.Parameters[16].Value = global::System.DBNull.Value;
     8052            }
     8053            this.Adapter.UpdateCommand.Parameters[17].Value = ((long)(JobId));
    80188054            global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
    80198055            if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
    … …  
    80358071        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    80368072        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    8037         public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {
    8038             return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_JobId);
     8073        public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage) {
     8074            return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_Percentage, Original_JobId);
    80398075        }
    80408076    }
Note: See TracChangeset for help on using the changeset viewer.