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