//MODIFY
public int mMember(string pMemcoCd, string pMemcoNm, string pUsingFlag, string pSortNo, string pMemo)
{
int reCnt = 0;
DbMember 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 DbMember(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.mMember(pMemcoCd, pMemcoNm, pUsingFlag, pSortNo, pMemo);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::mMember (Detail)::pMemcoCd=[" + pMemcoCd + "], pMemcoNm=[" + pMemcoNm + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::mMember (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
//SELECT -> GridView1
public DataSet sMember(string pMemcoCd)
{
DataSet ds = null;
DbMember 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 DbMember(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sMember(pMemcoCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::sMember (Detail)::pMemcoCd=[" + pMemcoCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMember.cs (Function)::sMember (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}