//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); }