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