public int mSysCodeGrp(string pScodeGrp, string pScodeNm, string pUsingFlag, string pSortNo, string pMemo)
{
int reCnt = 0;
DbSysCodeGrp db = null;
try
{
db = new DbSysCodeGrp();
reCnt = db.mSysCodeGrp(pScodeGrp, pScodeNm, pUsingFlag, pSortNo, pMemo);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::mSysCodeGrp (Detail)::pScodeGrp=[" + pScodeGrp + "], pScodeNm=[" + pScodeNm + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::mSysCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sSysCode(string pScodeGrp, string pUsingFlag, string pScodeNm)
{
DataSet ds = null;
DbSysCodeGrp db = null;
try
{
db = new DbSysCodeGrp();
ds = db.sSysCode(pScodeGrp, pUsingFlag, pScodeNm);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::pScodeGrp=[" + pScodeGrp + "], pUsingFlag=[" + pUsingFlag + "], pScodeNm=[" + pScodeNm + "]"
, "Error");
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public DataSet fSysCodeSearch(string _scodeGrp, string pScode_Nm)
{
DataSet ds = null;
DbSysCodeGrp db = null;
try
{
string SCODE_NM = pScode_Nm;
string SCODE_GRP = _scodeGrp;
db = new DbSysCodeGrp();
ds = db.fSysCodeSearch(SCODE_GRP, SCODE_NM);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::pScodeGrp=[" + pScode_Nm + "]", "Error");
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public int exSysCode(string pScode)
{
int reCnt = 0;
DbSysCodeGrp db = null;
try
{
db = new DbSysCodeGrp();
reCnt = db.exSysCode(pScode);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::exSysCode (Detail)::pScode=[" + pScode + "]", "Error");
logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::exSysCode (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int exSysCodeGrp(string sauthCd_val)
{
int reCnt = 0;
DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.exSysCodeGrp(sauthCd_val);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::exSysCodeGrp (Detail)::pScodeGrp=[" + sauthCd_val + "]", "Error");
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::exSysCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int mSysCodeGrp(string pScodeGrp, string pScodeNm, string pUsingFlag, string pSortNo, string pMemo)
{
int reCnt = 0;
DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.mSysCodeGrp(pScodeGrp, pScodeNm, pUsingFlag, pSortNo, pMemo);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::mSysCodeGrp (Detail)::pScodeGrp=[" + pScodeGrp + "], pScodeNm=[" + pScodeNm + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::mSysCodeGrp (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sSysCode(string pScodeGrp, string pUsingFlag, string pScodeNm)
{
DataSet ds = null;
DbSysCodeGrp 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 DbSysCodeGrp(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sSysCode(pScodeGrp, pUsingFlag, pScodeNm);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::pScodeGrp=[" + pScodeGrp + "], pUsingFlag=[" + pUsingFlag + "], pScodeNm=[" + pScodeNm + "]"
, "Error");
_logs.SaveLog("[error] (page)::BizSysCodeGrp.cs (Function)::sSysCode (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}