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