private HacchuuShoEntity Get_UIData()
{
HacchuuShoEntity hse = new HacchuuShoEntity()
{
JuchuuNO1 = txtJuchuuNO1.Text,
JuchuuNO2 = txtJuchuuNO2.Text,
HacchuuNO1 = txtHacchuuNO1.Text,
HacchuuNO2 = txtHacchuuNO2.Text,
InputDate1 = txtInputDate1.Text,
InputDate2 = txtInputDate2.Text,
BrandCD = txtBrandCD.Text,
YearTerm = txtYearTerm.Text,
SS = chkSS.Checked?"1":"",
FW = chkFW.Checked?"1":"",
Rdo_Type = Rdo1.Checked?0:1
};
hse.OperatorCD = OperatorCD;
hse.PC = PCID;
return(hse);
}
public DataTable Get_ExportData(HacchuuShoEntity hse)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[13];
parameters[0] = new SqlParameter("@JuchuuNO1", SqlDbType.VarChar)
{
Value = hse.JuchuuNO1
};
parameters[1] = new SqlParameter("@JuchuuNO2", SqlDbType.VarChar)
{
Value = hse.JuchuuNO2
};
parameters[2] = new SqlParameter("@HacchuuNO1", SqlDbType.VarChar)
{
Value = hse.HacchuuNO1
};
parameters[3] = new SqlParameter("@HacchuuNO2", SqlDbType.VarChar)
{
Value = hse.HacchuuNO2
};
parameters[4] = new SqlParameter("@InputDate1", SqlDbType.VarChar)
{
Value = hse.InputDate1
};
parameters[5] = new SqlParameter("@InputDate2", SqlDbType.VarChar)
{
Value = hse.InputDate2
};
parameters[6] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = hse.BrandCD
};
parameters[7] = new SqlParameter("@YearTerm", SqlDbType.VarChar)
{
Value = hse.YearTerm
};
parameters[8] = new SqlParameter("@SS", SqlDbType.VarChar)
{
Value = hse.SS
};
parameters[9] = new SqlParameter("@FW", SqlDbType.VarChar)
{
Value = hse.FW
};
parameters[10] = new SqlParameter("@Rdo_Type", SqlDbType.TinyInt)
{
Value = hse.Rdo_Type
};
parameters[11] = new SqlParameter("@Opt", SqlDbType.VarChar)
{
Value = hse.OperatorCD
};
parameters[12] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = hse.PC
};
DataTable dt = ckmdl.SelectDatatable("Get_HacchuuSho_ExportData", GetConnectionString(), parameters);
return(dt);
}