private DataTable Get_Form_Object(string str)
{
ShukkaSiziDataShuturyokuEntity obj = new ShukkaSiziDataShuturyokuEntity();
obj.ShukkaNo1 = txtShukkaNo1.Text;
obj.ShukkaNo2 = txtShukkaNo2.Text;
obj.ShukkaDate1 = txtShukkaDate1.Text;
obj.ShukkaDate2 = txtShukkaDate2.Text;
//obj.InputDate1 = string.IsNullOrEmpty(txtInputDate1.Text) ? baseEntity.LoginDate : txtInputDate1.Text;
//obj.InputDate2 = string.IsNullOrEmpty(txtInputDate2.Text) ? baseEntity.LoginDate : txtInputDate2.Text;
obj.InputDate1 = txtInputDate1.Text; //TaskNo575 HET
obj.InputDate2 = txtInputDate2.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.TokuisakiCD = txtToukuisaki.Text;
obj.KouritenCD = txtKouriten.Text;
if (rdo_MiHakkou.Checked)
{
if (str == string.Empty)
{
obj.Condition = "Mihakkoubunnomi";
}
else
{
obj.Condition = "Mihakkoubunnomi_" + str;
}
}
else
{
obj.Condition = "Hakkou";
}
obj.LoginDate = baseEntity.LoginDate;
DataTable dt = shukkaBL.ShukkaSiziDataShuturyoku_Excel(obj);
return(dt);
}
public DataTable ShukkaSiziDataShuturyoku_Excel(ShukkaSiziDataShuturyokuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[14];
parameters[0] = new SqlParameter("@ShukkaYoteiDate", SqlDbType.VarChar)
{
Value = obj.LoginDate
};
parameters[1] = new SqlParameter("@ShukkaSiziNO1", SqlDbType.VarChar)
{
Value = obj.ShukkaNo1
};
parameters[2] = new SqlParameter("@ShukkaSiziNO2", SqlDbType.VarChar)
{
Value = obj.ShukkaNo2
};
parameters[3] = new SqlParameter("@ShukkaYoteiDate1", SqlDbType.VarChar)
{
Value = obj.ShukkaDate1
};
parameters[4] = new SqlParameter("@ShukkaYoteiDate2", SqlDbType.VarChar)
{
Value = obj.ShukkaDate2
};
parameters[5] = new SqlParameter("@UpdateDateTime1", SqlDbType.VarChar)
{
Value = obj.InputDate1
};
parameters[6] = new SqlParameter("@UpdateDateTime2", SqlDbType.VarChar)
{
Value = obj.InputDate2
};
parameters[7] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = obj.BrandCD
};
parameters[8] = new SqlParameter("@YearTerm", 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.KouritenCD
};
parameters[13] = new SqlParameter("@condition", SqlDbType.VarChar)
{
Value = obj.Condition
};
DataTable dt = ckmdl.SelectDatatable("ShukkaSiziDataShuturyoku_Excel", GetConnectionString(), parameters);
return(dt);
}
