chenhaozhe
8 天以前 5cd7423376cef6dbb46904cfde4c821c2ddb5190
WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs
@@ -7463,7 +7463,7 @@
                    if (sWhere == null || sWhere.Equals(""))
                    {
                        string sql = "select * from h_v_OA_WorkLinkBillAllList order by 单据号 desc";
                        sql += $@"OFFSET {(page-1)*size} ROWS
                        sql += $@" OFFSET {(page-1)*size} ROWS
                                FETCH NEXT {size} ROWS ONLY; ";
                        ds = oCN.RunProcReturn(sql, "h_v_OA_WorkLinkBillAllList");
                    }
@@ -7471,7 +7471,7 @@
                    {
                        string sql1 = "select * from h_v_OA_WorkLinkBillAllList where 1 = 1 ";
                        string sql = sql1 + sWhere + " order by 单据号 desc";
                        sql += $@"OFFSET {(page - 1) * size} ROWS
                        sql += $@" OFFSET {(page - 1) * size} ROWS
                                FETCH NEXT {size} ROWS ONLY; ";
                        ds = oCN.RunProcReturn(sql, "h_v_OA_WorkLinkBillAllList");