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