using ClientLib; using ClientLib.CommonService2; using DevExpress.XtraEditors; using PublicLib; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Reflection; using System.Text; using System.Threading; using System.Windows.Forms; namespace HANMI_STD { partial class SelectCurrentMoneyGroupForm : XtraForm { public string m_CUST_CD; public string m_CUST_NN; public string m_TEL_NO; public string m_OWNER_TEL_NO; public string m_MGR_TEL_NO; public string m_GROUP_CD = ""; public string m_ITEM_CD = ""; public SelectCurrentMoneyGroupForm(string cust_nm, string group_cd, string item_cd) { InitializeComponent(); textEdit_Search.Text = cust_nm; m_GROUP_CD = group_cd; m_ITEM_CD = item_cd; radioGroup_CUST_KIND.Properties.Items.Clear(); DataView cust_kind = new DataView(ConstClass._DATA); cust_kind.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C06'"; foreach (DataRowView row in cust_kind) { radioGroup_CUST_KIND.Properties.Items.Add(new DevExpress.XtraEditors.Controls.RadioGroupItem(UtilClass.toStr(row["NO_CD"]), UtilClass.toStr(row["NO_CD_NM"]))); } radioGroup_CUST_KIND.Properties.Items.Add(new DevExpress.XtraEditors.Controls.RadioGroupItem("", "전체")); this.Shown += (sender, e) => { searchProc(); }; textEdit_Search.KeyPress += (sender, e) => { if (e.KeyChar == '\r') { searchProc(); } }; simpleButton_Text_Clear.Click += (sender, e) => { textEdit_Search.Text = ""; }; simpleButton_Search.Click += (sender, e) => { searchProc(); }; radioGroup_CUST_KIND.EditValueChanged += (sender, e) => { searchProc(); }; radioGroup_ORDER_BY.EditValueChanged += (sender, e) => { searchProc(); }; radioGroup_CUST_NAME_GBN.EditValueChanged += (sender, e) => { searchProc(); }; gridView_Main.KeyPress += (sender, e) => { if (e.KeyChar == '\r') { DataRow row = gridView_Main.GetFocusedDataRow(); try { if (row != null) { this.Cursor = Cursors.WaitCursor; DataTable aData = new DataTable(); ResultData[] dataList = null; ResultData data1 = new ResultData(); SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar,row["CUST_CD"].ToString()), ClientClass.CreateSqlParameter("RUN_RESULT", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000) }; ResultData result = ClientClass.SetTableData("U3SaveCurrentmoneyPopup", dataList, aParam); if (result.isError || !UtilClass.isNull(result.ResultValue)) { throw new Exception(result.ResultValue); } this.Cursor = Cursors.Arrow; } } catch (Exception ex) { this.Cursor = Cursors.Arrow; XtraMessageBox.Show(ex.Message); } searchProc_GROUP(); } }; gridView_Group.KeyPress += (sender, e) => { if (e.KeyChar == '\r') { DataRow row = gridView_Group.GetFocusedDataRow(); try { if (row != null) { this.Cursor = Cursors.WaitCursor; DataTable aData = new DataTable(); ResultData[] dataList = null; ResultData data1 = new ResultData(); SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar,row["CUST_CD"].ToString()), ClientClass.CreateSqlParameter("RUN_RESULT", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000) }; ResultData result = ClientClass.SetTableData("U3DeleteCurrentmoneyPopup", dataList, aParam); if (result.isError || !UtilClass.isNull(result.ResultValue)) { throw new Exception(result.ResultValue); } searchProc_GROUP(); this.Cursor = Cursors.Arrow; } } catch (Exception ex) { this.Cursor = Cursors.Arrow; XtraMessageBox.Show(ex.Message); } } }; gridView_Group.DoubleClick += (sender, e) => { DataRow row = gridView_Group.GetFocusedDataRow(); try { if (row != null) { this.Cursor = Cursors.WaitCursor; DataTable aData = new DataTable(); ResultData[] dataList = null; ResultData data1 = new ResultData(); SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar,row["CUST_CD"].ToString()), ClientClass.CreateSqlParameter("RUN_RESULT", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000) }; ResultData result = ClientClass.SetTableData("U3DeleteCurrentmoneyPopup", dataList, aParam); if (result.isError || !UtilClass.isNull(result.ResultValue)) { throw new Exception(result.ResultValue); } searchProc_GROUP(); this.Cursor = Cursors.Arrow; } } catch (Exception ex) { this.Cursor = Cursors.Arrow; XtraMessageBox.Show(ex.Message); } }; gridView_Main.DoubleClick += (sender, e) => { DataRow row = gridView_Main.GetFocusedDataRow(); try { if (row != null) { this.Cursor = Cursors.WaitCursor; DataTable aData = new DataTable(); ResultData[] dataList = null; ResultData data1 = new ResultData(); SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar,row["CUST_CD"].ToString()), ClientClass.CreateSqlParameter("RUN_RESULT", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000) }; ResultData result = ClientClass.SetTableData("U3SaveCurrentmoneyPopup", dataList, aParam); if (result.isError || !UtilClass.isNull(result.ResultValue)) { throw new Exception(result.ResultValue); } searchProc_GROUP(); this.Cursor = Cursors.Arrow; } } catch (Exception ex) { this.Cursor = Cursors.Arrow; XtraMessageBox.Show(ex.Message); } }; simpleButton_OK.Click += (sender, e) => { DataRow row = gridView_Main.GetFocusedDataRow(); try { if (row != null) { this.Cursor = Cursors.WaitCursor; DataTable aData = new DataTable(); ResultData[] dataList = null; ResultData data1 = new ResultData(); SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar,row["CUST_CD"].ToString()), ClientClass.CreateSqlParameter("RUN_RESULT", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000) }; ResultData result = ClientClass.SetTableData("U3SaveCurrentmoneyPopup", dataList, aParam); if (result.isError || !UtilClass.isNull(result.ResultValue)) { throw new Exception(result.ResultValue); } searchProc_GROUP(); this.Cursor = Cursors.Arrow; } } catch (Exception ex) { this.Cursor = Cursors.Arrow; XtraMessageBox.Show(ex.Message); } }; simpleButton_Cancel.Click += (sender, e) => { this.DialogResult = DialogResult.Cancel; this.Close(); }; } public void searchProc() { try { this.Cursor = Cursors.WaitCursor; gridControl_Main.DataSource = null; SerializedSqlParam[] aParam = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("CUST_KIND", SqlDbType.NVarChar, radioGroup_CUST_KIND.EditValue), ClientClass.CreateSqlParameter("ORDER_BY", SqlDbType.Int, radioGroup_ORDER_BY.EditValue), ClientClass.CreateSqlParameter("DEL_YN", SqlDbType.NVarChar, checkBox_DEL_YN.Checked ? 'N':'Y'), ClientClass.CreateSqlParameter("CUST_NAME_GBN", SqlDbType.Int, radioGroup_CUST_NAME_GBN.EditValue), ClientClass.CreateSqlParameter("SEARCH", SqlDbType.NVarChar, textEdit_Search.Text) }; ResultData resultData = ClientClass.GetData("U3GetCustSelectPopup", aParam); if (resultData.isError) { throw new Exception(resultData.ResultValue); } gridControl_Main.DataSource = resultData.TableData; gridView_Main.Focus(); searchProc_GROUP(); this.Cursor = Cursors.Arrow; } catch (Exception ex) { this.Cursor = Cursors.Arrow; MessageBox.Show(ex.Message); } } public void searchProc_GROUP() { try { this.Cursor = Cursors.WaitCursor; gridControl_Group.DataSource = null; SerializedSqlParam[] aParam2 = new SerializedSqlParam[] { ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD), ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, m_ITEM_CD), ClientClass.CreateSqlParameter("GRP_CD", SqlDbType.NVarChar, m_GROUP_CD) }; ResultData resultData2 = ClientClass.GetData("U3GetCurrentMoneyPopup", aParam2); if (resultData2.isError) { throw new Exception(resultData2.ResultValue); } gridControl_Group.DataSource = resultData2.TableData; gridControl_Group.Focus(); this.Cursor = Cursors.Arrow; } catch (Exception ex) { this.Cursor = Cursors.Arrow; MessageBox.Show(ex.Message); } } } }