//----------------------------------------------------------------------------------- // Actualiza Registros //----------------------------------------------------------------------------------- private void ActualizaRegistro() { string Rta = string.Empty; try { Rta = NbdiXPEpExtraccionSAP_Personal.Editar( this.txtPERNR.Text, this.txtNachn.Text, this.txtName2.Text, this.txtVorna.Text, this.txtDNI.Text, this.txtWERKS.Text, this.txtPersg.Text, this.txtKOSTL.Text); if (Rta.Equals("OK")) { this.MensajeOk("Regsitro Actualizado Correctamente"); } else { this.MensajeError("Error al Actualizar Registro "); } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); } }
private void buscarNombre() { if (this.txtBuscar.Text == "") { this.mostrar(); } else { this.dataListado.DataSource = NbdiXPEpExtraccionSAP_Personal.Buscar(this.txtBuscar.Text); // this.OcultarColumnas(); lblTotal.Text = "Total de Registros: " + Convert.ToString(dataListado.Rows.Count); } }
private void CargarCombos() { this.cboPERNR.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar(); //BURkS this.cboPERNR.ValueMember = "PERNR"; this.cboPERNR.DisplayMember = "PERNR"; this.cboPERNR.SelectedIndex = -1; this.cboCSTid.DataSource = NacfCSTt_Costo.Mostrar(); //BURkS this.cboCSTid.ValueMember = "CSTid"; this.cboCSTid.DisplayMember = "CSTid"; this.cboCSTid.SelectedIndex = -1; this.cboVNRid.DataSource = NacfVNRt_VNR.Mostrar(); //BURkS this.cboVNRid.ValueMember = "VNRid"; this.cboVNRid.DisplayMember = "VNRid"; this.cboVNRid.SelectedIndex = -1; this.cboACTid.DataSource = NacfACTt_Actividad.Mostrar(); //BURkS this.cboACTid.ValueMember = "ACTid"; this.cboACTid.DisplayMember = "ACTid"; this.cboACTid.SelectedIndex = -1; this.cboSELid.DataSource = NacfSELt_SistemaElectrico.Mostrar(); //BURkS this.cboSELid.ValueMember = "SELid"; this.cboSELid.DisplayMember = "SELid"; this.cboSELid.SelectedIndex = -1; this.cboSETid.DataSource = NacfUBEt_UbicacionElectrica.Mostrar(); //BURkS this.cboSETid.ValueMember = "UBEset"; this.cboSETid.DisplayMember = "UBEset"; this.cboSETid.SelectedIndex = -1; this.cboMARid.DataSource = NacfMARt_Marca.Mostrar(); //BURkS this.cboMARid.ValueMember = "MARid"; this.cboMARid.DisplayMember = "MARid"; this.cboMARid.SelectedIndex = -1; this.cboUNMid.DataSource = NacfUNMt_Unimed.Mostrar(); //BURkS this.cboUNMid.ValueMember = "UNMid"; this.cboUNMid.DisplayMember = "UNMid"; this.cboUNMid.SelectedIndex = -1; this.cboINVid.DataSource = NacfINVp_Inventario.Mostrar(); this.cboINVid.ValueMember = "INVid"; this.cboINVid.DisplayMember = "INVid"; this.cboINVid.SelectedIndex = -1; }
private void mostrar() { this.Configura(); this.Activo = 1; this.tomaTab(); this.Botones(true); this.dataListado.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar(); OcultarColumnas(); lblTotal.Text = "Total de Registros: " + Convert.ToString(dataListado.Rows.Count); if (dataListado.Rows.Count == 0) { BotonesSinReg(false); } else { BotonesSinReg(true); this.toolStripAgregar.Enabled = true; } this.dataListado.Select(); this.dataListado.Focus(); }
//----------------------------------------------------------------------------------- // Elimina Registros //----------------------------------------------------------------------------------- private void borrauno() { string Rta = string.Empty; DialogResult Opcion; Opcion = MessageBox.Show("Realmente Desea Eliminar los Registros", "Sistema de escolar", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (Opcion == DialogResult.OK) { string Codigo; Codigo = Convert.ToString(this.dataListado.CurrentRow.Cells[1].Value); Rta = NbdiXPEpExtraccionSAP_Personal.Eliminar(Codigo); if (Rta.Equals("OK")) { this.MensajeOk("Se Eliminó Correctamente el registro"); } else { this.MensajeError("Error al Eliminar el Registro "); } } }
private void CargarCombos() { this.cboAMBid.DataSource = NacfAMBt_Ambiente.Mostrar(); this.cboAMBid.ValueMember = "AMBid"; this.cboAMBid.DisplayMember = "AMBid"; this.cboAMBid.SelectedIndex = -1; this.cboACFid.DataSource = NacfACFp_Activo_Fijo.MostrarRegistro(""); this.cboACFid.ValueMember = "ACFid"; this.cboACFid.DisplayMember = "ACFid"; this.cboACFid.SelectedIndex = -1; this.cboPERNR.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar(); this.cboPERNR.ValueMember = "PERNR"; this.cboPERNR.DisplayMember = "PERNR"; this.cboPERNR.SelectedIndex = -1; this.cboCRP.DataSource = NacfCRPt_Centro_Responsabilidad.Mostrar(); this.cboCRP.ValueMember = "CRPid_crp"; this.cboCRP.DisplayMember = "CRPid_crp"; this.cboCRP.SelectedIndex = -1; }
private void borramuchos() { try { DialogResult Opcion; Opcion = MessageBox.Show("Realmente Desea Eliminar los Registros", "Sistema de escolar", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (Opcion == DialogResult.OK) { string Codigo; string Rta = string.Empty; foreach (DataGridViewRow row in dataListado.Rows) { if (Convert.ToBoolean(row.Cells[0].Value)) { Codigo = Convert.ToString(row.Cells[1].Value); Rta = NbdiXPEpExtraccionSAP_Personal.Eliminar(Codigo); if (Rta.Equals("OK")) { this.MensajeOk("Se Eliminó Correctamente el registro"); } else { this.MensajeError("Error al Eliminar el Registro ..."); } } } this.mostrar(); } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); } }
private void BotonImprimir() { FrmReportes rptalu = new FrmReportes("Reportes\\Rpt_XPESAPPersonal.rdlc", NbdiXPEpExtraccionSAP_Personal.Mostrar(), "ip"); rptalu.ShowDialog(); }
private void CargarCombos() { this.cboPERNR1.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar();// this.cboPERNR1.ValueMember = "PERNR"; this.cboPERNR1.DisplayMember = "PERNR"; this.cboPERNR1.SelectedIndex = -1; this.cboPERNR2.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar();// this.cboPERNR2.ValueMember = "PERNR"; this.cboPERNR2.DisplayMember = "PERNR"; this.cboPERNR2.SelectedIndex = -1; this.cboPERNR3.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar();// this.cboPERNR3.ValueMember = "PERNR"; this.cboPERNR3.DisplayMember = "PERNR"; this.cboPERNR3.SelectedIndex = -1; this.cboPERNR4.DataSource = NbdiXPEpExtraccionSAP_Personal.Mostrar();// this.cboPERNR4.ValueMember = "PERNR"; this.cboPERNR4.DisplayMember = "PERNR"; this.cboPERNR4.SelectedIndex = -1; this.cboAMB1.DataSource = NacfAMBt_Ambiente.Mostrar();// this.cboAMB1.ValueMember = "AMBid"; this.cboAMB1.DisplayMember = "AMBid"; this.cboAMB1.SelectedIndex = -1; this.cboAMB2.DataSource = NacfAMBt_Ambiente.Mostrar();// this.cboAMB2.ValueMember = "AMBid"; this.cboAMB2.DisplayMember = "AMBid"; this.cboAMB2.SelectedIndex = -1; this.cboZONA1.DataSource = NbdiSEGpSegmento.Mostrar();// this.cboZONA1.ValueMember = "id_zona"; this.cboZONA1.DisplayMember = "id_zona"; this.cboZONA1.SelectedIndex = -1; this.cboZONA2.DataSource = NbdiSEGpSegmento.Mostrar();// this.cboZONA2.ValueMember = "id_zona"; this.cboZONA2.DisplayMember = "id_zona"; this.cboZONA2.SelectedIndex = -1; this.cboMVPtipo.DataSource = NacfTMVt_TipoMovimiento.Mostrar();// this.cboMVPtipo.ValueMember = "TMVid"; this.cboMVPtipo.DisplayMember = "TMVid"; this.cboMVPtipo.SelectedIndex = -1; this.txtORGcrp.DataSource = NacfCRPt_Centro_Responsabilidad.Mostrar(); this.txtORGcrp.ValueMember = "CRPid_crp"; this.txtORGcrp.DisplayMember = "CRPid_crp"; this.txtORGcrp.SelectedIndex = -1; this.txtDSTcrp.DataSource = NacfCRPt_Centro_Responsabilidad.Mostrar(); this.txtDSTcrp.ValueMember = "CRPid_crp"; this.txtDSTcrp.DisplayMember = "CRPid_crp"; this.txtDSTcrp.SelectedIndex = -1; this.txtMVPds_movimiento.DataSource = NacfMVMt_MotivoMovimiento.Mostrar(); this.txtMVPds_movimiento.ValueMember = "MVMid"; this.txtMVPds_movimiento.DisplayMember = "MVMid"; this.txtMVPds_movimiento.SelectedIndex = -1; }