C# 클래스 avt.DynamicFlashRotator.Net.Data.AvtSqlHelper_Table

파일 보기 프로젝트 열기: dnnsharp/DynamicRotator 1 사용 예제들

공개 메소드들

메소드 설명
Add ( object pKeys ) : int
AvtSqlHelper_Table ( string connString, string table, bool isIdentity, string idColumns ) : System
Delete ( object pKeys ) : void
Delete ( string whereCond ) : void
Edit ( object pKeys ) : void
EncodeSql ( object data ) : string
ExecuteNonQuery ( SqlConnection connection, CommandType commandType, string commandText ) : int
ExecuteNonQuery ( string connectionString, CommandType commandType, string commandText ) : int
ExecuteReader ( SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter commandParameters ) : System.Data.SqlClient.SqlDataReader
ExecuteReader ( string connectionString, CommandType commandType, string commandText ) : System.Data.SqlClient.SqlDataReader
ExecuteScalar ( SqlConnection connection, CommandType commandType, string commandText ) : object
ExecuteScalar ( string connectionString, CommandType commandType, string commandText ) : object
Get ( string appendSql ) : IDataReader
GetScalar ( string column, string appendSql ) : object
Update ( object pKeys ) : int
UpdateField ( string fieldName, object data, string whereCond ) : void

비공개 메소드들

메소드 설명
JoinConditions ( string sep, string columns, object values ) : string
PrepareCommand ( SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter commandParameters, bool &mustCloseConnection ) : void
SqlAdd ( object pKeys ) : string
SqlEdit ( object pKeys ) : string

메소드 상세

Add() 공개 메소드

public Add ( object pKeys ) : int
pKeys object
리턴 int

AvtSqlHelper_Table() 공개 메소드

public AvtSqlHelper_Table ( string connString, string table, bool isIdentity, string idColumns ) : System
connString string
table string
isIdentity bool
idColumns string
리턴 System

Delete() 공개 메소드

public Delete ( object pKeys ) : void
pKeys object
리턴 void

Delete() 공개 메소드

public Delete ( string whereCond ) : void
whereCond string
리턴 void

Edit() 공개 메소드

public Edit ( object pKeys ) : void
pKeys object
리턴 void

EncodeSql() 공개 정적인 메소드

public static EncodeSql ( object data ) : string
data object
리턴 string

ExecuteNonQuery() 공개 정적인 메소드

public static ExecuteNonQuery ( SqlConnection connection, CommandType commandType, string commandText ) : int
connection System.Data.SqlClient.SqlConnection
commandType CommandType
commandText string
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

public static ExecuteNonQuery ( string connectionString, CommandType commandType, string commandText ) : int
connectionString string
commandType CommandType
commandText string
리턴 int

ExecuteReader() 공개 정적인 메소드

public static ExecuteReader ( SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter commandParameters ) : System.Data.SqlClient.SqlDataReader
connection System.Data.SqlClient.SqlConnection
transaction System.Data.SqlClient.SqlTransaction
commandType CommandType
commandText string
commandParameters System.Data.SqlClient.SqlParameter
리턴 System.Data.SqlClient.SqlDataReader

ExecuteReader() 공개 정적인 메소드

public static ExecuteReader ( string connectionString, CommandType commandType, string commandText ) : System.Data.SqlClient.SqlDataReader
connectionString string
commandType CommandType
commandText string
리턴 System.Data.SqlClient.SqlDataReader

ExecuteScalar() 공개 정적인 메소드

public static ExecuteScalar ( SqlConnection connection, CommandType commandType, string commandText ) : object
connection System.Data.SqlClient.SqlConnection
commandType CommandType
commandText string
리턴 object

ExecuteScalar() 공개 정적인 메소드

public static ExecuteScalar ( string connectionString, CommandType commandType, string commandText ) : object
connectionString string
commandType CommandType
commandText string
리턴 object

Get() 공개 메소드

public Get ( string appendSql ) : IDataReader
appendSql string
리턴 IDataReader

GetScalar() 공개 메소드

public GetScalar ( string column, string appendSql ) : object
column string
appendSql string
리턴 object

Update() 공개 메소드

public Update ( object pKeys ) : int
pKeys object
리턴 int

UpdateField() 공개 메소드

public UpdateField ( string fieldName, object data, string whereCond ) : void
fieldName string
data object
whereCond string
리턴 void