private DataTable Get_Form_Object()
{
JuchuuEntity obj = new JuchuuEntity();
obj.JuhuuDate1 = txtOrderDate1.Text;
obj.JuhuuDate2 = txtOrderDate2.Text;
obj.JuhuuNO1 = txtOrderNo1.Text;
obj.JuhuuNO2 = txtOrderNo2.Text;
obj.InputDate1 = txtInputDate1.Text;
obj.InputDate2 = txtInputDate2.Text;
obj.StaffCD = txtStaffCD.Text;
obj.BrandCD = txtBrand.Text;
obj.Year = txtYear.Text;
obj.SS = chk_SS.Checked == true ? "1" : "0";
obj.FW = chk_FW.Checked == true ? "1" : "0";
obj.Store = txtStore.Text;
obj.DestOrderNo = txtDestOrderNo.Text;
obj.Name = txtName.Text;
obj.YuubinNo1 = txtYubin1.Text;
obj.YuubinNo2 = txtYubin2.Text;
obj.Juusho = txtAddress.Text;
obj.Tel1 = txtPhNo1.Text;
obj.Tel2 = txtPhNo2.Text;
obj.Tel3 = txtPhNo3.Text;
obj.TokuisakiCD = txtTokuisaki.Text;
if (chk.Equals("1") && (!string.IsNullOrEmpty(txtTokuisaki.Text)))
{
obj.Condition = "Tokuisaki";
}
else
{
obj.Condition = "Juchuu";
}
obj.LoginDate = baseEntity.LoginDate;
DataTable dataTable = juchuuListBL.JuchuuList_Excel(obj);
return(dataTable);
}
public DataTable JuchuuList_Excel(JuchuuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[23];
parameters[0] = new SqlParameter("@JuchuuDate1", SqlDbType.VarChar)
{
Value = obj.JuhuuDate1
};
parameters[1] = new SqlParameter("@JuchuuDate2", SqlDbType.VarChar)
{
Value = obj.JuhuuDate2
};
parameters[2] = new SqlParameter("@JuchuuNO1", SqlDbType.VarChar)
{
Value = obj.JuhuuNO1
};
parameters[3] = new SqlParameter("@JuchuuNO2", SqlDbType.VarChar)
{
Value = obj.JuhuuNO2
};
parameters[4] = new SqlParameter("@UpdateDateTime1", SqlDbType.VarChar)
{
Value = obj.InputDate1
};
parameters[5] = new SqlParameter("@UpdateDateTime2", SqlDbType.VarChar)
{
Value = obj.InputDate2
};
parameters[6] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = obj.StaffCD
};
parameters[7] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = obj.BrandCD
};
parameters[8] = new SqlParameter("@Year", SqlDbType.VarChar)
{
Value = obj.Year
};
parameters[9] = new SqlParameter("@SeasonSS", SqlDbType.VarChar)
{
Value = obj.SS
};
parameters[10] = new SqlParameter("@SeasonFW", SqlDbType.VarChar)
{
Value = obj.FW
};
parameters[11] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar)
{
Value = obj.TokuisakiCD
};
parameters[12] = new SqlParameter("@KouritenCD", SqlDbType.VarChar)
{
Value = obj.Store
};
parameters[13] = new SqlParameter("@SenpouHacchuuNO", SqlDbType.VarChar)
{
Value = obj.DestOrderNo
};
parameters[14] = new SqlParameter("@Name", SqlDbType.VarChar)
{
Value = obj.Name
};
parameters[15] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar)
{
Value = obj.YuubinNo1
};
parameters[16] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar)
{
Value = obj.YuubinNo2
};
parameters[17] = new SqlParameter("@Juusho", SqlDbType.VarChar)
{
Value = obj.Juusho
};
parameters[18] = new SqlParameter("@Tel1", SqlDbType.VarChar)
{
Value = obj.Tel1
};
parameters[19] = new SqlParameter("@Tel2", SqlDbType.VarChar)
{
Value = obj.Tel2
};
parameters[20] = new SqlParameter("@Tel3", SqlDbType.VarChar)
{
Value = obj.Tel3
};
parameters[21] = new SqlParameter("@condition", SqlDbType.VarChar)
{
Value = obj.Condition
};
parameters[22] = new SqlParameter("@JuchuuDate", SqlDbType.VarChar)
{
Value = obj.LoginDate
};
//parameters[22] = new SqlParameter("@Year_1", SqlDbType.VarChar) { Value = "年" };
DataTable dt = ckmdl.SelectDatatable("JuchuuList_Excel", GetConnectionString(), parameters);
return(dt);
}
