public int aComnCodeGrp(string pCcodeGrp, string pCcodeGrpNm, string pUsingFlag, string pSortNo, string pMemo, string pInputId)
{
int reCnt = 0;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aComnCodeGrp(pCcodeGrp, pCcodeGrpNm, pUsingFlag, pSortNo, pMemo, pInputId);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aComnCodeGrp (Detail)::, pScodeGrp=[" + pCcodeGrp + "], Grp=[" + pCcodeGrpNm + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "], pInputId=[" + pInputId + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aComnCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sComnCodeGrpUsingFlag()
{
DataSet ds = null;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sComnCodeGrpUsingFlag();
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::sComnCodeGrp (Detail)::pScodeGrp=[ ]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::sComnCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public string aComnSite(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.aComnSite(param, out outVal);
}
catch (Exception ex)
{
outVal = null;
//logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aComnSite (Detail)::memcoCd_val=[" + memcoCd_val + "], siteNm_val=[" + siteNm_val + "], usingFlag_val=[" + usingFlag_val + "]" +
// ", sortNo_val=[" + sortNo_val + "], pInputId=[" + pInputId + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aComnSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int mComnSite(string pDbnm, string pSiteCd, string pCcode, string pUsingFlag, string pSortNo, string pMemo)
{
int reCnt = 0;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mComnSite(pDbnm, pSiteCd, pCcode, pUsingFlag, pSortNo, pMemo);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::mComnSite (Detail):: pDbnm=['" + pDbnm + "'], pSiteCd =['" + pSiteCd + "']" +
", pCcode=['" + pCcode + "'], pUsingFlag=[" + pUsingFlag + "], pSortNo=[" + pSortNo + "]" + ", pMemo=[" + pMemo + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::mComnSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int aSetAuthSiteMemberDB(string pDbnm, string pSiteCd, string pAuthCd, string pCcodeGrp, string pViewFlag, string pNewFlag, string pModifyFlag, string pDelFlag, string pReportFlag, string pPrintFlag, string pDownloadFlag, string pInputId)
{
int reCnt = 0;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aSetAuthSiteMemberDB(pDbnm, pSiteCd, pAuthCd, pCcodeGrp, pViewFlag, pNewFlag, pModifyFlag, pDelFlag, pReportFlag, pPrintFlag, pDownloadFlag, pInputId);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aSetAuthSiteMemberDB (Detail)::, pDbnm=['" + pDbnm + "'], pSiteCd=[" + pSiteCd + "]" +
", pCcodeGrp=['" + pCcodeGrp + "'], pAuthCd=['" + pAuthCd + "'], pViewFlag=[" + pViewFlag + "]" +
", pNewFlag=[" + pNewFlag + "], pModifyFlag =[" + pModifyFlag + "], pDelFlag=[" + pDelFlag + "], pReportFlag=[" + pReportFlag + "]" +
", pPrintFlag =[" + pPrintFlag + "], pDownloadFlag =[" + pDownloadFlag + "], pInputId =[" + pInputId + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::aSetAuthSiteMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sSetAuthSiteMemberDBSub(string pCcodeGrp, string pDbnm, string pSiteCd, string pAuthCd)
{
DataSet ds = null;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sSetAuthSiteMemberDBSub(pCcodeGrp, pDbnm, pSiteCd, pAuthCd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::sSetAuthSiteMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public string siteDbNm(string pSiteCd)
{
string reVal = "";
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reVal = db.siteDbNm(pSiteCd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::siteDbNm (Detail)::pSiteCd=[" + pSiteCd + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::siteDbNm (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int exComnCodeGrp(string pCcodeGrp)
{
int reCnt = 0;
DbComnCodeGrpMainDB 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 DbComnCodeGrpMainDB(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.exComnCodeGrp(pCcodeGrp);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::exComnCodeGrp (Detail)::pCcodeGrp=[" + pCcodeGrp + "]", "Error");
logs.SaveLog("[error] (page)::BizComnCodeGrp.cs (Function)::exComnCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}