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