Transparent DIV SPAN for all browsers, Firefox, Opera, Safari, Chrome, Internet Explorer Web Application
- 2011/10/24 17:48
- fortunejth.egloos.com/3252585
- 덧글수 : 0
Transparent DIV SPAN for all browsers, Firefox, Opera, Safari, Chrome, Internet Explorer
To make an HTML element transparent. Just use these css elements in your css class. filter, moz-opacity, opacity.
Internet Explorer uses filter and firefox uses moz-opacity.
.transparent{ filter:alpha(opacity=60); -moz-opacity: 0.6; opacity: 0.6; }
<div class="transparent">A transparent div.</div>
- 2011/10/13 22:54
- fortunejth.egloos.com/3245994
- 덧글수 : 0
set ANSI_NULLS ON
GO
set QUOTED_IDENTIFIER ON
GO
---------------------------------------------------------------------------------------------------------------------
-- Procedure name : up_GetCommonBoardList
-- Author : 조탁훈
-- Create date : 2009-01-13
-- Modify date : 2009-01-14
-- Description : 인자로 받은 조건에 해당하는 게시판 데이타를 가져옴
---------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE [up_GetCommonBoardList]
-- Add the parameters for the stored procedure here
@TableName NVARCHAR(50),
@PrimaryColumn NVARCHAR(50),
@SelectColumns NVARCHAR(500),
@WhereCondition NVARCHAR(4000),
@OrderbyCondition NVARCHAR(100),
@CurrentPageNo INT,
@RowsPerPage INT,
@RefTotalCount INT OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
--전역 변수 초기화
--SET @RefTotalCount = 0
-- 인자 값이 체크
IF @PrimaryColumn IS NULL OR @PrimaryColumn = ''
SET @PrimaryColumn = '*'
IF @SelectColumns IS NULL OR @SelectColumns = ''
SET @SelectColumns = '*'
IF @WhereCondition IS NULL
SET @WhereCondition = ''
IF @OrderbyCondition IS NULL
SET @OrderbyCondition = ''
IF @CurrentPageNo IS NULL
SET @CurrentPageNo = 1
IF @RowsPerPage IS NULL
SET @RowsPerPage = 15
--지역 변수 선언
DECLARE @SqlDataQuery NVARCHAR(MAX)
DECLARE @SqlDataTotalCount NVARCHAR(MAX)
DECLARE @StartRowCount INT
DECLARE @EndRowCount INT
SET @SqlDataTotalCount = ''
SET @SqlDataQuery = ''
SET @StartRowCount = 0
SET @EndRowCount = 0
--전체 글 수 조회
SET @SqlDataTotalCount =
'SELECT @RCOUNT = COUNT(' + @PrimaryColumn + ') ' +
'FROM ' + @TableName + ' ' +
@WhereCondition
EXEC sp_executesql @SqlDataTotalCount,
N'@RCOUNT INT output',
@RCOUNT = @RefTotalCount output
IF (@CurrentPageNo * @RowsPerPage) >= @RefTotalCount
SET @EndRowCount = @RefTotalCount
ELSE
SET @EndRowCount = (@CurrentPageNo * @RowsPerPage)
SET @StartRowCount = ((@CurrentPageNo - 1) * @RowsPerPage) + 1;
--쿼리 스트링 생성
-- SET @SqlDataQuery = '( SELECT ' + @SelectColumns + ' ' +
-- ' FROM ' + @TableName + ' ' +
-- @WhereCondition + ' ' + @OrderbyCondition + ' )'
SET @SqlDataQuery =
'WITH List AS ' +
'( ' +
' SELECT ' + @SelectColumns + ', ROW_NUMBER() OVER( ' + @OrderbyCondition + ' ) AS RowNo ' +
' FROM ' + @TableName + ' ' +
@WhereCondition + ' ' +
') ' +
'SELECT * ' +
'FROM List L ' +
'WHERE L.RowNo BETWEEN ' + CONVERT(NVARCHAR, @StartRowCount ) + ' AND ' + CONVERT(NVARCHAR, @EndRowCount)
EXEC (@SqlDataQuery)
END
====================================================================
사용 예제
/// <summary>
/// 인자로 받은 게시판 정보에 대한 데이터를 DataSet으로 반환하는 함수( 단. 반드시 orderbyColumn에 한개 이상의 정렬할 컬럼이 존재해야 함)
/// </summary>
/// <param name="tableName">테이블 명</param>
/// <param name="primaryColNm">해당 테이블에 Primary Key 컬럼 명</param>
/// <param name="selectColumns">반환 될 컬럼( ex> id, title)</param>
/// <param name="whereCondition">조건 식(WHERE문을 포함지 않아야 함)</param>
/// <param name="orderbyColumn">정렬식(ORDER BY를 포함하지 않아야 함, 필수로 디폴트 컬럼이라도 입력되어야 함)</param>
/// <param name="currentPageNo">현재 가져올 게시판의 페이지 번호</param>
/// <param name="rowsPerPage">한 페이지에 보여질 아이템 갯수</param>
/// <param name="TotalCount">전체 게시판 데이터 갯수(참조 변수)</param>
/// <param name="sqlHelper">MSSQL 연결 Helper 객체</param>
/// <returns></returns>
public static DataSet GetBoardListDataSet(string tableName, string primaryColNm, string selectColumns, string whereCondition, string orderbyColumn, string currentPageNo, string rowsPerPage, ref int TotalCount, MSSqlHandler sqlHelper)
{
DataSet ds = null;
List<SqlParameter> sqlPrams = null;
if (!string.IsNullOrEmpty(whereCondition) &&
whereCondition.Trim().Length > 0)
whereCondition = " WHERE " + whereCondition;
else
whereCondition = string.Empty;
if (!string.IsNullOrEmpty(orderbyColumn) &&
orderbyColumn.Trim().Length > 0)
orderbyColumn = " ORDER BY " + orderbyColumn;
else
throw new ArgumentNullException("orderbyColumn에 값이 존재하지 않습니다.");
try
{
if (sqlHelper.ConnState == 0)
sqlHelper.Open();
object refObj = null;
sqlPrams = new List<SqlParameter>();
SqlParameter pram = null;
pram = new SqlParameter("@TableName", SqlDbType.NVarChar);
pram.Value = tableName;
sqlPrams.Add(pram);
pram = new SqlParameter("@PrimaryColumn", SqlDbType.NVarChar);
pram.Value = primaryColNm;
sqlPrams.Add(pram);
pram = new SqlParameter("@SelectColumns", SqlDbType.NVarChar);
pram.Value = selectColumns;
sqlPrams.Add(pram);
pram = new SqlParameter("@WhereCondition", SqlDbType.NVarChar);
pram.Value = whereCondition;
sqlPrams.Add(pram);
pram = new SqlParameter("@OrderbyCondition", SqlDbType.NVarChar);
pram.Value = orderbyColumn;
sqlPrams.Add(pram);
pram = new SqlParameter("@CurrentPageNo", SqlDbType.NVarChar);
pram.Value = currentPageNo;
sqlPrams.Add(pram);
pram = new SqlParameter("@RowsPerPage", SqlDbType.NVarChar);
pram.Value = rowsPerPage;
sqlPrams.Add(pram);
pram = new SqlParameter("@RefTotalCount", SqlDbType.Int);
pram.Value = 0;
pram.Direction = ParameterDirection.Output;
sqlPrams.Add(pram);
ds = sqlHelper.GetDataSet(CommandType.StoredProcedure, "up_GetCommonBoardList", sqlPrams, "@RefTotalCount", ref refObj);
if (refObj != null)
TotalCount = int.Parse(Convert.ToString(refObj));
}
catch (Exception ex)
{
throw new Exception("GetBoardListDataSet Exception", ex);
}
return ds;
}
최근 덧글