コード例 #1
0
        public static DataTable ConsultarFolio(LineaDownLogica line)
        {
            DataTable datos = new DataTable();

            try
            {
                datos = AccesoDatos.Consultar("SELECT * FROM t_linedown WHERE folio = " + line.Folio + "");
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(datos);
        }
コード例 #2
0
        public static int Eliminar(LineaDownLogica line)
        {
            int iRes = 0;

            try
            {
                iRes = AccesoDatos.Borrar("DELETE FROM t_linedown WHERE folio = " + line.Folio + "");
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(iRes);
        }
コード例 #3
0
 public static int GuardarSP(LineaDownLogica line)
 {
     string[] parametros = { "@Folio", "@Fecha", "@Turno", "@Linea", "@Hora", "@Duracion", "@Motivo", "@Notas" };
     return(AccesoDatos.Actualizar("sp_mant_linedown", parametros, line.Folio, line.Fecha, line.Turno, line.Linea, line.Hora, line.Duracion, line.Motivo, line.Notas));
 }