public DataSet sSiteSubMenu1(string pDbNm, string pSiteCd, string pTopMenuCd)
{
DataSet ds = null;
DbMainHome 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 DbMainHome(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sSiteSubMenu1(pDbNm, pSiteCd, pTopMenuCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMainHome.cs (Function)::sSiteSubMenu1 (Detail)::pDbNm=[" + pDbNm + "], pSiteCd=[" + pSiteCd + "], pTopMenuCd=[" + pTopMenuCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMainHome.cs (Function)::sSiteSubMenu1 (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
db.DisConnect();
}
return ds;
}
public string sDbNm(string pMemcoCd)
{
string reVal = "";
DbMainHome 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 DbMainHome(dbCon_IP, dbCon_DB, dbCon_USER);
reVal = db.sDbNm(pMemcoCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMainHome.cs (Function)::sDbNm (Detail)::pMemcoCd=[" + pMemcoCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMainHome.cs (Function)::sDbNm (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
db.DisConnect();
}
return reVal;
}