public string AuthLaborModify(string pDbNm, string pSiteCd, string pAuthCd)
{
string reVal = "";
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");
DataSet ds1 = db.AuthLabor(pDbNm, pSiteCd, pAuthCd);
string pModify_Flag = ds1.Tables[0].Rows[0]["MODIFY_FLAG"].ToString();
reVal = pModify_Flag;
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::AuthLaborModify (Detail):: " +
" pSiteCd=['" + pDbNm + "'], pAuthCd=[" + pSiteCd + "], pLngBlock=[" + pAuthCd + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::AuthLaborModify (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
//JOB CMB BOX
public DataSet sLaborJobList(string pSiteCd, string pLngJob)
{
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.sLaborJobList(pSiteCd, pLngJob);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborJobList (Detail):: " +
" pSiteCd=['" + pSiteCd + "'], pLngJob=[" + pLngJob + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborJobList (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//MODIFY LABOR WITH PROCEDURE
public string mLaborPro(string pDbNm, Hashtable param, out Hashtable outVal)
{
string reVal = "";
DbLaborSearch 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 DbLaborSearch(dbCon_IP, dbCon_DB, dbCon_USER, "1");
reVal = db.mLaborPro(param, out outVal);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::mLaborPro (Detail):: " +
" pDbNm=['" + pDbNm + "'], param=[" + param + "]", "Error");
outVal = null;
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::mLaborPro (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
////FIRST INSERT LAB_TCODE_SITE_LOG
public int aLaborLabTcodeSiteLog(string pDbnm, string pLabNo, string pSiteCd, string pTcode, string pTtypeScd, string pValue, string pInputId)
{
int reCnt = 0;
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");
reCnt = db.aLaborLabTcodeSiteLog(pDbnm, pLabNo, pSiteCd, pTcode, pTtypeScd, pValue, pInputId);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::mLaborLabTcodeSiteLog (Detail)::pDbnm=[" + pDbnm + "], pLabNo=[" + pLabNo + "], myblockFlag_val=[" + pSiteCd + "]" +
", pTcode=[" + pTcode + "], pValue=[" + pValue + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::mLaborLabTcodeSiteLog (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
//CONST CMB BOX
public DataSet sLaborConstList(string pSiteCd, string pAuthCd, string pCcode, string pLngConst)
{
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");
DataSet ds1 = db.sMyFlags(pSiteCd, pAuthCd);
string pMyConFlag = ds1.Tables[0].Rows[0]["MYCON_FLAG"].ToString();
ds = db.sLaborConstList(pSiteCd, Convert.ToInt16(pMyConFlag), Convert.ToInt16(pCcode), pLngConst);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborConstList (Detail):: " +
" pSiteCd=['" + pSiteCd + "'], pAuthCd=[" + pAuthCd + "], pCcode=[" + pCcode + "],pLngBlock=[" + pLngConst + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborConstList (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//ADD INFO dgv4 COMBO (ex. CarSize, InspectionMethod)
public DataSet sLaborAddInfoSub(string pDbnm, string pTcode)
{
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.sLaborAddInfoSub(pDbnm, pTcode);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborAddInfoSub (Detail):: " +
" pDbnm=['" + pDbnm + "'], pTcode=[" + pTcode + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborAddInfoSub (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
//DUPLICATE CHECK MAIN AND RETURN LAB_NO
public string exLabMain(string pLabNm, string pMobileNo, string pBirthDate)
{
string reVal = "";
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");
reVal = db.exLabMain(pLabNm, pMobileNo, pBirthDate);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::exLabMain (Detail):: " +
" pLabNm=['" + pLabNm + "'], pMobileNo=[" + pMobileNo + "], pBirthDate=[" + pBirthDate + "]", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::exLabMain (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
//SELECT THE LOWEST AUTH_CD AT SITE
public string sLabAuth(string pSiteCd)
{
string reVal = "";
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");
reVal = db.sLabAuth(pSiteCd);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLabAuth (Detail):: " +
" pSiteCd=['" + pSiteCd + "']", "Error");
logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLabAuth (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
//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);
}
