1

zrg

2026-04-15 0b8efdbce56a9df6eb2ec48dbc75b433e8c14256

 WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs

@@ -1007,6 +1007,33 @@
        }
        #endregion

        #region 异常反馈根据设备ID获取数据
        [Route("Sc_MESTransFerWorkBill/Get_TransFerBillListByHEquipID")]
        [HttpGet]
        public ApiResult<DataSet> Get_TransFerBillListByHEquipID(string HEquipID, string sWhere)
        {
            if (string.IsNullOrEmpty(HEquipID))
                return new ApiResult<DataSet> { code = -1, msg = "设备不能为空" };
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            string sql = string.Format($@"
                select c.HNumber 警报代码,CONVERT(VARCHAR(255), ABS(DATEDIFF(HOUR, a.HMakeDate, a.HUpdateDate))) + '小时' 持续时间,a.HErrLev 原因, a.HDate 时间 from h_v_OA_ErrMsgBackBillEdit a
                left join Gy_EquipFileBillMain b on a.HSourceID = b.HSourceID
                left join Gy_ErrMsgBackType c on c.HItemID = a.HErrMsgBackTypeID  
                where b.HInterID = {HEquipID}
            ");

            if (!string.IsNullOrEmpty(sWhere))
            {
                sql += sWhere;
            }
            var dataSet = oCN.RunProcReturn(sql, "OA_ErrMsgBackBillMain");
            if (dataSet == null)
                return new ApiResult<DataSet> { code = -1, msg = "当前设备对应的警报记录不存在" };

            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
        }
        #endregion

        #region 异常反馈列表编辑获取数据
        [Route("Sc_MESTransFerWorkBill/Get_TransFerBillListCheckDetai")]
        [HttpGet]