frmModalDeviceList.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  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. using System.Collections;
  9. namespace FPER
  10. {
  11. public partial class frmModalDeviceList : Form
  12. {
  13. // cyim 2016.12.07 : 수신기 모델별 내부 로직 변경
  14. public MDIParent mdi = null;
  15. public frmModalDeviceList(MDIParent pMDI)
  16. {
  17. InitializeComponent();
  18. mdi = pMDI;
  19. }
  20. //입력값을 받고, 넘기기위한 VO
  21. private InputIDVo inputVo;
  22. public InputIDVo InputVo { get { return this.inputVo; } set { this.inputVo = value; } }
  23. //코드선택값 넘기는 VO
  24. private SearchCodeVo searchCode;
  25. public SearchCodeVo SearchCode { get { return this.searchCode; } set { this.searchCode = value; } }
  26. private int CommID = 1;
  27. private void frmModalDeviceList_Load(object sender, EventArgs e)
  28. {
  29. try
  30. {
  31. txtReceiverId.Text = String.Format("{0:00}", inputVo.ReceiverID);
  32. //cboBoardId 에 item넣기-통신보드ID
  33. DacBoardConfig dacBoardConfig = new DacBoardConfig(inputVo.ReceiverID); // cyim 2015.7.30 데이타베이스 접속 루틴 변경
  34. ArrayList ary = dacBoardConfig.Board_ListALL(inputVo.ReceiverID);
  35. Util.ComboSetting(cboBoardId, ary, null);
  36. //cboIOBoardID에 item넣기-IO보드
  37. DacIOBoardConfig dacIOBoardConfig = new DacIOBoardConfig(inputVo.ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  38. ArrayList ary1 = dacIOBoardConfig.Board_ListALL(mdi);
  39. Util.ComboSetting(cboIOBoardID, ary1, null);
  40. this.CommID = inputVo.CommID;
  41. if (this.CommID != 1 && this.CommID != 3) this.CommID = 1;
  42. if (this.CommID == 1) tabControl1.SelectedIndex = 0;
  43. else if (this.CommID == 3) tabControl1.SelectedIndex = 1;
  44. dataGridView1.Rows.Clear();
  45. if (searchCode.CodeName != null)
  46. {
  47. if (searchCode.CodeName.Length < 1) searchCode.CodeName = null;
  48. }
  49. txtSearchKey.Text = searchCode.CodeName;
  50. get_Data(null);
  51. }
  52. catch (Exception ex)
  53. {
  54. Util.UErrorMessage(ex, 0, 0);
  55. }
  56. }
  57. private void btnOK_Click(object sender, EventArgs e)
  58. {
  59. try
  60. {
  61. String searchKey = txtSearchKey.Text;
  62. //if (searchKey.Length < 1)
  63. //{
  64. // MessageBox.Show("먼저 검색할 단어를 입력하세요.", Application.ProductName);
  65. // return;
  66. //}
  67. if (tabControl1.SelectedIndex == 0) this.CommID = 1; else this.CommID = 3;
  68. if (searchKey.Equals("")) searchKey = null;
  69. get_Data(searchKey);
  70. }
  71. catch (Exception ex)
  72. {
  73. Util.UErrorMessage(ex, 0, 0);
  74. }
  75. }
  76. private void get_Data(String SearchKey)
  77. {
  78. dataGridView1.Rows.Clear();
  79. try
  80. {
  81. if (searchCode != null)
  82. {
  83. //통신보드
  84. if (this.CommID == 1)
  85. {
  86. String selectedValue1 = cboBoardId.SelectedValue.ToString();
  87. String selectedValue2 = cboLoopNo.SelectedValue.ToString();
  88. String selectedValue3 = cboRepeaterId.SelectedValue.ToString();
  89. int BoardId = Util.StrToInt(selectedValue1, -1);
  90. int LoopNo = Util.StrToInt(selectedValue2, -1);
  91. int RepeaterId = Util.StrToInt(selectedValue3, -1);
  92. DacDeviceConfig dacDeviceConfig = new DacDeviceConfig(this.inputVo.ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  93. DataTable dtable = dacDeviceConfig.Device_Modal_Select(this.inputVo.ReceiverID, BoardId, LoopNo, RepeaterId, -1
  94. , this.inputVo.InoutType, SearchKey);
  95. if (dtable.Rows.Count > 0)
  96. {
  97. foreach (DataRow dr in dtable.Rows)
  98. {
  99. //MI-##-#-###-# :M(구분 M-중계기,I-입력그룹)I,O(회로구분)-##(보드ID)-##(회로ID)
  100. //String dev_id = dr["DEVICE_ID"].ToString();
  101. MskDeviceIDString dev_s = new MskDeviceIDString(int.Parse(dr["COMM_ID"].ToString())
  102. , int.Parse(dr["BOARD_ID"].ToString())
  103. , int.Parse(dr["LOOP_NO"].ToString())
  104. , int.Parse(dr["REPEATER_ID"].ToString())
  105. , int.Parse(dr["DEVICE_ID"].ToString())
  106. , dr["INOUT_TYPE"].ToString());
  107. dataGridView1.Rows.Add(dev_s.MskId
  108. , string.Format("{0}-{1}", dr["DEVICE_TYPE"].ToString(), dr["DEVICE_TYPE_NAME"].ToString())
  109. , string.Format("{0}-{1}", dr["POSITION_CODE"].ToString(), dr["POSITION_NAME"].ToString())
  110. , dr["DEVICE_NAME"].ToString());
  111. }
  112. }
  113. }
  114. //IO보드
  115. else
  116. {
  117. //cboIOBoardID
  118. String selectedValue1 = cboIOBoardID.SelectedValue.ToString();
  119. int BoardId = Util.StrToInt(selectedValue1, -1);
  120. DacIODeviceConfig dacIODeviceConfig = new DacIODeviceConfig(this.inputVo.ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  121. DataTable dtable = dacIODeviceConfig.Device_Modal_Select(this.inputVo.ReceiverID, BoardId, -1
  122. , this.inputVo.InoutType, SearchKey);
  123. if (dtable.Rows.Count > 0)
  124. {
  125. foreach (DataRow dr in dtable.Rows)
  126. {
  127. //MI-##-#-###-# :M(구분 M-중계기,I-입력그룹)I,O(회로구분)-##(보드ID)-##(회로ID)
  128. int board_id = int.Parse(dr["BOARD_ID"].ToString());
  129. // cyim 2016.10.24 : 통신보드 15번 -> 0번카드로 대체
  130. //15번 보드는 기본보드로 선택불가
  131. // cyim 2016.12.07 : 수신기 모델별 내부 로직 변경
  132. int i;
  133. if (mdi.ReceiverModel == "IFC3300")
  134. i = 0;
  135. else
  136. i = 15;
  137. if (board_id != i)
  138. {
  139. MskDeviceIDString dev_s = new MskDeviceIDString(int.Parse(dr["COMM_ID"].ToString())
  140. , int.Parse(dr["BOARD_ID"].ToString())
  141. , int.Parse(dr["LOOP_NO"].ToString())
  142. , int.Parse(dr["REPEATER_ID"].ToString())
  143. , int.Parse(dr["DEVICE_ID"].ToString())
  144. , dr["INOUT_TYPE"].ToString());
  145. dataGridView1.Rows.Add(dev_s.MskId
  146. , string.Format("{0}-{1}", dr["DEVICE_TYPE"].ToString(), dr["DEVICE_TYPE_NAME"].ToString())
  147. , string.Format("{0}-{1}", dr["POSITION_CODE"].ToString(), dr["POSITION_NAME"].ToString())
  148. , dr["DEVICE_NAME"].ToString());
  149. }
  150. }
  151. }
  152. }
  153. }
  154. }
  155. catch (Exception ex)
  156. {
  157. Util.UErrorMessage(ex, 0, 0);
  158. //MessageBox.Show(ex.Message, Application.ProductName);
  159. //MessageBox.Show(string.Format("[{0}]\r\n{1}", ex.Message, ex.StackTrace), Application.ProductName);
  160. }
  161. }
  162. private void btnCancel_Click(object sender, EventArgs e)
  163. {
  164. try
  165. {
  166. this.Close();
  167. }
  168. catch (Exception ex)
  169. {
  170. Util.UErrorMessage(ex, 0, 0);
  171. }
  172. }
  173. private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
  174. {
  175. try
  176. {
  177. int sCommID = 1;
  178. if (tabControl1.SelectedIndex == 0) sCommID = 1; else sCommID = 3;
  179. if (sCommID != this.CommID) btnOK_Click(btnOK, EventArgs.Empty);
  180. }
  181. catch (Exception ex)
  182. {
  183. Util.UErrorMessage(ex, 0, 0);
  184. }
  185. }
  186. private void btnSaveOK_Click(object sender, EventArgs e)
  187. {
  188. try
  189. {
  190. if (dataGridView1.SelectedRows.Count > 0)
  191. {
  192. InputIDVo[] selectVo = new InputIDVo[dataGridView1.SelectedRows.Count];
  193. int rowindx = 0;
  194. foreach (DataGridViewRow row in dataGridView1.SelectedRows)
  195. {
  196. //DataGridViewRow row = dataGridView1.SelectedRows[0];
  197. selectVo[rowindx] = new InputIDVo();
  198. string dev_id_str = row.Cells[0].Value.ToString();
  199. MskDeviceIDString dev_s = new MskDeviceIDString(dev_id_str);
  200. selectVo[rowindx].ReceiverID = Util.StrToInt(txtReceiverId.Text, 0);
  201. selectVo[rowindx].CommID = dev_s.Comm_id;
  202. selectVo[rowindx].BoardID = dev_s.Board_id;
  203. selectVo[rowindx].LoopNo = dev_s.Loop_no;
  204. selectVo[rowindx].RepeaterID = dev_s.Repeater_id;
  205. selectVo[rowindx].DeviceID = dev_s.Device_id;
  206. selectVo[rowindx].InoutType = dev_s.Inout_type;
  207. rowindx++;
  208. }
  209. this.searchCode.SelectObject = selectVo;
  210. this.searchCode.SearchOK = true;
  211. this.Close();
  212. }
  213. else
  214. {
  215. MessageBox.Show("선택된 코드가 없습니다.", Application.ProductName);
  216. return;
  217. }
  218. }
  219. catch (Exception ex)
  220. {
  221. Util.UErrorMessage(ex, 0, 0);
  222. }
  223. }
  224. private void cboBoardId_SelectedIndexChanged(object sender, EventArgs e)
  225. {
  226. try
  227. {
  228. String selectedValue = cboBoardId.SelectedValue.ToString();
  229. int BoardId = Util.StrToInt(selectedValue, -1);
  230. //cboBoardId 에 item넣기-LoopNo
  231. DacBoardConfig dacBoardConfig = new DacBoardConfig(this.inputVo.ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  232. ArrayList ary = dacBoardConfig.Loop_ListALL(this.inputVo.ReceiverID, BoardId);
  233. Util.ComboSetting(cboLoopNo, ary, null);
  234. }
  235. catch (Exception ex)
  236. {
  237. Util.UErrorMessage(ex, 0, 0);
  238. }
  239. }
  240. private void cboLoopNo_SelectedIndexChanged(object sender, EventArgs e)
  241. {
  242. try
  243. {
  244. String selectedValue1 = cboBoardId.SelectedValue.ToString();
  245. String selectedValue2 = cboLoopNo.SelectedValue.ToString();
  246. int BoardId = Util.StrToInt(selectedValue1, -1);
  247. int LoopNo = Util.StrToInt(selectedValue2, -1);
  248. //cboBoardId 에 item넣기-LoopNo
  249. DacRepeaterConfig dacRepeaterConfig = new DacRepeaterConfig(this.inputVo.ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  250. ArrayList ary = dacRepeaterConfig.Repeater_ListALL(this.inputVo.ReceiverID, BoardId, LoopNo);
  251. Util.ComboSetting(cboRepeaterId, ary, null);
  252. }
  253. catch (Exception ex)
  254. {
  255. Util.UErrorMessage(ex, 0, 0);
  256. }
  257. }
  258. }
  259. }