[技术]-没有 ORM 的架构

USE [lysk2]
GO
    /****** Object:  StoredProcedure [dbo].[P_EvacuateNodes]    Script Date: 2023/11/30 8:25:41 ******/
SET
    ANSI_NULLS ON
GO
SET
    QUOTED_IDENTIFIER ON
GO
    ALTER proc [dbo].[P_EvacuateNodes] @node int = 999 as begin truncate table CalStartTab;

EXEC P_CalculateStartProc @node;

truncate table CalEndTab;

EXEC P_CalculateEndProc @node;

truncate table EvacEvenNodesTab;

insert into
    EvacEvenNodesTab
SELECT
    tp.*
FROM
    (
        SELECT
            TOP 100 PERCENT ROW_NUMBER() OVER (
                partition BY ddid
                ORDER BY
                    wtime
            ) AS rowNum,
            sid,
            tid,
            ygid,
            wtime,
            ddid
        FROM
            WFRecord
        WHERE
            id IN (
                SELECT
                    id
                FROM
                    WFRecord wf
                    INNER JOIN CalStartTab s ON wf.ddid = s.ddid
                    INNER JOIN CalEndTab e ON wf.ddid = e.ddid
                WHERE
                    (
                        sid = @node
                        OR tid = @node
                    )
                    AND wtime >= s.minTime
                    AND wtime <= e.maxTime
                GROUP BY
                    wf.ddid,
                    wf.id
            )
        ORDER BY
            wtime
    ) tp
WHERE
    tp.rowNum % 2 = 0 truncate table EvacOddNodesTab;

insert into
    EvacOddNodesTab
SELECT
    tp.*
FROM
    (
        SELECT
            TOP 100 PERCENT ROW_NUMBER() OVER (
                partition BY ddid
                ORDER BY
                    wtime
            ) AS rowNum,
            sid,
            tid,
            ygid,
            wtime,
            ddid
        FROM
            WFRecord
        WHERE
            id IN (
                SELECT
                    id
                FROM
                    WFRecord wf
                    INNER JOIN CalStartTab s ON wf.ddid = s.ddid
                    INNER JOIN CalEndTab e ON wf.ddid = e.ddid
                WHERE
                    (
                        sid = @node
                        OR tid = @node
                    )
                    AND wtime >= s.minTime
                    AND wtime <= e.maxTime
                GROUP BY
                    wf.ddid,
                    wf.id
            )
        ORDER BY
            wtime
    ) tp
WHERE
    tp.rowNum % 2 = 1
end

突然翻到之前自己写的存储过程现在看看都是头皮发麻公司框架用的还是 .Net Framework 4.5

直接用 CYQ.Data 和数据库交互 sql 中 order by 还失效必须先查询加载到内存后再排序

之前一直用的是 EF 或者 EF Core 也用过 SqlSugar 这样的第三方框架