public F820007()
{
this.Tag = 820007;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820007_Vmg_BuildingInformation.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820007_Vmg_BuildingInformation.Height, this.r820007_Vmg_BuildingInformation.Width, this.r820007_Vmg_BuildingInformation.Text, this.r820007_Vmg_BuildingInformation.BackColor, this.r820007_Vmg_BuildingInformation.Font);
this.r820007_Vmg_BuildingInformation.Text = string.Empty;
this.AddDataSetValues("r820007_CommercialConstruction_BuildingInformation", "StoredProcedure", "r820007_Get");
}
public F820010()
{
this.Tag = 820010;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820010_Vmg_CondemnationReasons.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820010_Vmg_CondemnationReasons.Height, this.r820010_Vmg_CondemnationReasons.Width, this.r820010_Vmg_CondemnationReasons.Text, this.r820010_Vmg_CondemnationReasons.BackColor, this.r820010_Vmg_CondemnationReasons.Font);
this.r820010_Vmg_CondemnationReasons.Text = string.Empty;
this.AddDataSetValues("r820010_Condemnation_Reasons", "StoredProcedure", "r820010_Get");
}
public F820018()
{
this.Tag = 820018;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820018_Vmg_Structure.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820018_Vmg_Structure.Height, this.r820018_Vmg_Structure.Width, this.r820018_Vmg_Structure.Text, this.r820018_Vmg_Structure.BackColor, this.r820018_Vmg_Structure.Font);
this.r820018_Vmg_Structure.Text = string.Empty;
this.AddDataSetValues("r820018_InternationalProperty_Structure", "StoredProcedure", "r820018_Get");
}
public F820015()
{
this.Tag = 820015;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820015_Vmg_SystemInformation.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820015_Vmg_SystemInformation.Height, this.r820015_Vmg_SystemInformation.Width, this.r820015_Vmg_SystemInformation.Text, this.r820015_Vmg_SystemInformation.BackColor, this.r820015_Vmg_SystemInformation.Font);
this.r820015_Vmg_SystemInformation.Text = string.Empty;
this.AddDataSetValues("r820015_MechanicalPermit_SystemInformation", "StoredProcedure", "r820015_Get");
}
public F820016()
{
this.Tag = 820016;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820016_Vmg_OccupancyPermit.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820016_Vmg_OccupancyPermit.Height, this.r820016_Vmg_OccupancyPermit.Width, this.r820016_Vmg_OccupancyPermit.Text, this.r820016_Vmg_OccupancyPermit.BackColor, this.r820016_Vmg_OccupancyPermit.Font);
this.r820016_Vmg_OccupancyPermit.Text = string.Empty;
this.AddDataSetValues("r820016_OccupancyPermit", "StoredProcedure", "r820016_Get");
this.AddDataSetValues("Name_Full", "", "SELECT UserID, Name_Full FROM tTS_User");
}
public F84603(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 84603;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84603_Vmg_Location.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84603_Vmg_Location.Height, this.r84603_Vmg_Location.Width, this.r84603_Vmg_Location.Text, this.r84603_Vmg_Location.BackColor, this.r84603_Vmg_Location.Font);
this.r84603_Vmg_Location.Text = string.Empty;
}
public F820002()
{
this.Tag = 820002;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820002_Vmg_Contractor.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820002_Vmg_Contractor.Height, this.r820002_Vmg_Contractor.Width, this.r820002_Vmg_Contractor.Text, this.r820002_Vmg_Contractor.BackColor, this.r820002_Vmg_Contractor.Font);
this.r820002_Vmg_Contractor.Text = string.Empty;
this.AddDataSetValues("r820002_Contractor", "StoredProcedure", "r820002_Get");
////this.AddDataSetValues("Name", "", "SELECT ContractorID, Name FROM tGD_Contractor");
this.AddDataSetValues("Name", "", "SELECT ContractorID , [Name] AS [Value] FROM [dbo].[r820002_udf_GetName] (null) AS A");
}
public F820003(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit, int featureClassID)
{
this.Tag = 820003;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820003_Vmg_Owner.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820003_Vmg_Owner.Height, this.r820003_Vmg_Owner.Width, this.r820003_Vmg_Owner.Text, this.r820003_Vmg_Owner.BackColor, this.r820003_Vmg_Owner.Font);
this.r820003_Vmg_Owner.Text = string.Empty;
this.AddDataSetValues("r820003_Owner", "StoredProcedure", "r820003_Get");
}
public F820001()
{
this.Tag = 820001;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820001_Vmg_Architect.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820001_Vmg_Architect.Height, this.r820001_Vmg_Architect.Width, this.r820001_Vmg_Architect.Text, this.r820001_Vmg_Architect.BackColor, this.r820001_Vmg_Architect.Font);
this.r820001_Vmg_Architect.Text = string.Empty;
this.AddDataSetValues("r820001_Architect", "StoredProcedure", "r820001_Get");
//this.AddDataSetValues("Name", "", "SELECT ArchitectID, Name FROM tGD_Architect");
this.AddDataSetValues("Name", "", "SELECT ArchitectID , [Name] AS [Value] FROM [dbo].[r820001_udf_GetName] (null) AS A");
//this.AddDataSetValues("Name", "", "SELECT MIN(ArchitectID) AS ArchitectID,[Name] FROM tGD_Architect WHERE IsDeleted = 0 GROUP BY [Name]");
}
public F846041()
{
this.Tag = 846041;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84604_Location_Vmg_Location.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84604_Location_Vmg_Location.Height, this.r84604_Location_Vmg_Location.Width, this.r84604_Location_Vmg_Location.Text, this.r84604_Location_Vmg_Location.BackColor, this.r84604_Location_Vmg_Location.Font);
this.r84604_Location_Vmg_Location.Text = string.Empty;
this.AddDataSetValues("qStormBasinInformation", "StoredProcedure", "r84604_Location_Get");
this.AddDataSetValues("AdministrativeAreaID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'AdministrativeAreaID')");
this.AddDataSetValues("OperationalAreaID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'OperationalAreaID')");
this.AddDataSetValues("GridID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'GridID')");
}
public F846042()
{
this.Tag = 846042;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84604_Properties_Vmg_Properties.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84604_Properties_Vmg_Properties.Height, this.r84604_Properties_Vmg_Properties.Width, this.r84604_Properties_Vmg_Properties.Text, this.r84604_Properties_Vmg_Properties.BackColor, this.r84604_Properties_Vmg_Properties.Font);
this.r84604_Properties_Vmg_Properties.Text = string.Empty;
this.AddDataSetValues("qStormBasin", "StoredProcedure", "r84604_Properties_Get");
this.AddDataSetValues("LifeCycleStatusID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField ='LifeCycleStatusID')");
this.AddDataSetValues("MaterialTypeID", "", "SELECT ItemID,Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField ='MaterialTypeID')");
this.AddDataSetValues("AccessTypeID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'AccessTypeID')");
}
public F820005(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 820005;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820005_Vmg_BuildingInformation.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820005_Vmg_BuildingInformation.Height, this.r820005_Vmg_BuildingInformation.Width, this.r820005_Vmg_BuildingInformation.Text, this.r820005_Vmg_BuildingInformation.BackColor, this.r820005_Vmg_BuildingInformation.Font);
this.r820005_Vmg_BuildingInformation.Text = string.Empty;
this.AddDataSetValues("r820005_AccessoryStructure_BuildingInformation", "StoredProcedure", "r820005_Get");
}
public F820016(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 820016;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820016_Vmg_OccupancyPermit.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820016_Vmg_OccupancyPermit.Height, this.r820016_Vmg_OccupancyPermit.Width, this.r820016_Vmg_OccupancyPermit.Text, this.r820016_Vmg_OccupancyPermit.BackColor, this.r820016_Vmg_OccupancyPermit.Font);
this.r820016_Vmg_OccupancyPermit.Text = string.Empty;
this.AddDataSetValues("r820016_OccupancyPermit", "StoredProcedure", "r820016_Get");
this.AddDataSetValues("Name_Full", "", "SELECT UserID, Name_Full FROM tTS_User");
}
public F846031()
{
this.Tag = 846031;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84603_Location_Vmg_Location.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84603_Location_Vmg_Location.Height, this.r84603_Location_Vmg_Location.Width, this.r84603_Location_Vmg_Location.Text, this.r84603_Location_Vmg_Location.BackColor, this.r84603_Location_Vmg_Location.Font);
this.r84603_Location_Vmg_Location.Text = string.Empty;
this.AddDataSetValues("qStormJunctionLocation", "StoredProcedure", "r84603_Location_Get");
this.AddDataSetValues("AdministrativeAreaID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'AdministrativeAreaID'");
this.AddDataSetValues("OperationalAreaID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'OperationalAreaID'");
this.AddDataSetValues("GridID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'GridID'");
this.AddDataSetValues("GPSByID", "", "SELECT UserID, Name_Display FROM tTS_User");
this.AddDataSetValues("N_S_StreetID", "", "SELECT StreetID, StreetName FROM tGD_Street");
this.AddDataSetValues("E_W_StreetID", "", "SELECT StreetID, StreetName FROM tGD_Street");
}
public F846042(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit, int featureClassID)
{
this.Tag = 846042;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84604_Properties_Vmg_Properties.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84604_Properties_Vmg_Properties.Height, this.r84604_Properties_Vmg_Properties.Width, this.r84604_Properties_Vmg_Properties.Text, this.r84604_Properties_Vmg_Properties.BackColor, this.r84604_Properties_Vmg_Properties.Font);
this.r84604_Properties_Vmg_Properties.Text = string.Empty;
this.AddDataSetValues("qStormBasin", "StoredProcedure", "r84604_Properties_Get");
this.AddDataSetValues("LifeCycleStatusID", "", "SELECT ItemID, Value AS LifecycleStatusID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField ='LifeCycleStatusID')");
this.AddDataSetValues("MaterialTypeID", "", "SELECT ItemID,Value AS MaterialTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField ='MaterialTypeID')");
this.AddDataSetValues("AccessTypeID", "", "SELECT ItemID, Value AS AccessTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'AccessTypeID')");
}
public F820002(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 820002;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820002_Vmg_Contractor.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820002_Vmg_Contractor.Height, this.r820002_Vmg_Contractor.Width, this.r820002_Vmg_Contractor.Text, this.r820002_Vmg_Contractor.BackColor, this.r820002_Vmg_Contractor.Font);
this.r820002_Vmg_Contractor.Text = string.Empty;
this.AddDataSetValues("r820002_Contractor", "StoredProcedure", "r820002_Get");
////this.AddDataSetValues("Name", "", "SELECT ContractorID, Name FROM tGD_Contractor");
////this.AddDataSetValues("Name", "", "SELECT MIN(EventID) AS EventID,[Name] FROM tGD_Contractor WHERE IsDeleted = 0 GROUP BY [Name]");
this.AddDataSetValues("Name", "", "SELECT ContractorID , [Name] AS [Value] FROM [dbo].[r820002_udf_GetName] (null) AS A");
}
public F846041(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit, int featureClassID)
{
this.Tag = 846041;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84604_Location_Vmg_Location.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84604_Location_Vmg_Location.Height, this.r84604_Location_Vmg_Location.Width, this.r84604_Location_Vmg_Location.Text, this.r84604_Location_Vmg_Location.BackColor, this.r84604_Location_Vmg_Location.Font);
this.r84604_Location_Vmg_Location.Text = string.Empty;
this.AddDataSetValues("qStormBasinInformation", "StoredProcedure", "r84604_Location_Get");
this.AddDataSetValues("AdministrativeAreaID", "", "SELECT ItemID, Value AS AdministrativeAreaID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'AdministrativeAreaID')");
this.AddDataSetValues("OperationalAreaID", "", "SELECT ItemID, Value AS OperationalAreaID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'OperationalAreaID')");
this.AddDataSetValues("GridID", "", "SELECT ItemID, Value AS GridID FROM tGD_PropertyReference WHERE (FeatureClassID = 84604) AND (RefField = 'GridID')");
}
public F820001(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 820001;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r820001_Vmg_Architect.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r820001_Vmg_Architect.Height, this.r820001_Vmg_Architect.Width, this.r820001_Vmg_Architect.Text, this.r820001_Vmg_Architect.BackColor, this.r820001_Vmg_Architect.Font);
this.r820001_Vmg_Architect.Text = string.Empty;
this.AddDataSetValues("r820001_Architect", "StoredProcedure", "r820001_Get");
/*Query Modified as per change request - here query sent by client*/
////this.AddDataSetValues("Name", "", "SELECT ArchitectID, Name FROM tGD_Architect");
this.AddDataSetValues("Name", "", "SELECT ArchitectID , [Name] AS [Value] FROM [dbo].[r820001_udf_GetName] (null) AS A");
//this.AddDataSetValues("Name", "", "SELECT MIN(ArchitectID) AS ArchitectID,[Name] FROM tGD_Architect WHERE IsDeleted = 0 GROUP BY [Name]");
}
public F846032()
{
this.Tag = 846032;
InitializeComponent();
this.actualHeight = this.Height;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84603_Properties_Vmg_Properties.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84603_Properties_Vmg_Properties.Height, this.r84603_Properties_Vmg_Properties.Width, this.r84603_Properties_Vmg_Properties.Text, this.r84603_Properties_Vmg_Properties.BackColor, this.r84603_Properties_Vmg_Properties.Font);
this.r84603_Properties_Vmg_Properties.Text = string.Empty;
this.AddDataSetValues("qStormJunction", "StoredProcedure", "r84603_Properties_Get");
this.AddDataSetValues("LifeCycleStatusID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'LifeCycleStatusID'");
this.AddDataSetValues("CoverDiameterID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'CoverDiameterID'");
this.AddDataSetValues("CoverTypeID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'CoverTypeID'");
this.AddDataSetValues("JunctionTypeID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'JunctionTypeID'");
this.AddDataSetValues("FrameTypeID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'FrameTypeID'");
this.AddDataSetValues("JunctionMaterialID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'JunctionMaterialID'");
this.AddDataSetValues("RingMaterialID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'RingMaterialID'");
this.AddDataSetValues("AccessTypeID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'AccessTypeID'");
this.AddDataSetValues("SurfaceCoverID", "", "SELECT ItemID, Value FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'SurfaceCoverID'");
}
public F846032(int masterform, int formNo, int keyID, int red, int green, int blue, string tabText, bool permissionEdit)
{
this.Tag = 846032;
InitializeComponent();
this.actualHeight = this.Height;
this.formMasterPermissionEdit = permissionEdit;
this.masterFormNo = masterform;
this.keyId = keyID;
comboTextCollection = new List <ComboSQLText>();
dataSetCollection = new List <DataSetCollection>();
this.r84603_Properties_Vmg_Properties.Image = ExtendedGraphics.GenerateVerticalLabelText(this.r84603_Properties_Vmg_Properties.Height, this.r84603_Properties_Vmg_Properties.Width, this.r84603_Properties_Vmg_Properties.Text, this.r84603_Properties_Vmg_Properties.BackColor, this.r84603_Properties_Vmg_Properties.Font);
this.r84603_Properties_Vmg_Properties.Text = string.Empty;
this.AddDataSetValues("qStormJunction", "StoredProcedure", "r84603_Properties_Get");
this.AddDataSetValues("LifeCycleStatusID", "", "SELECT ItemID, Value AS LifecycleStatusID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'LifeCycleStatusID'");
this.AddDataSetValues("CoverDiameterID", "", "SELECT ItemID, Value AS CoverDiameterID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'CoverDiameterID'");
this.AddDataSetValues("CoverTypeID", "", "SELECT ItemID, Value AS CoverTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'CoverTypeID'");
this.AddDataSetValues("JunctionTypeID", "", "SELECT ItemID, Value AS JunctionTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'JunctionTypeID'");
this.AddDataSetValues("FrameTypeID", "", "SELECT ItemID, Value AS FrameTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'FrameTypeID'");
this.AddDataSetValues("JunctionMaterialID", "", "SELECT ItemID, Value AS JunctionMaterialID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'JunctionMaterialID'");
this.AddDataSetValues("RingMaterialID", "", "SELECT ItemID, Value AS RingMaterialID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'RingMaterialID'");
this.AddDataSetValues("AccessTypeID", "", "SELECT ItemID, Value AS AccessTypeID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'AccessTypeID'");
this.AddDataSetValues("SurfaceCoverID", "", "SELECT ItemID, Value AS SurfaceCoverID FROM tGD_PropertyReference WHERE (FeatureClassID = 84603) and RefField = 'SurfaceCoverID'");
}