//INSERT WITH PROCEDURE public string aDevicePro(string pDbNm, string[] param, out string reData, out string reMsg) { string reCode = "N"; string reVal = ""; BizDevice bizSys = null; try { bizSys = new BizDevice(); try { Hashtable hParam = new Hashtable(); hParam.Add("pSiteCd", Convert.ToInt32(param[0])); hParam.Add("pDeviceId", Convert.ToInt32(param[1])); hParam.Add("pDevTypeScd", param[2].ToString()); hParam.Add("pDevIOScd", param[3].ToString()); hParam.Add("pDevNm", param[4].ToString()); hParam.Add("pIp", param[5].ToString()); hParam.Add("pUsingFlag", Convert.ToInt32(param[6])); hParam.Add("pSortNo", Convert.ToInt32(param[7])); hParam.Add("pMemo", param[8].ToString()); hParam.Add("pUserId", Convert.ToInt32(param[9])); hParam.Add("@rtnDevCd", ""); reVal = bizSys.aDevicePro(pDbNm, hParam, out Hashtable outVal); if (outVal != null) { foreach (DictionaryEntry dictionaryEntry in outVal) { string[] row = new string[] { dictionaryEntry.Key.ToString(), dictionaryEntry.Value.ToString(), "" }; //string rowCount = row.Length.ToString(); //string rowKey = row[0].ToString(); reVal = row[1].ToString(); } } reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString(); reCode = "N"; } reData = reVal; return(reCode); }