public DataSet team_Cmb(string pSiteCd)
{
DataSet ds = null;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.team_Cmb(pSiteCd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sLaborCompanyList (Detail)::pSiteCd=[" + pSiteCd + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sLaborCompanyList (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public int mInOut2020(string pLabNo, string pSiteCd, string pRegDate, string pCoCd, string pTeamCd, string pInHHMM, string pOutHHMM)
{
int reCnt = 0;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.mInOut2020(pLabNo, pSiteCd, pRegDate, pCoCd, pTeamCd, pInHHMM, pOutHHMM);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::mInOut2020 (Detail):: pLabNo=[" + pLabNo + "]" +
", pSiteCd=[" + pSiteCd + "], pCoCd=[" + pCoCd + "], pTeamCd=[" + pTeamCd + "], pRegDate=[" + pRegDate + "], " +
" pInHHMM=[" + pInHHMM + "], pOutHHMM=[" + pOutHHMM + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::mInOut2020 (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int exInOut2020(string pLabNo, string pSiteCd, string pRegdate)
{
int reCnt = 0;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.exInOut2020(pLabNo, pSiteCd, pRegdate);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::exInOut2020 (Detail)::, pLabNo=[" + pLabNo + "], pSiteCd=[" + pSiteCd + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::exInOut2020 (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int aInOutHistory(string pDbnm, string pLabNo, string pSiteCd, string pRegDate, string pEventDt, string pCoCd, string pTeamCd, string pInputId)
{
int reCnt = 0;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
reCnt = db.aInOutHistory(pDbnm, pLabNo, pSiteCd, pRegDate, pEventDt, pCoCd, pTeamCd, pInputId);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::aInOutHistory (Detail)::, pDbnm=[" + pDbnm + "], pLabNo=[" + pLabNo + "]" +
", pSiteCd=[" + pSiteCd + "], pRegDate=[" + pRegDate + "], pEventDt=[" + pEventDt + "], pCoCd=[" + pCoCd + "]" +
", pTeamCd=[" + pTeamCd + "], pInputId=[" + pInputId + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::aInOutHistory (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public DataSet sInOutHistory(string pDbnm, string pSiteCd, string pDtp1, string pDtp2, string pCocd)
{
DataSet ds = null;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sInOutHistory(pDbnm, pSiteCd, pDtp1, pDtp2, pCocd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sInOutHistory (Detail)::pDbnm=[" + pDbnm + "], " +
"pSiteCd=[" + pSiteCd + "], pDtp1=[" + pDtp1 + "], pDtp2=[" + pDtp2 + "], pCocd=[" + pCocd + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sInOutHistory (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//CONST CMB BOX WITHOUT NOSELECT
public DataSet sLaborCompanyList(string pSiteCd, string pAuthCd, string pCoCd)
{
DataSet ds = null;
DbInOut 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 DbInOut(dbCon_IP, dbCon_DB, dbCon_USER, "0");
//MYCOM_FLAG 값을 구해옴
//string pMyComFlag = "";
//pMyComFlag = db.sMyComFlag(pSiteCd, pAuthCd);
ds = db.sLaborCompanyList(pSiteCd, Convert.ToInt16(pCoCd));
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sLaborCompanyList (Detail)::pSiteCd=[" + pSiteCd + "], " +
" pAuthCd=[" + pAuthCd + "], pCoCd=[" + pCoCd + "]", "Error");
logs.SaveLog("[error] (page)::BizInOut.cs (Function)::sLaborCompanyList (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
