C# 클래스 AerolineaFrba.SQLManager

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

공개 프로퍼티들

프로퍼티	타입	설명
command	System.Data.SqlClient.SqlCommand

공개 메소드들

메소드	설명
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

비공개 메소드들

메소드	설명
crearDataTable ( IEnumerable
crearDataTable ( IEnumerable lista ) : DataTable

메소드 상세

agregarBooleanoSP() 공개 메소드

public agregarBooleanoSP ( string nombreVariable, bool valor ) : SQLManager
nombreVariable	string
valor	bool
리턴	SQLManager

agregarDecimalSP() 공개 메소드

public agregarDecimalSP ( string nombreVariable, decimal numero ) : SQLManager
nombreVariable	string
numero	decimal
리턴	SQLManager

agregarFechaNula() 공개 메소드

public agregarFechaNula ( string nombreVariable ) : SQLManager
nombreVariable	string
리턴	SQLManager

agregarFechaSP() 공개 메소드

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

agregarFechaSP() 공개 메소드

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

agregarInt64SP() 공개 메소드

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

agregarInt64SP() 공개 메소드

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

agregarIntSP() 공개 메소드

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

agregarIntSP() 공개 메소드

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

agregarListaSP() 공개 메소드

public agregarListaSP ( string nombreVariable, List
nombreVariable	string
funcionalidades	List
리턴	SQLManager

agregarListaSP() 공개 메소드

public agregarListaSP ( string nombreVariable, List codigos ) : SQLManager
nombreVariable	string
codigos	List
리턴	SQLManager

agregarStringSP() 공개 메소드

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

agregarStringSP() 공개 메소드

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

agregarStringSP() 공개 메소드

public agregarStringSP ( string nombreVariable, string nombre ) : SQLManager
nombreVariable	string
nombre	string
리턴	SQLManager

agregarTableSP() 공개 메소드

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

ejecutarQuery() 공개 정적인 메소드

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

ejecutarSP() 공개 메소드

public ejecutarSP ( ) : Object
리턴	Object

generarSP() 공개 메소드

public generarSP ( string nombre ) : SQLManager
nombre	string
리턴	SQLManager

프로퍼티 상세

command 공개적으로 프로퍼티

public SqlCommand,System.Data.SqlClient command
리턴	System.Data.SqlClient.SqlCommand