private DataTable Get_Form_Object()
{
HacchuuEntity obj = new HacchuuEntity();
obj.HacchuuNO1 = txtHacchuuNO1.Text;
obj.HacchuuNO2 = txtHacchuuNO2.Text;
obj.HacchuuDate1 = txtHacchuuDate1.Text;
obj.HacchuuDate2 = txtHacchuuDate2.Text;
//obj.Hacchuu_UpdateDate1 = string.IsNullOrEmpty(txtUpdate_HacchuuDate1.Text) ? baseEntity.LoginDate : txtUpdate_HacchuuDate1.Text;
//obj.Hacchuu_UpdateDate2 = string.IsNullOrEmpty(txtUpdate_HacchuuDate2.Text) ? baseEntity.LoginDate : txtUpdate_HacchuuDate2.Text;
obj.Hacchuu_UpdateDate1 = txtUpdate_HacchuuDate1.Text; //TaskNo575 HET
obj.Hacchuu_UpdateDate2 = txtUpdate_HacchuuDate2.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.JuchuuDate1 = txtJuchuuDate1.Text;
obj.JuchuuDate2 = txtJuchuuDate2.Text;
obj.JuchuuNO1 = txtJuchuuNO1.Text;
obj.JuchuuNO2 = txtJuchuuNO2.Text;
obj.Juchuu_UpdateDate1 = txtUpdate_JuchuuDate1.Text;
obj.Juchuu_UpdateDate2 = txtUpdate_JuchuuDate2.Text;
if (rdo_Hac.Checked)
{
obj.Condition = "Hacchuu";
}
else
{
obj.Condition = "Juchuu";
}
obj.LoginDate = baseEntity.LoginDate;
DataTable dt = obj_Bl.GetHacchuuList(obj);
return(dt);
}
public DataTable GetHacchuuList(HacchuuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[19];
parameters[0] = new SqlParameter("@HacchuDate1", SqlDbType.VarChar)
{
Value = obj.HacchuuDate1
};
parameters[1] = new SqlParameter("@HacchuDate2", SqlDbType.VarChar)
{
Value = obj.HacchuuDate2
};
parameters[2] = new SqlParameter("@Update_HacchuDate1", SqlDbType.VarChar)
{
Value = obj.Hacchuu_UpdateDate1
};
parameters[3] = new SqlParameter("@Update_HacchuDate2", SqlDbType.VarChar)
{
Value = obj.Hacchuu_UpdateDate2
};
parameters[4] = new SqlParameter("@HacchuNO1", SqlDbType.VarChar)
{
Value = obj.HacchuuNO1
};
parameters[5] = new SqlParameter("@HacchuNO2", SqlDbType.VarChar)
{
Value = obj.HacchuuNO2
};
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("@SS", SqlDbType.VarChar)
{
Value = obj.SS
};
parameters[10] = new SqlParameter("@FW", SqlDbType.VarChar)
{
Value = obj.FW
};
parameters[11] = new SqlParameter("@condition", SqlDbType.VarChar)
{
Value = obj.Condition
};
parameters[12] = new SqlParameter("@JuchuuDate1", SqlDbType.VarChar)
{
Value = obj.JuchuuDate1
};
parameters[13] = new SqlParameter("@JuchuuDate2", SqlDbType.VarChar)
{
Value = obj.JuchuuDate2
};
parameters[14] = new SqlParameter("@Update_JuchuuDate1", SqlDbType.VarChar)
{
Value = obj.Juchuu_UpdateDate1
};
parameters[15] = new SqlParameter("@Update_JuchuuDate2", SqlDbType.VarChar)
{
Value = obj.Juchuu_UpdateDate2
};
parameters[16] = new SqlParameter("@JuchuuNO1", SqlDbType.VarChar)
{
Value = obj.JuchuuNO1
};
parameters[17] = new SqlParameter("@JuchuuNO2", SqlDbType.VarChar)
{
Value = obj.JuchuuNO2
};
parameters[18] = new SqlParameter("@HacchuDate", SqlDbType.VarChar)
{
Value = obj.LoginDate
};
DataTable dt = ckmdl.SelectDatatable("Hacchuu_Search", GetConnectionString(), parameters);
return(dt);
}
