Exemple #1
0
        public int mSysCodeGrp(string pScodeGrp, string pScodeNm, string pUsingFlag, string pSortNo, string pMemo)
        {
            int reCnt = 0;

            DbSysCodeGrp db = null;

            try
            {
                db    = new DbSysCodeGrp();
                reCnt = db.mSysCodeGrp(pScodeGrp, pScodeNm, pUsingFlag, pSortNo, pMemo);
            }
            catch (Exception ex)
            {
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::mSysCodeGrp  (Detail)::pScodeGrp=[" + pScodeGrp + "], pScodeNm=[" + pScodeNm + "], pUsingFlag=[" + pUsingFlag + "]" +
                             ", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::mSysCodeGrp  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
Exemple #2
0
        public DataSet sSysCode(string pScodeGrp, string pUsingFlag, string pScodeNm)
        {
            DataSet ds = null;

            DbSysCodeGrp db = null;

            try
            {
                db = new DbSysCodeGrp();
                ds = db.sSysCode(pScodeGrp, pUsingFlag, pScodeNm);
            }
            catch (Exception ex)
            {
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::pScodeGrp=[" + pScodeGrp + "], pUsingFlag=[" + pUsingFlag + "], pScodeNm=[" + pScodeNm + "]"
                             , "Error");
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(ds);
        }
Exemple #3
0
        public DataSet fSysCodeSearch(string _scodeGrp, string pScode_Nm)
        {
            DataSet ds = null;

            DbSysCodeGrp db = null;

            try
            {
                string SCODE_NM  = pScode_Nm;
                string SCODE_GRP = _scodeGrp;

                db = new DbSysCodeGrp();
                ds = db.fSysCodeSearch(SCODE_GRP, SCODE_NM);
            }
            catch (Exception ex)
            {
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::pScodeGrp=[" + pScode_Nm + "]", "Error");
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(ds);
        }
Exemple #4
0
        public int exSysCode(string pScode)
        {
            int reCnt = 0;

            DbSysCodeGrp db = null;

            try
            {
                db    = new DbSysCodeGrp();
                reCnt = db.exSysCode(pScode);
            }
            catch (Exception ex)
            {
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::exSysCode  (Detail)::pScode=[" + pScode + "]", "Error");
                logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::exSysCode  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
Exemple #5
0
        public int exSysCodeGrp(string sauthCd_val)
        {
            int reCnt = 0;

            DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
                reCnt = db.exSysCodeGrp(sauthCd_val);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::exSysCodeGrp  (Detail)::pScodeGrp=[" + sauthCd_val + "]", "Error");
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::exSysCodeGrp  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
Exemple #6
0
        public int mSysCodeGrp(string pScodeGrp, string pScodeNm, string pUsingFlag, string pSortNo, string pMemo)
        {
            int reCnt = 0;

            DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
                reCnt = db.mSysCodeGrp(pScodeGrp, pScodeNm, pUsingFlag, pSortNo, pMemo);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::mSysCodeGrp  (Detail)::pScodeGrp=[" + pScodeGrp + "], pScodeNm=[" + pScodeNm + "], pUsingFlag=[" + pUsingFlag + "]" +
                              ", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::mSysCodeGrp  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(reCnt);
        }
Exemple #7
0
        public DataSet sSysCode(string pScodeGrp, string pUsingFlag, string pScodeNm)
        {
            DataSet ds = null;

            DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
                ds = db.sSysCode(pScodeGrp, pUsingFlag, pScodeNm);
            }
            catch (Exception ex)
            {
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::pScodeGrp=[" + pScodeGrp + "], pUsingFlag=[" + pUsingFlag + "], pScodeNm=[" + pScodeNm + "]"
                              , "Error");
                _logs.SaveLog("[error]  (page)::BizSysCodeGrp.cs  (Function)::sSysCode  (Detail)::" + "\r\n" + ex.ToString(), "Error");
            }
            finally
            {
                if (db != null)
                {
                    db.DisConnect();
                }
            }

            return(ds);
        }