C# Class AerolineaFrba.SQLManager

Mostrar archivo 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 funcionalidades ) : SQLManager
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 lista ) : DataTable
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 funcionalidades ) : SQLManager
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