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