/*
* --------------------------------------------------------------------
* METHODS
* --------------------------------------------------------------------
*/
#region __METHODS__
/// <summary>
/// select( params_report_WBR_catch prm )
/// </summary>
/// <param name="prm">
/// заполненная структура параметров вызова хранимой процедуры сервера
/// </param>
public void select(params_report_WBR_catch prm)
{
if (
prm.year_1st == 0 || prm.year_2nd == 0 ||
prm.percent == 0 || prm.stat_type.Length == 0
)
{
return;
}
this.data.Clear( );
using (
SqlConnection cnn =
new SqlConnection(Program.db_connection_sting)
)
{
//
SqlCommand cmd = cnn.CreateCommand( );
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[sp_fishing_2years_v3]";
cmd.Parameters.AddRange(
new SqlParameter[]
{
new SqlParameter("@nYear1", prm.year_1st),
new SqlParameter("@nYear2", prm.year_2nd),
new SqlParameter("@nPercent", prm.percent),
new SqlParameter("@StatType", prm.stat_type),
new SqlParameter("@id_subject", prm.id_subject),
new SqlParameter("@id_regime", prm.id_regime),
new SqlParameter("@id_region", prm.id_region),
new SqlParameter("@id_WBR", prm.id_WBR),
new SqlParameter("@id_declarant", prm.id_declarant),
}
);
cnn.Open( );
SqlDataReader reader = cmd.ExecuteReader( );
try
{
while (reader.Read( ))
{
object[] data_row = new object[reader.FieldCount];
reader.GetValues(data_row);
this.data.Add(new data_report_WBR_catch(data_row));
}
}
finally
{
// Always call Close when done reading.
reader.Close( );
}
}//using( cnn )
}
/// <summary>
/// select_report_WBR_catch( params_report_WBR_catch prm )
/// - выборка данных отчёта о вылове за 2 года подряд,
/// где процент освоения менее заданного
/// </summary>
/// <param name="prm">параметры хранимой процедуры сервера</param>
public static void select_report_WBR_catch(params_report_WBR_catch prm)
{
dc_report_WBR_catch dc = new dc_report_WBR_catch( );
dc.select(prm);
if (data_model_store.report_catch_data == null)
{
data_model_store.report_catch_data = new list_report_catch( );
}
data_model_store.report_catch_data = dc.data;
}
