1

chenhaozhe

2026-03-17 9f8a298b7e11f1be6931451842a8273460212d6f

 WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs

@@ -7439,7 +7439,7 @@
        #region 工作联系单列表
        [Route("Sc_MESTransFerWorkBill/GetOA_WorkLinkBillList")]
        [HttpGet]
        public object GetOA_WorkLinkBillList(string sWhere, string user)
        public object GetOA_WorkLinkBillList(string sWhere, string user, int page, int size)
        {
            try
            {
@@ -7458,12 +7458,16 @@
                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");
                }