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