优化自动产生工作联系单方法

zrg

7 天以前 981ea6f779477b4b729c6796cfc42ee933c781b0

 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, int page, int size)
        public object GetOA_WorkLinkBillList(string sWhere, string user)
        {
            try
            {
@@ -7458,16 +7458,13 @@
                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");
                }