/// <summary> /// Detalle de inspeccion del panel general /// </summary> /// <returns></returns> private List <Detail> GetInspectionDetail() { string query = OracleQuery.ListFaultInfo(this); DataTable dt = _oracle.Query(query); List <Detail> ldet = new List <Detail>(); if (dt.Rows.Count > 0) { #region FILL_ERROR_DETAIL foreach (DataRow r in dt.Rows) { int bid = int.Parse(r["bloque"].ToString()); Detail det = new Detail(); det.faultcode = r["fault_code"].ToString(); det.estado = r["resultado"].ToString(); det.referencia = r["COMPONENT_NAME"].ToString(); det.bloqueId = bid; //det.total_faultcode = int.Parse(r["total"].ToString()); det.descripcionFaultcode = Faultcode.Description(det.faultcode); ldet.Add(det); } #endregion } return(ldet); }
private PcbInfo CreatePCBInfo() { string query = OracleQuery.ListBlocks(this); DataTable dt = _oracle.Query(query); int totalRows = dt.Rows.Count; int bloques = (from DataRow r in dt.Rows select int.Parse(r["seg_no"].ToString())).Distinct().Count(); //var segmentos = (from DataRow r in dt.Rows select int.Parse(r["seg_id"].ToString())).Distinct(); PcbInfo pcb = new PcbInfo(); pcb.bloques = bloques; pcb.nombre = programa; pcb.programa = programa; pcb.id = vtsOraclePgItemId; pcb.tipoMaquina = machineNameKey; return(pcb); }
private void OracleQuery(string query) { try { DataTable dt = oracle.Query(query); gridOracle.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }