- Timestamp:
- 12/16/08 17:26:43 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs
r991 r995 4168 4168 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4169 4169 private void InitCommandCollection() { 4170 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 2];4170 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4]; 4171 4171 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 4172 4172 this._commandCollection[0].Connection = this.Connection; … … 4175 4175 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 4176 4176 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\'"; 4178 4179 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, "", "", "")); 4180 4190 } 4181 4191 … … 4205 4215 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 4206 4216 [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)] 4207 4239 public virtual int FillById(dsHiveServer.ResourceDataTable dataTable, long ID) { 4208 this.Adapter.SelectCommand = this.CommandCollection[ 1];4240 this.Adapter.SelectCommand = this.CommandCollection[2]; 4209 4241 this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ID)); 4210 4242 if ((this.ClearBeforeFill == true)) { … … 4219 4251 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)] 4220 4252 public virtual dsHiveServer.ResourceDataTable GetDataById(long ID) { 4221 this.Adapter.SelectCommand = this.CommandCollection[ 1];4253 this.Adapter.SelectCommand = this.CommandCollection[2]; 4222 4254 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 } 4223 4289 dsHiveServer.ResourceDataTable dataTable = new dsHiveServer.ResourceDataTable(); 4224 4290 this.Adapter.Fill(dataTable); … … 4544 4610 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4545 4611 private void InitCommandCollection() { 4546 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 2];4612 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4]; 4547 4613 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 4548 4614 this._commandCollection[0].Connection = this.Connection; … … 4552 4618 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 4553 4619 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\'"; 4555 4621 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, "", "", "")); 4557 4632 } 4558 4633 … … 4582 4657 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 4583 4658 [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)] 4584 4681 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]; 4586 4683 if ((ID.HasValue == true)) { 4587 4684 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ID.Value)); … … 4601 4698 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)] 4602 4699 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]; 4604 4701 if ((ID.HasValue == true)) { 4605 4702 this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(ID.Value)); … … 4608 4705 this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value; 4609 4706 } 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)); 4610 4731 dsHiveServer.ClientDataTable dataTable = new dsHiveServer.ClientDataTable(); 4611 4732 this.Adapter.Fill(dataTable); … … 5454 5575 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 5455 5576 private void InitCommandCollection() { 5456 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 2];5577 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[3]; 5457 5578 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 5458 5579 this._commandCollection[0].Connection = this.Connection; … … 5464 5585 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 5465 5586 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, "", "", "")); 5466 5592 } 5467 5593 … … 5507 5633 this.Adapter.SelectCommand = this.CommandCollection[1]; 5508 5634 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 } 5509 5669 dsHiveServer.PermissionOwnerDataTable dataTable = new dsHiveServer.PermissionOwnerDataTable(); 5510 5670 this.Adapter.Fill(dataTable); … … 5784 5944 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 5785 5945 private void InitCommandCollection() { 5786 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 1];5946 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[3]; 5787 5947 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 5788 5948 this._commandCollection[0].Connection = this.Connection; 5789 5949 this._commandCollection[0].CommandText = "SELECT PermissionOwnerId FROM dbo.UserGroup"; 5790 5950 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, "", "", "")); 5791 5963 } 5792 5964 … … 5808 5980 public virtual dsHiveServer.UserGroupDataTable GetData() { 5809 5981 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 } 5810 6040 dsHiveServer.UserGroupDataTable dataTable = new dsHiveServer.UserGroupDataTable(); 5811 6041 this.Adapter.Fill(dataTable); … … 6061 6291 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 6062 6292 private void InitCommandCollection() { 6063 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 2];6293 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4]; 6064 6294 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 6065 6295 this._commandCollection[0].Connection = this.Connection; … … 6068 6298 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 6069 6299 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"; 6071 6301 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, "", "", "")); 6073 6315 } 6074 6316 … … 6098 6340 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 6099 6341 [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)] 6100 6392 public virtual int FillByUserGroupId(dsHiveServer.PermissionOwner_UserGroupDataTable dataTable, long UserGroupId) { 6101 this.Adapter.SelectCommand = this.CommandCollection[ 1];6393 this.Adapter.SelectCommand = this.CommandCollection[3]; 6102 6394 this.Adapter.SelectCommand.Parameters[0].Value = ((long)(UserGroupId)); 6103 6395 if ((this.ClearBeforeFill == true)) { … … 6112 6404 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)] 6113 6405 public virtual dsHiveServer.PermissionOwner_UserGroupDataTable GetDataByUserGroupId(long UserGroupId) { 6114 this.Adapter.SelectCommand = this.CommandCollection[ 1];6406 this.Adapter.SelectCommand = this.CommandCollection[3]; 6115 6407 this.Adapter.SelectCommand.Parameters[0].Value = ((long)(UserGroupId)); 6116 6408 dsHiveServer.PermissionOwner_UserGroupDataTable dataTable = new dsHiveServer.PermissionOwner_UserGroupDataTable(); … … 6366 6658 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 6367 6659 private void InitCommandCollection() { 6368 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 1];6660 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[2]; 6369 6661 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 6370 6662 this._commandCollection[0].Connection = this.Connection; 6371 6663 this._commandCollection[0].CommandText = "SELECT ResourceId FROM dbo.ClientGroup"; 6372 6664 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, "", "", "")); 6373 6670 } 6374 6671 … … 6390 6687 public virtual dsHiveServer.ClientGroupDataTable GetData() { 6391 6688 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)); 6392 6713 dsHiveServer.ClientGroupDataTable dataTable = new dsHiveServer.ClientGroupDataTable(); 6393 6714 this.Adapter.Fill(dataTable); … … 6664 6985 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 6665 6986 private void InitCommandCollection() { 6666 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 1];6987 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[6]; 6667 6988 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 6668 6989 this._commandCollection[0].Connection = this.Connection; 6669 6990 this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM dbo.Job"; 6670 6991 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, "", "", "")); 6671 7016 } 6672 7017 … … 6688 7033 public virtual dsHiveServer.JobDataTable GetData() { 6689 7034 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 } 6690 7183 dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable(); 6691 7184 this.Adapter.Fill(dataTable); … … 7053 7546 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 7054 7547 private void InitCommandCollection() { 7055 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[ 1];7548 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[4]; 7056 7549 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 7057 7550 this._commandCollection[0].Connection = this.Connection; 7058 7551 this._commandCollection[0].CommandText = "SELECT ClientGroupId, ResourceId FROM dbo.ClientGroup_Resource"; 7059 7552 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, "", "", "")); 7060 7570 } 7061 7571 … … 7077 7587 public virtual dsHiveServer.ClientGroup_ResourceDataTable GetData() { 7078 7588 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)); 7079 7663 dsHiveServer.ClientGroup_ResourceDataTable dataTable = new dsHiveServer.ClientGroup_ResourceDataTable(); 7080 7664 this.Adapter.Fill(dataTable);
Note: See TracChangeset
for help on using the changeset viewer.