/// <summary> /// 영업마스터 조회 /// </summary> /// <returns></returns> public List <SOMasterVO> GetSOMasterAll(WhereSoVO vo) { using (SqlCommand cmd = new SqlCommand()) { //string sql = "SELECT so_id, plan_id, so_wo_id, company_code, company_type, product_name, so_pcount, so_ocount, so_ccount, so_edate, so_sdate, so_uadmin, so_udate, so_comment FROM TBL_SO_MASTER ORDER BY plan_id ASC"; StringBuilder sql = new StringBuilder(); sql.Append("select so_id, so_wo_id, s.company_code, company_name, p.product_name, p.product_codename, so_pcount, so_ccount, so_ocount, so_comment, so_edate, so_sdate, so_uadmin, so_udate from dbo.TBL_SO_MASTER s inner join dbo.TBL_COMPANY c on s.company_code = c.company_code inner join dbo.TBL_PRODUCT p on s.product_name = p.product_codename where CONVERT (DATETIME, so_edate) >= CONVERT (DATETIME, @startDate) and CONVERT (DATETIME, so_edate) <= CONVERT (DATETIME, @endDate) and CONVERT (DATETIME, so_sdate) >= CONVERT (DATETIME, @regstartDate) and CONVERT (DATETIME, so_sdate) <= CONVERT (DATETIME, @regendDate)"); if (vo.CompanyName != null) { sql.Append(" and company_name = @company_name"); cmd.Parameters.AddWithValue("@company_name", vo.CompanyName); } //p.product_codename을 product_name으로 바꾸기 cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = sql.ToString(); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@startDate", vo.startDate); cmd.Parameters.AddWithValue("@endDate", vo.endDate); cmd.Parameters.AddWithValue("@regstartDate", vo.RegStartDate); cmd.Parameters.AddWithValue("@regendDate", vo.RegEndDate); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <SOMasterVO> list = Helper.DataReaderMapToList <SOMasterVO>(reader); cmd.Connection.Close(); return(list); } }
private void btnSearch_Click(object sender, EventArgs e) { //조회 버튼 WhereSoVO vo = new WhereSoVO(); vo.startDate = dtpStartDate.Value.ToShortDateString(); vo.endDate = dtpEndDate.Value.ToShortDateString(); vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString(); vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString(); if (cboCompany.Text != "선택") { vo.CompanyName = cboCompany.Text; } OrderService service = new OrderService(); try { List <SOMasterVO> list = service.GetSOMasterAll(vo); dataGridView1.DataSource = list; SetBottomStatusLabel("조회가 완료되었습니다."); } catch (Exception err) { LoggingUtility.GetLoggingUtility(err.Message, Level.Error); SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오."); } }
private void SalesMaster_Load(object sender, EventArgs e) { //납기일 초기화 dtpStartDate.Value = DateTime.Now; dtpEndDate.Value = DateTime.Now.AddMonths(+1).AddDays(-1); //등록일 초기화 dtpRegFirstDate.Value = DateTime.Now.AddMonths(-1); dtpRegLastDate.Value = DateTime.Now; OrderService service = new OrderService(); //List<SOMasterVO> list = service.GetSOMasterAll(); //고객사, 도착지 콤보박스 바인딩 CompanyList = new List <CompanyVO>(); try { //datagridview SetDataGrid(); CompanyList = service.GetCompanyAll("cooperative"); ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택"); //DestinationList = new List<CompanyVO>(); //DestinationList = service.GetCompanyAll("cooperative"); //ComboUtil.ComboBinding(cboDestination, DestinationList, "company_code", "company_name", "선택"); //조회 버튼 WhereSoVO vo = new WhereSoVO(); vo.startDate = dtpStartDate.Value.ToShortDateString(); vo.endDate = dtpEndDate.Value.ToShortDateString(); vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString(); vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString(); if (cboCompany.Text != "선택") { vo.CompanyName = cboCompany.Text; } try { List <SOMasterVO> list = service.GetSOMasterAll(vo); dataGridView1.DataSource = list; SetBottomStatusLabel("조회가 완료되었습니다."); } catch (Exception err) { LoggingUtility.GetLoggingUtility(err.Message, Level.Error); SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오."); } } catch (Exception err) { LoggingUtility.GetLoggingUtility(err.Message, Level.Error); } }
private void btnRefresh_Click(object sender, EventArgs e) { //새로고침 버튼 //납기일 초기화 dtpStartDate.Value = DateTime.Now; dtpEndDate.Value = DateTime.Now.AddMonths(+1).AddDays(-1); //등록일 초기화 dtpRegFirstDate.Value = DateTime.Now.AddMonths(-1); dtpRegLastDate.Value = DateTime.Now; cboCompany.SelectedIndex = 0; OrderService service = new OrderService(); WhereSoVO vo = new WhereSoVO(); vo.startDate = dtpStartDate.Value.ToShortDateString(); vo.endDate = dtpEndDate.Value.ToShortDateString(); vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString(); vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString(); if (cboCompany.Text != "선택") { vo.CompanyName = cboCompany.Text; } try { List <SOMasterVO> list = service.GetSOMasterAll(vo); dataGridView1.DataSource = list; SetBottomStatusLabel("조회가 완료되었습니다."); } catch (Exception err) { LoggingUtility.GetLoggingUtility(err.Message, Level.Error); SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오."); } }
public List <SOMasterVO> GetSOMasterAll(WhereSoVO vo) { OrderDac dac = new OrderDac(); return(dac.GetSOMasterAll(vo)); }