//INSERT COMPANY WITH PROCEDURE
public string aCompanyPro(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.aCompanyPro(param, out outVal);
}
catch (Exception ex)
{
outVal = null;
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::aCompanyPro (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int aCompanyMemcoSite(string pSiteCd, string pCoCd, string pStartDate, string pEndDate, string pUsingFlag, string pSortNo, string pMemo, string pInputId)
{
int reCnt = 0;
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aCompanyMemcoSite(pSiteCd, pCoCd, pStartDate, pEndDate, pUsingFlag, pSortNo, pMemo, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::aCompanyMemcoSite (Detail)::pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pStartDate=[" + pStartDate + "]" +
", pEndDate=[" + pEndDate + "], pMemo=[" + pUsingFlag + "], pMemo=[" + pSortNo + "], pMemo=[" + pMemo + "], pSortNo=[" + pInputId + "]", "Error");
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::aCompanyMemcoSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int mConpanyMainLog(string pCoCd, string pCoNm, string pBizNo, string pConstCcd, string pCoTypeScd, string pOwnerNm, string pTel, string pAddr, string pUsingCnt, string pInputId)
{
int reCnt = 0;
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mConpanyMainLog(pCoCd, pCoNm, pBizNo, pConstCcd, pCoTypeScd, pOwnerNm, pTel, pAddr, pUsingCnt, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::mConpanyMainLog (Detail)::pCoCd=[" + pCoCd + "], pCoNm=[" + pCoNm + "], pBizNo=[" + pBizNo + "]" +
", pConstCcd=[" + pConstCcd + "], pCoTypeScd=[" + pCoTypeScd + "], pOwnerNm=[" + pOwnerNm + "], pTel=[" + pTel + "], pAddr=[" + pAddr + "], pUsingCnt=[" + pUsingCnt + "], pInputId=[" + pInputId + "]", "Error");
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::mConpanyMainLog (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int mCompanyMemco(string pSiteCd, string pCoCd, string pCoNm, string pHeadcoCd, string pConstCcd, string pCoTypeScd, string pSortNo)
{
int reCnt = 0;
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mCompanyMemco(pSiteCd, pCoCd, pCoNm, pHeadcoCd, pConstCcd, pCoTypeScd, pSortNo);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::mCompanyMemco (Detail)::pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pCoNm=[" + pCoNm + "], pHeadcoCd=[" + pHeadcoCd + "]" +
", pConstCcd=[" + pConstCcd + "], pCoTypeScd=[" + pCoTypeScd + "], pSortNo=[" + pSortNo + "]", "Error");
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::mCompanyMemco (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sCompany(string pSiteCd, string pUsingFlag, string pCoNm)
{
DataSet ds = null;
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sCompany(pSiteCd, pUsingFlag, pCoNm);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::sCompany (Detail)::pSiteCd=[" + pSiteCd + "], pUsingFlag=[" + pUsingFlag + "], pCoNm=[" + pCoNm + "]"
, "Error");
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::sCompany (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//CO_TYPE CMB BOX WITHOUT NO SELECT
public DataSet cotype_Cmb2()
{
DataSet ds = null;
DbCompany 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 DbCompany(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.cotype_Cmb2();
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizCompany.cs (Function)::cotype_Cmb2 (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}