C# Class LoginServer.Systems.MsSQL

Exibir arquivo Open project: CarlosX/DarkEmu

Public Properties

Property Type Description
SQL string
cmd1 System.Data.SqlClient.SqlCommand
connection System.Data.SqlClient.SqlConnection
connection1 System.Data.SqlClient.SqlConnection
da System.Data.SqlClient.SqlDataAdapter
reader System.Data.SqlClient.SqlDataReader

Public Methods

Method Description
CharacterData ( string charname, string toGet ) : string
CharacterDataInt ( string charname, string toGet ) : int
Close ( ) : void
Connection ( string connections ) : void
Count ( ) : int
DeleteData ( string command ) : void
GetByte ( string column ) : byte
GetData ( string sql, string column ) : string
GetDataDouble ( string column ) : double
GetDataDouble ( string sql, string column ) : double
GetDataFloat ( string column ) : float
GetDataInt ( string sql, string column ) : int
GetDataLong ( string sql, string column ) : long
GetDouble ( string column ) : double
GetInt16 ( string column ) : short
GetInt32 ( string column ) : int
GetInt64 ( string column ) : long
GetRowsCount ( string command ) : int
GetSingle ( string column ) : float
GetString ( string column ) : string
InsertData ( string command ) : void
MsSQL ( string sql ) : System
Read ( ) : System.Data.SqlClient.SqlDataReader
UpdateData ( string command ) : void

Method Details

CharacterData() public static method

public static CharacterData ( string charname, string toGet ) : string
charname string
toGet string
return string

CharacterDataInt() public static method

public static CharacterDataInt ( string charname, string toGet ) : int
charname string
toGet string
return int

Close() public method

public Close ( ) : void
return void

Connection() public static method

public static Connection ( string connections ) : void
connections string
return void

Count() public method

public Count ( ) : int
return int

DeleteData() public static method

public static DeleteData ( string command ) : void
command string
return void

GetByte() public method

public GetByte ( string column ) : byte
column string
return byte

GetData() public static method

public static GetData ( string sql, string column ) : string
sql string
column string
return string

GetDataDouble() public method

public GetDataDouble ( string column ) : double
column string
return double

GetDataDouble() public static method

public static GetDataDouble ( string sql, string column ) : double
sql string
column string
return double

GetDataFloat() public method

public GetDataFloat ( string column ) : float
column string
return float

GetDataInt() public static method

public static GetDataInt ( string sql, string column ) : int
sql string
column string
return int

GetDataLong() public static method

public static GetDataLong ( string sql, string column ) : long
sql string
column string
return long

GetDouble() public method

public GetDouble ( string column ) : double
column string
return double

GetInt16() public method

public GetInt16 ( string column ) : short
column string
return short

GetInt32() public method

public GetInt32 ( string column ) : int
column string
return int

GetInt64() public method

public GetInt64 ( string column ) : long
column string
return long

GetRowsCount() public static method

public static GetRowsCount ( string command ) : int
command string
return int

GetSingle() public method

public GetSingle ( string column ) : float
column string
return float

GetString() public method

public GetString ( string column ) : string
column string
return string

InsertData() public static method

public static InsertData ( string command ) : void
command string
return void

MsSQL() public method

public MsSQL ( string sql ) : System
sql string
return System

Read() public method

public Read ( ) : System.Data.SqlClient.SqlDataReader
return System.Data.SqlClient.SqlDataReader

UpdateData() public static method

public static UpdateData ( string command ) : void
command string
return void

Property Details

SQL public_oe property

public string SQL
return string

cmd1 public_oe property

public SqlCommand,System.Data.SqlClient cmd1
return System.Data.SqlClient.SqlCommand

connection public_oe static_oe property

public static SqlConnection,System.Data.SqlClient connection
return System.Data.SqlClient.SqlConnection

connection1 public_oe property

public SqlConnection,System.Data.SqlClient connection1
return System.Data.SqlClient.SqlConnection

da public_oe static_oe property

public static SqlDataAdapter,System.Data.SqlClient da
return System.Data.SqlClient.SqlDataAdapter

reader public_oe property

public SqlDataReader,System.Data.SqlClient reader
return System.Data.SqlClient.SqlDataReader