//UPDATE
public int mTeamMemco(string pSiteCd, string pTeamCd, string pTeamNm, string pUsingFalg, string pSortNo, string pMemo)
{
int reCnt = 0;
DbTeam 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 DbTeam(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mTeamMemco(pSiteCd, pTeamCd, pTeamNm, pUsingFalg, pSortNo, pMemo);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::mCompanyMemco (Detail)::pSiteCd=[" + pSiteCd + "], pTeamCd=[" + pTeamCd + "], pTeamNm=[" + pTeamNm + "], pUsingFalg=[" + pUsingFalg + "]" +
", pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]", "Error");
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::mCompanyMemco (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
//COMPANY CMB BOX
public DataSet companyCmb(string pSiteCd)
{
DataSet ds = null;
DbTeam 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 DbTeam(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.companyCmb(pSiteCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::companyCmb (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//SELECT TEAM
public DataSet sTeam(string pSiteCd, string pCoCd, string pUsingFlag, string pTeamNm)
{
DataSet ds = null;
DbTeam 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 DbTeam(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sTeam(pSiteCd, pCoCd, pUsingFlag, pTeamNm);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::sTeam (Detail)::pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pUsingFlag=[" + pUsingFlag + "], pTeamNm=[" + pTeamNm + "]"
, "Error");
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::sTeam (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//INSERT TEAM WITH PROCEDURE
public string aTeamPro(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbTeam 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 DbTeam(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.aTeamPro(param, out outVal);
}
catch (Exception ex)
{
outVal = null;
_logs.SaveLog("[error] (page)::BizTeam.cs (Function)::aTeamPro (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}