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(string proc_nm)
{
CheckLogin();
string[] result = null;
DataSet ds = WebSql.SelectSqlByName(proc_nm);
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);
}
}
protected DataSet GetDataSet(string proc_nm)
{
try
{
// 체크 잠시 중단
//return WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param));
return(WebSql.SelectSqlByName(proc_nm));
}
catch (Exception e)
{
CLog.debug(logger, "PageBase.GetDataSet(" + proc_nm + ") : " + e.Message);
}
return(null);
}
/// <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="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>
/// 공고사항 리스트를 가져온다.
/// </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 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="procIndex">프로시저번호</param>
/// <param name="param">파라미터</param>
protected string[] ExecuteQueryResult(int procIndex, string param)
{
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();
}
}
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);
}
