private void btn_cust_search_Click(object sender, EventArgs e)
{
Popup.pop거래처검색영업관리 frm = new Popup.pop거래처검색영업관리();
frm.sCustGbn = "1";
frm.sCustNm = txt_cust_nm.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txt_cust_cd.Text = frm.sCode.Trim();
txt_cust_nm.Text = frm.sName.Trim();
txt_balance.Text = frm.sBalance.Trim();
}
frm.Dispose();
frm = null;
try
{
스마트팩토리.Model.Query.scQuery sc = new 스마트팩토리.Model.Query.scQuery();
DataTable dt = new DataTable();
// dt = sc.selectSalesList(txt_cust_cd.Text.ToString());
}
catch (Exception ex)
{
MessageBox.Show("시스템 오류" + ex.ToString());
}
}
private void btn_search_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
if (txt_cust_nm.Text == null || txt_cust_nm.Text.Equals(""))
{
sb.AppendLine(" WHERE A.SALES_DATE >= '" + start_date.Text + "' and A.SALES_DATE <= '" + end_date.Text + "' ");
}
else
{
Popup.pop거래처검색영업관리 frm = new Popup.pop거래처검색영업관리();
frm.str매출등록 = "2";
frm.sCustGbn = "1";
frm.sCustNm = txt_cust_nm.Text.ToString();
frm.start_date = start_date.Text;
frm.str매출원장 = end_date.Text;
frm.ShowDialog();
sb.AppendLine(" WHERE A.SALES_DATE >= '" + start_date.Text + "' and A.SALES_DATE <= '" + end_date.Text + "' ");
if (frm.sCode != "")
{
txt_cust_cd.Text = frm.sCode.Trim();
txt_cust_nm.Text = frm.sName.Trim();
//old_cust_nm = frm.sCode.Trim();
sb.AppendLine(" and CUST_NM LIKE '%" + txt_cust_nm.Text + "%' ");
}
frm.Dispose();
frm = null;
}
SalesGrid(dgv_Sales, sb.ToString());
}
