若依前端-APP中使用数据字典

ALTER TABLE ryvue_mes.pro_task ADD first_flag INT NULL COMMENT '首道工序(0否/1是)';
ALTER TABLE ryvue_mes.pro_task ADD last_flag INT NULL COMMENT '末道工序(0否/1是)';
ALTER TABLE ryvue_mes.pro_task ADD bf_flag INT NULL COMMENT 'BFFlag 倒冲工序(0否/1是)';
ALTER TABLE ryvue_mes.pro_task ADD report_flag INT NULL COMMENT 'ReportFlag 报告点 (0否/1是)';
ALTER TABLE ryvue_mes.pro_task ADD fee_flag INT NULL COMMENT 'FeeFlag 计费点(0否/1是)';
ALTER TABLE ryvue_mes.pro_task ADD delivery_days DECIMAL NULL COMMENT 'DeliveryDays 交货天数';

1 在main.js文件中注册有关字典的组件和相关的属性等，如下所示，有添加字典注解的地方

import Vue from 'vue'
import App from './App'
import wx from 'weixin-js-sdk'
import store from './store' // store
import plugins from './plugins' // plugins
import './permission' // permission
//字典
import { getDicts } from "@/api/system/dict/data"
// 字典标签组件
import DictTag from '@/components/DictTag'
// 字典数据组件
import DictData from '@/components/DictData'

Vue.use(plugins)
//安装字典
DictData.install()

Vue.config.productionTip = false
Vue.prototype.$store = store
Vue.prototype.getDicts = getDicts
//全局注册字典
Vue.component('DictTag', DictTag)

App.mpType = 'app'

const app = new Vue({
  ...App
})

app.$mount()

2 在D:\ideaProject\RuoYi-App-master\components目录，添加从前端的项目复制DictData,DictTag两个目录的全部文件

3在D:\ideaProject\RuoYi-App-master\utils目录，添加从前端的项目复制utils的文件，存在的文件就跳过

4 在组件文件中直接使用<dict-tag :options="dict.type.mes_order_status" value="CONFIRMED" />来表示字典显示的内容

4.1 定义字典的内容

dicts: ['mes_order_status','mes_workorder_sourcetype','mes_workorder_type'],

4.2 在要显示标签的地方，写下dict-tag标签的语法，vaule属性可以使用变量

<dict-tag :options="dict.type.mes_order_status" value="CONFIRMED" />

<template>
    <view class="normal-login-container">
        <view class="logo-content align-center justify-center flex">
            <image style="width: 100rpx;height: 100rpx;" :src="globalConfig.appInfo.logo" mode="widthFix">
            </image>
            <text class="title">若依移动端登录</text>
            <view>
                 
                    <dict-tag :options="dict.type.mes_order_status" value="CONFIRMED" />
             
            </view>
        </view>
        <view class="login-form-content">
            <view class="input-item flex align-center">
                <view class="iconfont icon-user icon"></view>
                <input v-model="loginForm.username" class="input" type="text" placeholder="请输入账号" maxlength="30" />
            </view>
            <view class="input-item flex align-center">
                <view class="iconfont icon-password icon"></view>
                <input v-model="loginForm.password" type="password" class="input" placeholder="请输入密码" maxlength="20" />
            </view>
            <view class="input-item flex align-center" style="width: 60%;margin: 0px;" v-if="captchaEnabled">
                <view class="iconfont icon-code icon"></view>
                <input v-model="loginForm.code" type="number" class="input" placeholder="请输入验证码" maxlength="4" />
                <view class="login-code">
                    <image :src="codeUrl" @click="getCode" class="login-code-img"></image>
                </view>
            </view>
            <view class="action-btn">
                <button @click="handleLogin" class="login-btn cu-btn block bg-blue lg round">登录</button>
            </view>
            <view class="reg text-center" v-if="register">
                <text class="text-grey1">没有账号？</text>
                <text @click="handleUserRegister" class="text-blue">立即注册</text>
            </view>
            <view class="xieyi text-center">
                <text class="text-grey1">登录即代表同意</text>
                <text @click="handleUserAgrement" class="text-blue">《用户协议》</text>
                <text @click="handlePrivacy" class="text-blue">《隐私协议》</text>
            </view>

        </view>
    </view>
</template>

<script>
    import {
        getCodeImg
    } from '@/api/login'

    export default {
        dicts: ['mes_order_status','mes_workorder_sourcetype','mes_workorder_type'],
        data() {
            return {
                codeUrl: "",
                captchaEnabled: true,
                // 用户注册开关
                register: false,
                globalConfig: getApp().globalData.config,
                loginForm: {
                    username: "admin",
                    password: "admin123",
                    code: "",
                    uuid: ''
                }
            }
        },
        created() {
            this.getCode()
        },
        methods: {
            // 用户注册
            handleUserRegister() {
                this.$tab.redirectTo(`/pages/register`)
            },
            // 隐私协议
            handlePrivacy() {
                let site = this.globalConfig.appInfo.agreements[0]
                this.$tab.navigateTo(`/pages/common/webview/index?title=${site.title}&url=${site.url}`)
            },
            // 用户协议
            handleUserAgrement() {
                let site = this.globalConfig.appInfo.agreements[1]
                this.$tab.navigateTo(`/pages/common/webview/index?title=${site.title}&url=${site.url}`)
            },
            // 获取图形验证码
            getCode() {
                getCodeImg().then(res => {
                    this.captchaEnabled = res.captchaEnabled === undefined ? true : res.captchaEnabled
                    if (this.captchaEnabled) {
                        this.codeUrl = 'data:image/gif;base64,' + res.img
                        this.loginForm.uuid = res.uuid
                    }
                })
            },
            // 登录方法
            async handleLogin() {
                if (this.loginForm.username === "") {
                    this.$modal.msgError("请输入您的账号")
                } else if (this.loginForm.password === "") {
                    this.$modal.msgError("请输入您的密码")
                } else if (this.loginForm.code === "" && this.captchaEnabled) {
                    this.$modal.msgError("请输入验证码")
                } else {
                    this.$modal.loading("登录中，请耐心等待...")
                    this.pwdLogin()
                }
            },
            // 密码登录
            async pwdLogin() {
                this.$store.dispatch('Login', this.loginForm).then(() => {
                    this.$modal.closeLoading()
                    this.loginSuccess()
                }).catch(() => {
                    if (this.captchaEnabled) {
                        this.getCode()
                    }
                })
            },
            // 登录成功后，处理函数
            loginSuccess(result) {
                // 设置用户信息
                this.$store.dispatch('GetInfo').then(res => {
                    this.$tab.reLaunch('/pages/index')
                })
            }
        }
    }
</script>

<style lang="scss">
    page {
        background-color: #ffffff;
    }

    .normal-login-container {
        width: 100%;

        .logo-content {
            width: 100%;
            font-size: 21px;
            text-align: center;
            padding-top: 15%;

            image {
                border-radius: 4px;
            }

            .title {
                margin-left: 10px;
            }
        }

        .login-form-content {
            text-align: center;
            margin: 20px auto;
            margin-top: 15%;
            width: 80%;

            .input-item {
                margin: 20px auto;
                background-color: #f5f6f7;
                height: 45px;
                border-radius: 20px;

                .icon {
                    font-size: 38rpx;
                    margin-left: 10px;
                    color: #999;
                }

                .input {
                    width: 100%;
                    font-size: 14px;
                    line-height: 20px;
                    text-align: left;
                    padding-left: 15px;
                }

            }

            .login-btn {
                margin-top: 40px;
                height: 45px;
            }

            .reg {
                margin-top: 15px;
            }

            .xieyi {
                color: #333;
                margin-top: 20px;
            }

            .login-code {
                height: 38px;
                float: right;

                .login-code-img {
                    height: 38px;
                    position: absolute;
                    margin-left: 10px;
                    width: 200rpx;
                }
            }
        }
    }
</style>

1 为表添加数据同步相关的信息

ALTER TABLE ryvue_mes.out_workorder ADD sync_id varchar(100) NULL COMMENT '同步ID(接名名称或AP名行或JOB名称等）';
ALTER TABLE ryvue_mes.out_workorder ADD sync_status INT NULL COMMENT '同步状态(0成功1失败2执行3重传）';
ALTER TABLE ryvue_mes.out_workorder ADD sync_time DATETIME NULL COMMENT '同步完成时间';
ALTER TABLE ryvue_mes.out_workorder ADD sync_qty INT NULL COMMENT '同步记录数';
ALTER TABLE ryvue_mes.out_workorder ADD sync_message varchar(100) NULL COMMENT '同步消息';

ALTER TABLE ryvue_mes.pro_route ADD run_card_flag INT NULL COMMENT '启用流转卡 (0否1是）';
ALTER TABLE ryvue_mes.pro_route ADD aux_unit_code varchar(100) NULL COMMENT '辅助计量单位';
ALTER TABLE ryvue_mes.pro_route ADD runcard_batch_qty DECIMAL NULL COMMENT '流转卡批量数据';
ALTER TABLE ryvue_mes.pro_route ADD route_tyype INT NULL COMMENT 'RountingType 类型(1-主要/2-替代)  ';
ALTER TABLE ryvue_mes.pro_route ADD route_version varchar(100) NULL COMMENT '版本';
ALTER TABLE ryvue_mes.pro_route ADD version_desc varchar(100) NULL COMMENT '版本说明';
ALTER TABLE ryvue_mes.pro_route ADD version_start_date DATE NULL COMMENT '版本生效日期';
ALTER TABLE ryvue_mes.pro_route ADD version_end_date DATE NULL COMMENT '版本结束日期';
ALTER TABLE ryvue_mes.pro_route ADD ident_code varchar(100) NULL COMMENT '替代标识';
ALTER TABLE ryvue_mes.pro_route ADD ident_desc varchar(100) NULL COMMENT '替代说明';
ALTER TABLE ryvue_mes.pro_route ADD auditor_user varchar(100) NULL COMMENT '审核人员';
ALTER TABLE ryvue_mes.pro_route ADD auditor_time DATETIME NULL;
ALTER TABLE ryvue_mes.pro_route ADD close_user varchar(100) NULL COMMENT '关闭人员';
ALTER TABLE ryvue_mes.pro_route ADD close_time varchar(100) NULL;
ALTER TABLE ryvue_mes.pro_route ADD change_rate DECIMAL NULL COMMENT '换算率';
ALTER TABLE ryvue_mes.pro_route ADD update_count varchar(100) NULL COMMENT '修改次数';
ALTER TABLE ryvue_mes.pro_route ADD print_count varchar(100) NULL COMMENT '打印次数';

    <select id="checkFirstProTask" parameterType="ProTask" resultMap="ProTaskResult">
        <include refid="selectProTaskVo"/>
        <where>
            <if test="workorderCode != null  and workorderCode != ''"> and t.workorder_code = #{workorderCode}</if>
            <if test="processCode != null"> and t.process_code = #{processCode} </if>
            <if test="workorderCode != null  and workorderCode != ''"> and (workorder_code,process_order_num)  in (select workorder_code,min(process_order_num) from  ryvue_mes.pro_task  where workorder_code =#{workorderCode} ) </if>

        </where>
    </select>

    <select id="checkLastProTask" parameterType="ProTask" resultMap="ProTaskResult">
        <include refid="selectProTaskVo"/>
        <where>
            <if test="workorderCode != null  and workorderCode != ''"> and t.workorder_code = #{workorderCode}</if>
            <if test="processCode != null"> and t.process_code = #{processCode} </if>
            <if test="workorderCode != null  and workorderCode != ''"> and (workorder_code,process_order_num)  in (select workorder_code,min(process_order_num) from  pro_task  where workorder_code =#{workorderCode} ) </if>
        </where>
    </select>

    <select id="queryPreviousProTask" parameterType="ProTask" resultMap="ProTaskResult">
        <include refid="selectProTaskVo"/>
        <where>
            <if test="workorderCode != null  and workorderCode != ''"> and t.workorder_code = #{workorderCode}</if>
            <if test="workorderCode != null  and workorderCode != '' and  processCode != null  "> and process_order_num  &lt; (select  min(process_order_num) from  pro_task  where workorder_code =#{workorderCode}  and process_code = #{processCode} ) </if>
        </where>
        order by process_order_num desc  limit 1
    </select>
    
    <select id="queryNextProTask" parameterType="ProTask" resultMap="ProTaskResult">
        <include refid="selectProTaskVo"/>
        <where>
            <if test="workorderCode != null  and workorderCode != ''"> and t.workorder_code = #{workorderCode}</if>
            <if test="workorderCode != null  and workorderCode != '' and  processCode != null  "> and process_order_num  &gt; (select  min(process_order_num) from  pro_task  where workorder_code =#{workorderCode}  and process_code = #{processCode} ) </if>
        </where>
        order by process_order_num    limit 1
    </select>

https://blog.csdn.net/hmmmmm/article/details/124625612