Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
12/16/08 17:26:43 (16 years ago)
Author:
svonolfe
Message:

Refactored DAL, Improved Caching (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r991 r995  
    41684168        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    41694169        private void InitCommandCollection() {
    4170             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2];
     4170            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4];
    41714171            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    41724172            this._commandCollection[0].Connection = this.Connection;
    … …  
    41754175            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    41764176            this._commandCollection[1].Connection = this.Connection;
    4177             this._commandCollection[1].CommandText = "SELECT * FROM dbo.Resource WHERE ResourceId = @ID";
     4177            this._commandCollection[1].CommandText = "SELECT Resource.* FROM \r\n  Resource INNER JOIN Client ON Resource.ResourceId = Cl" +
     4178                "ient.ResourceId\r\n  WHERE Client.Status <> \'offline\'";
    41784179            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    4179             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, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     4180            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     4181            this._commandCollection[2].Connection = this.Connection;
     4182            this._commandCollection[2].CommandText = "SELECT * FROM dbo.Resource WHERE ResourceId = @ID";
     4183            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     4184            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ID", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     4185            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
     4186            this._commandCollection[3].Connection = this.Connection;
     4187            this._commandCollection[3].CommandText = "SELECT * FROM dbo.Resource WHERE Name = @Name";
     4188            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
     4189            this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Name", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "Name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    41804190        }
    41814191       
    … …  
    42054215        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    42064216        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     4217        public virtual int FillByActive(dsHiveServer.ResourceDataTable dataTable) {
     4218            this.Adapter.SelectCommand = this.CommandCollection[1];
     4219            if ((this.ClearBeforeFill == true)) {
     4220                dataTable.Clear();
     4221            }
     4222            int returnValue = this.Adapter.Fill(dataTable);
     4223            return returnValue;
     4224        }
     4225       
     4226        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4227        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4228        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     4229        public virtual dsHiveServer.ResourceDataTable GetDataByActive() {
     4230            this.Adapter.SelectCommand = this.CommandCollection[1];
     4231            dsHiveServer.ResourceDataTable dataTable = new dsHiveServer.ResourceDataTable();
     4232            this.Adapter.Fill(dataTable);
     4233            return dataTable;
     4234        }
     4235       
     4236        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4237        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4238        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    42074239        public virtual int FillById(dsHiveServer.ResourceDataTable dataTable, long ID) {
    4208             this.Adapter.SelectCommand = this.CommandCollection[1];
     4240            this.Adapter.SelectCommand = this.CommandCollection[2];
    42094241            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ID));
    42104242            if ((this.ClearBeforeFill == true)) {
    … …  
    42194251        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    42204252        public virtual dsHiveServer.ResourceDataTable GetDataById(long ID) {
    4221             this.Adapter.SelectCommand = this.CommandCollection[1];
     4253            this.Adapter.SelectCommand = this.CommandCollection[2];
    42224254            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ID));
     4255            dsHiveServer.ResourceDataTable dataTable = new dsHiveServer.ResourceDataTable();
     4256            this.Adapter.Fill(dataTable);
     4257            return dataTable;
     4258        }
     4259       
     4260        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4261        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4262        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     4263        public virtual int FillByName(dsHiveServer.ResourceDataTable dataTable, string Name) {
     4264            this.Adapter.SelectCommand = this.CommandCollection[3];
     4265            if ((Name == null)) {
     4266                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     4267            }
     4268            else {
     4269                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     4270            }
     4271            if ((this.ClearBeforeFill == true)) {
     4272                dataTable.Clear();
     4273            }
     4274            int returnValue = this.Adapter.Fill(dataTable);
     4275            return returnValue;
     4276        }
     4277       
     4278        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4279        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4280        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     4281        public virtual dsHiveServer.ResourceDataTable GetDataByName(string Name) {
     4282            this.Adapter.SelectCommand = this.CommandCollection[3];
     4283            if ((Name == null)) {
     4284                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     4285            }
     4286            else {
     4287                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     4288            }
    42234289            dsHiveServer.ResourceDataTable dataTable = new dsHiveServer.ResourceDataTable();
    42244290            this.Adapter.Fill(dataTable);
    … …  
    45444610        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    45454611        private void InitCommandCollection() {
    4546             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2];
     4612            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4];
    45474613            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    45484614            this._commandCollection[0].Connection = this.Connection;
    … …  
    45524618            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    45534619            this._commandCollection[1].Connection = this.Connection;
    4554             this._commandCollection[1].CommandText = "SELECT * FROM dbo.Client WHERE GUID = @ID";
     4620            this._commandCollection[1].CommandText = "SELECT * FROM dbo.Client WHERE Status <> \'offline\'";
    45554621            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    4556             this._commandCollection[1].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ID", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "GUID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     4622            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     4623            this._commandCollection[2].Connection = this.Connection;
     4624            this._commandCollection[2].CommandText = "SELECT * FROM dbo.Client WHERE GUID = @ID";
     4625            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     4626            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ID", global::System.Data.SqlDbType.UniqueIdentifier, 16, global::System.Data.ParameterDirection.Input, 0, 0, "GUID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     4627            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
     4628            this._commandCollection[3].Connection = this.Connection;
     4629            this._commandCollection[3].CommandText = "SELECT * FROM dbo.Client WHERE ResourceId = @Id";
     4630            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
     4631            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, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    45574632        }
    45584633       
    … …  
    45824657        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    45834658        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     4659        public virtual int FillByActive(dsHiveServer.ClientDataTable dataTable) {
     4660            this.Adapter.SelectCommand = this.CommandCollection[1];
     4661            if ((this.ClearBeforeFill == true)) {
     4662                dataTable.Clear();
     4663            }
     4664            int returnValue = this.Adapter.Fill(dataTable);
     4665            return returnValue;
     4666        }
     4667       
     4668        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4669        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4670        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     4671        public virtual dsHiveServer.ClientDataTable GetDataByActive() {
     4672            this.Adapter.SelectCommand = this.CommandCollection[1];
     4673            dsHiveServer.ClientDataTable dataTable = new dsHiveServer.ClientDataTable();
     4674            this.Adapter.Fill(dataTable);
     4675            return dataTable;
     4676        }
     4677       
     4678        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4679        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4680        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    45844681        public virtual int FillById(dsHiveServer.ClientDataTable dataTable, global::System.Nullable<global::System.Guid> ID) {
    4585             this.Adapter.SelectCommand = this.CommandCollection[1];
     4682            this.Adapter.SelectCommand = this.CommandCollection[2];
    45864683            if ((ID.HasValue == true)) {
    45874684                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ID.Value));
    … …  
    46014698        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    46024699        public virtual dsHiveServer.ClientDataTable GetDataById(global::System.Nullable<global::System.Guid> ID) {
    4603             this.Adapter.SelectCommand = this.CommandCollection[1];
     4700            this.Adapter.SelectCommand = this.CommandCollection[2];
    46044701            if ((ID.HasValue == true)) {
    46054702                this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ID.Value));
    … …  
    46084705                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    46094706            }
     4707            dsHiveServer.ClientDataTable dataTable = new dsHiveServer.ClientDataTable();
     4708            this.Adapter.Fill(dataTable);
     4709            return dataTable;
     4710        }
     4711       
     4712        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4713        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4714        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     4715        public virtual int FillByResourceId(dsHiveServer.ClientDataTable dataTable, long Id) {
     4716            this.Adapter.SelectCommand = this.CommandCollection[3];
     4717            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     4718            if ((this.ClearBeforeFill == true)) {
     4719                dataTable.Clear();
     4720            }
     4721            int returnValue = this.Adapter.Fill(dataTable);
     4722            return returnValue;
     4723        }
     4724       
     4725        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4726        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     4727        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     4728        public virtual dsHiveServer.ClientDataTable GetDataByResourceId(long Id) {
     4729            this.Adapter.SelectCommand = this.CommandCollection[3];
     4730            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
    46104731            dsHiveServer.ClientDataTable dataTable = new dsHiveServer.ClientDataTable();
    46114732            this.Adapter.Fill(dataTable);
    … …  
    54545575        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    54555576        private void InitCommandCollection() {
    5456             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2];
     5577            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[3];
    54575578            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    54585579            this._commandCollection[0].Connection = this.Connection;
    … …  
    54645585            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    54655586            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, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     5587            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     5588            this._commandCollection[2].Connection = this.Connection;
     5589            this._commandCollection[2].CommandText = "SELECT * FROM dbo.PermissionOwner WHERE Name = @Name";
     5590            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     5591            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Name", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "Name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    54665592        }
    54675593       
    … …  
    55075633            this.Adapter.SelectCommand = this.CommandCollection[1];
    55085634            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     5635            dsHiveServer.PermissionOwnerDataTable dataTable = new dsHiveServer.PermissionOwnerDataTable();
     5636            this.Adapter.Fill(dataTable);
     5637            return dataTable;
     5638        }
     5639       
     5640        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     5641        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     5642        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     5643        public virtual int FillByName(dsHiveServer.PermissionOwnerDataTable dataTable, string Name) {
     5644            this.Adapter.SelectCommand = this.CommandCollection[2];
     5645            if ((Name == null)) {
     5646                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     5647            }
     5648            else {
     5649                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     5650            }
     5651            if ((this.ClearBeforeFill == true)) {
     5652                dataTable.Clear();
     5653            }
     5654            int returnValue = this.Adapter.Fill(dataTable);
     5655            return returnValue;
     5656        }
     5657       
     5658        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     5659        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     5660        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     5661        public virtual dsHiveServer.PermissionOwnerDataTable GetDataByName(string Name) {
     5662            this.Adapter.SelectCommand = this.CommandCollection[2];
     5663            if ((Name == null)) {
     5664                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     5665            }
     5666            else {
     5667                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     5668            }
    55095669            dsHiveServer.PermissionOwnerDataTable dataTable = new dsHiveServer.PermissionOwnerDataTable();
    55105670            this.Adapter.Fill(dataTable);
    … …  
    57845944        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    57855945        private void InitCommandCollection() {
    5786             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
     5946            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[3];
    57875947            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    57885948            this._commandCollection[0].Connection = this.Connection;
    57895949            this._commandCollection[0].CommandText = "SELECT PermissionOwnerId FROM dbo.UserGroup";
    57905950            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
     5951            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
     5952            this._commandCollection[1].Connection = this.Connection;
     5953            this._commandCollection[1].CommandText = "SELECT * FROM dbo.UserGroup WHERE PermissionOwnerId  = @Id";
     5954            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
     5955            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, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     5956            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     5957            this._commandCollection[2].Connection = this.Connection;
     5958            this._commandCollection[2].CommandText = "SELECT     UserGroup.*\r\nFROM         UserGroup INNER JOIN\r\n                   Per" +
     5959                "missionOwner ON UserGroup.PermissionOwnerId = PermissionOwner.PermissionOwnerId\r" +
     5960                "\nWHERE     (PermissionOwner.Name = @Name)";
     5961            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     5962            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Name", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "Name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    57915963        }
    57925964       
    … …  
    58085980        public virtual dsHiveServer.UserGroupDataTable GetData() {
    58095981            this.Adapter.SelectCommand = this.CommandCollection[0];
     5982            dsHiveServer.UserGroupDataTable dataTable = new dsHiveServer.UserGroupDataTable();
     5983            this.Adapter.Fill(dataTable);
     5984            return dataTable;
     5985        }
     5986       
     5987        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     5988        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     5989        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     5990        public virtual int FillById(dsHiveServer.UserGroupDataTable dataTable, long Id) {
     5991            this.Adapter.SelectCommand = this.CommandCollection[1];
     5992            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     5993            if ((this.ClearBeforeFill == true)) {
     5994                dataTable.Clear();
     5995            }
     5996            int returnValue = this.Adapter.Fill(dataTable);
     5997            return returnValue;
     5998        }
     5999       
     6000        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6001        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6002        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     6003        public virtual dsHiveServer.UserGroupDataTable GetDataById(long Id) {
     6004            this.Adapter.SelectCommand = this.CommandCollection[1];
     6005            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     6006            dsHiveServer.UserGroupDataTable dataTable = new dsHiveServer.UserGroupDataTable();
     6007            this.Adapter.Fill(dataTable);
     6008            return dataTable;
     6009        }
     6010       
     6011        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6012        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6013        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     6014        public virtual int FillByName(dsHiveServer.UserGroupDataTable dataTable, string Name) {
     6015            this.Adapter.SelectCommand = this.CommandCollection[2];
     6016            if ((Name == null)) {
     6017                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     6018            }
     6019            else {
     6020                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     6021            }
     6022            if ((this.ClearBeforeFill == true)) {
     6023                dataTable.Clear();
     6024            }
     6025            int returnValue = this.Adapter.Fill(dataTable);
     6026            return returnValue;
     6027        }
     6028       
     6029        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6030        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6031        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     6032        public virtual dsHiveServer.UserGroupDataTable GetDataByName(string Name) {
     6033            this.Adapter.SelectCommand = this.CommandCollection[2];
     6034            if ((Name == null)) {
     6035                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     6036            }
     6037            else {
     6038                this.Adapter.SelectCommand.Parameters[0].Value = ((string)(Name));
     6039            }
    58106040            dsHiveServer.UserGroupDataTable dataTable = new dsHiveServer.UserGroupDataTable();
    58116041            this.Adapter.Fill(dataTable);
    … …  
    60616291        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    60626292        private void InitCommandCollection() {
    6063             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2];
     6293            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4];
    60646294            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    60656295            this._commandCollection[0].Connection = this.Connection;
    … …  
    60686298            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    60696299            this._commandCollection[1].Connection = this.Connection;
    6070             this._commandCollection[1].CommandText = "SELECT * FROM dbo.PermissionOwner_UserGroup WHERE UserGroupId = @UserGroupId";
     6300            this._commandCollection[1].CommandText = "SELECT * FROM dbo.PermissionOwner_UserGroup WHERE PermissionOwnerId = @Id";
    60716301            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    6072             this._commandCollection[1].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@UserGroupId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "UserGroupId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     6302            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, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     6303            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     6304            this._commandCollection[2].Connection = this.Connection;
     6305            this._commandCollection[2].CommandText = "SELECT * FROM dbo.PermissionOwner_UserGroup WHERE PermissionOwnerId = @Permission" +
     6306                "OwnerId AND UserGroupId = @UserGroupId";
     6307            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     6308            this._commandCollection[2].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, "", "", ""));
     6309            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@UserGroupId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "UserGroupId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     6310            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
     6311            this._commandCollection[3].Connection = this.Connection;
     6312            this._commandCollection[3].CommandText = "SELECT * FROM dbo.PermissionOwner_UserGroup WHERE UserGroupId = @UserGroupId";
     6313            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
     6314            this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@UserGroupId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "UserGroupId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    60736315        }
    60746316       
    … …  
    60986340        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    60996341        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     6342        public virtual int FillByPermissionOwnerId(dsHiveServer.PermissionOwner_UserGroupDataTable dataTable, long Id) {
     6343            this.Adapter.SelectCommand = this.CommandCollection[1];
     6344            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     6345            if ((this.ClearBeforeFill == true)) {
     6346                dataTable.Clear();
     6347            }
     6348            int returnValue = this.Adapter.Fill(dataTable);
     6349            return returnValue;
     6350        }
     6351       
     6352        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6353        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6354        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     6355        public virtual dsHiveServer.PermissionOwner_UserGroupDataTable GetDataByPermissionOwnerId(long Id) {
     6356            this.Adapter.SelectCommand = this.CommandCollection[1];
     6357            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     6358            dsHiveServer.PermissionOwner_UserGroupDataTable dataTable = new dsHiveServer.PermissionOwner_UserGroupDataTable();
     6359            this.Adapter.Fill(dataTable);
     6360            return dataTable;
     6361        }
     6362       
     6363        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6364        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6365        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     6366        public virtual int FillByPermownerUsergroupId(dsHiveServer.PermissionOwner_UserGroupDataTable dataTable, long PermissionOwnerId, long UserGroupId) {
     6367            this.Adapter.SelectCommand = this.CommandCollection[2];
     6368            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId));
     6369            this.Adapter.SelectCommand.Parameters[1].Value = ((long)(UserGroupId));
     6370            if ((this.ClearBeforeFill == true)) {
     6371                dataTable.Clear();
     6372            }
     6373            int returnValue = this.Adapter.Fill(dataTable);
     6374            return returnValue;
     6375        }
     6376       
     6377        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6378        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6379        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     6380        public virtual dsHiveServer.PermissionOwner_UserGroupDataTable GetDataByPermownerUsergroupId(long PermissionOwnerId, long UserGroupId) {
     6381            this.Adapter.SelectCommand = this.CommandCollection[2];
     6382            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId));
     6383            this.Adapter.SelectCommand.Parameters[1].Value = ((long)(UserGroupId));
     6384            dsHiveServer.PermissionOwner_UserGroupDataTable dataTable = new dsHiveServer.PermissionOwner_UserGroupDataTable();
     6385            this.Adapter.Fill(dataTable);
     6386            return dataTable;
     6387        }
     6388       
     6389        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6390        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6391        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    61006392        public virtual int FillByUserGroupId(dsHiveServer.PermissionOwner_UserGroupDataTable dataTable, long UserGroupId) {
    6101             this.Adapter.SelectCommand = this.CommandCollection[1];
     6393            this.Adapter.SelectCommand = this.CommandCollection[3];
    61026394            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(UserGroupId));
    61036395            if ((this.ClearBeforeFill == true)) {
    … …  
    61126404        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    61136405        public virtual dsHiveServer.PermissionOwner_UserGroupDataTable GetDataByUserGroupId(long UserGroupId) {
    6114             this.Adapter.SelectCommand = this.CommandCollection[1];
     6406            this.Adapter.SelectCommand = this.CommandCollection[3];
    61156407            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(UserGroupId));
    61166408            dsHiveServer.PermissionOwner_UserGroupDataTable dataTable = new dsHiveServer.PermissionOwner_UserGroupDataTable();
    … …  
    63666658        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    63676659        private void InitCommandCollection() {
    6368             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
     6660            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2];
    63696661            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    63706662            this._commandCollection[0].Connection = this.Connection;
    63716663            this._commandCollection[0].CommandText = "SELECT ResourceId FROM dbo.ClientGroup";
    63726664            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
     6665            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
     6666            this._commandCollection[1].Connection = this.Connection;
     6667            this._commandCollection[1].CommandText = "SELECT * FROM dbo.ClientGroup WHERE ResourceId = @Id";
     6668            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
     6669            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, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    63736670        }
    63746671       
    … …  
    63906687        public virtual dsHiveServer.ClientGroupDataTable GetData() {
    63916688            this.Adapter.SelectCommand = this.CommandCollection[0];
     6689            dsHiveServer.ClientGroupDataTable dataTable = new dsHiveServer.ClientGroupDataTable();
     6690            this.Adapter.Fill(dataTable);
     6691            return dataTable;
     6692        }
     6693       
     6694        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6695        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6696        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     6697        public virtual int FillById(dsHiveServer.ClientGroupDataTable dataTable, long Id) {
     6698            this.Adapter.SelectCommand = this.CommandCollection[1];
     6699            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     6700            if ((this.ClearBeforeFill == true)) {
     6701                dataTable.Clear();
     6702            }
     6703            int returnValue = this.Adapter.Fill(dataTable);
     6704            return returnValue;
     6705        }
     6706       
     6707        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     6708        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     6709        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     6710        public virtual dsHiveServer.ClientGroupDataTable GetDataById(long Id) {
     6711            this.Adapter.SelectCommand = this.CommandCollection[1];
     6712            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
    63926713            dsHiveServer.ClientGroupDataTable dataTable = new dsHiveServer.ClientGroupDataTable();
    63936714            this.Adapter.Fill(dataTable);
    … …  
    66646985        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    66656986        private void InitCommandCollection() {
    6666             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
     6987            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[6];
    66676988            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    66686989            this._commandCollection[0].Connection = this.Connection;
    66696990            this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM dbo.Job";
    66706991            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
     6992            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
     6993            this._commandCollection[1].Connection = this.Connection;
     6994            this._commandCollection[1].CommandText = "SELECT * FROM dbo.Job WHERE Status <> \'offline\'";
     6995            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
     6996            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     6997            this._commandCollection[2].Connection = this.Connection;
     6998            this._commandCollection[2].CommandText = "SELECT * FROM dbo.Job WHERE ResourceId = @ResourceId";
     6999            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     7000            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, "", "", ""));
     7001            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
     7002            this._commandCollection[3].Connection = this.Connection;
     7003            this._commandCollection[3].CommandText = "SELECT * FROM dbo.Job WHERE JobId = @Id";
     7004            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
     7005            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, "", "", ""));
     7006            this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand();
     7007            this._commandCollection[4].Connection = this.Connection;
     7008            this._commandCollection[4].CommandText = "SELECT * FROM dbo.Job WHERE ParentJobId = @Id";
     7009            this._commandCollection[4].CommandType = global::System.Data.CommandType.Text;
     7010            this._commandCollection[4].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, "", "", ""));
     7011            this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand();
     7012            this._commandCollection[5].Connection = this.Connection;
     7013            this._commandCollection[5].CommandText = "SELECT * FROM dbo.Job WHERE PermissionOwnerId = @PermissionOwnerId ";
     7014            this._commandCollection[5].CommandType = global::System.Data.CommandType.Text;
     7015            this._commandCollection[5].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, "", "", ""));
    66717016        }
    66727017       
    … …  
    66887033        public virtual dsHiveServer.JobDataTable GetData() {
    66897034            this.Adapter.SelectCommand = this.CommandCollection[0];
     7035            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7036            this.Adapter.Fill(dataTable);
     7037            return dataTable;
     7038        }
     7039       
     7040        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7041        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7042        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7043        public virtual int FillByActive(dsHiveServer.JobDataTable dataTable) {
     7044            this.Adapter.SelectCommand = this.CommandCollection[1];
     7045            if ((this.ClearBeforeFill == true)) {
     7046                dataTable.Clear();
     7047            }
     7048            int returnValue = this.Adapter.Fill(dataTable);
     7049            return returnValue;
     7050        }
     7051       
     7052        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7053        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7054        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7055        public virtual dsHiveServer.JobDataTable GetDataByActive() {
     7056            this.Adapter.SelectCommand = this.CommandCollection[1];
     7057            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7058            this.Adapter.Fill(dataTable);
     7059            return dataTable;
     7060        }
     7061       
     7062        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7063        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7064        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7065        public virtual int FillByClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> ResourceId) {
     7066            this.Adapter.SelectCommand = this.CommandCollection[2];
     7067            if ((ResourceId.HasValue == true)) {
     7068                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ResourceId.Value));
     7069            }
     7070            else {
     7071                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7072            }
     7073            if ((this.ClearBeforeFill == true)) {
     7074                dataTable.Clear();
     7075            }
     7076            int returnValue = this.Adapter.Fill(dataTable);
     7077            return returnValue;
     7078        }
     7079       
     7080        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7081        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7082        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7083        public virtual dsHiveServer.JobDataTable GetDataByClient(global::System.Nullable<long> ResourceId) {
     7084            this.Adapter.SelectCommand = this.CommandCollection[2];
     7085            if ((ResourceId.HasValue == true)) {
     7086                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ResourceId.Value));
     7087            }
     7088            else {
     7089                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7090            }
     7091            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7092            this.Adapter.Fill(dataTable);
     7093            return dataTable;
     7094        }
     7095       
     7096        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7097        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7098        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7099        public virtual int FillById(dsHiveServer.JobDataTable dataTable, long Id) {
     7100            this.Adapter.SelectCommand = this.CommandCollection[3];
     7101            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     7102            if ((this.ClearBeforeFill == true)) {
     7103                dataTable.Clear();
     7104            }
     7105            int returnValue = this.Adapter.Fill(dataTable);
     7106            return returnValue;
     7107        }
     7108       
     7109        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7110        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7111        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7112        public virtual dsHiveServer.JobDataTable GetDataById(long Id) {
     7113            this.Adapter.SelectCommand = this.CommandCollection[3];
     7114            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     7115            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7116            this.Adapter.Fill(dataTable);
     7117            return dataTable;
     7118        }
     7119       
     7120        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7121        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7122        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7123        public virtual int FillBySubjobs(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> Id) {
     7124            this.Adapter.SelectCommand = this.CommandCollection[4];
     7125            if ((Id.HasValue == true)) {
     7126                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id.Value));
     7127            }
     7128            else {
     7129                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7130            }
     7131            if ((this.ClearBeforeFill == true)) {
     7132                dataTable.Clear();
     7133            }
     7134            int returnValue = this.Adapter.Fill(dataTable);
     7135            return returnValue;
     7136        }
     7137       
     7138        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7139        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7140        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7141        public virtual dsHiveServer.JobDataTable GetDataBySubjobs(global::System.Nullable<long> Id) {
     7142            this.Adapter.SelectCommand = this.CommandCollection[4];
     7143            if ((Id.HasValue == true)) {
     7144                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id.Value));
     7145            }
     7146            else {
     7147                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7148            }
     7149            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7150            this.Adapter.Fill(dataTable);
     7151            return dataTable;
     7152        }
     7153       
     7154        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7155        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7156        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7157        public virtual int FillByUser(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> PermissionOwnerId) {
     7158            this.Adapter.SelectCommand = this.CommandCollection[5];
     7159            if ((PermissionOwnerId.HasValue == true)) {
     7160                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId.Value));
     7161            }
     7162            else {
     7163                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7164            }
     7165            if ((this.ClearBeforeFill == true)) {
     7166                dataTable.Clear();
     7167            }
     7168            int returnValue = this.Adapter.Fill(dataTable);
     7169            return returnValue;
     7170        }
     7171       
     7172        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7173        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7174        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7175        public virtual dsHiveServer.JobDataTable GetDataByUser(global::System.Nullable<long> PermissionOwnerId) {
     7176            this.Adapter.SelectCommand = this.CommandCollection[5];
     7177            if ((PermissionOwnerId.HasValue == true)) {
     7178                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId.Value));
     7179            }
     7180            else {
     7181                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7182            }
    66907183            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    66917184            this.Adapter.Fill(dataTable);
    … …  
    70537546        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    70547547        private void InitCommandCollection() {
    7055             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
     7548            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4];
    70567549            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    70577550            this._commandCollection[0].Connection = this.Connection;
    70587551            this._commandCollection[0].CommandText = "SELECT ClientGroupId, ResourceId FROM dbo.ClientGroup_Resource";
    70597552            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
     7553            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
     7554            this._commandCollection[1].Connection = this.Connection;
     7555            this._commandCollection[1].CommandText = "SELECT * FROM dbo.ClientGroup_Resource WHERE ClientGroupId = @Id";
     7556            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
     7557            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, "ClientGroupId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7558            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
     7559            this._commandCollection[2].Connection = this.Connection;
     7560            this._commandCollection[2].CommandText = "SELECT * FROM dbo.ClientGroup_Resource WHERE ClientGroupId = @ClientGroupId AND  " +
     7561                "ResourceId = @ResourceId";
     7562            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
     7563            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ClientGroupId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ClientGroupId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7564            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, "", "", ""));
     7565            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
     7566            this._commandCollection[3].Connection = this.Connection;
     7567            this._commandCollection[3].CommandText = "SELECT * FROM dbo.ClientGroup_Resource WHERE ResourceId = @Id";
     7568            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
     7569            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, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    70607570        }
    70617571       
    … …  
    70777587        public virtual dsHiveServer.ClientGroup_ResourceDataTable GetData() {
    70787588            this.Adapter.SelectCommand = this.CommandCollection[0];
     7589            dsHiveServer.ClientGroup_ResourceDataTable dataTable = new dsHiveServer.ClientGroup_ResourceDataTable();
     7590            this.Adapter.Fill(dataTable);
     7591            return dataTable;
     7592        }
     7593       
     7594        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7595        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7596        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7597        public virtual int FillByClientGroupId(dsHiveServer.ClientGroup_ResourceDataTable dataTable, long Id) {
     7598            this.Adapter.SelectCommand = this.CommandCollection[1];
     7599            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     7600            if ((this.ClearBeforeFill == true)) {
     7601                dataTable.Clear();
     7602            }
     7603            int returnValue = this.Adapter.Fill(dataTable);
     7604            return returnValue;
     7605        }
     7606       
     7607        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7608        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7609        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7610        public virtual dsHiveServer.ClientGroup_ResourceDataTable GetDataByClientGroupId(long Id) {
     7611            this.Adapter.SelectCommand = this.CommandCollection[1];
     7612            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     7613            dsHiveServer.ClientGroup_ResourceDataTable dataTable = new dsHiveServer.ClientGroup_ResourceDataTable();
     7614            this.Adapter.Fill(dataTable);
     7615            return dataTable;
     7616        }
     7617       
     7618        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7619        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7620        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7621        public virtual int FillByClientGroupResourceId(dsHiveServer.ClientGroup_ResourceDataTable dataTable, long ClientGroupId, long ResourceId) {
     7622            this.Adapter.SelectCommand = this.CommandCollection[2];
     7623            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ClientGroupId));
     7624            this.Adapter.SelectCommand.Parameters[1].Value = ((long)(ResourceId));
     7625            if ((this.ClearBeforeFill == true)) {
     7626                dataTable.Clear();
     7627            }
     7628            int returnValue = this.Adapter.Fill(dataTable);
     7629            return returnValue;
     7630        }
     7631       
     7632        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7633        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7634        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7635        public virtual dsHiveServer.ClientGroup_ResourceDataTable GetDataByClientGroupResourceId(long ClientGroupId, long ResourceId) {
     7636            this.Adapter.SelectCommand = this.CommandCollection[2];
     7637            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ClientGroupId));
     7638            this.Adapter.SelectCommand.Parameters[1].Value = ((long)(ResourceId));
     7639            dsHiveServer.ClientGroup_ResourceDataTable dataTable = new dsHiveServer.ClientGroup_ResourceDataTable();
     7640            this.Adapter.Fill(dataTable);
     7641            return dataTable;
     7642        }
     7643       
     7644        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7645        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7646        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7647        public virtual int FillByResourceId(dsHiveServer.ClientGroup_ResourceDataTable dataTable, long Id) {
     7648            this.Adapter.SelectCommand = this.CommandCollection[3];
     7649            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
     7650            if ((this.ClearBeforeFill == true)) {
     7651                dataTable.Clear();
     7652            }
     7653            int returnValue = this.Adapter.Fill(dataTable);
     7654            return returnValue;
     7655        }
     7656       
     7657        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7658        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7659        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7660        public virtual dsHiveServer.ClientGroup_ResourceDataTable GetDataByResourceId(long Id) {
     7661            this.Adapter.SelectCommand = this.CommandCollection[3];
     7662            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
    70797663            dsHiveServer.ClientGroup_ResourceDataTable dataTable = new dsHiveServer.ClientGroup_ResourceDataTable();
    70807664            this.Adapter.Fill(dataTable);
Note: See TracChangeset for help on using the changeset viewer.