Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
06/04/09 15:35:17 (15 years ago)
Author:
svonolfe
Message:

Updated JobAdapter (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r1999 r2001  
    75167516        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    75177517        private void InitCommandCollection() {
    7518             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[11];
     7518            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[10];
    75197519            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    75207520            this._commandCollection[0].Connection = this.Connection;
    … …  
    75337533            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
    75347534            this._commandCollection[2].Connection = this.Connection;
    7535             this._commandCollection[2].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    7536                 "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7537                 "ROM Job WHERE (JobState = \'calculating\') OR (JobState = \'idle\')";
     7535            this._commandCollection[2].CommandText = @"SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE ((JobState = 'calculating')  OR (JobState = 'abort') OR (JobState = 'requestSnapshot ') OR (JobState = 'requestSnapshotSent')) AND (ResourceId = @ResourceId)";
    75387536            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     7537            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75397538            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
    75407539            this._commandCollection[3].Connection = this.Connection;
    7541             this._commandCollection[3].CommandText = @"SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE ((JobState = 'calculating')  OR (JobState = 'abort') OR (JobState = 'requestSnapshot ')) AND (ResourceId = @ResourceId)";
     7540            this._commandCollection[3].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
     7541                "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
     7542                "ROM Job WHERE (ResourceId = @ResourceId)";
    75427543            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
    75437544            this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    … …  
    75467547            this._commandCollection[4].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    75477548                "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7548                 "ROM Job WHERE (ResourceId = @ResourceId)";
     7549                "ROM Job WHERE (JobId = @Id)";
    75497550            this._commandCollection[4].CommandType = global::System.Data.CommandType.Text;
    7550             this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7551            this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75517552            this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand();
    75527553            this._commandCollection[5].Connection = this.Connection;
    … …  
    75607561            this._commandCollection[6].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    75617562                "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7562                 "ROM Job WHERE (JobId = @Id)";
     7563                "ROM Job WHERE (ParentJobId = @Id)";
    75637564            this._commandCollection[6].CommandType = global::System.Data.CommandType.Text;
    7564             this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7565            this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75657566            this._commandCollection[7] = new global::System.Data.SqlClient.SqlCommand();
    75667567            this._commandCollection[7].Connection = this.Connection;
    7567             this._commandCollection[7].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    7568                 "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7569                 "ROM Job WHERE (ParentJobId = @Id)";
     7568            this._commandCollection[7].CommandText = "SELECT * FROM dbo.Job WHERE ProjectId = @ProjectId";
    75707569            this._commandCollection[7].CommandType = global::System.Data.CommandType.Text;
    7571             this._commandCollection[7].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7570            this._commandCollection[7].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ProjectId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ProjectId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75727571            this._commandCollection[8] = new global::System.Data.SqlClient.SqlCommand();
    75737572            this._commandCollection[8].Connection = this.Connection;
    7574             this._commandCollection[8].CommandText = "SELECT * FROM dbo.Job WHERE ProjectId = @ProjectId";
     7573            this._commandCollection[8].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
     7574                "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
     7575                "ROM Job WHERE (JobState = @State)";
    75757576            this._commandCollection[8].CommandType = global::System.Data.CommandType.Text;
    7576             this._commandCollection[8].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ProjectId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "ProjectId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7577            this._commandCollection[8].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, "", "", ""));
    75777578            this._commandCollection[9] = new global::System.Data.SqlClient.SqlCommand();
    75787579            this._commandCollection[9].Connection = this.Connection;
    75797580            this._commandCollection[9].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    75807581                "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7581                 "ROM Job WHERE (JobState = @State)";
     7582                "ROM Job WHERE (UserId = @UserId)";
    75827583            this._commandCollection[9].CommandType = global::System.Data.CommandType.Text;
    7583             this._commandCollection[9].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, "", "", ""));
    7584             this._commandCollection[10] = new global::System.Data.SqlClient.SqlCommand();
    7585             this._commandCollection[10].Connection = this.Connection;
    7586             this._commandCollection[10].CommandText = "SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, P" +
    7587                 "arentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId F" +
    7588                 "ROM Job WHERE (UserId = @UserId)";
    7589             this._commandCollection[10].CommandType = global::System.Data.CommandType.Text;
    7590             this._commandCollection[10].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@UserId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "UserId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7584            this._commandCollection[9].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@UserId", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "UserId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    75917585        }
    75927586       
    … …  
    76747668        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    76757669        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7676         public virtual int FillByActive(dsHiveServer.JobDataTable dataTable) {
     7670        public virtual int FillByCalculatingClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ResourceId) {
    76777671            this.Adapter.SelectCommand = this.CommandCollection[2];
     7672            if ((ResourceId.HasValue == true)) {
     7673                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ResourceId.Value));
     7674            }
     7675            else {
     7676                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7677            }
    76787678            if ((this.ClearBeforeFill == true)) {
    76797679                dataTable.Clear();
    … …  
    76867686        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    76877687        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7688         public virtual dsHiveServer.JobDataTable GetDataByActive() {
     7688        public virtual dsHiveServer.JobDataTable GetDataByCalculatingClient(global::System.Nullable<global::System.Guid> ResourceId) {
    76897689            this.Adapter.SelectCommand = this.CommandCollection[2];
     7690            if ((ResourceId.HasValue == true)) {
     7691                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ResourceId.Value));
     7692            }
     7693            else {
     7694                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7695            }
    76907696            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    76917697            this.Adapter.Fill(dataTable);
    … …  
    76967702        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    76977703        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7698         public virtual int FillByCalculatingClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ResourceId) {
     7704        public virtual int FillByClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ResourceId) {
    76997705            this.Adapter.SelectCommand = this.CommandCollection[3];
    77007706            if ((ResourceId.HasValue == true)) {
    … …  
    77147720        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77157721        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7716         public virtual dsHiveServer.JobDataTable GetDataByCalculatingClient(global::System.Nullable<global::System.Guid> ResourceId) {
     7722        public virtual dsHiveServer.JobDataTable GetDataByClient(global::System.Nullable<global::System.Guid> ResourceId) {
    77177723            this.Adapter.SelectCommand = this.CommandCollection[3];
    77187724            if ((ResourceId.HasValue == true)) {
    … …  
    77307736        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77317737        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7732         public virtual int FillByClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ResourceId) {
     7738        public virtual int FillById(dsHiveServer.JobDataTable dataTable, System.Guid Id) {
    77337739            this.Adapter.SelectCommand = this.CommandCollection[4];
    7734             if ((ResourceId.HasValue == true)) {
    7735                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ResourceId.Value));
    7736             }
    7737             else {
    7738                 this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    7739             }
     7740            this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
    77407741            if ((this.ClearBeforeFill == true)) {
    77417742                dataTable.Clear();
    … …  
    77487749        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77497750        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7750         public virtual dsHiveServer.JobDataTable GetDataByClient(global::System.Nullable<global::System.Guid> ResourceId) {
     7751        public virtual dsHiveServer.JobDataTable GetDataById(System.Guid Id) {
    77517752            this.Adapter.SelectCommand = this.CommandCollection[4];
    7752             if ((ResourceId.HasValue == true)) {
    7753                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ResourceId.Value));
    7754             }
    7755             else {
    7756                 this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    7757             }
     7753            this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
    77587754            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    77597755            this.Adapter.Fill(dataTable);
    … …  
    77647760        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77657761        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7766         public virtual int FillById(dsHiveServer.JobDataTable dataTable, System.Guid Id) {
     7762        public virtual int FillByJob(dsHiveServer.JobDataTable dataTable, System.Guid Id) {
    77677763            this.Adapter.SelectCommand = this.CommandCollection[5];
    77687764            this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
    … …  
    77777773        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77787774        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7779         public virtual dsHiveServer.JobDataTable GetDataById(System.Guid Id) {
     7775        public virtual dsHiveServer.JobDataTable GetDataByJob(System.Guid Id) {
    77807776            this.Adapter.SelectCommand = this.CommandCollection[5];
    77817777            this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
    … …  
    77887784        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77897785        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7790         public virtual int FillByJob(dsHiveServer.JobDataTable dataTable, System.Guid Id) {
     7786        public virtual int FillByParentJob(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> Id) {
    77917787            this.Adapter.SelectCommand = this.CommandCollection[6];
    7792             this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
     7788            if ((Id.HasValue == true)) {
     7789                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id.Value));
     7790            }
     7791            else {
     7792                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7793            }
    77937794            if ((this.ClearBeforeFill == true)) {
    77947795                dataTable.Clear();
    … …  
    78017802        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78027803        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7803         public virtual dsHiveServer.JobDataTable GetDataByJob(System.Guid Id) {
     7804        public virtual dsHiveServer.JobDataTable GetDataByParentJob(global::System.Nullable<global::System.Guid> Id) {
    78047805            this.Adapter.SelectCommand = this.CommandCollection[6];
    7805             this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id));
     7806            if ((Id.HasValue == true)) {
     7807                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id.Value));
     7808            }
     7809            else {
     7810                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7811            }
    78067812            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    78077813            this.Adapter.Fill(dataTable);
    … …  
    78127818        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78137819        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7814         public virtual int FillByParentJob(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> Id) {
     7820        public virtual int FillByProjectId(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ProjectId) {
    78157821            this.Adapter.SelectCommand = this.CommandCollection[7];
    7816             if ((Id.HasValue == true)) {
    7817                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id.Value));
     7822            if ((ProjectId.HasValue == true)) {
     7823                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ProjectId.Value));
    78187824            }
    78197825            else {
    … …  
    78307836        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78317837        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7832         public virtual dsHiveServer.JobDataTable GetDataByParentJob(global::System.Nullable<global::System.Guid> Id) {
     7838        public virtual dsHiveServer.JobDataTable GetDataByProjectId(global::System.Nullable<global::System.Guid> ProjectId) {
    78337839            this.Adapter.SelectCommand = this.CommandCollection[7];
    7834             if ((Id.HasValue == true)) {
    7835                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(Id.Value));
     7840            if ((ProjectId.HasValue == true)) {
     7841                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ProjectId.Value));
    78367842            }
    78377843            else {
    … …  
    78467852        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78477853        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7848         public virtual int FillByProjectId(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> ProjectId) {
     7854        public virtual int FillByState(dsHiveServer.JobDataTable dataTable, string State) {
    78497855            this.Adapter.SelectCommand = this.CommandCollection[8];
    7850             if ((ProjectId.HasValue == true)) {
    7851                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ProjectId.Value));
    7852             }
    7853             else {
     7856            if ((State == null)) {
    78547857                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7858            }
     7859            else {
     7860                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(State));
    78557861            }
    78567862            if ((this.ClearBeforeFill == true)) {
    … …  
    78647870        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78657871        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7866         public virtual dsHiveServer.JobDataTable GetDataByProjectId(global::System.Nullable<global::System.Guid> ProjectId) {
     7872        public virtual dsHiveServer.JobDataTable GetDataByState(string State) {
    78677873            this.Adapter.SelectCommand = this.CommandCollection[8];
    7868             if ((ProjectId.HasValue == true)) {
    7869                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ProjectId.Value));
    7870             }
    7871             else {
     7874            if ((State == null)) {
    78727875                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7876            }
     7877            else {
     7878                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(State));
    78737879            }
    78747880            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    … …  
    78807886        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78817887        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7882         public virtual int FillByState(dsHiveServer.JobDataTable dataTable, string State) {
     7888        public virtual int FillByUser(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> UserId) {
    78837889            this.Adapter.SelectCommand = this.CommandCollection[9];
    7884             if ((State == null)) {
     7890            if ((UserId.HasValue == true)) {
     7891                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(UserId.Value));
     7892            }
     7893            else {
    78857894                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    7886             }
    7887             else {
    7888                 this.Adapter.SelectCommand.Parameters[0].Value = ((string)(State));
    78897895            }
    78907896            if ((this.ClearBeforeFill == true)) {
    … …  
    78987904        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78997905        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7900         public virtual dsHiveServer.JobDataTable GetDataByState(string State) {
     7906        public virtual dsHiveServer.JobDataTable GetDataByUser(global::System.Nullable<global::System.Guid> UserId) {
    79017907            this.Adapter.SelectCommand = this.CommandCollection[9];
    7902             if ((State == null)) {
    7903                 this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    7904             }
    7905             else {
    7906                 this.Adapter.SelectCommand.Parameters[0].Value = ((string)(State));
    7907             }
    7908             dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    7909             this.Adapter.Fill(dataTable);
    7910             return dataTable;
    7911         }
    7912        
    7913         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    7914         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    7915         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7916         public virtual int FillByUser(dsHiveServer.JobDataTable dataTable, global::System.Nullable<global::System.Guid> UserId) {
    7917             this.Adapter.SelectCommand = this.CommandCollection[10];
    7918             if ((UserId.HasValue == true)) {
    7919                 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(UserId.Value));
    7920             }
    7921             else {
    7922                 this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    7923             }
    7924             if ((this.ClearBeforeFill == true)) {
    7925                 dataTable.Clear();
    7926             }
    7927             int returnValue = this.Adapter.Fill(dataTable);
    7928             return returnValue;
    7929         }
    7930        
    7931         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    7932         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    7933         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7934         public virtual dsHiveServer.JobDataTable GetDataByUser(global::System.Nullable<global::System.Guid> UserId) {
    7935             this.Adapter.SelectCommand = this.CommandCollection[10];
    79367908            if ((UserId.HasValue == true)) {
    79377909                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(UserId.Value));
Note: See TracChangeset for help on using the changeset viewer.