1

chenhaozhe

昨天 98a5940029c14ccd95aeee7d6dc6487c1ca306ba

1

 WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs

@@ -7458,16 +7458,14 @@
                if (sWhere == null || sWhere.Equals(""))
                {
                    string sql = "select * from h_v_OA_WorkLinkBillAllList order by 单据号 desc";
                    sql += $@"OFFSET {page-1 * size} ROWS
                            FETCH NEXT {size} ROWS ONLY; ";

                    ds = oCN.RunProcReturn(sql, "h_v_OA_WorkLinkBillAllList");
                }
                else
                {
                    string sql1 = "select * from h_v_OA_WorkLinkBillAllList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 单据号 desc";
                    sql += $@"OFFSET {page - 1 * size} ROWS
                            FETCH NEXT {size} ROWS ONLY; ";

                    ds = oCN.RunProcReturn(sql, "h_v_OA_WorkLinkBillAllList");
                }