Detalle: ordenes.asp

ordenes.asp

Ir a la Página Volver a la Lista

Archivo ASP

ordenes.asp

Página Razor

Compras/Ordenes.cshtml

Módulo

Compras

Líneas de Código

105

Características

En Menú:	Sí
Formularios:	1 formulario(s)
Consultas SQL:	2 consulta(s)
Complejidad:	low
Bases de Datos:	Session DB

Tablas Utilizadas (1)

Cordm

Consultas SQL (2)

SQL Original (ASP)

select * from Cordm where (usuario  like'

Tablas: Cordm

SQL Original (ASP)

select * from Cordm where (usuario  like'" & nombre & "') order by Ordens

Tablas: Cordm

Comentarios y Notas (0)

No hay comentarios aún

Enlaces Salientes (6) Páginas a las que esta página enlaza

Archivo ASP	Tipo	Módulo	Estado	Página Razor
`barra.asp`	include	General	Pendiente	-
`empresa.asp`	include	General	Pendiente	-
`general.asp`	include	General	Pendiente	-
`mpro.asp`	include	General	Pendiente	-
`ordenlist.asp`	include	Compras	Pendiente	ordenlist
`user.asp`	include	General	Pendiente	-

Enlaces Entrantes (0) Páginas que enlazan a esta página

No hay enlaces entrantes

<%  
Option Explicit
%>
<%
Session.LCID = 2058
%> 
<!--#include file="User.asp"-->
<!--#include file="general.asp"-->
<html>
<head>
<title>Grupo MIM</title>
<link href="css/Modulo5.css" rel="stylesheet" />
<link rel=stylesheet href="vista.css">
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function NewWindow(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',resizable'
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
//  End -->
</script>
</head>
<BODY>
<!--#INCLUDE FILE="BARRA.asp"-->

<div class="normalw" style="position:absolute; top:1px">
<center>
<!--#include file="empresa.asp"--><br>
<hr>
</center>
</div>

<div class="normalw" style="position:absolute; top:1px;">
Bienvenido: <%= nombre %>. <br>
Hora Actual: <%= time %>
</div>
<div class="normalw" style="position:absolute; top:34px; left:1">
<!--#include file="mpro.asp"-->
</div>

<div class="normal" style="position:absolute; top:60px; left:10">
<%
dim rs5, sql5
set rs5 = server.CreateObject("ADODB.Recordset")
sql5 = "select * from Cordm where (usuario  like'" & nombre & "') order by Ordens"
rs5.open sql5,cn1,1,2
%>

<%
do while not rs5.EOF
%>
<a href="<%=rs5.fields("ordenm")%>.asp"><img src="image/<%=rs5.fields("Ordenn")%>.gif" border=0 Alt="<%=rs5.fields("Ordenn")%>"></a>
<%
rs5.MoveNext
loop
%>

</div>

<div  align="center" style="position:absolute; top:100px; left:50%; transform: translateX(-50%);">
<br>
	<BR>
		<B>***** BUSQUEDA DE ORDENES *****</B>
		<BR><BR>
			<Form action="Ordenes.asp" method="post" >

			<Table Id="TablaOpc">
				<Tr>	
					<Td>Numero OC:</Td>
					<Td>Nombre Proveedor:</Td>
					<Td>Fecha Inical:</Td>
					<Td>Fecha Final:</Td>
				</Tr>
				<Tr>
					<Td>
					<input tabindex="1" type="text" placeholder="Numero OC" Title="NÃºmero OC" name="Numord" Id="TablaOpc" id="Numord" Size="7" value="<%= Numord %>">
					</td>
					<Td>
					<input tabindex="2" type="text" placeholder="Nombre Proveedor" Title="Nombre Proveedor" Id="TablaOpc" name="Nomprv" id="Nomprv" Size="15" value="<%= Nomprv %>">				
					</Td>
					<td><input type=text class=normalb name="FechaInicio"Size="10" Id="TablaOpc" Value="<%= date()-365 %>" size=7 onChange="javascript:this.value=this.value.toUpperCase();"></td>
					<td><input type=text class=normalb name="FechaFinal"Size="10" Id="TablaOpc" Value="<%= date()+1 %>" size=7 onChange="javascript:this.value=this.value.toUpperCase();"></td>
					<Td>
					<button  tabindex="4" type="submit" name="Buscar" id="BuscarCli"/>Buscar</button>
					</td>
				</Tr>
			</table>
			</form>

<!--#include file="OrdenList.asp"-->

</div>
</body>
</html>
<%  
End Sub 
'Add the chosen course to the cart
 Call AddUsuario() 
'Display contents of electronic shopping cart
 Call DisplayUsuario()
%>

using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using MimPortal.Data;
using MimPortal.Data.Entities;

namespace MimPortal.Pages.Compras
{
    public class OrdenesModel : PageModel
    {
        private readonly MimDbContext _context;
        private const int PageSize = 25;

        public OrdenesModel(MimDbContext context)
        {
            _context = context;
        }

        [BindProperty(SupportsGet = true)]
        public int? NumOC { get; set; }

        [BindProperty(SupportsGet = true)]
        public string? Proveedor { get; set; }

        [BindProperty(SupportsGet = true)]
        public string? Status { get; set; }

        [BindProperty(SupportsGet = true)]
        public DateTime? FechaDesde { get; set; }

        [BindProperty(SupportsGet = true)]
        public DateTime? FechaHasta { get; set; }

        [BindProperty(SupportsGet = true)]
        public int PageNum { get; set; } = 1;

        public List<OrdenViewModel> Ordenes { get; set; } = new();
        public int TotalCount { get; set; }
        public int TotalPages { get; set; }
        public int CurrentPage => PageNum;

        public async Task OnGetAsync()
        {
            var sucursal = HttpContext.Session.GetString("Sucursal") ?? "MERIDA";
            // Use a simpler query that avoids keyless entity comparison issues
            var query = from o in _context.CORDENC
                        where o.Sucursal == sucursal
                        join p in _context.PROVEEDORES on o.PROORE equals p.CVEPRV into provJoin
                        from prov in provJoin.DefaultIfEmpty()
                        select new OrdenViewModel
                        {
                            Id = o.Id,
                            NUMORE = o.NUMORE,
                            FECORE = o.FECORE,
                            PROORE = o.PROORE,
                            ProveedorNombre = prov.NOMPRV ?? o.PROORE,
                            MONORE = o.MONORE,
                            TCAORE = o.TCAORE,
                            SUBORE = o.SUBORE,
                            IVTORE = o.IVTORE,
                            IVAORE = o.IVAORE,
                            USUORE = o.USUORE,
                            OBSORE = o.OBSORE
                        };

            // Apply filters
            if (NumOC.HasValue)
            {
                query = query.Where(o => o.NUMORE == NumOC.Value);
            }

            if (!string.IsNullOrEmpty(Proveedor))
            {
                query = query.Where(o => o.ProveedorNombre.Contains(Proveedor));
            }

            if (!string.IsNullOrEmpty(Status) && int.TryParse(Status, out int statusInt))
            {
                query = query.Where(o => o.MONORE == statusInt);
            }

            if (FechaDesde.HasValue)
            {
                query = query.Where(o => o.FECORE >= FechaDesde.Value);
            }

            if (FechaHasta.HasValue)
            {
                query = query.Where(o => o.FECORE <= FechaHasta.Value);
            }

            // Order by date descending
            query = query.OrderByDescending(o => o.FECORE);

            // Get total count
            TotalCount = await query.CountAsync();
            TotalPages = (int)Math.Ceiling(TotalCount / (double)PageSize);

            // Paginate
            Ordenes = await query
                .Skip((PageNum - 1) * PageSize)
                .Take(PageSize)
                .ToListAsync();
        }
    }

    public class OrdenViewModel
    {
        public Guid Id { get; set; }
        public int NUMORE { get; set; }
        public DateTime FECORE { get; set; }
        public string? PROORE { get; set; }
        public string? ProveedorNombre { get; set; }
        public int MONORE { get; set; }
        public decimal? TCAORE { get; set; }
        public decimal? SUBORE { get; set; }
        public decimal? IVTORE { get; set; }
        public decimal? IVAORE { get; set; }
        public string? USUORE { get; set; }
        public string? OBSORE { get; set; }
    }
}

@page
@model MimPortal.Pages.Compras.OrdenesModel
@{
    ViewData["Title"] = "Órdenes de Compra";
}
<div id="page-content">

<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center">
        <h5><i class="bi bi-file-earmark-text"></i> Órdenes de Compra</h5>
        <a href="/Compras/Ordenadd" class="btn btn-success btn-sm">
            <i class="bi bi-plus-circle"></i> Nueva Orden
        </a>
    </div>
    <div class="card-body">
        <form method="get" class="row g-3 mb-4">
            <div class="col-md-2">
                <label class="form-label">Número OC</label>
                <input type="number" class="form-control" name="NumOC" value="@Model.NumOC" placeholder="# OC" />
            </div>
            <div class="col-md-3">
                <label class="form-label">Proveedor</label>
                <input type="text" class="form-control" name="Proveedor" value="@Model.Proveedor" placeholder="Nombre proveedor..." />
            </div>
            <div class="col-md-2">
                <label class="form-label">Status</label>
                <select class="form-select" name="Status">
                    <option value="">Todos</option>
                    <option value="P" selected="@(Model.Status == "P")">Pendiente</option>
                    <option value="A" selected="@(Model.Status == "A")">Autorizada</option>
                    <option value="R" selected="@(Model.Status == "R")">Recibida</option>
                    <option value="C" selected="@(Model.Status == "C")">Cancelada</option>
                </select>
            </div>
            <div class="col-md-2">
                <label class="form-label">Desde</label>
                <input type="date" class="form-control" name="FechaDesde" value="@Model.FechaDesde?.ToString("yyyy-MM-dd")" />
            </div>
            <div class="col-md-2">
                <label class="form-label">Hasta</label>
                <input type="date" class="form-control" name="FechaHasta" value="@Model.FechaHasta?.ToString("yyyy-MM-dd")" />
            </div>
            <div class="col-md-1 d-flex align-items-end">
                <button type="submit" class="btn btn-primary"><i class="bi bi-search"></i></button>
            </div>
        </form>

        <div class="table-responsive">
            <table class="table table-hover table-striped">
                <thead class="table-dark">
                    <tr>
                        <th>OC #</th>
                        <th>Fecha</th>
                        <th>Proveedor</th>
                        <th>Moneda</th>
                        <th class="text-end">Subtotal</th>
                        <th class="text-end">IVA</th>
                        <th class="text-end">Total</th>
                        <th>Status</th>
                        <th>Usuario</th>
                        <th>Acciones</th>
                    </tr>
                </thead>
                <tbody>
                    @if (Model.Ordenes != null && Model.Ordenes.Any())
                    {
                        @foreach (var orden in Model.Ordenes)
                        {
                            <tr>
                                <td><strong>@orden.NUMORE</strong></td>
                                <td>@orden.FECORE.ToString("dd/MM/yyyy")</td>
                                <td>@orden.ProveedorNombre</td>
                                <td>@(orden.MONORE == 1 ? "MXN" : "USD")</td>
                                <td class="text-end">@orden.SUBORE?.ToString("N2")</td>
                                <td class="text-end">@orden.IVTORE?.ToString("N2")</td>
                                <td class="text-end"><strong>@orden.IVAORE?.ToString("N2")</strong></td>
                                <td>
                                    @switch (orden.MONORE)
                                    {
                                        case 0:
                                            <span class="badge bg-warning">Pendiente</span>
                                            break;
                                        case 1:
                                            <span class="badge bg-success">Comprada</span>
                                            break;
                                        case 2:
                                            <span class="badge bg-danger">Cancelada</span>
                                            break;
                                        case 3:
                                            <span class="badge bg-danger">Cancelada</span>
                                            break;
                                        default:
                                            <span class="badge bg-secondary">@orden.MONORE</span>
                                            break;
                                    }
                                </td>
                                <td>@orden.USUORE</td>
                                <td>
                                    <a href="/Compras/OrdenDetalle/@orden.NUMORE" class="btn btn-sm btn-outline-primary" title="Ver Detalle">
                                        <i class="bi bi-eye"></i>
                                    </a>
                                    @if (orden.MONORE == 1)
                                    {
                                        <a href="/Compras/Ordenmod/@orden.NUMORE" class="btn btn-sm btn-outline-warning" title="Editar">
                                            <i class="bi bi-pencil"></i>
                                        </a>
                                    }
                                    <a href="/Compras/Ordenimp/@orden.NUMORE" class="btn btn-sm btn-outline-secondary" title="Imprimir">
                                        <i class="bi bi-printer"></i>
                                    </a>
                                </td>
                            </tr>
                        }
                    }
                    else
                    {
                        <tr>
                            <td colspan="10" class="text-center text-muted py-4">
                                <i class="bi bi-inbox fs-1"></i>
                                <p class="mt-2">No se encontraron órdenes de compra</p>
                            </td>
                        </tr>
                    }
                </tbody>
            </table>
        </div>

@{
            var paginationModel = new MimPortal.Pages.Shared.PaginationModel 
            { 
                CurrentPage = Model.CurrentPage, 
                TotalPages = Model.TotalPages, 
                BaseUrl = "/Compras/Ordenes", 
                QueryParams = new Dictionary<string, string> 
                { 
                    { "NumOC", Model.NumOC?.ToString() ?? "" }, 
                    { "Proveedor", Model.Proveedor ?? "" }, 
                    { "Status", Model.Status ?? "" } 
                } 
            };
        }
        <partial name="_Pagination" model="paginationModel" />

        <div class="text-muted small">
            Mostrando @Model.Ordenes?.Count de @Model.TotalCount órdenes
        </div>
    </div>
</div>
</div>

MATERIALES INDUSTRIALES DE MEXICO

ordenes.asp

Archivo ASP

Página Razor

Módulo

Líneas de Código

SELECT select * from Cordm where (usuario like'

SQL Original (ASP)

SELECT select * from Cordm where (usuario like'" & nombre & "') order by Ordens

SQL Original (ASP)