public int mCodeTAuth(string pTcodeNm, string pSiteCd, string pAuthCd, string pViewFlag, string pNewFlag, string pModifyFlag)
{
int reCnt = 0;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mCodeTAuth(pTcodeNm, pSiteCd, pAuthCd, pViewFlag, pNewFlag, pModifyFlag);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::mCodeTAuth (Detail):: " +
" pTcodeNm=['" + pTcodeNm + "'], pSiteCd=[" + pSiteCd + "], pAuthCd=[" + pAuthCd + "]" + ", pViewFlag=[" + pViewFlag + "]" +
", pNewFlag=['" + pNewFlag + "'], pModifyFlag=[" + pModifyFlag + "]", "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::mCodeTAuth (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sCodeT(string pScode)
{
DataSet ds = null;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sCodeT(pScode);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::sCodeT (Detail):: " +
" pScode=['" + pScode + "']", "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::sCodeT (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//SELECT : WHEN USER CLICK TTYPE_SCD
public DataSet sCodeTAuthTtype(string pTtypeScd, string pSiteCd, string pAuthCd)
{
DataSet ds = null;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sCodeTAuthTtype(pTtypeScd, pSiteCd, pAuthCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::sCodeTAuthTtype (Detail):: pTtypeScd=[" + pTtypeScd + "], pSiteCd=[" + pSiteCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::sCodeTAuthTtype (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public int aCodeTSiteLog(string pDbnm, string pSiteCd, string pTcode, string pTgrpCcd, string pRequiredFlag, string pNumericFlag, string pDefaultValue, string pUsingFlag, string pSortNo, string pMemo, string pInputId)
{
int reCnt = 0;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aCodeTSiteLog(pDbnm, pSiteCd, pTcode, pTgrpCcd, pRequiredFlag, pNumericFlag, pDefaultValue, pUsingFlag, pSortNo, pMemo, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::aCodeT (Detail):: " +
", pDbnm=['" + pDbnm + "'], pSiteCd=[" + pSiteCd + "], pTcode=[" + pTcode + "]" +
", pTgrpCcd=['" + pTgrpCcd + "'], pRequiredFlag=[" + pRequiredFlag + "], pNumericFlag=[" + pNumericFlag + "]" +
", pDefaultValue=['" + pDefaultValue + "'], pUsingFlag=[" + pUsingFlag + "], pSortNo=[" + pSortNo + "]" +
", pMemo=[" + pMemo + "], pInputId=[" + pInputId + "]", "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::aCodeT (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public string aCodeTSubSite(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.aCodeTSubSite(param, out outVal);
}
catch (Exception ex)
{
outVal = null;
//logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::aCodeTSite (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)::aCodeTSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int aCodeTSub(string pTcode, string pTscodeNm, string pUsingCnt, string pInputId)
{
int reCnt = 0;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aCodeTSub(pTcode, pTscodeNm, pUsingCnt, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::aCodeTSub (Detail):: " +
", pTcode=['" + pTcode + "'], pTscodeNm=[" + pTscodeNm + "], pUsingCnt=[" + pUsingCnt + "]" + ", pInputId=[" + pInputId + "]"
, "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::aCodeTSub (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int mCodeT(string pTcode, string pListFlag, string pRequiredFlag, string pNumericFlag)
{
int reCnt = 0;
DbCodeT 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 DbCodeT(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mCodeT(pTcode, pListFlag, pRequiredFlag, pNumericFlag);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::mCodeT (Detail):: " +
", pTcode=['" + pTcode + "'], pListFlag=[" + pListFlag + "], pRequiredFlag=[" + pRequiredFlag + "]" + ", pNumericFlag=[" + pNumericFlag + "]"
, "Error");
_logs.SaveLog("[error] (page)::BizCodeT.cs (Function)::mCodeT (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}