//MODIFY public string mSite(string siteCd_val, string siteNm_val, string usingFlag_val, string sortNo_val, string memo_val, out string reMsg, out string reData) { string reCode = "N"; reData = "0"; BizSite bizSys = null; try { bizSys = new BizSite(); int reCnt = bizSys.mSite(siteCd_val, siteNm_val, usingFlag_val, sortNo_val, memo_val); if (reCnt > 0) { reMsg = "[저장 성공]"; reCode = "Y"; reData = reCnt.ToString(); } else { reMsg = "[저장 성공] - 정보 없음"; reCode = "Y"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsMember.svc (Function)::mSite (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[저장 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
//DUPLICATE CHECK public string exSite(string pSiteNm, out string reMsg, out string reData) { string reCode = "N"; reData = "0"; BizSite bizSys = null; try { bizSys = new BizSite(); int reCnt = bizSys.exSite(pSiteNm); if (reCnt > 0) { reMsg = "[검색 성공]"; reCode = "Y"; reData = reCnt.ToString(); } else { reMsg = "[검색 성공] - 정보 없음"; reCode = "Y"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsMember.svc (Function)::exSite (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
public string aSite(string pDbNm, string[] param, out string reData, out string reMsg) { string reCode = "N"; string reVal = ""; BizSite bizSys = null; try { bizSys = new BizSite(); try { Hashtable hParam = new Hashtable(); hParam.Add("pMemco_Cd", Convert.ToInt32(param[0])); hParam.Add("pSite_Nm", param[1].ToString()); hParam.Add("pSort_No", Convert.ToInt32(param[2])); hParam.Add("pMemo", param[3].ToString()); hParam.Add("pInput_Id", param[4].ToString()); hParam.Add("pHeadco_Cd", param[5].ToString()); hParam.Add("@rtnSite_Cd", ""); reVal = bizSys.aSite(pDbNm, hParam, out Hashtable outVal); if (outVal != null) { foreach (DictionaryEntry dictionaryEntry in outVal) { string[] row = new string[] { dictionaryEntry.Key.ToString(), dictionaryEntry.Value.ToString(), "" }; //string rowCount = row.Length.ToString(); //string rowKey = row[0].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); }
//SELECT public string sSite(string pMemcoCd, string pUsingFlag, out List <DataSiteDB> reList, out string reMsg) //셀렉트 { string reCode = "N"; DataSet ds = null; BizSite bizSys = null; try { bizSys = new BizSite(); try { ds = bizSys.sSite(pMemcoCd, pUsingFlag); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataSiteDB> data = new List <DataSiteDB>(); try { data = ListClass.ConvertDataTableToList <DataSiteDB>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsMember.svc (Function)::sSite (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }