C# Class AerolineaFrba.SQLManager

Exibir arquivo Open project: santileira/BHLP Class Usage Examples

Public Properties

Property	Type	Description
command	System.Data.SqlClient.SqlCommand

Public Methods

Method	Description
agregarBooleanoSP ( string nombreVariable, bool valor ) : SQLManager
agregarDecimalSP ( string nombreVariable, decimal numero ) : SQLManager
agregarFechaNula ( string nombreVariable ) : SQLManager
agregarFechaSP ( string nombreVariable, System.DateTime dateTime ) : SQLManager
agregarFechaSP ( string nombreVariable, DateTimePicker dateTime ) : SQLManager
agregarInt64SP ( string nombreVariable, System.Int64 numero ) : SQLManager
agregarInt64SP ( string nombreVariable, TextBox txt ) : SQLManager
agregarIntSP ( string nombreVariable, Int32 numero ) : SQLManager
agregarIntSP ( string nombreVariable, TextBox txt ) : SQLManager
agregarListaSP ( string nombreVariable, List
agregarListaSP ( string nombreVariable, List codigos ) : SQLManager
agregarStringSP ( string nombreVariable, ComboBox cmb ) : SQLManager
agregarStringSP ( string nombreVariable, TextBox txt ) : SQLManager
agregarStringSP ( string nombreVariable, string nombre ) : SQLManager
agregarTableSP ( string nombreVariable, DataTable tabla ) : SQLManager
ejecutarQuery ( string query, System.Windows.Forms.DataGridView unDg ) : void
ejecutarSP ( ) : Object
generarSP ( string nombre ) : SQLManager

Private Methods

Method	Description
crearDataTable ( IEnumerable
crearDataTable ( IEnumerable lista ) : DataTable

Method Details

agregarBooleanoSP() public method

public agregarBooleanoSP ( string nombreVariable, bool valor ) : SQLManager
nombreVariable	string
valor	bool
return	SQLManager

agregarDecimalSP() public method

public agregarDecimalSP ( string nombreVariable, decimal numero ) : SQLManager
nombreVariable	string
numero	decimal
return	SQLManager

agregarFechaNula() public method

public agregarFechaNula ( string nombreVariable ) : SQLManager
nombreVariable	string
return	SQLManager

agregarFechaSP() public method

public agregarFechaSP ( string nombreVariable, System.DateTime dateTime ) : SQLManager
nombreVariable	string
dateTime	System.DateTime
return	SQLManager

agregarFechaSP() public method

public agregarFechaSP ( string nombreVariable, DateTimePicker dateTime ) : SQLManager
nombreVariable	string
dateTime	System.Windows.Forms.DateTimePicker
return	SQLManager

agregarInt64SP() public method

public agregarInt64SP ( string nombreVariable, System.Int64 numero ) : SQLManager
nombreVariable	string
numero	System.Int64
return	SQLManager

agregarInt64SP() public method

public agregarInt64SP ( string nombreVariable, TextBox txt ) : SQLManager
nombreVariable	string
txt	System.Windows.Forms.TextBox
return	SQLManager

agregarIntSP() public method

public agregarIntSP ( string nombreVariable, Int32 numero ) : SQLManager
nombreVariable	string
numero	System.Int32
return	SQLManager

agregarIntSP() public method

public agregarIntSP ( string nombreVariable, TextBox txt ) : SQLManager
nombreVariable	string
txt	System.Windows.Forms.TextBox
return	SQLManager

agregarListaSP() public method

public agregarListaSP ( string nombreVariable, List
nombreVariable	string
funcionalidades	List
return	SQLManager

agregarListaSP() public method

public agregarListaSP ( string nombreVariable, List codigos ) : SQLManager
nombreVariable	string
codigos	List
return	SQLManager

agregarStringSP() public method

public agregarStringSP ( string nombreVariable, ComboBox cmb ) : SQLManager
nombreVariable	string
cmb	System.Windows.Forms.ComboBox
return	SQLManager

agregarStringSP() public method

public agregarStringSP ( string nombreVariable, TextBox txt ) : SQLManager
nombreVariable	string
txt	System.Windows.Forms.TextBox
return	SQLManager

agregarStringSP() public method

public agregarStringSP ( string nombreVariable, string nombre ) : SQLManager
nombreVariable	string
nombre	string
return	SQLManager

agregarTableSP() public method

public agregarTableSP ( string nombreVariable, DataTable tabla ) : SQLManager
nombreVariable	string
tabla	System.Data.DataTable
return	SQLManager

ejecutarQuery() public static method

public static ejecutarQuery ( string query, System.Windows.Forms.DataGridView unDg ) : void
query	string
unDg	System.Windows.Forms.DataGridView
return	void

ejecutarSP() public method

public ejecutarSP ( ) : Object
return	Object

generarSP() public method

public generarSP ( string nombre ) : SQLManager
nombre	string
return	SQLManager

Property Details

command public_oe property

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