public List <BIOSUM_VOLUME> ExecuteSelectSQL_CreateBIOSUM_VOLUMEList(string p_strSQL)
{
List <BIOSUM_VOLUME> oList = new List <BIOSUM_VOLUME>();
bool bCloseConnection = false;
if (this._OracleADO.ConnectionDisposed ||
this._OracleADO.m_Connection == null ||
this._OracleADO.m_Connection.State != System.Data.ConnectionState.Open)
{
_OracleADO.OpenConnection(FCSOracle.FCSConnectionString);
bCloseConnection = true;
}
_OracleADO.SqlQueryReader(_OracleADO.m_Connection, p_strSQL);
if (_OracleADO.m_intError == 0 && _OracleADO.m_DataReader.HasRows)
{
while (_OracleADO.m_DataReader.Read())
{
if (_OracleADO.m_DataReader != null)
{
BIOSUM_VOLUME oNew = new BIOSUM_VOLUME();
oNew.STATECD = Convert.ToInt32(_OracleADO.m_DataReader["STATECD"]);
oNew.COUNTYCD = Convert.ToInt32(_OracleADO.m_DataReader["COUNTYCD"]);
oNew.PLOT = Convert.ToInt32(_OracleADO.m_DataReader["PLOT"]);
oNew.INVYR = Convert.ToInt32(_OracleADO.m_DataReader["INVYR"]);
oNew.TREE = Convert.ToInt32(_OracleADO.m_DataReader["TREE"]);
if (_OracleADO.m_DataReader["VOL_LOC_GRP"] != DBNull.Value)
{
oNew.VOL_LOC_GRP = _OracleADO.m_DataReader["VOL_LOC_GRP"].ToString();
}
if (_OracleADO.m_DataReader["SPCD"] != DBNull.Value)
{
oNew.SPCD = Convert.ToInt32(_OracleADO.m_DataReader["SPCD"]);
}
if (_OracleADO.m_DataReader["DIA"] != DBNull.Value)
{
oNew.DIA = Convert.ToDouble(_OracleADO.m_DataReader["DIA"]);
}
if (_OracleADO.m_DataReader["HT"] != DBNull.Value)
{
oNew.HT = Convert.ToInt32(_OracleADO.m_DataReader["HT"]);
}
if (_OracleADO.m_DataReader["ACTUALHT"] != DBNull.Value)
{
oNew.ACTUALHT = Convert.ToInt32(_OracleADO.m_DataReader["ACTUALHT"]);
}
if (_OracleADO.m_DataReader["CR"] != DBNull.Value)
{
oNew.ACTUALHT = Convert.ToInt32(_OracleADO.m_DataReader["CR"]);
}
oNew.STATUSCD = Convert.ToInt16(_OracleADO.m_DataReader["STATUSCD"]);
if (_OracleADO.m_DataReader["DECAYCD"] != DBNull.Value)
{
oNew.DECAYCD = Convert.ToInt32(_OracleADO.m_DataReader["DECAYCD"]);
}
if (_OracleADO.m_DataReader["TREECLCD"] != DBNull.Value)
{
oNew.TREECLCD = Convert.ToInt32(_OracleADO.m_DataReader["TREECLCD"]);
}
if (_OracleADO.m_DataReader["ROUGHCULL"] != DBNull.Value)
{
oNew.ROUGHCULL = Convert.ToInt32(_OracleADO.m_DataReader["ROUGHCULL"]);
}
if (_OracleADO.m_DataReader["CULL"] != DBNull.Value)
{
oNew.CULL = Convert.ToInt32(_OracleADO.m_DataReader["CULL"]);
}
if (_OracleADO.m_DataReader["TOTAGE"] != DBNull.Value)
{
oNew.TOTAGE = Convert.ToDouble(_OracleADO.m_DataReader["TOTAGE"]);
}
oNew.TRE_CN = _OracleADO.m_DataReader["TRE_CN"].ToString();
oNew.PLT_CN = _OracleADO.m_DataReader["PLT_CN"].ToString();
oNew.CND_CN = _OracleADO.m_DataReader["CND_CN"].ToString();
if (_OracleADO.m_DataReader["VOLCFGRS_CALC"] != DBNull.Value)
{
oNew.VOLCFGRS_CALC = Convert.ToDouble(_OracleADO.m_DataReader["VOLCFGRS_CALC"]);
}
if (_OracleADO.m_DataReader["VOLCSGRS_CALC"] != DBNull.Value)
{
oNew.VOLCSGRS_CALC = Convert.ToDouble(_OracleADO.m_DataReader["VOLCSGRS_CALC"]);
}
if (_OracleADO.m_DataReader["VOLCFNET_CALC"] != DBNull.Value)
{
oNew.VOLCFNET_CALC = Convert.ToDouble(_OracleADO.m_DataReader["VOLCFNET_CALC"]);
}
if (_OracleADO.m_DataReader["DRYBIOM_CALC"] != DBNull.Value)
{
oNew.DRYBIOM_CALC = Convert.ToDouble(_OracleADO.m_DataReader["DRYBIOM_CALC"]);
}
if (_OracleADO.m_DataReader["DRYBIOT_CALC"] != DBNull.Value)
{
oNew.DRYBIOT_CALC = Convert.ToDouble(_OracleADO.m_DataReader["DRYBIOT_CALC"]);
}
if (_OracleADO.m_DataReader["VOLTSGRS_CALC"] != DBNull.Value)
{
oNew.VOLTSGRS_CALC = Convert.ToDouble(_OracleADO.m_DataReader["VOLTSGRS_CALC"]);
}
oList.Add(oNew);
oNew = null;
}
}
_OracleADO.m_DataReader.Close();
_OracleADO.m_DataReader.Dispose();
_OracleADO.m_DataReader = null;
}
if (bCloseConnection)
{
_OracleADO.CloseAndDisposeConnection(_OracleADO.m_Connection, false);
}
if (oList.Count == 0)
{
return(null);
}
else
{
return(oList);
}
}
public static void rowCopyToBIOSUM_VOLUME(System.Data.DataRow p_oRow, BIOSUM_VOLUME p_BIOSUM_VOLUME_ITEM)
{
p_oRow["STATECD"] = p_BIOSUM_VOLUME_ITEM.STATECD;
p_oRow["COUNTYCD"] = p_BIOSUM_VOLUME_ITEM.COUNTYCD;
p_oRow["PLOT"] = p_BIOSUM_VOLUME_ITEM.PLOT;
p_oRow["INVYR"] = p_BIOSUM_VOLUME_ITEM.INVYR;
p_oRow["TREE"] = p_BIOSUM_VOLUME_ITEM.TREE;
if (p_BIOSUM_VOLUME_ITEM.VOL_LOC_GRP != null &&
p_BIOSUM_VOLUME_ITEM.VOL_LOC_GRP.Trim().Length > 0)
{
p_oRow["VOL_LOC_GRP"] = p_BIOSUM_VOLUME_ITEM.VOL_LOC_GRP.ToString();
}
if (p_BIOSUM_VOLUME_ITEM.SPCD != null)
{
p_oRow["SPCD"] = p_BIOSUM_VOLUME_ITEM.SPCD;
}
if (p_BIOSUM_VOLUME_ITEM.DIA != null)
{
p_oRow["DIA"] = Convert.ToDecimal(p_BIOSUM_VOLUME_ITEM.DIA);
}
if (p_BIOSUM_VOLUME_ITEM.HT != null)
{
p_oRow["HT"] = p_BIOSUM_VOLUME_ITEM.HT;
}
if (p_BIOSUM_VOLUME_ITEM.ACTUALHT != null)
{
p_oRow["ACTUALHT"] = p_BIOSUM_VOLUME_ITEM.ACTUALHT;
}
if (p_BIOSUM_VOLUME_ITEM.CR != null)
{
p_oRow["CR"] = p_BIOSUM_VOLUME_ITEM.CR;
}
p_oRow["STATUSCD"] = p_BIOSUM_VOLUME_ITEM.STATUSCD;
if (p_BIOSUM_VOLUME_ITEM.DECAYCD != null)
{
p_oRow["DECAYCD"] = p_BIOSUM_VOLUME_ITEM.DECAYCD;
}
if (p_BIOSUM_VOLUME_ITEM.TREECLCD != null)
{
p_oRow["TREECLCD"] = p_BIOSUM_VOLUME_ITEM.TREECLCD;
}
if (p_BIOSUM_VOLUME_ITEM.ROUGHCULL != null)
{
p_oRow["ROUGHCULL"] = p_BIOSUM_VOLUME_ITEM.ROUGHCULL;
}
if (p_BIOSUM_VOLUME_ITEM.CULL != null)
{
p_oRow["CULL"] = p_BIOSUM_VOLUME_ITEM.CULL;
}
if (p_BIOSUM_VOLUME_ITEM.TOTAGE != null)
{
p_oRow["TOTAGE"] = p_BIOSUM_VOLUME_ITEM.TOTAGE;
}
p_oRow["TRE_CN"] = p_BIOSUM_VOLUME_ITEM.TRE_CN;
p_oRow["PLT_CN"] = p_BIOSUM_VOLUME_ITEM.PLT_CN;
p_oRow["CND_CN"] = p_BIOSUM_VOLUME_ITEM.CND_CN;
}