public DataSet sSite(string pMemcoCd, string pUsingFlag)
{
DataSet ds = null;
DbSite 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 DbSite(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sSite(pMemcoCd, pUsingFlag);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSite.cs (Function)::sSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//DUPLICATE CHECK
public int exSite(string pSiteNm)
{
int reCnt = 0;
DbSite 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 DbSite(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.exSite(pSiteNm);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSite.cs (Function)::exSite (Detail)::pSiteNm=[" + pSiteNm + "]", "Error");
logs.SaveLog("[error] (page)::BizSite.cs (Function)::exSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public string aSite(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbSite 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 DbSite(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.aSite(param, out outVal);
}
catch (Exception ex)
{
outVal = null;
//logs.SaveLog("[error] (page)::BizSite.cs (Function)::aSite (Detail)::memcoCd_val=[" + memcoCd_val + "], siteNm_val=[" + siteNm_val + "], usingFlag_val=[" + usingFlag_val + "]" +
// ", sortNo_val=[" + sortNo_val + "], pInputId=[" + pInputId + "]", "Error");
logs.SaveLog("[error] (page)::BizSite.cs (Function)::aSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int mSite(string siteCd_val, string siteNm_val, string usingFlag_val, string sortNo_val, string memo_val)
{
int reCnt = 0;
DbSite 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 DbSite(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mSite(siteCd_val, siteNm_val, usingFlag_val, sortNo_val, memo_val);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSite.cs (Function)::mSite (Detail)::siteCd_val=[" + siteCd_val + "], siteNm_val=[" + siteNm_val + "]" +
", usingFlag_val=[" + usingFlag_val + "], sortNo_val=[" + sortNo_val + "], memo_val=[" + memo_val + "]", "Error");
logs.SaveLog("[error] (page)::BizSite.cs (Function)::mSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}