public string GetRecruitMyInfo(string reg_seq_no, string name, string cellphone, string email) { string result = string.Empty; name = HttpUtility.UrlDecode(name); StringBuilder param = new StringBuilder(); param.Append(reg_seq_no); param.Append(CConst.DB_PARAM_DELIMITER).Append(name); param.Append(CConst.DB_PARAM_DELIMITER).Append(cellphone); param.Append(CConst.DB_PARAM_DELIMITER).Append(email); // DB조회 DataSet ds = WebSql.SelectSql(1454, param.ToString()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { result = XmlUtil.GetDefaultXml(ds.Tables[0].Rows[0]["SUPPORT_NO"].ToString(), ""); } else { result = XmlUtil.GetDefaultXml("C", "지원자 정보를 찾지 못했습니다. 입사지원 했던 정보 그대로 입력하셔야 합니다."); } return(result); }
/// <summary> /// 프로시저 실행 후 결과를 리턴한다. /// </summary> /// <param name="procIndex">프로시저번호</param> /// <param name="param">파라미터</param> protected string[] ExecuteQueryResult(int procIndex, string param) { CheckLogin(); string[] result = null; DataSet ds = WebSql.SelectSql(procIndex, param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { result = new string[3]; result[0] = ds.Tables[0].Rows[0]["RESULT_CD"].ToString(); result[1] = ds.Tables[0].Rows[0]["RESULT_MSG"].ToString(); if (ds.Tables[0].Columns.Contains("PROD_CD")) { result[2] = ds.Tables[0].Rows[0]["PROD_CD"].ToString(); } if (ds.Tables[0].Columns.Contains("SEQ")) { result[2] = ds.Tables[0].Rows[0]["SEQ"].ToString(); } } return(result); }
/// <summary> /// 데이터 조회 /// </summary> private void SearchData() { StringBuilder param = new StringBuilder(); param.Append(LANG_CD); mds = WebSql.SelectSql(1001, param.ToString()); }
/// <summary> /// 데이터 셋팅(레코드셋 여러개) /// 페이지 단에서 가져올 때 = GetData(int tableNum, int rowNum, string colName) 종류의 메소드 사용 /// </summary> /// <param name="procIndex">프로시저 Index</param> /// <param name="param">"|" 연결된 파라미터 조합</param> protected void SetDataTableList(int procIndex, string param) { try { mds = WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param)); } catch (Exception e) { CLog.debug(logger, "PageBase.SetDataList(" + procIndex + "," + param + ") : " + e.Message); } }
/// <summary> /// 데이터 조회 /// </summary> /// <param name="procIndex"></param> /// <param name="param"></param> /// <returns></returns> protected DataSet GetDataSet(int procIndex, string param) { try { return(WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param))); } catch (Exception e) { CLog.debug(logger, "PageBase.GetDataSet(" + procIndex + "," + param + ") : " + e.Message); } return(null); }
/// <summary> /// 데이터 셋팅(레코드셋 1개 = 0번째 테이블) /// </summary> /// <param name="procIndex">프로시저 Index</param> /// <param name="param">"|" 연결된 파라미터 조합</param> protected void SetDataList(int procIndex, string param) { try { DataSet mds = WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param)); dataRow = mds.Tables[0].Select(); System.Diagnostics.Debug.WriteLine("dataRow=" + dataRow); } catch (Exception e) { CLog.debug(logger, "PageBase.SetDataList(" + procIndex + "," + param + ") : " + e.Message); } }
/// <summary> /// 우편번호 검색 /// </summary> /// <param name="text">검색어</param> /// <returns></returns> public string GetZipcode(string text) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(text); // DB조회 DataSet ds = WebSql.SelectSql(10, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "Zipcode"); return(result); }
/// <summary> /// 레코드 총 수(레코드셋 1개 = 0번째 테이블) /// </summary> /// <param name="procIndex"></param> /// <param name="param"></param> protected void SetDataCount(int procIndex, string param) { try { DataSet ds = WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param)); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { dataTotalCount = Convert.ToInt32(ds.Tables[0].Select()[0][0]); } } catch (Exception e) { CLog.debug(logger, "PageBase.SetDataCount(" + procIndex + "," + param + ") : " + e.Message); } }
public string GetDutyAuth(string dutyNo) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(dutyNo); // DB조회 DataSet ds = WebSql.SelectSql(3826, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "Auth"); return(result); }
public string GetMenuAuth(string adminId) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(adminId); // DB조회 DataSet ds = WebSql.SelectSql(3805, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "Menu"); return(result); }
/// <summary> /// 제품유형을 가져온다. /// </summary> /// <param name="upperProdTypeNo"></param> /// <returns></returns> public string GetProductType(string upperProdTypeNo, string depth) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(upperProdTypeNo); param.Append(CConst.DB_PARAM_DELIMITER).Append(depth); // DB조회 DataSet ds = WebSql.SelectSql(1, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "ProductType"); return(result); }
/// <summary> /// 공고사항 리스트를 가져온다. /// </summary> /// <param name="upperProdTypeNo"></param> /// <returns></returns> public string GetNoticeList(int now_page, string title) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(now_page); param.Append(CConst.DB_PARAM_DELIMITER).Append(title); // DB조회 DataSet ds = WebSql.SelectSql(2231, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "Investment"); return(result); }
/// <summary> /// 제품유형을 가져온다. /// </summary> /// <param name="upperProdTypeNo"></param> /// <returns></returns> public string GetProductList(int now_page, string lang_cd, string catg_no1, string catg_no2, string prod_type_cd, string prod_s_init_cd, string prod_e_init_cd, string prod_tag) { string result = string.Empty; StringBuilder param = new StringBuilder(); param.Append(now_page); param.Append(CConst.DB_PARAM_DELIMITER).Append(lang_cd); param.Append(CConst.DB_PARAM_DELIMITER).Append(catg_no1); // 1차 카테고리(동물의약품) param.Append(CConst.DB_PARAM_DELIMITER).Append(catg_no2); // 2차 카테고리 (항생.소독제) param.Append(CConst.DB_PARAM_DELIMITER).Append(prod_type_cd); // 제품유형 코드 param.Append(CConst.DB_PARAM_DELIMITER).Append(CStringUtil.GetInitial(lang_cd, "S", prod_s_init_cd)); param.Append(CConst.DB_PARAM_DELIMITER).Append(CStringUtil.GetInitial(lang_cd, "E", prod_e_init_cd)); param.Append(CConst.DB_PARAM_DELIMITER).Append(prod_tag); // 태그명으로 검색 // DB조회 DataSet ds = WebSql.SelectSql(2001, param.ToString()); // XML로 변환 result = XmlUtil.GetXml(ds, "Products"); return(result); }
/// <summary> /// CallBack /// </summary> /// <param name="myXAQueryClass"></param> private void ReceiveData(XAQueryClass myXAQueryClass) { string result = ""; try { string hname = myXAQueryClass.GetFieldData("t1102OutBlock", "hname", 0); string price = myXAQueryClass.GetFieldData("t1102OutBlock", "price", 0); string sign = myXAQueryClass.GetFieldData("t1102OutBlock", "sign", 0); string change = myXAQueryClass.GetFieldData("t1102OutBlock", "change", 0); string diff = myXAQueryClass.GetFieldData("t1102OutBlock", "diff", 0); if (CStringUtil.IsNullOrEmpty(hname) == false) { StringBuilder param = new StringBuilder(); param.Append(hname); param.Append(CConst.DB_PARAM_DELIMITER).Append(price); param.Append(CConst.DB_PARAM_DELIMITER).Append(sign); param.Append(CConst.DB_PARAM_DELIMITER).Append(change); param.Append(CConst.DB_PARAM_DELIMITER).Append(diff); WebSql.SelectSql(3102, param.ToString()); result = param.ToString(); } } catch (Exception e) { result = "데이터 가져오기 실패"; CLog.debug(logger, "CAgent.ReceiveData: " + e.Message + ", XASession: " + XASession.GetErrorMessage(XASession.GetLastError())); } if (form != null) { form.DisplayReturnMessage(result); } }
/// <summary> /// 프로시저 실행 /// </summary> /// <param name="procIndex">프로시저번호</param> /// <param name="param">파라미터</param> protected void ExecuteQuery(int procIndex, string param) { WebSql.SelectSql(procIndex, param); }