public static DataTable VisorSP(MonitorSetupLogica set) { DataTable datos = new DataTable(); try { string[] parametros = { "@FechaIni", "@FechaFin", "@IndPlanta", "@Planta", "@IndLinea", "@Linea", "@Turno", "@Estatus" }; datos = AccesoDatos.ConsultaSP("sp_mon_lineset_visor", parametros, set.FechaIni, set.FechaFin, set.IndPlanta, set.Planta, set.IndLinea, set.Linea, set.Turno, set.Estatus); } catch (Exception ex) { throw ex; } return(datos); }
public static DataTable DuracionSP(MonitorSetupLogica set) { DataTable datos = new DataTable(); try { string[] parametros = { "@FechaIni", "@FechaFin", "@IndPlanta", "@Planta", "@IndLinea", "@Linea" }; datos = AccesoDatos.ConsultaSPPRO("sp_rep_setup_dura", parametros, set.FechaIni, set.FechaFin, set.IndPlanta, set.Planta, set.IndLinea, set.Linea); } catch (Exception ex) { throw ex; } return(datos); }
public static DataTable ListarSetup(MonitorSetupLogica det) { DataTable datos = new DataTable(); try { string sSql = "SELECT st.fecha, sd.folio, sd.consec, sd.turno, sd.planta, sd.linea, " + "sd.rpo, sd.rpo_sig, case sd.inicio_prog when '' then '' else convert(varchar(10), st.fecha, 101) + ' ' + sd.inicio_prog end, sd.duracion " + "FROM t_lineset st INNER JOIN t_linesedet sd ON st.folio = sd.folio " + "WHERE sd.estatus <> 'C' AND (CAST(st.fecha AS DATE) between CAST('" + det.FechaIni + "' AS DATE) AND CAST('" + det.FechaIni + "' AS DATE)) " + "ORDER BY sd.planta,sd.linea,st.fecha"; datos = AccesoDatos.ConsultarPRO(sSql); } catch (Exception ex) { throw ex; } return(datos); }
public static bool Listar(MonitorSetupLogica det) { DataTable datos = new DataTable(); try { string sSql = "SELECT * FROM t_linesedet where u_id = 'SYSCOM' AND f_id >= '" + det.FechaIni + "' "; datos = AccesoDatos.ConsultarPRO(sSql); if (datos.Rows.Count > 0) { return(true); } } catch (Exception ex) { throw ex; } return(false); }