/// <summary> /// F34100_ the get AglandUseDetails. /// </summary> /// <param name="AglandID">The TIF id.</param> /// <returns>The TIFDistrict dataset.</returns> public static F34100AglandUseData F34100_GetAglandDetails(int AglandID) { F34100AglandUseData AglandData = new F34100AglandUseData(); Hashtable ht = new Hashtable(); //DataSet ds = new DataSet(); ht.Add("@AglandID", AglandID); string[] tableNames = new string[] { AglandData.AglandUseDataTable.TableName, AglandData.AglandTypeDataTable.TableName, AglandData.AglandMethodDataTable.TableName }; Utility.LoadDataSet(AglandData, "f39100_pcget_AglandUse", ht, tableNames); return(AglandData); }
/// <summary> /// Populates the TIF District fund detais. /// </summary> private void PopulateAgLandUseDetails() { this.pageLoadStatus = true; this.AglandUseData.Clear(); //this.AglandUseData.AglandMethodDataTable.Clear(); //this.AglandUseData.AglandTypeDataTable.Clear(); this.AglandUseData.AglandUseDataTable.Clear(); //this.TIFId = this.keyId; this.AglandUseData = this.form39100Controll.WorkItem.F34100_GetAglandDetails(this.keyId); int rollYear; //this.MethodData.Merge(this.AglandUseData.AglandMethodDataTable); //this.TypeData.Merge(this.AglandUseData.AglandTypeDataTable); int.TryParse(this.RollYearTextBox.Text, out rollYear); /// used for the display of combobox after leave active control if (this.AglandUseData.AglandMethodDataTable.Rows.Count > 0) { this.MethodComboBox.DataSource = this.AglandUseData.AglandMethodDataTable; this.MethodComboBox.DisplayMember = this.AglandUseData.AglandMethodDataTable.AglandMethodColumn.ColumnName.ToString(); this.MethodComboBox.ValueMember = this.AglandUseData.AglandMethodDataTable.AglandMethodIDColumn.ColumnName.ToString(); } else { this.MethodComboBox.SelectedIndex = -1; } if (this.AglandUseData.AglandTypeDataTable.Rows.Count > 0) { /// used for the display of combobox after leave active control this.TypeComboBox.DataSource = this.AglandUseData.AglandTypeDataTable; this.TypeComboBox.DisplayMember = this.AglandUseData.AglandTypeDataTable.AglandTypeColumn.ColumnName.ToString(); this.TypeComboBox.ValueMember = this.AglandUseData.AglandTypeDataTable.AglandTypeIDColumn.ColumnName.ToString(); } else { this.TypeComboBox.SelectedIndex = -1; } //// load the form f27081 using keyid and userid if (this.AglandUseData.AglandUseDataTable.Rows.Count > 0) { this.RollYearTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.RollYearColumn.ColumnName].ToString(); this.UseTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.UseColumn.ColumnName].ToString(); this.DescriptionTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.DescriptionColumn.ColumnName].ToString(); decimal factorValue; decimal.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.FactorColumn.ColumnName].ToString(), out factorValue); factorValue *= 100; //this.BaseAdjustmentTextBox.Text = factorAdjValue.ToString(); this.FactorTextBox.Text = factorValue.ToString(); //this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.FactorColumn.ColumnName].ToString(); this.ValueTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.ValueColumn.ColumnName].ToString(); this.MinimumValueTextBox.Text = this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.MinimumValueColumn.ColumnName].ToString(); int aglandTypeID; int.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.AglandTypeIDColumn.ColumnName].ToString(), out aglandTypeID); this.TypeComboBox.SelectedValue = aglandTypeID; int aglandMethodID; int.TryParse(this.AglandUseData.AglandUseDataTable.Rows[0][this.AglandUseData.AglandUseDataTable.AglandMethodIDColumn.ColumnName].ToString(), out aglandMethodID); this.MethodComboBox.SelectedValue = aglandMethodID; this.LockControls(false); } else { this.ClearAGLANDText(); this.LockControls(true); } this.pageMode = TerraScanCommon.PageModeTypes.View; this.pageLoadStatus = false; }