private void btnSearch_Click(object sender, EventArgs e)
{
//조회 버튼
try
{
SupplierVO vo = new SupplierVO();
vo.order_state = "O_COMPLETE";
vo.start_date = dtpStartDate.Value.ToShortDateString();
vo.end_date = dtpEndDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.company_name = cboCompany.Text;
}
if (txtOrderID.Text != "")
{
vo.order_id = txtOrderID.Text;
}
SetDataGridWatingReceiving();
SetDataGridResult();
SupplierService service = new SupplierService();
dt = service.GetAlreadyOrderList(vo);
dgvWatingReceive.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//조회 버튼
try
{
SupplierVO vo = new SupplierVO();
vo.start_date = dtpStartDate.Value.ToShortDateString();
vo.end_date = dtpEndDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.company_name = cboCompany.Text;
}
if (cboOrderState.Text != "선택")
{
vo.order_state = cboOrderState.SelectedValue.ToString();
}
MaterialLedgerService service = new MaterialLedgerService();
dt = service.GetWatingReceivingList(vo);
dgvWatingList.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
public DataTable GetWatingReceivingList(SupplierVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
StringBuilder sql = new StringBuilder();
sql.Append($"select order_serial, concat(LEFT(order_serial, 4),'-',SUBSTRING(order_serial, 5,2),'-',SUBSTRING(order_serial, 7,2)) as order_ddate, c.company_name, p.product_codename, product_name, o.order_count, o.order_pdate, cc.common_name, o.order_sdate from TBL_ORDER o inner join TBL_PRODUCT p on o.product_id = p.product_id inner join TBL_COMPANY c on p.product_demand_com = c.company_code inner join TBL_COMMON_CODE cc on o.order_state = cc.common_value where CONVERT (DATETIME, o.order_pdate) >= CONVERT (DATETIME, @startDate) and CONVERT (DATETIME, o.order_pdate) <= CONVERT (DATETIME, @endDate)");
if (vo.company_name != null)
{
sql.Append(" and company_name = @company_name");
cmd.Parameters.AddWithValue("@company_name", vo.company_name);
}
if (vo.order_state != null)
{
sql.Append($" and order_state = @order_state");
cmd.Parameters.AddWithValue("@order_state", vo.order_state);
}
else
{
sql.Append($" and order_state != 'P_COMPLETE'");
}
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = sql.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@startDate", vo.start_date);
cmd.Parameters.AddWithValue("@endDate", vo.end_date);
DataTable dataTable = new DataTable();
cmd.Connection.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dataTable);
da.Dispose();
cmd.Connection.Close();
return(dataTable);
}
}
public DataTable GetWatingReceivingList(SupplierVO vo)
{
MaterialLedgerDAC dac = new MaterialLedgerDAC();
return(dac.GetWatingReceivingList(vo));
}
public DataTable GetOrderList(SupplierVO vo)
{
PurchasingDAC dac = new PurchasingDAC();
return(dac.GetOrderList(vo));
}
public DataTable GetAlreadyOrderList(SupplierVO vo)
{
SupplierDAC dac = new SupplierDAC();
return(dac.GetAlreadyOrderList(vo));
}
