private void buscarNombre()
{
if (this.txtBuscar.Text == "")
{
this.mostrar();
}
else
{
this.dataListado.DataSource = NacfAMBt_Ambiente.Buscar(this.txtBuscar.Text);
//this.OcultarColumnas();
lblTotal.Text = "Total de Registros: " + Convert.ToString(dataListado.Rows.Count);
}
}
//-----------------------------------------------------------------------------------
// Actualiza Registros
//-----------------------------------------------------------------------------------
private void ActualizaRegistro()
{
string Rta = string.Empty;
try
{
Rta = NacfAMBt_Ambiente.Editar(this.txtAMBid.Text, this.txtLOCid.Text, this.txtAMBambiente.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 mostrar()
{
this.Configura();
this.Activo = 1;
this.tomaTab();
this.Botones(true);
this.dataListado.DataSource = NacfAMBt_Ambiente.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 = NacfAMBt_Ambiente.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 = NacfAMBt_Ambiente.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_AMBAmbiente.rdlc", NacfAMBt_Ambiente.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;
}