//SELECT
public DataSet sLaborSearch(string pSiteCd, string pBlockCcd, string pConstCcd, string pCoCd, string pTeamCd, string pSearchCondition, string pSearchTxt, string pTtypeScd, string pTcode, string pValue)
{
DataSet ds = null;
DbLaborSearch 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 DbLaborSearch(dbCon_IP, dbCon_DB, dbCon_USER, "0");
ds = db.sLaborSearch(pSiteCd, pBlockCcd, pConstCcd, pCoCd, pTeamCd, pSearchCondition, pSearchTxt, pTtypeScd, pTcode, pValue);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborSearch (Detail):: " +
" pSiteCd=['" + pSiteCd + "'], pBlockCcd=[" + pBlockCcd + "], pConstCcd=[" + pConstCcd + "], pCoCd=[" + pCoCd + "],pTeamCd=[" + pTeamCd + "],pSearchCondition=[" + pSearchCondition + "]," +
"pSearchTxt=[" + pSearchTxt + "],pTtypeScd=[" + pTtypeScd + "],pTcode=[" + pTcode + "], pValue=[" + pValue + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborSearch (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}