C# Class afung.MangaWeb3.Server.Database

Afficher le fichier Open project: a-fung/MangaWeb3

Méthodes publiques

Méthode	Description
BuildWhereClauseOr ( string field, IEnumerable values ) : string
Clear ( string table ) : void
Delete ( string table, string where ) : void
ExecuteSql ( string sql ) : void
GetConnection ( string server, int port, string username, string password, string database ) : MySqlConnection
GetDistinctStringValues ( string table, string field ) : string[]
GetDistinctStringValues ( string table, string field, string where ) : string[]
Insert ( string table, object>.Dictionary data ) : void
InsertAndReturnId ( string table, object>.Dictionary data ) : int
Quote ( string str ) : string
Replace ( string table, object>.Dictionary data ) : void
Select ( string table ) : object>[].Dictionary
Select ( string table, string where ) : object>[].Dictionary
Select ( string table, string where, string order ) : object>[].Dictionary
Select ( string table, string where, string order, string limit ) : object>[].Dictionary
Select ( string table, string where, string order, string limit, string fields ) : object>[].Dictionary
Update ( string table, object>.Dictionary data, string where ) : void
Update ( string table, object>.Dictionary data, string where, string limit ) : void

Private Methods

Méthode	Description
DefaultConnection ( ) : MySqlConnection
InsertOrReplace ( string method, string table, object>.Dictionary data ) : void
LastInsertId ( ) : int

Method Details

BuildWhereClauseOr() public static méthode

public static BuildWhereClauseOr ( string field, IEnumerable values ) : string
field	string
values	IEnumerable
Résultat	string

Clear() public static méthode

public static Clear ( string table ) : void
table	string
Résultat	void

Delete() public static méthode

public static Delete ( string table, string where ) : void
table	string
where	string
Résultat	void

ExecuteSql() public static méthode

public static ExecuteSql ( string sql ) : void
sql	string
Résultat	void

GetConnection() public static méthode

public static GetConnection ( string server, int port, string username, string password, string database ) : MySqlConnection
server	string
port	int
username	string
password	string
database	string
Résultat	MySql.Data.MySqlClient.MySqlConnection

GetDistinctStringValues() public static méthode

public static GetDistinctStringValues ( string table, string field ) : string[]
table	string
field	string
Résultat	string[]

GetDistinctStringValues() public static méthode

public static GetDistinctStringValues ( string table, string field, string where ) : string[]
table	string
field	string
where	string
Résultat	string[]

Insert() public static méthode

public static Insert ( string table, object>.Dictionary data ) : void
table	string
data	object>.Dictionary
Résultat	void

InsertAndReturnId() public static méthode

public static InsertAndReturnId ( string table, object>.Dictionary data ) : int
table	string
data	object>.Dictionary
Résultat	int

Quote() public static méthode

public static Quote ( string str ) : string
str	string
Résultat	string

Replace() public static méthode

public static Replace ( string table, object>.Dictionary data ) : void
table	string
data	object>.Dictionary
Résultat	void

Select() public static méthode

public static Select ( string table ) : object>[].Dictionary
table	string
Résultat	object>[].Dictionary

Select() public static méthode

public static Select ( string table, string where ) : object>[].Dictionary
table	string
where	string
Résultat	object>[].Dictionary

Select() public static méthode

public static Select ( string table, string where, string order ) : object>[].Dictionary
table	string
where	string
order	string
Résultat	object>[].Dictionary

Select() public static méthode

public static Select ( string table, string where, string order, string limit ) : object>[].Dictionary
table	string
where	string
order	string
limit	string
Résultat	object>[].Dictionary

Select() public static méthode

public static Select ( string table, string where, string order, string limit, string fields ) : object>[].Dictionary
table	string
where	string
order	string
limit	string
fields	string
Résultat	object>[].Dictionary

Update() public static méthode

public static Update ( string table, object>.Dictionary data, string where ) : void
table	string
data	object>.Dictionary
where	string
Résultat	void

Update() public static méthode

public static Update ( string table, object>.Dictionary data, string where, string limit ) : void
table	string
data	object>.Dictionary
where	string
limit	string
Résultat	void