public DataSet sSysAuthMemberDB(string pDbnm, string pUsingFlag)
{
DataSet ds = null;
DbSysAuthMemberDB 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 DbSysAuthMemberDB(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sSysAuthMemberDB(pDbnm, pUsingFlag);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::sSysAuthMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public string sDbNm(string pMemcoCd)
{
string reVal = "";
DbSysAuthMemberDB 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 DbSysAuthMemberDB(dbCon_IP, dbCon_DB, dbCon_USER);
reVal = db.sDbNm(pMemcoCd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::sDbNm (Detail)::pMemcoCd=[" + pMemcoCd + "]", "Error");
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::sDbNm (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int aSysAuthMainDB(string sauthCd_val, string sauthNm_val, string myblockFlag_val, string myconFlag_val, string mycomFlag_val, string myteamFlag_val, string usingFlag_val, string sauthLevel_val, string memo_val, string pInputId)
{
int reCnt = 0;
DbSysAuthMemberDB 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 DbSysAuthMemberDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.aSysAuthMainDB(sauthCd_val, sauthNm_val, myblockFlag_val, myconFlag_val, mycomFlag_val, myteamFlag_val, usingFlag_val, sauthLevel_val, memo_val, pInputId);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::aSysAuthMainDB (Detail)::sauthCd_val=[" + sauthCd_val + "], sauthNm_val=[" + sauthNm_val + "], myblockFlag_val=[" + myblockFlag_val + "]" +
", myconFlag_val=[" + myconFlag_val + "], mycomFlag_val=[" + mycomFlag_val + "]", "Error");
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::aSysAuthMainDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int exSysAuthMainDB(string sauthCd_val, string sauthNm_val)
{
int reCnt = 0;
DbSysAuthMemberDB 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 DbSysAuthMemberDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.exSysAuthMainDB(sauthCd_val, sauthNm_val);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::exSysAuthMainDB (Detail)::sauthCd_val=[" + sauthCd_val + "]", "Error");
logs.SaveLog("[error] (page)::BizSysAuthMemberDB.cs (Function)::exSysAuthMainDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}