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); }