protected IDataReader InfoThresholdCode_Doc(int threshold_ref_id)
{
string query = @"
SELECT
(SELECT COUNT(THRESHOLD_REF_ID) FROM BSC_THRESHOLD_CODE) AS TOTCOUNT,
THRESHOLD_REF_ID,
THRESHOLD_KNAME,
THRESHOLD_ENAME,
IMAGE_FILE_NAME,
SEQUENCE,
USE_YN
FROM
BSC_THRESHOLD_CODE
WHERE
THRESHOLD_REF_ID = CASE WHEN @THRESHOLD_REF_ID=0 THEN THRESHOLD_REF_ID
ELSE @THRESHOLD_REF_ID
END
";
IDbDataParameter[] paramArray = CreateDataParameters(1);
paramArray[0] = CreateDataParameter("@THRESHOLD_REF_ID", SqlDbType.Int);
paramArray[0].Value = threshold_ref_id;
return(DbAgentObj.ExecuteReader(query, paramArray, CommandType.Text));
}
protected IDataReader InfoThresholdStep_Dac(int threshold_ref_id, string threshold_level)
{
string query = @"SELECT TS.THRESHOLD_REF_ID
,TC.THRESHOLD_ENAME
,TS.THRESHOLD_LEVEL
,TS.POINT
,TS.SEQUENCE
,TS.BASE_LINE_YN
,(SELECT MAX(SEQUENCE) FROM BSC_THRESHOLD_STEP WHERE THRESHOLD_LEVEL = @THRESHOLD_LEVEL) AS MAXSEQ
FROM BSC_THRESHOLD_STEP TS
LEFT OUTER JOIN BSC_THRESHOLD_CODE TC
ON TS.THRESHOLD_REF_ID = TC.THRESHOLD_REF_ID
WHERE TS.THRESHOLD_REF_ID = @THRESHOLD_REF_ID
AND TS.THRESHOLD_LEVEL = @THRESHOLD_LEVEL" ;
IDbDataParameter[] paramArray = CreateDataParameters(2);
paramArray[0] = CreateDataParameter("@THRESHOLD_REF_ID", SqlDbType.Int);
paramArray[0].Value = threshold_ref_id;
paramArray[1] = CreateDataParameter("@THRESHOLD_LEVEL", SqlDbType.VarChar);
paramArray[1].Value = threshold_level;
IDataReader sdr = DbAgentObj.ExecuteReader(query, paramArray, CommandType.Text);
return(sdr);
}
//--------------------------------------------------------------------------------------------
// 추가일 : 2007.05.30
// UserControl - LeftMenu, TopMenu의 메뉴 Data를 호출한다
//--------------------------------------------------------------------------------------------
#region
public IDataReader GetAuthReadMenu(string asEmpRefID)
{
IDbDataParameter[] paramArray = null;
string query = @"
SELECT
CMI.MENU_REF_ID AS MENU_REF_ID,
MENU_NAME AS MENU_NAME,
MENU_PRIORITY AS MENU_SORT,
UP_MENU_ID AS UP_MENU_ID,
MENU_DIR AS MENU_DIR,
MENU_PAGE_NAME AS MENU_PAGE_NAME,
MENU_PARAM AS MENU_PARAM,
MENU_FULL_PATH AS MENU_FULL_PATH
FROM
COM_MENU_INFO AS CMI
INNER JOIN
(
SELECT DISTINCT
A.MENU_REF_ID
FROM
COM_ROLE_MENU_REL AS A
INNER JOIN COM_EMP_ROLE_REL AS B
ON A.ROLE_REF_ID = B.ROLE_REF_ID
WHERE
B.EMP_REF_ID = @EMP_REF_ID
) AS CMI_R
ON CMI.MENU_REF_ID = CMI_R.MENU_REF_ID
WHERE
MENU_TYPE IN ('T','M','S')
ORDER BY
MENU_PRIORITY
";
paramArray = CreateDataParameters(1);
paramArray[0] = CreateDataParameter("@EMP_REF_ID", SqlDbType.Int);
paramArray[0].Value = int.Parse(asEmpRefID);
IDataReader dr = DbAgentObj.ExecuteReader(query, paramArray);
return(dr);
}
