private void limpiarDatos() { txtFecha.Text = DateTime.Now.Date.Date.ToString("MM-dd-yyyy"); txtHora.Text = DateTime.Now.ToShortTimeString().ToString(); obDatos.Conectar(); obDatos.consultar("SELECT COUNT(numfac_fac) from ", "facturas"); numeroFactura = Convert.ToInt32(obDatos.ds.Tables["facturas"].Rows[0][0].ToString()) + 1; this.txtNumeroFactura.Text = (Convert.ToString(numeroFactura)); actualizarDatosFactura(); this.cmbTipoPago.DataSource = obDatos.ConsultaTabla("tipo_factura", " descri_fac"); this.cmbTipoPago.DisplayMember = "descri_fac"; this.cmbTipoPago.ValueMember = "codtip_fac"; this.cmbTipoNCF.DataSource = obDatos.ConsultaTabla("tipo_NCF", " descri_tncf"); this.cmbTipoNCF.DisplayMember = "descri_tncf"; this.cmbTipoNCF.ValueMember = "codigo_tncf"; this.cmbTipoNCF.SelectedIndex = 6; string truncarTablaTemporal = ("truncate table facturatemporal"); obDatos.Consulta_llenar_datos(truncarTablaTemporal); actualizarDatosFactura(); this.txtCodigoArticulo.Focus(); this.txtCodigoCliente.Text = ""; this.lblNombreCliente.Text = ""; this.lblRepresentante.Text = ""; this.txtConcepto.Text = ""; this.txtNCF.Text = ""; }
private void Form1_Load(object sender, EventArgs e) { obDatos.consultar("SELECT Id_Colaborador AS Número_de_empleado,Nombre,Apellido_Paterno,Apellido_Materno FROM tbl_colaboradoresgi WHERE Id_Colaborador!=1", "tbl_colaboradoresgi"); this.datagrid_gi.DataSource = obDatos.ds.Tables["tbl_colaboradoresgi"]; this.datagrid_gi.Refresh(); obDatos.consultar("SELECT * FROM tbl_colaboradoresgi", "tbl_colaboradoresgi"); this.datagrid_plubek.DataSource = obDatos.ds.Tables["tbl_colaboradoresgi"]; this.datagrid_plubek.Refresh(); }
private void Alta_area_Load(object sender, EventArgs e) { this.CancelButton = btncancelararea; this.AcceptButton = btnaceptararea; //cmbdepartamento.Focus(); //cmbdepartamento.Select(); this.cmbdepartamento.ValueMember = "Id_Departamento"; obDatos.consultar("SELECT Id_Departamento, cast(Id_Departamento AS varchar) +' '+ Nombre AS Combo_Dep FROM tbl_departamentos", "combo_dep"); obDatos.da.Fill(obDatos.ds, "tbl_departamentos"); this.cmbdepartamento.DataSource = obDatos.ds.Tables[0].DefaultView; this.cmbdepartamento.DisplayMember = "Combo_Dep"; }
private void frm_areas_Load(object sender, EventArgs e) { //txt_filtroareas.Focus(); //txt_filtroareas.Select(); this.AcceptButton = btnNuevo; this.CancelButton = btnCerrar; obDatos.consultar("SELECT tbl_areas.Id_Area as Clave_área, tbl_areas.Nombre AS Área, tbl_departamentos.Nombre AS Departamento FROM tbl_areas LEFT JOIN tbl_departamentos ON tbl_areas.Id_Departamento = tbl_Departamentos.Id_Departamento WHERE Id_Area!=0", "tbl_areas"); this.dgv_areas.DataSource = obDatos.ds.Tables["tbl_areas"]; this.dgv_areas.Refresh(); //obDatos.consultar("SELECT tbl_areas.Id_Area as Clave_área, tbl_areas.Nombre AS Área, tbl_departamentos.Nombre AS Departamento FROM tbl_areas LEFT JOIN tbl_departamentos ON tbl_areas.Id_Departamento = tbl_Departamentos.Id_Departamento WHERE Id_Area!= 1 AND tbl_areas.Id_Eliminado IS NULL AND tbl_areas.Nombre LIKE'%chi%'", "tbl_areas"); //this.dgv_areas.DataSource = obDatos.ds.Tables["tbl_areas"]; }
private void proximoCodigoCxP() { objDatos.Conectar(); objDatos.consultar("SELECT codigo_cpp from ", "numero_cpp"); if (objDatos.ds.Tables[0].Rows.Count > 0) { CodigoCxP = Convert.ToInt32(objDatos.ds.Tables["numero_cpp"].Rows[0][0].ToString()) + 1; this.txtCodigoCxP.Text = CodigoCxP.ToString(); } else { CodigoCxP = 1; this.txtCodigoCxP.Text = CodigoCxP.ToString(); } objDatos.Desconectar(); }
private void proCuentasxCobrar_Load(object sender, EventArgs e) { txtFecha.Text = DateTime.Now.Date.Date.ToString("MM-dd-yyyy"); objDatos.Conectar(); objDatos.consultar("SELECT codigo_cpc from ", "numero_cpc"); if (objDatos.ds.Tables[0].Rows.Count > 0) { CodigoCxC = Convert.ToInt32(objDatos.ds.Tables["numero_cpc"].Rows[0][0].ToString()) + 1; this.txtCodigoCxC.Text = CodigoCxC.ToString(); } else { CodigoCxC = 1; this.txtCodigoCxC.Text = CodigoCxC.ToString(); } this.cmbTipoPago.DataSource = objDatos.ConsultaTabla("tipo_pagos", " descri_tpa"); this.cmbTipoPago.DisplayMember = "descri_tpa"; this.cmbTipoPago.ValueMember = "codigo_tpa"; objDatos.Desconectar(); }
private void FiltroDep_KeyUp(object sender, KeyEventArgs e) { obDatos.consultar("select Id_Departamento as Clave, Nombre FROM tbl_departamentos WHERE tbl_departamentos.ID_Eliminado=0 and tbl_departamentos.Id_Departamento!=1 AND tbl_departamentos.Nombre LIKE '%" + this.txt_buscar.Text + "%' ", "tbl_departamentos"); this.datagrid_departamentos.DataSource = obDatos.ds.Tables["tbl_departamentos"]; return; }