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;
}
