public long GetValorSecReleOperFunc(RelesOperados item) { long rtn = 0; OracleCommand cmd = null; string sql = @"SELECT NVL (MAX (sec_rele_oper_func),0) +1 FROM f_gf_reles_oper WHERE pk_cod_falla = :pk_cod_falla AND pk_origen_informe = :pk_origen_informe AND pk_d_cod_tipoinforme = :pk_d_cod_tipoinforme AND pk_cod_componente = :pk_cod_componente AND funcion_rele = :funcion_rele AND fec_apertura = :fec_apertura "; cmd = CrearCommand(); cmd.CommandText = sql; cmd.BindByName = true; cmd.Parameters.Add(RelesOperados.C_PK_COD_FALLA, OracleDbType.Int64, item.PkCodFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.PK_ORIGEN_INFORME, OracleDbType.Int64, item.PkOrigenFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_PK_D_COD_TIPOINFORME, OracleDbType.Int64, item.PkDCodTipoinforme, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_PK_COD_COMPONENTE, OracleDbType.Int64, item.PkCodComponente, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_FUNCION, OracleDbType.Varchar2, item.Funcion, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_FEC_APERTURA, OracleDbType.TimeStamp, item.FecApertura, System.Data.ParameterDirection.Input); DataTable dt = EjecutarCmd(cmd); if (dt != null) { if (dt.Rows.Count > 0) { rtn = (long)(decimal)dt.Rows[0][0]; } } return(rtn); }
public void Borrar(RelesOperados item) { string sql = @"DELETE FROM F_GF_RELES_OPER WHERE PK_COD_FALLA = :PK_COD_FALLA AND PK_ORIGEN_INFORME = :PK_ORIGEN_INFORME AND PK_D_COD_TIPOINFORME = :PK_D_COD_TIPOINFORME AND PK_COD_COMPONENTE = :PK_COD_COMPONENTE AND FUNCION_RELE = :FUNCION_RELE AND FEC_APERTURA = :FEC_APERTURA AND SEC_RELE_OPER_FUNC = :SEC_RELE_OPER_FUNC "; OracleCommand cmd = CrearCommand(); cmd.CommandText = sql; cmd.Parameters.Add("PK_COD_FALLA", OracleDbType.Int32, item.PkCodFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add("PK_ORIGEN_INFORME", OracleDbType.Int64, item.PkOrigenFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add("PK_D_COD_TIPOINFORME", OracleDbType.Int64, item.PkDCodTipoinforme, System.Data.ParameterDirection.Input); cmd.Parameters.Add("PK_COD_COMPONENTE", OracleDbType.Int64, item.PkCodComponente, System.Data.ParameterDirection.Input); cmd.Parameters.Add("FUNCION_RELE", OracleDbType.Varchar2, item.Funcion, System.Data.ParameterDirection.Input); cmd.Parameters.Add("FEC_APERTURA", OracleDbType.TimeStamp, item.FecApertura, System.Data.ParameterDirection.Input); cmd.Parameters.Add("SEC_RELE_OPER_FUNC", OracleDbType.Int64, item.SecReleOperFunc, System.Data.ParameterDirection.Input); cmd.BindByName = true; Actualizar(cmd); }
public DialogResult Editar(RelesOperados releOperado, List <string> funcionesUsadas) { _releOperado = releOperado; _funcionesUsadas = funcionesUsadas; CargarFunciones(); VisualizarRele(); return(ShowDialog()); }
private void _dgvRelesOperados_SelectionChanged(object sender, EventArgs e) { if (_dgvRelesOperados.SelectedRows.Count > 0) { _releSeleccionado = (RelesOperados)_dgvRelesOperados.SelectedRows[0].DataBoundItem; } else { _releSeleccionado = null; } }
private void CopiarReles(OperacionInterruptores opInterrup, InformeFalla informeDestino) { DataTable tablaReles = ModeloMgr.Instancia.RelesOperadosMgr.GetTablaRelesOperador(opInterrup); foreach (DataRow row in tablaReles.Rows) { RelesOperados rele = new RelesOperados(row); rele.PkOrigenFalla = informeDestino.PkOrigenInforme; rele.PkDCodTipoinforme = informeDestino.PkDCodTipoinforme; rele.EsNuevo = true; ModeloMgr.Instancia.RelesOperadosMgr.Guardar(rele); } }
private void _btnAdicionar_Click(object sender, EventArgs e) { if (_ctrlComponenteComprometido.Componente == null) { MessageBox.Show(MessageMgr.Instance.GetMessage("SELEC_INTERRUP")); return; } RelesOperados rele = _opInterruptor.CrearNuevoReleOperado(); FormReleOperado frm = new FormReleOperado(); if (frm.Editar(rele, GetFuncionesUsadas()) == DialogResult.OK) { _listaRelesOperados.Add(rele); } }
public void Guardar(RelesOperados obj) { OracleCommand cmd = null; string sql = string.Empty; if (obj.EsNuevo) { //Pista p = PistaMgr.Instance.Info("DALSisFalla", obj.GetEstadoString()); //obj.SecLog = (long)p.PK_SecLog; sql = "INSERT INTO {0} ({1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13})" + "VALUES(:{1},:{2},:{3},:{4},:{5},:{6},:{7},:{8},:{9},:{10},:{11},:{12},:{13})"; obj.SecReleOperFunc = GetValorSecReleOperFunc(obj); } else { sql = "UPDATE {0} SET " + "{7}=:{7} ," + "{8}=:{8} ," + "{9}=:{9} ," + "{10}=:{10}, " + "{11}=:{11}, " + "{12}=:{12} " + "WHERE " + "{1}=:{1} AND " + "{2}=:{2} AND " + "{3}=:{3} AND " + "{4}=:{4} AND " + "{5}=:{5} AND " + "{6}=:{6} AND " + "{13}=:{13} "; } sql = string.Format(sql, RelesOperados.NOMBRE_TABLA, RelesOperados.C_PK_COD_FALLA, RelesOperados.PK_ORIGEN_INFORME, RelesOperados.C_PK_D_COD_TIPOINFORME, RelesOperados.C_PK_COD_COMPONENTE, RelesOperados.C_FUNCION, RelesOperados.C_FEC_APERTURA, RelesOperados.C_TIPO_RELE, RelesOperados.C_TIEMPO, RelesOperados.C_ZONA, RelesOperados.C_DIS, RelesOperados.C_NUMERO, RelesOperados.C_SINC_VER, RelesOperados.C_SEC_RELE_OPER_FUNC); cmd = CrearCommand(); cmd.CommandText = sql; cmd.BindByName = true; cmd.Parameters.Add(RelesOperados.C_PK_COD_FALLA, OracleDbType.Int64, obj.PkCodFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.PK_ORIGEN_INFORME, OracleDbType.Int64, obj.PkOrigenFalla, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_PK_D_COD_TIPOINFORME, OracleDbType.Int64, obj.PkDCodTipoinforme, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_PK_COD_COMPONENTE, OracleDbType.Int64, obj.PkCodComponente, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_FUNCION, OracleDbType.Varchar2, obj.Funcion, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_FEC_APERTURA, OracleDbType.TimeStamp, obj.FecApertura, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_TIPO_RELE, OracleDbType.Varchar2, obj.TipoRele, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_TIEMPO, OracleDbType.Double, obj.Tiempo, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_ZONA, OracleDbType.Double, obj.Zona, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_DIS, OracleDbType.Double, obj.Distancia, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_NUMERO, OracleDbType.Double, obj.Numero, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_SINC_VER, OracleDbType.Int64, obj.SincVer, System.Data.ParameterDirection.Input); cmd.Parameters.Add(RelesOperados.C_SEC_RELE_OPER_FUNC, OracleDbType.Int64, obj.SecReleOperFunc, System.Data.ParameterDirection.Input); if (Actualizar(cmd)) { obj.EsNuevo = false; } }