Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }