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