private void Form1_Load(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select max(codigo_salida_camiones) as 'ultimo' from salida_camiones"); if (objDatos.ds.Tables[0].Rows.Count > 0) { ultimaSalida = Convert.ToInt32(objDatos.ds.Tables[0].Rows[0][0].ToString()); } objDatos.Consulta_llenar_datos("consultar_ultima_salida_camion " + ultimaSalida); Reportes.ReporteSalida.rptUltimaSalida rp = new Reportes.ReporteSalida.rptUltimaSalida(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.ShowCloseButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowGotoPageButton = false; crystalReportViewer1.ShowLogo = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.DisplayStatusBar = false; crystalReportViewer1.RefreshReport(); objDatos.Desconectar(); }
private void button1_Click(object sender, EventArgs e) { if (this.txtAPagar.Text != "") { int rows = dataGridView1.RowCount; for (int i = 0; i < rows; i++) { objDatos.Conectar(); objDatos3.Conectar(); string sql = "select cpp.codigo_cpp from cuentas_por_pagar cpp where cpp.numfac_fac = '" + dataGridView1.Rows[i].Cells[0].Value + "'"; string referecnia = "select referecnia from cuentas_por_pagar cpp where cpp.numfac_fac = '" + dataGridView1.Rows[i].Cells[0].Value + "'"; objDatos.Consulta_llenar_datos(sql); objDatos3.Consulta_llenar_datos(referecnia); codigoCpC = Convert.ToInt32(objDatos.ds.Tables[0].Rows[0][0].ToString()); objDatos.Consulta_llenar_datos("insert into cuenta_por_pagar_temporal values ('" + dataGridView1.Rows[i].Cells[0].Value + "','" + dataGridView1.Rows[i].Cells[2].Value + "'," + dataGridView1.Rows[i].Cells[3].Value + ",'" + dataGridView1.Rows[i].Cells[4].Value + "','" + dataGridView1.Rows[i].Cells[5].Value + "','" + dataGridView1.Rows[i].Cells[6].Value + "'," + dataGridView1.Rows[i].Cells[7].Value + "," + dataGridView1.Rows[i].Cells[8].Value + ",'" + dataGridView1.Rows[i].Cells[9].Value + "'," + codigoCpC.ToString() + ",'" + objDatos3.ds.Tables[0].Rows[0][0].ToString() + "')"); objDatos.Desconectar(); objDatos3.Desconectar(); } //Buscar cantidad de facturas marcadas objDatos.Consulta_llenar_datos("select count(codigo_cpp) from cuenta_por_pagar_temporal where saldar = 1"); int cantFacturas = 0; cantFacturas = Convert.ToInt32(objDatos.ds.Tables[0].Rows[0][0].ToString()); for (int n = 0; n < cantFacturas; n++) { objDatos2.Conectar(); objDatos2.Consulta_llenar_datos("select * from cuenta_por_pagar_temporal where saldar = 1"); Int32 codigoCXP = Convert.ToInt32(objDatos2.ds.Tables[0].Rows[n][9].ToString()); DateTime fecha = Convert.ToDateTime(objDatos2.ds.Tables[0].Rows[n][1].ToString()); string numfac_fac = objDatos2.ds.Tables[0].Rows[n][0].ToString(); double credito = Convert.ToDouble(objDatos2.ds.Tables[0].Rows[n][2].ToString()); double monto = Convert.ToDouble(objDatos2.ds.Tables[0].Rows[n][2].ToString()); double debito = Convert.ToDouble(objDatos2.ds.Tables[0].Rows[n][2].ToString()); double saldo_final = 0.0; int codigocliente = Convert.ToInt16(objDatos2.ds.Tables[0].Rows[n][7].ToString()); string ncf = objDatos2.ds.Tables[0].Rows[n][4].ToString(); string referencia = objDatos2.ds.Tables[0].Rows[n][10].ToString(); string sql = "actualiza_cuentas_por_pagar " + codigoCXP.ToString() + ",'" + fecha.ToShortDateString() + "','" + numfac_fac.ToString() + "'," + credito.ToString() + "," + monto.ToString() + "," + debito.ToString() + "," + saldo_final.ToString() + "," + this.cmbTipoPago.SelectedValue.ToString() + "," + codigoEmpleado + "," + codigocliente.ToString() + ",'" + ncf.ToString() + "','" + referencia.ToString() + "'"; objDatos2.Consulta_llenar_datos(sql); string sql2 = "insert into registro_detalles_abonos_cpp values (" + codigoCXP + ",'" + numfac_fac.ToString() + "'," + monto.ToString() + ")"; objDatos2.Consulta_llenar_datos(sql2); objDatos2.Desconectar(); objDatos.Consulta_llenar_datos("insert into registro_abonos_cpp values (" + codigoCXP + "," + this.txtCodigoCliente.Text + ",'" + this.txtFecha.Text.ToString() + "')"); } MessageBox.Show("Proceso concluido"); objDatos.Consulta_llenar_datos("truncate table cuenta_por_pagar_temporal"); limpiarPantall(); } else { MessageBox.Show("Expecifique el monto que desea abonar a la CxP"); } }
private void actualizarDatosFactura() { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select cpp.numfac_fac as 'No. Fac.',cpp.codigo_cpp as 'CxP',cpp.fecha as 'Fecha Factura',cpp.monto as 'Monto',u.nombre_usuario as 'Usuario',cpp.ncf_ncf as 'NCF',tf.descri_fac as 'Tipo Factura',cpp.saldo_final as 'Balance',cpp.codigo_suplidor as 'Codigo Suplidor', cpp.Saldar as 'Saldar' from tipo_factura tf,usuarios u,cuentas_por_pagar cpp where cpp.codtip_fac = tf.codtip_fac and cpp.codigo_usuario = u.codigo_usuario and cpp.saldo_final > 0 and cpp.codigo_suplidor = " + CodigoCliente.ToString() + ""); if (objDatos.ds.Tables[0].Rows.Count > 0) { int nSaldar = ((int)objDatos.ds.Tables[0].Rows.Count) - 1; this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 60; this.dataGridView1.Columns[1].Width = 60; this.dataGridView1.Columns[2].Width = 80; this.dataGridView1.Columns[3].Width = 70; this.dataGridView1.Columns[4].Width = 95; this.dataGridView1.Columns[5].Width = 139; this.dataGridView1.Columns[6].Width = 99; this.dataGridView1.Columns[7].Width = 65; this.dataGridView1.Columns[8].Width = 88; this.dataGridView1.Columns[9].Width = 50; } else { MessageBox.Show("El suplidor " + this.txtNombreCliente.Text.TrimEnd() + ", no tiene cuentas por pagar pendientes"); } }
private Int32 kilometrajeActualCambioAceite() { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select * from control_cambio_aceite where control_cambio_aceite.codveh_veh = " + txtCodigoCamion.Text); if (objDatos.ds.Tables[0].Rows.Count > 0) { return(Convert.ToInt32(this.txtCamion.Text = objDatos.ds.Tables[0].Rows[0][2].ToString())); } else { return(0); } }
private void proCuadreCaja_Load(object sender, EventArgs e) { try { datos objDatos = new datos(); string fecha = DateTime.Now.Date.Date.ToString("yyyy-MM-dd"); objDatos.Conectar(); objDatos.Consulta_llenar_datos("select SUM(f.monfac_fac)as 'monto' from facturas f where f.fecfac_fac = " + "'" + fecha.ToString() + "' and f.codtip_fac = 1"); if (Convert.ToString(objDatos.ds.Tables[0].Rows[0][0].ToString()) == "") { this.txtTotalEfectivoSistema.Text = "$0.00"; } else { vendidoEfectivo = Convert.ToDouble(objDatos.ds.Tables[0].Rows[0][0].ToString()); this.txtTotalEfectivoSistema.Text = vendidoEfectivo.ToString("C"); } objDatos.Desconectar(); objDatos.Conectar(); objDatos.Consulta_llenar_datos("select SUM(f.monfac_fac)as 'monto' from facturas f where f.codtip_fac = 2 and f.fecfac_fac = " + "'" + fecha.ToString() + "'"); if (Convert.ToString(objDatos.ds.Tables[0].Rows[0][0].ToString()) == "") { this.txtVentasEfectivo.Text = "$0.00"; } else { { vendidoCredito = Convert.ToDouble(objDatos.ds.Tables[0].Rows[0][0].ToString()); this.txtVentasEfectivo.Text = vendidoCredito.ToString("C"); } } //-------------------VENTAS EN TARJETA DE CREDITO--------------------- // objDatos.Consulta_llenar_datos("select SUM(f.monfac_fac)as 'monto' from facturas f where f.codtip_fac = 3 and f.fecfac_fac = " + "'" + fecha.ToString() + "'"); // if (objDatos.ds.Tables[0].Rows.Count < 1) // { // this.txtTotalVentasTarjeta.Text = "$0.00"; // } // else // { // vendidotarjeta = Convert.ToDouble(objDatos.ds.Tables[0].Rows[0][0].ToString()); // this.txtTotalVentasTarjeta.Text = vendidotarjeta.ToString("C"); // } } catch (System.Exception ex) { MessageBox.Show("No se encontraron facturas el dia de hoy"); } this.lblSistema.Text = (vendidoCredito + vendidoEfectivo).ToString("C"); this.lblSistema2.Text = (vendidoEfectivo).ToString("C"); }
private void txtCamion_TextChanged(object sender, EventArgs e) { if (this.txtCamion.Text != "Nuevo") { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select m.descripcion + ' ' + mv.descripcion + ' año ' + convert(varchar(4),v.anoveh_veh) + ', Placa ' + convert(varchar(12),v.numpla_veh) + ' Chasis ' + convert(varchar(17),v.numcha_veh) as vehiculo from vehiculo v, marca_articulos m, tipo_vehiculos tv, modelos_vehiculos mv, colores c where v.codigo_marca = m.codigo_marca and v.codigo_tipo_vehiculo = tv.codigo_tipo_vehiculo and v.codigo_modelos =mv.codigo_modelos and c.codigo_color = v.codigo_color and v.codveh_veh = " + txtCamion.Text); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.lblDatosCamion.Text = objDatos.ds.Tables[0].Rows[0][0].ToString(); } else { MessageBox.Show("Cliente no encontrado", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
private void cmdNuevo_Click(object sender, EventArgs e) { if (txtCamion.Text != "") { datos objDatos = new datos(); objDatos.Conectar(); objDatos.Consulta_llenar_datos("consultar_salida_camion " + this.txtCamion.Text + ""); Reportes.Salida.rptSalidaCamiones rp = new Reportes.Salida.rptSalidaCamiones(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.ShowCloseButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowGotoPageButton = false; crystalReportViewer1.ShowLogo = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.DisplayStatusBar = false; crystalReportViewer1.RefreshReport(); objDatos.Desconectar(); } else { MessageBox.Show("Debe seleccionar un camion"); } }
private void busquedaServicios_Load(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select * from servicios"); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 80; this.dataGridView1.Columns[0].HeaderText = "ID"; this.dataGridView1.Columns[1].Width = 418; this.dataGridView1.Columns[1].HeaderText = "Nombre del servicio"; this.dataGridView1.Columns[2].Width = 150; this.dataGridView1.Columns[2].HeaderText = "Precio"; this.dataGridView1.Columns[3].Width = 100; this.dataGridView1.Columns[3].HeaderText = "Estado"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); textBox1.Focus(); }
private void txtID_TextChanged(object sender, EventArgs e) { if (this.txtID.Text != "Nuevo") { objDatos.Conectar(); string sql = ("select * from clientes c, tipo_cliente tc where c.codtip_tip = tc.codtip_tip and codigo_cliente = " + this.txtID.Text + ""); objDatos.Consulta_llenar_datos(sql); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.txtnombre.Text = objDatos.ds.Tables[0].Rows[0][1].ToString(); this.txtIDentificacion.Text = objDatos.ds.Tables[0].Rows[0][2].ToString(); //this.dateTimePicker1.Text = objDatos.ds.Tables[0].Rows[0][4].ToString(); this.txtTelefono1.Text = objDatos.ds.Tables[0].Rows[0][5].ToString(); this.txtDireccion.Text = objDatos.ds.Tables[0].Rows[0][7].ToString(); this.txtTelefono2.Text = objDatos.ds.Tables[0].Rows[0][6].ToString(); this.cbmTipoCliente.Text = objDatos.ds.Tables[0].Rows[0][12].ToString(); this.txtRepresentante.Text = objDatos.ds.Tables[0].Rows[0][9].ToString(); this.telRepresentante.Text = objDatos.ds.Tables[0].Rows[0][10].ToString(); this.txtRNC.Text = objDatos.ds.Tables[0].Rows[0][11].ToString(); if (Convert.ToBoolean(objDatos.ds.Tables[0].Rows[0][3]) == true) { this.estado.Checked = true; } if (Convert.ToBoolean(objDatos.ds.Tables[0].Rows[0][3]) == false) { this.estado.Checked = false; } buscarImagen(); this.cmdEliminar.Enabled = true; objDatos.Cn.Close(); } } }
private void busquedaSuplidores_Load(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select c.codigo_suplidor, c.nombre, c.direccion,c.telefono1, c.telefono2 from suplidores c"); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 48; this.dataGridView1.Columns[0].HeaderText = "ID"; this.dataGridView1.Columns[1].Width = 200; this.dataGridView1.Columns[1].HeaderText = "Nombre del suplidor"; this.dataGridView1.Columns[2].Width = 300; this.dataGridView1.Columns[2].HeaderText = "Direccion del suplidor"; this.dataGridView1.Columns[3].Width = 100; this.dataGridView1.Columns[3].HeaderText = "Telefono 1"; this.dataGridView1.Columns[4].Width = 100; this.dataGridView1.Columns[4].HeaderText = "Telefono 2"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); textBox1.Focus();; }
private void txtCamion_TextChanged(object sender, EventArgs e) { if (this.txtCamion.Text != "Nuevo") { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select m.descripcion + ' ' + mv.descripcion + ' año ' + convert(varchar(4),v.anoveh_veh) + ', Placa ' + convert(varchar(12),v.numpla_veh) + ' Chasis ' + convert(varchar(17),v.numcha_veh) as vehiculo,mav.aceite,mav.seguro,mav.correa_tiempo,mav.frenos,mav.codigo_mantenimiento_vehiculos from vehiculo v, marca_articulos m, tipo_vehiculos tv, modelos_vehiculos mv, colores c, mantenimiento_vehiculos mav where v.codigo_marca = m.codigo_marca and v.codigo_tipo_vehiculo = tv.codigo_tipo_vehiculo and v.codigo_modelos =mv.codigo_modelos and c.codigo_color = v.codigo_color and mav.codveh_veh = v.codveh_veh and v.codveh_veh = " + txtCamion.Text); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.lblDatosCamion.Text = objDatos.ds.Tables[0].Rows[0][0].ToString(); this.txtAceite.Text = objDatos.ds.Tables[0].Rows[0][1].ToString(); dateTimePicker1.Text = objDatos.ds.Tables[0].Rows[0][2].ToString(); this.txtCorreaTiempo.Text = objDatos.ds.Tables[0].Rows[0][3].ToString(); this.txtFrenos.Text = objDatos.ds.Tables[0].Rows[0][4].ToString(); this.txtID.Text = objDatos.ds.Tables[0].Rows[0][5].ToString(); } else { if (txtCamion.Text == "0") { } else { MessageBox.Show("Todavia No se ha guardado ninguna configuracion para este camion", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } }
private void txtID_TextChanged(object sender, EventArgs e) { if (this.txtID.Text != "Nuevo") { objDatos.Conectar(); string sql = ("select * from vendedores c where codigo_vendedor = " + this.txtID.Text + ""); objDatos.Consulta_llenar_datos(sql); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.txtnombre.Text = objDatos.ds.Tables[0].Rows[0][1].ToString(); this.txtIDentificacion.Text = objDatos.ds.Tables[0].Rows[0][2].ToString(); this.dateTimePicker1.Text = objDatos.ds.Tables[0].Rows[0][4].ToString(); this.txtTelefono1.Text = objDatos.ds.Tables[0].Rows[0][6].ToString(); this.txtDireccion.Text = objDatos.ds.Tables[0].Rows[0][8].ToString(); this.txtTelefono2.Text = objDatos.ds.Tables[0].Rows[0][7].ToString(); if (Convert.ToBoolean(objDatos.ds.Tables[0].Rows[0][3]) == true) { this.estado.Checked = true; } if (Convert.ToBoolean(objDatos.ds.Tables[0].Rows[0][3]) == false) { this.estado.Checked = false; } buscarImagen(); this.cmdEliminar.Enabled = true; objDatos.Cn.Close(); } } }
private void cargarContactos() { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select a.nombre, a.telefono1, a.telefono2, b.tipo_contacto from agenda a, tipo_contacto b where b.codigo_tipo_contacto = a.codigo_tipo_contacto order by nombre asc"); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 350; this.dataGridView1.Columns[0].HeaderText = "Contacto"; this.dataGridView1.Columns[1].Width = 100; this.dataGridView1.Columns[1].HeaderText = "Telefono 1"; this.dataGridView1.Columns[2].Width = 100; this.dataGridView1.Columns[2].HeaderText = "Telefono 2"; this.dataGridView1.Columns[3].Width = 197; this.dataGridView1.Columns[3].HeaderText = "Servicio"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); this.ActiveControl = textBox1; }
private void descontarInventario() { try { datos objDatos1 = new datos(); //Buscar cantidad de articulos = 3 obDatos.consultar("select count(distinct codigo_art) from ", "facturatemporal"); int cantArticulos = Convert.ToInt32(obDatos.ds.Tables["facturatemporal"].Rows[0][0].ToString()); //Buscar los codigos de los articulos entrados string sql3 = "select distinct codigo_art,cantidad from facturatemporal"; objDatos1.Consulta_llenar_datos(sql3); for (int n = 0; n < cantArticulos; n++) { string sql2 = ""; int existencia = 0, existencia_actual = 0, cantidad = Convert.ToInt32(objDatos1.ds.Tables[0].Rows[n][1].ToString()), codArt = Convert.ToInt32(objDatos1.ds.Tables[0].Rows[n][0].ToString()); sql2 = "select SUM(existencia) from inventario where codigo_art = " + objDatos1.ds.Tables[0].Rows[n][0].ToString(); obDatos.Consulta_llenar_datos(sql2); existencia_actual = Convert.ToInt32(obDatos.ds.Tables[0].Rows[0][0].ToString()); existencia = existencia_actual - cantidad; obDatos.Consulta_llenar_datos("exec inserta_actualiza_inventario 1," + codArt.ToString() + "," + existencia.ToString() + ",1"); } } catch (System.Exception ex) { MessageBox.Show("No existe suficiente cantidad del articulo"); } }
private void guardarDetalleFactura() { datos objDatos = new datos(); objDatos.Conectar(); string sql = "select precio,cantidad,codigo_art,descuento,cantidad*precio as 'importe' from facturatemporal"; objDatos.Consulta_llenar_datos(sql); //Buscar cantidad de articulos obDatos.consultar("select count(distinct codigo_art) from ", "facturatemporal"); int cantArticulos = Convert.ToInt32(obDatos.ds.Tables["facturatemporal"].Rows[0][0].ToString()); for (int n = 0; n < cantArticulos; n++) { double precio = Convert.ToDouble(objDatos.ds.Tables[0].Rows[n][0].ToString()); int cantidad = Convert.ToInt32(objDatos.ds.Tables[0].Rows[n][1].ToString()); int codArticulo = Convert.ToInt32(objDatos.ds.Tables[0].Rows[n][2].ToString()); int descuento = Convert.ToInt32(objDatos.ds.Tables[0].Rows[n][3].ToString()); double importe = Convert.ToDouble(objDatos.ds.Tables[0].Rows[n][4].ToString()); obDatos.consultar("SELECT COUNT(id_detall) from ", "detalle_facturas"); int idDetall = Convert.ToInt32(obDatos.ds.Tables["detalle_facturas"].Rows[0][0].ToString()) + 1; obDatos.Consulta_llenar_datos("exec inserta_detalles_facturas " + idDetall + "," + this.txtNumeroFactura.Text + "," + precio + "," + cantidad + "," + codArticulo + "," + descuento + "," + importe + ""); objDatos.Desconectar(); } }
public void cargarMarcas() { this.txtID.Text = "Nuevo"; this.txtMarca.Text = ""; this.txtUsuario.Text = ""; this.txtContrasena1.Text = ""; this.txtContrasena2.Text = ""; txtFecha.Text = DateTime.Now.Date.Date.ToString("yyyy-MM-dd"); this.txtHora.Text = DateTime.Now.ToString("h:mm:ss tt"); this.txtMarca.Focus(); this.txtID.Enabled = false; objDatos.Conectar(); string sring = ("exec obtenerUsuarios"); objDatos.Consulta_llenar_datos(sring); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 30; this.dataGridView1.Columns[0].HeaderText = "ID"; this.dataGridView1.Columns[1].Width = 100; this.dataGridView1.Columns[1].HeaderText = "Nombre Usuario"; this.dataGridView1.Columns[2].Width = 80; this.dataGridView1.Columns[2].HeaderText = "Usuario"; this.dataGridView1.Columns[3].Width = 100; this.dataGridView1.Columns[3].HeaderText = "Contraseña"; this.dataGridView1.Columns[4].Width = 60; this.dataGridView1.Columns[4].HeaderText = "Fecha Creacion"; this.dataGridView1.Columns[5].Width = 60; this.dataGridView1.Columns[5].HeaderText = "Hora Creacion"; this.dataGridView1.Columns[6].Width = 60; this.dataGridView1.Columns[6].HeaderText = "Codigo Perfil"; this.dataGridView1.Columns[7].Width = 83; this.dataGridView1.Columns[7].HeaderText = "Perfil Asignado"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.cmdEliminar.Enabled = false; this.dataGridView1.ClearSelection(); this.cmbPerfiles.DataSource = objDatos.ConsultaTabla("perfiles_usuarios", " descripcion"); this.cmbPerfiles.DisplayMember = "descripcion"; this.cmbPerfiles.ValueMember = "nivel"; objDatos.Desconectar(); }
private void cmdNuevo_Click(object sender, EventArgs e) { if (this.txtID.Text == "") { MessageBox.Show("Debe de especificar el numero de salida", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { datos objDatos = new datos(); objDatos.Conectar(); objDatos.Consulta_llenar_datos("consultar_ultima_salida_camion " + this.txtID.Text); Reportes.ReporteSalida.rptUltimaSalida rp = new Reportes.ReporteSalida.rptUltimaSalida(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.ShowCloseButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowGotoPageButton = false; crystalReportViewer1.ShowLogo = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.DisplayStatusBar = false; crystalReportViewer1.RefreshReport(); objDatos.Desconectar(); } }
private void conFacturas_Load(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select f.numfac_fac, c.nombre, f.fecfac_fac, f.monfac_fac from facturas f, detalle_facturas dt, clientes c where dt.numfac_fac = f.numfac_fac and c.codigo_cliente = f.codcli_cli order by f.numfac_fac desc"); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 65; this.dataGridView1.Columns[0].HeaderText = "Factura"; this.dataGridView1.Columns[1].Width = 295; this.dataGridView1.Columns[1].HeaderText = "Cliente"; this.dataGridView1.Columns[2].Width = 150; this.dataGridView1.Columns[2].HeaderText = "Fecha Factura"; this.dataGridView1.Columns[3].Width = 150; this.dataGridView1.Columns[3].HeaderText = "Monto Factura"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); textBox1.Focus(); }
private void cargarDatos() { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select descripcion from notificacion_correos where codigo_notificacion_correos = " + this.textBox2.Text); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.txtID.Text = objDatos.ds.Tables[0].Rows[0][0].ToString(); } }
void actualizarGrid() { string sring = ("exec consultarCxP " + CodigoSuplidor.ToString()); objDatos.Consulta_llenar_datos(sring); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; objDatos.Desconectar(); this.dataGridView1.Columns[0].Width = 50; this.dataGridView1.Columns[1].Width = 250; this.dataGridView1.Columns[2].Width = 100; this.dataGridView1.Columns[3].Width = 80; this.dataGridView1.Columns[4].Width = 80; this.dataGridView1.Columns[5].Width = 256; dataGridView1.Columns[4].DefaultCellStyle.Format = "c"; dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy"; }
private void button1_Click(object sender, EventArgs e) { try { int codigoPago = 0; datos objDatos = new datos(); objDatos.Consulta_llenar_datos("insert into resgistro_pago_tarjetas values (" + this.txt4Digitos.Text + "," + this.txtAprobacion.Text + "," + this.txtCantidadPagar.Text + "," + numfac_fac.ToString() + ")"); } catch (SystemException ex) { MessageBox.Show(ex.Message); } }
private void cmdNuevo_Click(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("consultar_entrada_camion " + this.txtCamion.Text + ""); Reportes.Entradas.rptEntrada rp = new Reportes.Entradas.rptEntrada(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.ShowCloseButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowGotoPageButton = false; crystalReportViewer1.ShowLogo = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.DisplayStatusBar = false; crystalReportViewer1.RefreshReport(); objDatos.Desconectar(); }
private void cmdBuscarCodCli_Click(object sender, EventArgs e) { Busquedas.BusquedaCamiones BC = new Busquedas.BusquedaCamiones(); DialogResult res = BC.ShowDialog(); if (res == DialogResult.OK) { this.txtCamion.Text = BC.ReturnValue1; objDatos.Conectar(); objDatos.Consulta_llenar_datos("select * from mantenimiento_vehiculos where mantenimiento_vehiculos.codveh_veh = " + txtCamion.Text); if (objDatos.ds.Tables[0].Rows.Count > 0) { this.cmdProcesar.Enabled = true; } else { MessageBox.Show("Antes de Darle salida al vehiculo, debe configurar la fecha de vencimiento del seguro, en el menu Administrar y luego en Configuracion de Mantenimientos a Camiones", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.cmdProcesar.Enabled = false; } } }
private void imprimirFacturas_Load(object sender, EventArgs e) { datos objDatos = new datos(); objDatos.Conectar(); objDatos.Consulta_llenar_datos("consultar_factura_por_codigo " + codFactura + ""); Reportes.Facturas rp = new Reportes.Facturas(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.RefreshReport(); objDatos.Desconectar(); this.crystalReportViewer1.RefreshReport(); }
private void BusquedaCamiones_Load(object sender, EventArgs e) { objDatos.Conectar(); objDatos.Consulta_llenar_datos("select v.codveh_veh, m.descripcion, mv.descripcion, v.anoveh_veh, c.descripcion, v.descri_veh, v.numpla_veh, v.numcha_veh,v.kilome_veh from vehiculo v, marca_articulos m, tipo_vehiculos tv, modelos_vehiculos mv, colores c where v.codigo_marca = m.codigo_marca and v.codigo_tipo_vehiculo = tv.codigo_tipo_vehiculo and v.codigo_modelos =mv.codigo_modelos and c.codigo_color = v.codigo_color and v.alquilado = 0"); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 30; this.dataGridView1.Columns[0].HeaderText = "ID"; this.dataGridView1.Columns[1].Width = 90; this.dataGridView1.Columns[1].HeaderText = "Marca"; this.dataGridView1.Columns[2].Width = 80; this.dataGridView1.Columns[2].HeaderText = "Modelo"; this.dataGridView1.Columns[3].Width = 70; this.dataGridView1.Columns[3].HeaderText = "Año"; this.dataGridView1.Columns[4].Width = 70; this.dataGridView1.Columns[4].HeaderText = "Color"; this.dataGridView1.Columns[5].Width = 120; this.dataGridView1.Columns[5].HeaderText = "Descripcion"; this.dataGridView1.Columns[6].Width = 100; this.dataGridView1.Columns[6].HeaderText = "Placa"; this.dataGridView1.Columns[7].Width = 120; this.dataGridView1.Columns[7].HeaderText = "Chasis"; this.dataGridView1.Columns[8].Width = 68; this.dataGridView1.Columns[8].HeaderText = "Kilometraje"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); textBox1.Focus(); }
void cargarMarcas() { this.txtID.Text = "Nuevo"; this.txtMarca.Text = ""; this.txtPrecio.Text = ""; this.txtMarca.Focus(); this.txtID.Enabled = false; objDatos.Conectar(); string sring = ("exec obtenerServicios"); objDatos.Consulta_llenar_datos(sring); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; this.dataGridView1.Columns[0].Width = 60; this.dataGridView1.Columns[0].HeaderText = "ID"; this.dataGridView1.Columns[1].Width = 270; this.dataGridView1.Columns[1].HeaderText = "Descripcion"; this.dataGridView1.Columns[2].Width = 120; this.dataGridView1.Columns[2].HeaderText = "Precio Unitario"; this.dataGridView1.Columns[3].Width = 91; this.dataGridView1.Columns[3].HeaderText = "Estado"; this.dataGridView1.RowHeadersVisible = false; this.dataGridView1.DefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; this.dataGridView1.AllowUserToOrderColumns = false; this.dataGridView1.AllowUserToResizeRows = false; this.dataGridView1.ReadOnly = true; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.dataGridView1.MultiSelect = false; this.dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; this.cmdEliminar.Enabled = false; this.dataGridView1.ClearSelection(); objDatos.Desconectar(); }
private void Form1_Load(object sender, EventArgs e) { datos objDatos = new datos(); objDatos.Conectar(); objDatos.Consulta_llenar_datos("select * from reporteCxP"); Reportes.CxP.CrystalReport1 rp = new Reportes.CxP.CrystalReport1(); rp.SetDataSource(objDatos.ds.Tables[0]); crystalReportViewer1.ReportSource = rp; objDatos.Desconectar(); this.crystalReportViewer1.RefreshReport(); crystalReportViewer1.ShowCloseButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowGotoPageButton = false; crystalReportViewer1.ShowLogo = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.DisplayStatusBar = false; }
private void enviarCorreoCambioAceite() { try { datos objDatos = new datos(); string correo = ""; objDatos.Conectar(); objDatos.Consulta_llenar_datos("select descripcion from notificacion_correos"); if (objDatos.ds.Tables[0].Rows.Count > 0) { correo = objDatos.ds.Tables[0].Rows[0][0].ToString(); } EnviarCorreo mandaCorreoAceite = new EnviarCorreo(); mandaCorreoAceite.enviarCorreoAceite(correo); } catch (System.Data.SqlClient.SqlException ex) { MessageBox.Show(ex.Message.ToString()); } }
void cargarMarcas() { this.txtID.Text = "Nuevo"; this.txtNombre.Text = ""; this.txtTelefono1.Text = ""; this.txtTelefono2.Text = ""; this.txtNombre.Focus(); this.txtID.Enabled = false; objDatos.Conectar(); string sring = ("exec obtenerContactos"); objDatos.Consulta_llenar_datos(sring); this.miFiltro = (objDatos.ds.Tables[0].DefaultView); this.dataGridView1.DataSource = miFiltro; dataGridView1.Columns[0].Width = 30; dataGridView1.Columns[1].Width = 150; dataGridView1.Columns[2].Width = 185; dataGridView1.Columns[3].Width = 88; dataGridView1.Columns[4].Width = 88; dataGridView1.RowHeadersVisible = false; dataGridView1.DefaultCellStyle.ForeColor = Color.Black; dataGridView1.RowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White; dataGridView1.AllowUserToAddRows = false; dataGridView1.AllowUserToDeleteRows = false; dataGridView1.AllowUserToOrderColumns = false; dataGridView1.AllowUserToResizeRows = false; dataGridView1.ReadOnly = true; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; dataGridView1.MultiSelect = false; dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; cmdEliminar.Enabled = false; dataGridView1.ClearSelection(); objDatos.Desconectar(); }
private void cmdAgregarNCF_Click(object sender, EventArgs e) { datos objDato = new datos(); objDato.Conectar(); string sql = ""; sql = ("select n.ncf_ncf from NCF n where n.codigo_tncf = " + this.cmbTipoNCF.SelectedValue.ToString() + " and estado = 1"); objDato.Consulta_llenar_datos(sql); this.txtCantidad.Focus(); if (objDato.ds.Tables[0].Rows.Count > 0) { string NCF; NCF = objDato.ds.Tables[0].Rows[0][0].ToString(); this.txtNCF.Text = NCF.ToString(); } else { MessageBox.Show("No hay NCF disponibles de este tipo"); } objDato.Desconectar(); }