示例#1
0
        //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);
        }