private void MostrarRegistro(string ACFid)
{
try
{
DataTable dat = NacfUBEt_UbicacionElectrica.Buscar(ACFid);
//ACFdescripcion.Text= dat.Rows[0]["ACFdescripcion"].ToString();
if (dat.Rows.Count > 0)
{
DataRow row = dat.Rows[0];
txtUBEid.Text = Convert.ToString(row["UBEid"]);
//guardo datos en variables
//txtACFid.Text = Convert.ToString(row["ACFid"]);
//txtACFdescripcion.Text = Convert.ToString(row["ACFdescripcion"]);
}
else
{
MessageBox.Show("Registro Nuevo", " Nuevo");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
private void grabarseleBUIELEC()
{
try
{
//falta mostrar el ACFid
Int32 total = 0;
foreach (DataGridViewRow row in dataListado.Rows)
{
string Rta = string.Empty;
if (Convert.ToBoolean(row.Cells[0].Value))
{
Rta = NacfUBEt_UbicacionElectrica.SAPIMPORT(
Convert.ToString(row.Cells[17].Value), // BEcodigogis
Convert.ToString(row.Cells[29].Value), // UBEobra -- proyecto
Convert.ToString(row.Cells[122].Value), //"0", // KOSTL
Convert.ToString(row.Cells[16].Value), // VNRid
Convert.ToString(row.Cells[19].Value), // SELid
"0", // UBEset
Convert.ToString(row.Cells[20].Value), // UBEsetetq
"0", // UBEalimentador
Convert.ToString(row.Cells[21].Value), // UBEalimentadoretq
"0", // UBEsed
Convert.ToString(row.Cells[22].Value), // UBEsedetq
"0", // UBEcircuito
Convert.ToString(row.Cells[23].Value), // UBEcircuitoetq
"0", // UBEpuntoi
Convert.ToString(row.Cells[27].Value), // UBEpuntoietq
"0", // UBEpuntof
Convert.ToString(row.Cells[28].Value), // UBEpuntofetq
//"0", // UBEid
Convert.ToString(row.Cells[3].Value), // ACFid
Convert.ToString(row.Cells[18].Value), // UBIGEO
Convert.ToString(row.Cells[24].Value), // UBEpostei
Convert.ToString(row.Cells[25].Value) // UBEpostef
);
if (Rta.Equals("OK"))
{
//MessageBox.Show("Datos agregados");
}
else
{
//MessageBox.Show("Datos No Agregados");
break;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
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 MostrarRegistro(String ACFid, String INVid)
{
try
{
DataTable dat = NacfINBt_Inventariobienes.Buscar(ACFid, INVid);
//ACFdescripcion.Text= dat.Rows[0]["ACFdescripcion"].ToString();
if (dat.Rows.Count > 0)
{
DataRow row = dat.Rows[0];
cboACTid.Text = Convert.ToString(row["ACTid"]);
txtACFdescripcion.Text = Convert.ToString(row["ACFactivo"]);
//txtACFobservacion.Text = Convert.ToString(row["ACFobservacion"]);
cboVNRid.Text = Convert.ToString(row["VNRid"]);
txtUBEid1.Text = Convert.ToString(row["UBEid"]);
cboCSTid.Text = Convert.ToString(row["CSTid"]);
cboPERNR.Text = Convert.ToString(row["PERNR"]);
txtACFobra.Text = Convert.ToString(row["ACFobra"]);
txtINBbukrs.Text = Convert.ToString(row["BUKRS"]);
}
else
{
MessageBox.Show("No Existe", "Registro");
}
DataTable datt = NacfICRt_Inventariocaracteristicas.Buscar(ACFid, INVid);
if (datt.Rows.Count > 0)
{
DataRow row = datt.Rows[0];
cboMARid.Text = Convert.ToString(row["MARid"]);
txtCRSserie.Text = Convert.ToString(row["CRSserie"]);
txtCRSmodelo.Text = Convert.ToString(row["CRSmodelo"]);
txtESTid.Text = Convert.ToString(row["ESTid"]);
// txtCRSobservacion.Text = Convert.ToString(row["CRSobservacion"]);
txtCRScantidad.Text = Convert.ToString(row["CRScantidad"]);
cboUNMid.Text = Convert.ToString(row["UNMid"]);
dtpCRSfinscpredio.Text = Convert.ToString(row["CRSfinscpredio"]);
txtCRSficharegistral.Text = Convert.ToString(row["CRSficharegistral"]);
txtCRSareaconstruida.Text = Convert.ToString(row["CRSareaconstruida"]);
txtCRSperimetro.Text = Convert.ToString(row["CRSperimetro"]);
txtCRSusopredio.Text = Convert.ToString(row["CRSusopredio"]);
cboCRSvehplaca.Text = Convert.ToString(row["CRSvehplaca"]);
txtCRSvehexpediente.Text = Convert.ToString(row["CRSvehexpediente"]);
dtpCRSvehinscripcion.Text = Convert.ToString(row["CRSvehinscripcion"]);
txtCRSvehclase.Text = Convert.ToString(row["CRSvehclase"]);
txtCRSvehcombustible.Text = Convert.ToString(row["CRSvehcombustible"]);
txtCRSvehejes.Text = Convert.ToString(row["CRSvehejes"]);
txtCRSvehpasajeros.Text = Convert.ToString(row["CRSvehpasajeros"]);
txtCRSvehasientos.Text = Convert.ToString(row["CRSvehasientos"]);
txtCRSvehpesoseco.Text = Convert.ToString(row["CRSvehpesoseco"]);
txtCRSvehcargautil.Text = Convert.ToString(row["CRSvehcargautil"]);
txtCRSaltura.Text = Convert.ToString(row["CRSaltura"]);
txtCRSancho.Text = Convert.ToString(row["CRSancho"]);
txtCRSvelocidad.Text = Convert.ToString(row["CRSvelocidad"]);
txtCRSresolucion.Text = Convert.ToString(row["CRSresolucion"]);
txtCRScapacidad.Text = Convert.ToString(row["CRScapacidad"]);
txtCRSpotencia.Text = Convert.ToString(row["CRSpotencia"]);
txtCRSvnominal.Text = Convert.ToString(row["CRSvnominal"]);
txtCRSventrada.Text = Convert.ToString(row["CRSventrada"]);
txtCRSvsalida.Text = Convert.ToString(row["CRSvsalida"]);
txtCRSfrecuencia.Text = Convert.ToString(row["CRSfrecuencia"]);
txtCRStemperatura.Text = Convert.ToString(row["CRStemperatura"]);
txtCRSprocesador.Text = Convert.ToString(row["CRSprocesador"]);
txtCRSpuertos.Text = Convert.ToString(row["CRSpuertos"]);
}
else
{
MessageBox.Show("No Existe", "Registro");
}
DataTable dattt = NacfUBEt_UbicacionElectrica.Buscar(ACFid);
if (datt.Rows.Count > 0)
{
DataRow row = dattt.Rows[0];
txtUBEgis.Text = Convert.ToString(row["UBEcodigogis"]);
cboSELid.Text = Convert.ToString(row["SELid"]);
cboSETid.Text = Convert.ToString(row["UBEset"]);
txtUBEsetetq.Text = Convert.ToString(row["UBEsetetq"]);
txtUBEalimentador.Text = Convert.ToString(row["UBEalimentador"]);
txtUBEsed.Text = Convert.ToString(row["UBEsed"]);
txtUBEcircuito.Text = Convert.ToString(row["UBEcircuito"]);
txtUBEpuntoi.Text = Convert.ToString(row["UBEpuntoi"]);
txtUBEpuntoi.Text = Convert.ToString(row["UBEpuntof"]);
//Agregar tabla detalle
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
