//INSERT COMPANY WITH PROCEDURE
        public string aCompanyPro(string pDbNm, Hashtable param, out Hashtable outVal)
        {
            string reVal = "";

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = "Initial Catalog=PLUS-" + pDbNm + ";";
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db    = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "1");
                reVal = db.aCompanyPro(param, out outVal);
            }
            catch (Exception ex)
            {
                outVal = null;
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::aCompanyPro  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reVal);
        }
        public int aCompanyMemcoSite(string pSiteCd, string pCoCd, string pStartDate, string pEndDate, string pUsingFlag, string pSortNo, string pMemo, string pInputId)
        {
            int reCnt = 0;

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db    = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
                reCnt = db.aCompanyMemcoSite(pSiteCd, pCoCd, pStartDate, pEndDate, pUsingFlag, pSortNo, pMemo, pInputId);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::aCompanyMemcoSite  (Detail)::pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pStartDate=[" + pStartDate + "]" +
                              ", pEndDate=[" + pEndDate + "], pMemo=[" + pUsingFlag + "], pMemo=[" + pSortNo + "], pMemo=[" + pMemo + "], pSortNo=[" + pInputId + "]", "Error");
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::aCompanyMemcoSite  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
        public int mConpanyMainLog(string pCoCd, string pCoNm, string pBizNo, string pConstCcd, string pCoTypeScd, string pOwnerNm, string pTel, string pAddr, string pUsingCnt, string pInputId)
        {
            int reCnt = 0;

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db    = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
                reCnt = db.mConpanyMainLog(pCoCd, pCoNm, pBizNo, pConstCcd, pCoTypeScd, pOwnerNm, pTel, pAddr, pUsingCnt, pInputId);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::mConpanyMainLog  (Detail)::pCoCd=[" + pCoCd + "], pCoNm=[" + pCoNm + "], pBizNo=[" + pBizNo + "]" +
                              ", pConstCcd=[" + pConstCcd + "], pCoTypeScd=[" + pCoTypeScd + "], pOwnerNm=[" + pOwnerNm + "], pTel=[" + pTel + "], pAddr=[" + pAddr + "], pUsingCnt=[" + pUsingCnt + "], pInputId=[" + pInputId + "]", "Error");
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::mConpanyMainLog  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
        public int mCompanyMemco(string pSiteCd, string pCoCd, string pCoNm, string pHeadcoCd, string pConstCcd, string pCoTypeScd, string pSortNo)
        {
            int reCnt = 0;

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db    = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
                reCnt = db.mCompanyMemco(pSiteCd, pCoCd, pCoNm, pHeadcoCd, pConstCcd, pCoTypeScd, pSortNo);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::mCompanyMemco  (Detail)::pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pCoNm=[" + pCoNm + "], pHeadcoCd=[" + pHeadcoCd + "]" +
                              ", pConstCcd=[" + pConstCcd + "], pCoTypeScd=[" + pCoTypeScd + "], pSortNo=[" + pSortNo + "]", "Error");
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::mCompanyMemco  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
        public DataSet sCompany(string pSiteCd, string pUsingFlag, string pCoNm)
        {
            DataSet ds = null;

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
                ds = db.sCompany(pSiteCd, pUsingFlag, pCoNm);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::sCompany  (Detail)::pSiteCd=[" + pSiteCd + "], pUsingFlag=[" + pUsingFlag + "], pCoNm=[" + pCoNm + "]"
                              , "Error");
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::sCompany  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(ds);
        }
        //CO_TYPE CMB BOX WITHOUT NO SELECT
        public DataSet cotype_Cmb2()
        {
            DataSet ds = null;

            DbCompany db = null;

            try
            {
                string dbCon_IP   = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
                string dbCon_DB   = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
                string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;

                db = new DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
                ds = db.cotype_Cmb2();
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizCompany.cs  (Function)::cotype_Cmb2  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(ds);
        }