设备保养关联工作接口查询、提交修改

yl

2023-01-10 4e2ad6fb29941fb759de11697db680012ab5d06d

 VueWebApi/DLL/DAL/AppDeviceManageDAL.cs

@@ -61,8 +61,46 @@
        }
        #endregion

        #region[日常点检,扫描工位/设备二维码查找点检标准]
        public static ToMessage CheckScanDeviceTemp(string eqpcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取对应设备点检标准
                sql = @"select M.code,M.name   from TEqpchk_Eqp E
                        inner join TEqpchk_Main M on E.eqpchkmain_code=M.code
                        where E.eqp_code=@eqpcode order by M.lm_date desc";
                dynamicParams.Add("@eqpcode", eqpcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "200";
                    mes.Message = "查询成功!";
                    mes.data = data;
                }
                else
                {
                    mes.code = "300";
                    mes.Message = "当前设备/工位未指定点检标准!";
                    mes.data = data;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }

        #endregion

        #region[日常点检,选择扫码设备列表带出点检项]
        public static ToMessage SelectScanDeviceQrCodeItem(string eqpcode)
        public static ToMessage SelectScanDeviceQrCodeItem(string eqpcode,string checktempcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
@@ -73,9 +111,10 @@
                        from TEqpchk_Eqp A
                        inner join TEqpchk_Main B on A.eqpchkmain_code=B.code
                        inner join TEqpchk_Deta S on B.code=S.eqpchk_main_code
                        where A.eqp_code=@eqpcode
                        where A.eqp_code=@eqpcode and B.code=@checktempcode
                        order by S.seq asc";
                dynamicParams.Add("@eqpcode", eqpcode);
                dynamicParams.Add("@checktempcode", checktempcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
@@ -239,20 +278,18 @@
        }
        #endregion

        #region[日常保养,选择扫码设备列表带出保养项]
        public static ToMessage RepairSelectScanDeviceQrCodeItem(string eqpcode)
        #region[定期保养,扫描工位/设备二维码查找保养标准]
        public static ToMessage RepairScanDeviceTemp(string eqpcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取对应设备关联的保养项目
                sql = @"select S.seq,S.code,S.name,S.chk_desc,S.isscan,B.main_cycle 
                        from TEqpmai_Eqp A
                        inner join TEqpmai_Main B on A.eapmai_code=B.code
                        inner join TEqpmai_Deta S on B.code=S.eapmai_code
                        where A.eqp_code=@eqpcode
                        order by S.seq asc";
                //获取对应设备保养标准
                sql = @"select M.code,M.name,main_cycle   from TEqpmai_Eqp E
                        inner join TEqpmai_Main M on E.eapmai_code=M.code
                        where E.eqp_code=@eqpcode
                        order by M.lm_date desc";
                dynamicParams.Add("@eqpcode", eqpcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
@@ -264,7 +301,48 @@
                else
                {
                    mes.code = "300";
                    mes.Message = "当前设备未设置点检标准绑定点检项目!";
                    mes.Message = "当前设备/工位未指定保养标准!";
                    mes.data = data;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[日常保养,选择扫码设备列表带出保养项]
        public static ToMessage RepairSelectScanDeviceQrCodeItem(string eqpcode,string repartempcode)
        {
            string sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //获取对应设备关联的保养项目
                sql = @"select S.seq,S.code,S.name,S.chk_desc,S.isscan,B.main_cycle 
                        from TEqpmai_Eqp A
                        inner join TEqpmai_Main B on A.eapmai_code=B.code
                        inner join TEqpmai_Deta S on B.code=S.eapmai_code
                        where A.eqp_code='SB003' and B.code=@repartempcode
                        order by S.seq asc";
                dynamicParams.Add("@eqpcode", eqpcode);
                dynamicParams.Add("@repartempcode", repartempcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    mes.code = "200";
                    mes.Message = "查询成功!";
                    mes.data = data;
                }
                else
                {
                    mes.code = "300";
                    mes.Message = "当前设备未设置保养标准绑定点检项目!";
                    mes.data = data;
                }
            }