1

zrg

2026-03-17 40ab7d625a01026d9b26abfcf574fde5e9954e36

 WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs

@@ -907,6 +907,7 @@
                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
                    oItem.HBarCode = DBUtility.ClsPub.isStrNull(oItem.HBarCode);
                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                    {
                        objJsonResult.code = "0";
@@ -7438,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
            {
@@ -7457,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");
                }