1522b16d92bc155f05bccac28f45481f9bccbe5c.svn-base 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Text;
  7. using System.Windows.Forms;
  8. namespace FPER
  9. {
  10. public partial class frmModalDeviceType : Form
  11. {
  12. public int ReceiverID = 0;
  13. public frmModalDeviceType(int ID)// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  14. {
  15. InitializeComponent();
  16. ReceiverID = ID;
  17. }
  18. private SearchCodeVo searchCode;
  19. public SearchCodeVo SearchCode { get { return this.searchCode; } set { this.searchCode = value; } }
  20. private void frmModalDeviceType_Load(object sender, EventArgs e)
  21. {
  22. try
  23. {
  24. dataGridView1.Rows.Clear();
  25. if (searchCode.CodeType != null)
  26. {
  27. if (searchCode.CodeType.Length < 1) searchCode.CodeType = null;
  28. }
  29. if (searchCode.CodeName != null)
  30. {
  31. if (searchCode.CodeName.Length < 1) searchCode.CodeName = null;
  32. }
  33. txtSearchKey.Text = searchCode.CodeName;
  34. get_Data(searchCode.CodeType, null);
  35. }
  36. catch (Exception ex)
  37. {
  38. Util.UErrorMessage(ex, 0, 0);
  39. }
  40. }
  41. private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
  42. {
  43. try
  44. {
  45. //셀 더블클릭시
  46. if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
  47. {
  48. string CodeValue = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
  49. string CodeName = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
  50. this.searchCode.Code = CodeValue;
  51. this.searchCode.CodeName = CodeName;
  52. this.searchCode.SearchOK = true;
  53. this.Close();
  54. }
  55. }
  56. catch (Exception ex)
  57. {
  58. Util.UErrorMessage(ex, 0, 0);
  59. }
  60. }
  61. private void btnOK_Click(object sender, EventArgs e)
  62. {
  63. try
  64. {
  65. String searchKey = txtSearchKey.Text;
  66. //if (searchKey.Length < 1)
  67. //{
  68. // MessageBox.Show("먼저 검색할 단어를 입력하세요.", Application.ProductName);
  69. // return;
  70. //}
  71. if (searchKey.Equals("")) searchKey = null;
  72. get_Data(searchCode.CodeType, searchKey);
  73. }
  74. catch (Exception ex)
  75. {
  76. Util.UErrorMessage(ex, 0, 0);
  77. }
  78. }
  79. private void get_Data(String CodeType, String SearchKey)
  80. {
  81. dataGridView1.Rows.Clear();
  82. try
  83. {
  84. if (searchCode != null)
  85. {
  86. DacDeviceConfig dacDeviceConfig = new DacDeviceConfig(ReceiverID); // cyim 2015.7.30 데이타베이스 접속 루틴 변경
  87. DataTable dtable = dacDeviceConfig.Device_Type_Modal_Select(CodeType, SearchKey);
  88. if (dtable.Rows.Count > 0)
  89. {
  90. foreach (DataRow dr in dtable.Rows)
  91. {
  92. dataGridView1.Rows.Add(dr["SYMBOL_TYPE"].ToString(), dr["DEVICE_TYPE"].ToString(), dr["DEVICE_TYPE_NAME"].ToString());
  93. }
  94. }
  95. }
  96. }
  97. catch (Exception ex)
  98. {
  99. Util.UErrorMessage(ex, 0, 0);
  100. //MessageBox.Show(ex.Message, Application.ProductName);
  101. //MessageBox.Show(string.Format("[{0}]\r\n{1}", ex.Message, ex.StackTrace), Application.ProductName);
  102. }
  103. }
  104. private void txtSearchKey_KeyDown(object sender, KeyEventArgs e)
  105. {
  106. //엔터키 입력시 확인버튼으로 포커스
  107. if (e.KeyCode == Keys.Enter)
  108. {
  109. btnOK_Click(btnOK, EventArgs.Empty);
  110. }
  111. }
  112. private void btnCancel_Click(object sender, EventArgs e)
  113. {
  114. try
  115. {
  116. this.Close();
  117. }
  118. catch (Exception ex)
  119. {
  120. Util.UErrorMessage(ex, 0, 0);
  121. }
  122. }
  123. private void btnSaveOK_Click(object sender, EventArgs e)
  124. {
  125. try
  126. {
  127. if (dataGridView1.SelectedRows.Count > 0)
  128. {
  129. DataGridViewRow row = dataGridView1.SelectedRows[0];
  130. string CodeValue = row.Cells[1].Value.ToString();
  131. string CodeName = row.Cells[2].Value.ToString();
  132. this.searchCode.Code = CodeValue;
  133. this.searchCode.CodeName = CodeName;
  134. this.searchCode.SearchOK = true;
  135. this.Close();
  136. }
  137. else
  138. {
  139. MessageBox.Show("선택된 코드가 없습니다.", Application.ProductName);
  140. return;
  141. }
  142. }
  143. catch (Exception ex)
  144. {
  145. Util.UErrorMessage(ex, 0, 0);
  146. }
  147. }
  148. }
  149. }