//MODIFY WITH PROCEDURE
public string mLaborPro(string pDbNm, string[] param, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
Hashtable hParam = new Hashtable();
hParam.Add("pLab_No", Convert.ToInt32(param[0]));
hParam.Add("pUser_No", Convert.ToInt32(param[1]));
hParam.Add("pLab_Nm", param[2].ToString());
hParam.Add("pBirth_Date", Convert.ToInt32(param[3]));
hParam.Add("pMobile_No", param[4].ToString());
hParam.Add("pSite_Cd", Convert.ToInt32(param[5]));
hParam.Add("pCo_Cd", Convert.ToInt32(param[6]));
hParam.Add("pAprv_Flag", Convert.ToInt32(param[7]));
hParam.Add("pTeam_Cd", Convert.ToInt32(param[8]));
hParam.Add("pJob_Cd", Convert.ToInt32(param[9]));
hParam.Add("pBlock_Cd", Convert.ToInt32(param[10]));
hParam.Add("pInput_Id", Convert.ToInt32(param[11]));
hParam.Add("@rtnVal", "");
reVal = bizSys.mLaborPro(pDbNm, hParam, out Hashtable outVal);
if (outVal != null)
{
foreach (DictionaryEntry dictionaryEntry in outVal)
{
string[] row = new string[] { dictionaryEntry.Key.ToString(), dictionaryEntry.Value.ToString(), "" };
reVal = row[1].ToString();
}
}
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
//UPDATE LAB_TCODE_SITE //추가
public string mLaborLabTcodeSite(string pDbnm, string pLabNo, string pSiteCd, string pTcode, string pValue, out string reData, out string reMsg)
{
string reCode = "N";
reData = "";
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
int reCnt = bizSys.mLaborLabTcodeSite(pDbnm, pLabNo, pSiteCd, pTcode, pValue);
if (reCnt >= 0)
{
reMsg = "[저장 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[저장 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::mLaborLabTcodeSite (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[저장 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
//DUPLICATE CHECK MAIN AND RETURN LAB_NO
public string exLabMain(string pLabNm, string pMobileNo, string pBirthDate, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
reVal = bizSys.exLabMain(pLabNm, pMobileNo, pBirthDate);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러 - BizMainHome 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
//SELECT THE LOWEST AUTH_CD AT SITE
public string sLabAuth(string pSiteCd, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
reVal = bizSys.sLabAuth(pSiteCd);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러 - BizMainHome 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
//ADD INFO DATA
public string sLaborAddInfoSub(string pSiteCd, string pTcode, out List <DataAddinfoCcodesub> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
ds = bizSys.sLaborAddInfoSub(pSiteCd, pTcode);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataAddinfoCcodesub> data = new List <DataAddinfoCcodesub>();
try
{
data = ListClass.ConvertDataTableToList <DataAddinfoCcodesub>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sLaborAddInfoSub (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}
//SELECT
public string sLaborSearch(string pSiteCd, string pBlockCcd, string pConstCcd, string pCoCd, string pTeamCd, string pSearchCondition, string pSearchTxt, string pTtypeScd, string pTcode, string pValue, out List <DataLaborSearch> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
ds = bizSys.sLaborSearch(pSiteCd, pBlockCcd, pConstCcd, pCoCd, pTeamCd, pSearchCondition, pSearchTxt, pTtypeScd, pTcode, pValue);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataLaborSearch> data = new List <DataLaborSearch>();
try
{
data = ListClass.ConvertDataTableToList <DataLaborSearch>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sDevice (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}
//LAB INFO TYPE CMB
public string sLabTcodeList(string pSiteCd, string pTgrpCcd, string pTtypeScd, string pLngCategory, string pAuthCd, out List <DataComComboStr> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizLaborSearch bizSys = null;
try
{
bizSys = new BizLaborSearch();
try
{
ds = bizSys.sLabTcodeList(pSiteCd, pTgrpCcd, pTtypeScd, pLngCategory, pAuthCd);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataComComboStr> data = new List <DataComComboStr>();
try
{
data = ListClass.ConvertDataTableToList <DataComComboStr>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sLabTcodeList (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}