/// <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>
/// 레코드 총 수(레코드셋 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);
}
}
