public HarvestActivityManager()
: base()
{
this.cmdPopulateHarv = new SqlCommand("dbo.p_rsm_LoadHarvActivity",connRSM);
this.cmdPopulateHarv.CommandType = System.Data.CommandType.StoredProcedure;
this.cmdPopulateHarv.Parameters.Add("@runID",System.Data.SqlDbType.Int);
this.cmdPopulateHarv.Parameters.Add("@projectionid",System.Data.SqlDbType.VarChar,30);
this.cmdPopulateHarv.Parameters.Add("@lnversionid",System.Data.SqlDbType.Int);
cmdSelectByRunHarv = new SqlCommand("select * from rsm_harvestactivity where runid = @runid and harvestunitname = @harvestunitname and lnversionid = @lnversionid and enabledharv = 1", connRSM);
cmdSelectByRunHarv.Parameters.Add("@runid", SqlDbType.Int);
cmdSelectByRunHarv.Parameters.Add("@lnversionid", SqlDbType.Int);
cmdSelectByRunHarv.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 30);
cmdUpdateEnabled = new SqlCommand("update rsm_HarvestActivity set enabledharv = @enabled where harvestunitname = @harvestunitname and runid = @runid and lnversionid = @lnversionid", connRSM);
cmdUpdateEnabled.Parameters.Add("@runid", SqlDbType.Int);
cmdUpdateEnabled.Parameters.Add("@lnversionid", SqlDbType.Int);
cmdUpdateEnabled.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 30);
cmdUpdateEnabled.Parameters.Add("@enabled", SqlDbType.Int);
modelRunManager = new ModelRunManager();
daData = new SqlDataAdapter("select * from rsm_harvestactivity",connRSM);
cbData= new SqlCommandBuilder(daData);
cmdSelectHarvestUnits = new SqlCommand("select harvestunitname from rsm_harvestunits where lnversionid = @lnversionid", connRSM);
cmdSelectHarvestUnits.Parameters.Add("@lnversionid", SqlDbType.Int);
}
public HarvestActivityManager() : base()
{
this.cmdPopulateHarv = new SqlCommand("dbo.p_rsm_LoadHarvActivity", connRSM);
this.cmdPopulateHarv.CommandType = System.Data.CommandType.StoredProcedure;
this.cmdPopulateHarv.Parameters.Add("@runID", System.Data.SqlDbType.Int);
this.cmdPopulateHarv.Parameters.Add("@projectionid", System.Data.SqlDbType.VarChar, 30);
this.cmdPopulateHarv.Parameters.Add("@lnversionid", System.Data.SqlDbType.Int);
cmdSelectByRunHarv = new SqlCommand("select * from rsm_harvestactivity where runid = @runid and harvestunitname = @harvestunitname and lnversionid = @lnversionid and enabledharv = 1", connRSM);
cmdSelectByRunHarv.Parameters.Add("@runid", SqlDbType.Int);
cmdSelectByRunHarv.Parameters.Add("@lnversionid", SqlDbType.Int);
cmdSelectByRunHarv.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 30);
cmdUpdateEnabled = new SqlCommand("update rsm_HarvestActivity set enabledharv = @enabled where harvestunitname = @harvestunitname and runid = @runid and lnversionid = @lnversionid", connRSM);
cmdUpdateEnabled.Parameters.Add("@runid", SqlDbType.Int);
cmdUpdateEnabled.Parameters.Add("@lnversionid", SqlDbType.Int);
cmdUpdateEnabled.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 30);
cmdUpdateEnabled.Parameters.Add("@enabled", SqlDbType.Int);
modelRunManager = new ModelRunManager();
daData = new SqlDataAdapter("select * from rsm_harvestactivity", connRSM);
cbData = new SqlCommandBuilder(daData);
cmdSelectHarvestUnits = new SqlCommand("select harvestunitname from rsm_harvestunits where lnversionid = @lnversionid", connRSM);
cmdSelectHarvestUnits.Parameters.Add("@lnversionid", SqlDbType.Int);
}
