条码生产

陈婷婷

2025-11-27 1544dcf0a81cf0a271a78ea82c52ab952c91f8d7

条码生产

 public/static/grf/ÎïÁÏÌõÂë.grf

@@ -1,375 +1,93 @@
Object Report
    Version='6.8.2.5'
    Title='生产任务单'
    PrintAsDesignPaper=F
    Object Font
        Name='宋体'
        Size=135000,0
        Weight=400
        Charset=134
    End
    Object Printer
        Size=256
        Width=9.75
        Height=6
        LeftMargin=0
        TopMargin=0
        RightMargin=0
        BottomMargin=0
    End
    Object DetailGrid
        CenterView=T
        ShowColLine=F
        ShowRowLine=F
        Object Border
            Styles=[]
        End
        Object Recordset
            Items Field
                Item
                    Name='生产工单号'
                    DBFieldName='源单单号'
                End
                Item
                    Name='物料代码'
                End
                Item
                    Name='物料名称'
                End
                Item
                    Name='规格型号'
                End
                Item
                    Name='数量'
                End
                Item
                    Name='条码编号'
                End
                Item
                    Name='销售订单号'
                End
                Item
                    Name='批号'
                End
                Item
                    Name='日期'
                    Type=DateTime
                    Format='yyyy/MM/dd'
                End
                Item
                    Name='制作人'
                End
                Item
                    Name='客户型号'
                End
                Item
                    Name='计量单位'
                End
                Item
                    Name='源单单号'
                End
                Item
                    Name='供应商'
                End
                    End
    End
    Items Column
        Item
            Name='Column3'
            Width=9.60438
        End
    End
Object ColumnContent
    Height=6.00604
    RowsPerPage=1
    Items ColumnContentCell
        Item
            Column='Column3'
            FreeCell=T
            CanGrow=T
            Items Control
                Item
                    Type=MemoBox
                    Name='凯贝奈特'
                    Left=0.79375
                    Top=0.211667
                    Width=5.3975
                    Height=1.37583
                    Object Font
                        Name='宋体'
                        Size=142500,0
                        Weight=400
                        Charset=134
                    End
                    ShrinkFontToFit=T
                    TextAlign=MiddleCenter
                    CharSpacing=4
                    Text='条码信息'
                End
                Item
                    Type=Barcode
                    Name='Barcode1'
                    Left=6.79979
                    Top=0.211667
                    Width=1.79917
                    Height=1.37583
                    BarcodeType=QRCode
                    CaptionPosition=None
                    Text='[#条码编号#]'
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                End
                Item
                    Type=FreeGrid
                    Name='FreeGrid1'
                    Left=0.132292
                    Top=1.69333
                    Object Border
                        Styles=[DrawLeft|DrawTop|DrawRight|DrawBottom]
                    End
                    ColumnCount=6
                    Items FreeGridColumn
                        Item[1]
                            Width=1.56104
                        End
                        Item[2]
                            Width=1.85208
                        End
                        Item[3]
                            Width=1.16417
                        End
                        Item[4]
                            Width=1.69333
                        End
                        Item[5]
                            Width=1.00542
                        End
                        Item[6]
                            Width=2.11667
                        End
                                    End
                Items FreeGridRow
                    Item[1]
                        Height=0.820208
                    End
                    Item[2]
                        Height=0.79375
                    End
                    Item[3]
                        Height=0.79375
                    End
                    Item[4]
                        Height=0.820208
                    End
                    Item[5]
                        Height=0.740833
                    End
                            End
            Items FreeGridCell
                Item[1,1]
                    Object Font
                        Name='宋体'
                        Weight=400
                        Charset=134
                    End
                    Text='工单号'
                End
                Item[1,2]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    ShrinkFontToFit=T
                    Text='[#生产工单号#]'
                    ColSpan=2
                End
                Item[1,4]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='供应商'
                End
                Item[1,5]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#供应商#]'
                    ColSpan=2
                End
                Item[2,1]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='物料编码'
                End
                Item[2,2]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#物料代码#]'
                    ColSpan=5
                End
                Item[3,1]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='物料名称'
                End
                Item[3,2]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#物料名称#]'
                    ColSpan=5
                End
                Item[4,1]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='数量'
                    DataName='数量'
                End
                Item[4,2]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#数量#]'
                End
                Item[4,3]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='单位'
                    DataName='单位'
                End
                Item[4,4]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#计量单位#]'
                End
                Item[4,5]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='批号'
                End
                Item[4,6]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#批号#]'
                End
                Item[5,1]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='打印人员'
                    DataName='打印人员'
                End
                Item[5,2]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#制作人#]'
                    ColSpan=2
                End
                Item[5,4]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='打印日期'
                    DataName='打印日期'
                End
                Item[5,5]
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='[#日期#]'
                    ColSpan=2
                End
                    End
    End
End
End
End
End
Object ColumnTitle
    Height=0
    Items ColumnTitleCell
        Item
            GroupTitle=F
            Column='Column3'
            Text='Column1'
        End
    End
End
End
Items ReportHeader
    Item
        Name='ReportHeader1'
        Height=0
        RepeatOnPage=T
    End
End
Items ReportFooter
    Item
        Name='ReportFooter1'
        Height=0
    End
End
End
{
    "Version":"6.8.2.2",
    "Title":"1a.简单表格",
    "Author":"锐浪报表软件",
    "Description":"演示一个最基本的列表报表。",
    "Font":{
        "Name":"宋体",
        "Size":90000,
        "Weight":400,
        "Charset":134
    },
    "Printer":{
        "Size":256,
        "Width":9,
        "Height":6,
        "LeftMargin":0,
        "TopMargin":0,
        "RightMargin":0,
        "BottomMargin":0
    },
    "DetailGrid":{
        "CenterView":true,
        "PrintAdaptMethod":"ResizeToFit",
        "Recordset":{
            "ConnectionString":"xml",
            "QuerySQL":"销售出库单.txt",
            "Field":[
                {
                    "Name":"条码编号"
                }
            ]
        },
        "Column":[
            {
                "Name":"单据号",
                "Width":8.78417
            }
        ],
        "ColumnContent":{
            "Height":3.41313,
            "ColumnContentCell":[
                {
                    "Column":"单据号",
                    "FreeCell":true,
                    "Control":[
                        {
                            "Type":"StaticBox",
                            "Name":"StaticBox1",
                            "Left":0.396875,
                            "Top":0.211667,
                            "Width":8.20208,
                            "Height":2.98979
                        },
                        {
                            "Type":"Barcode",
                            "Name":"Barcode1",
                            "Left":0.211667,
                            "Top":0.396875,
                            "Width":4.39208,
                            "Height":2.59292,
                            "BarcodeType":"QRCode",
                            "Text":"[#条码编号#]"
                        }
                    ]
                }
            ]
        },
        "ColumnTitle":{
            "BackColor":"C0C0C0",
            "Height":0,
            "Font":{
                "Name":"宋体",
                "Size":90000,
                "Bold":true,
                "Charset":134
            },
            "RepeatStyle":"OnPage",
            "ColumnTitleCell":[
                {
                    "GroupTitle":false,
                    "Column":"单据号",
                    "BackColor":"FFFFFF",
                    "TextAlign":"MiddleCenter"
                }
            ]
        }
    },
    "ReportHeader":[
        {
            "Height":0
        }
    ]
}

 src/views/component/HSourceReportHtml/index.vue

@@ -2,13 +2,19 @@
    <div style="padding: 10px; position: relative;">
        <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" label-width="78px" class="searchBox">
            <el-form-item label="单据号" prop="HBillNo" style="margin-left: 100px">
                <el-input v-model="queryParams.HBillNo" placeholder="请输入单据号" @keyup.enter.native="handleQuery" />
                <el-input v-model="queryParams.HBillNo" placeholder="请输入单据号" style="width: 150px" />
            </el-form-item>
            <el-form-item label="部门">
            <el-form-item label="部门" label-width="48px">
                <el-select v-model="queryParams.HDeptName" placeholder="请选择" style="width: 150px">
                    <el-option v-for="(item, index) in HDeptList" :key="index" :label="item.HName"
                        :value="item.HName" />
                        :value="item.HItemID" />
                </el-select>
            </el-form-item>
            <el-form-item label="流转卡号" prop="HProcExchBillNo" v-if="HSouceBillType == '生产入库单'">
                <el-input v-model="queryParams.HProcExchBillNo" placeholder="请输入流转卡号" style="width: 150px" />
            </el-form-item>
            <el-form-item label="物料编码" prop="PartNumber">
                <el-input v-model="queryParams.PartNumber" placeholder="请输入物料编码" style="width: 150px" />
            </el-form-item>
            <el-form-item label-width="78px">
                <el-button type="primary" icon="el-icon-search" @click="handleQuery">
@@ -18,21 +24,33 @@
            <el-collapse v-model="activeSeach">
                <el-collapse-item title="更多" name="1">
                    <el-card class="box-card">
                        <el-form-item label="部门名称" prop="HDepartName">
                            <el-input v-model="queryParams.HDepartName" placeholder="请输入部门名称"
                                @keyup.enter.native="HDepartName" />
                        <el-form-item label="物料名称" prop="PartName">
                            <el-input v-model="queryParams.PartName" placeholder="请输入物料名称" />
                        </el-form-item>
                        <el-form-item label="物料代码" prop="HMaterNumber">
                            <el-input v-model="queryParams.HMaterNumber" placeholder="请输入物料代码"
                                @keyup.enter.native="handleQuery" />
                        <el-form-item label="状态" prop="HBillStatus">
                            <el-select v-model="queryParams.HBillStatus" placeholder="请选择">
                                <el-option label="计划" value="计划" />
                                <el-option label="计划确认" value="计划确认" />
                                <el-option label="下达" value="下达" />
                                <el-option label="开工" value="开工" />
                                <el-option label="完工" value="完工" />
                                <el-option label="结案" value="结案" />
                                <el-option label="结案" value="结算" />
                            </el-select>
                        </el-form-item>
                        <el-form-item label="物料名称" prop="HMaterName">
                            <el-input v-model="queryParams.HMaterName" placeholder="请输入物料名称"
                                @keyup.enter.native="handleQuery" />
                        <el-form-item label="领料状态" prop="HSPickMtrlStatus" v-if="HSouceBillType == '生产订单'">
                            <el-select v-model="queryParams.HSPickMtrlStatus" placeholder="请选择">
                                <el-option label="未领料" value="未领料" />
                                <el-option label="部分领料" value="部分领料" />
                                <el-option label="全部领料" value="全部领料" />
                                <el-option label="超额领料" value="超额领料" />
                            </el-select>
                        </el-form-item>
                        <el-form-item label="仓库" prop="HWHID">
                            <el-input v-model="queryParams.HWHID" placeholder="请输入仓库"
                                @keyup.enter.native="handleQuery" />
                        <el-form-item label="是否排产" prop="HIsScheduling" v-if="HSouceBillType == '生产订单'">
                            <el-select v-model="queryParams.HIsScheduling" placeholder="请选择">
                                <el-option label="已排产" value="已排产" />
                                <el-option label="未排产" value="未排产" />
                            </el-select>
                        </el-form-item>
                        <div slot="header" class="clearfix"><span>过滤</span></div>
                        <div>
@@ -54,8 +72,7 @@
                                            </el-select>
                                        </el-col>
                                        <el-col :span="11">
                                            <el-input v-model="queryParams.ColContent1" placeholder="请输入" clearable
                                                @keyup.enter.native="handleQuery" />
                                            <el-input v-model="queryParams.ColContent1" placeholder="请输入" clearable />
                                        </el-col>
                                    </el-row>
                                </el-form-item>
@@ -166,10 +183,12 @@
            queryParams: {
                HBillNo: "",
                HDeptName: '',
                HDepartName: "",
                HWHID: null,
                HMaterNumber: "",
                HMaterName: "",
                HProcExchBillNo: "",
                PartNumber: "",
                PartName: "",
                HBillStatus: '开工',
                HSPickMtrlStatus: "",
                HIsScheduling: "",
                ColName1: "",
                ColName2: "",
                ColName: "",
@@ -266,6 +285,17 @@
            if (this.pageSize == 0) {
                this.pageSize = 50;
            }
            if (this.queryParams.HBillStatus &&this.HSouceBillType == '生产订单') {
                this.sWhere += " and çŠ¶æ€ = '" + this.queryParams.HBillStatus + "'";
            }
            if (this.HSouceBillType == '生产订单') {
                this.queryParams.HIsScheduling = '已排产'
                if (sessionStorage["Organization"] == "九菱电机") {
                    if (this.queryParams.HIsScheduling) {
                        this.sWhere += this.queryParams.HIsScheduling == "未排产" ? "and æ˜¯å¦æŽ’产 = ''" : " and æ˜¯å¦æŽ’产 = '" + this.queryParams.HIsScheduling + "'"
                    }
                }
            }
            // åˆ—表
            axios.get(this.baseURL + "/Sc_BarCode/ReportFromBillList", {
                params: {
@@ -293,6 +323,10 @@
                            name: data1.list[key].ColmCols,
                            Type: data1.list[key].ColmType,
                        }); //从每个对象中提取数据
                        var patrn = new RegExp(/^h/i);
                        if (patrn.test(data1.list[key].ColmCols)) {
                            this.titleData[key] = data1.list[key].ColmCols;
                        }
                    }
                    //在列表左边添加勾选框
                    col.push({ type: "checkbox", fixed: "left", totalRowText: "合计" });
@@ -335,45 +369,45 @@
                    option.data = data1.data;
                    var result = data1.data;
                    option.data = result;
                     switch (this.HSouceBillType) {
                    case '生产订单':
                        this.HModName = "Sc_ICMOBill_3710";
                        break;
                    case '生产汇报单':
                        this.HModName = "Sc_ICMOReportBill_3711";
                        break;
                    case '采购订单':
                        this.HModName = "Cg_POOrderBill_1102";
                        break;
                    case '收料通知单':
                        this.HModName = "Cg_POInStockBill_1103";
                        break;
                    case '委外订单':
                        this.HModName = "WW_EntrustOrderBill_1601";
                        break;
                    case '生产入库单':
                        $("#HProcExchBillNoHidden").show();
                        this.HModName = "ProductInBill_1202";
                        break;
                    case '采购入库单':
                        this.HModName = "POStockInBill_1201";
                        break;
                    case '销售退货':
                        this.HModName = "SellOutBackBill_1247";
                        break;
                    case '生产退料':
                        this.HModName = "MateOutBackBill_1244";
                        break;
                    case '工序流转卡':
                        this.HModName = "ProcessExchangeBill_3772";
                        break;
                    case '销售出库单':
                        this.HModName = "SellOutBill_1205";
                        break;
                    case '领料出库单':
                        this.HModName = "MateOutBill_1204";
                        break;
                }
                    switch (this.HSouceBillType) {
                        case '生产订单':
                            this.HModName = "Sc_ICMOBill_3710";
                            break;
                        case '生产汇报单':
                            this.HModName = "Sc_ICMOReportBill_3711";
                            break;
                        case '采购订单':
                            this.HModName = "Cg_POOrderBill_1102";
                            break;
                        case '收料通知单':
                            this.HModName = "Cg_POInStockBill_1103";
                            break;
                        case '委外订单':
                            this.HModName = "WW_EntrustOrderBill_1601";
                            break;
                        case '生产入库单':
                            $("#HProcExchBillNoHidden").show();
                            this.HModName = "ProductInBill_1202";
                            break;
                        case '采购入库单':
                            this.HModName = "POStockInBill_1201";
                            break;
                        case '销售退货':
                            this.HModName = "SellOutBackBill_1247";
                            break;
                        case '生产退料':
                            this.HModName = "MateOutBackBill_1244";
                            break;
                        case '工序流转卡':
                            this.HModName = "ProcessExchangeBill_3772";
                            break;
                        case '销售出库单':
                            this.HModName = "SellOutBill_1205";
                            break;
                        case '领料出库单':
                            this.HModName = "MateOutBill_1204";
                            break;
                    }
                    this.DisPlay_HideColumn(this.HModName, sessionStorage["HUserName"], option, this.dataList);
                }
            }).catch((error) => {
@@ -640,17 +674,28 @@
            if (this.queryParams.HBillNo) {
                this.sWhere += " and å•æ®å· like '%" + this.queryParams.HBillNo + "%'";
            }
            if (this.queryParams.HDepartName) {
                this.sWhere += " and éƒ¨é—¨åç§° like '%" + this.queryParams.HDepartName + "%'";
            if (this.queryParams.HProcExchBillNo &&this.HSouceBillType == '生产入库单') {
                this.sWhere += " and æµè½¬å¡å· like '%" + this.queryParams.HProcExchBillNo + "%'";
            }
            if (this.queryParams.HWHID) {
                this.sWhere += " and ä»“库 like '%" + this.queryParams.HWHID + "%'";
            if (this.queryParams.HDeptName) {
                this.sWhere += " and HDeptID = '" + this.queryParams.HDeptName + "'";
            }
            if (this.queryParams.HMaterNumber) {
                this.sWhere += " and ç‰©æ–™ä»£ç  like '%" + this.queryParams.HMaterNumber + "%'";
            if (this.queryParams.PartNumber) {
                this.sWhere += " and ç‰©æ–™ä»£ç  like '%" + this.queryParams.PartNumber + "%'";
            }
            if (this.queryParams.HMaterName) {
                this.sWhere += " and ç‰©æ–™åç§° like '%" + this.queryParams.HMaterName + "%'";
            if (this.queryParams.PartName) {
                this.sWhere += " and ç‰©æ–™åç§° like '%" + this.queryParams.PartName + "%'";
            }
            if (this.queryParams.HBillStatus &&this.HSouceBillType == '生产订单') {
                this.sWhere += " and çŠ¶æ€ like '%" + this.queryParams.HBillStatus + "%'";
            }
            if (sessionStorage["Organization"] == "九菱电机" && this.HSouceBillType == '生产订单') {
                if (this.queryParams.HIsScheduling) {
                    this.sWhere += " and é¢†æ–™çŠ¶æ€ like '%" + this.queryParams.HIsScheduling + "%'";
                }
                if (this.queryParams.HIsScheduling) {
                    this.sWhere += this.queryParams.HIsScheduling == "未排产" ? "and æ˜¯å¦æŽ’产 = ''" : " and æ˜¯å¦æŽ’产 = '" + this.queryParams.HIsScheduling + "'"
                }
            }
            this.getList();
        },

 src/views/warehouse/barcodeMaster/Gy_BarCodeBill.vue

@@ -225,7 +225,7 @@
                </el-tab-pane>
                <el-tab-pane label="条码信息" name="tiaoma">
                    <el-table :data="editTmData" style="width: 100%" height="480" width="100%" ref="tbzbTable"
                        @selection-change="handleTableWlxxZbEdit" :row-class-name="tiaomaZbIndex" border>
                        @selection-change="handleTableWlxxZbEdit" :row-class-name="tiaomaZbIndex" border v-if="editTmData.length>0">
                        <el-table-column align="center" label="序号" type="index" width="80" fixed />
                        <template v-for="(item, index) in tmBtList">
                            <el-table-column align="center" :prop="item.field" :label="item.title" :width="item.width"
@@ -235,7 +235,7 @@
                </el-tab-pane>
                <el-tab-pane label="档案列表" name="dangan">
                    <el-table :data="editDaData" style="width: 100%" height="480" width="100%" ref="dazbTable"
                        @selection-change="handleTableDangan" :row-class-name="danganZbIndex" border>
                        @selection-change="handleTableDangan" :row-class-name="danganZbIndex" border v-if="editDaData.length>0">
                        <el-table-column type="selection" width="55" align="center" />
                        <el-table-column align="center" label="序号" type="index" width="80" fixed />
                        <template v-for="(item, index) in daBtList">
@@ -251,7 +251,7 @@
            </el-tabs>
        </el-form>
        <!-- éƒ¨é—¨å¼¹çª— -->
        <el-dialog :title="dialogTitle" :visible.sync="openData" width="1280px" append-to-body>
        <el-dialog :title="dialogTitle" :visible.sync="openData" width="1280px" append-to-body @close="closeBill">
            <HSourceReportHtml @deptEmitDb="dbEmitData" @deptEmit="emitData" :openPage="HModName"
                :HOrgID='this.form.HOrgID' :HSouceBillType="HSouceBillType" v-if="ScICMOBillShow" />
            <div slot="footer" class="dialog-footer">
@@ -521,6 +521,9 @@
        this.getdata()
    },
    methods: {
        closeBill(){
            this.ScICMOBillShow=false
        },
        get_PrintReport() {
            if (this.danganSelList.length == 0) {
                this.$modal.msgError("请选择数据");