添加生产订单追溯码打印

wtt

2024-10-22 121384e3358b185247985fe3ecc18c0e3ac07968

添加生产订单追溯码打印

 WebTM/Vlog/webapi20241022.txt

New file
@@ -0,0 +1,11 @@
2024/10/22 14:41:35 æ‰“印sql:select * from h_v_IF_ICMOBillList where hmainid in(1118)

2024/10/22 14:41:36 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;

2024/10/22 14:41:36 ReportDataSet:1

2024/10/22 14:50:46 æ‰“印sql:select * from h_v_IF_ICMOBillList where hmainid in(1111)

2024/10/22 14:50:46 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;

2024/10/22 14:50:46 ReportDataSet:1

 WebTM/WebTM.csproj

@@ -381,6 +381,7 @@
    <Content Include="views\基础资料\公用基础资料\xmlLBM_HPOInStockBillByID.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_HSeOutStockBillListByID.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Kf_SellOutBillListByID.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillListTK.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOReportBillList2.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOReportBillList.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_QC_TakeSampleCheckBillMainList.aspx" />
@@ -2356,6 +2357,13 @@
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Pay_WorkTimesBillList.aspx.designer.cs">
      <DependentUpon>xmlLBM_Pay_WorkTimesBillList.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillListTK.aspx.cs">
      <DependentUpon>xmlLBM_Sc_ICMOBillListTK.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillListTK.aspx.designer.cs">
      <DependentUpon>xmlLBM_Sc_ICMOBillListTK.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOReportBillList2.aspx.cs">
      <DependentUpon>xmlLBM_Sc_ICMOReportBillList2.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

 WebTM/WebTM.csproj.user

@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\智云迈思\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>C:\Users\86130\Desktop\智云迈思\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ProjectFiles</ProjectView>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>

 WebTM/views/grf/×·ËÝÂë.grf

New file
@@ -0,0 +1,110 @@
{
    "Version":"6.8.2.5",
    "Font":{
        "Name":"宋体",
        "Size":105000,
        "Weight":400,
        "Charset":134
    },
    "Printer":{
        "Size":256,
        "Width":3,
        "Height":2,
        "Oriention":"Landscape",
        "LeftMargin":0,
        "TopMargin":0,
        "RightMargin":0,
        "BottomMargin":0
    },
    "DetailGrid":{
        "Recordset":{
            "Field":[
                {
                    "Name":"单据号"
                }
            ]
        },
        "Column":[
            {
                "Name":"Column1",
                "Width":1.98438
            }
        ],
        "ColumnContent":{
            "Height":2.01083,
            "ColumnContentCell":[
                {
                    "Column":"Column1",
                    "FreeCell":true,
                    "Control":[
                        {
                            "Type":"Barcode",
                            "Name":"Barcode2",
                            "Anchor":"[]",
                            "Dock":"Top",
                            "Center":"Horizontal",
                            "Height":1.37583,
                            "Border":{
                                "Styles":"[DrawBottom]"
                            },
                            "BarcodeType":"QRCode",
                            "Text":"[#单据号#]",
                            "Font":{
                                "Name":"宋体",
                                "Size":75000,
                                "Weight":400,
                                "Charset":134
                            }
                        },
                        {
                            "Type":"StaticBox",
                            "Name":"StaticBox1",
                            "Center":"Horizontal",
                            "Top":1.40229,
                            "Width":1.95792,
                            "Height":0.396875,
                            "Font":{
                                "Name":"宋体",
                                "Size":75000,
                                "Bold":true,
                                "Charset":134
                            },
                            "TextAlign":"MiddleCenter",
                            "Text":"追溯码"
                        }
                    ]
                }
            ]
        },
        "ColumnTitle":{
            "Height":0.608542,
            "ColumnTitleCell":[
                {
                    "GroupTitle":false,
                    "Column":"Column1",
                    "Font":{
                        "Name":"宋体",
                        "Size":67500,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"添康科技",
                    "BorderCustom":true,
                    "Border":{
                        "Styles":"[DrawLeft|DrawTop|DrawRight|DrawBottom]"
                    }
                }
            ]
        }
    },
    "PageHeader":{
        "Height":0.608542
    },
    "Parameter":[
        {
            "Name":"单据号",
            "Value":"[#单据号#]"
        }
    ]
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/HBarPlanPrint.html

@@ -158,6 +158,9 @@
            case "HIcmoBill"://生产订单打印
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ICMOBillList.aspx?linterid=" + value, true, "");
                break;
            case "HIcmoBillTK"://生产订单打印追溯码
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ICMOBillListTK.aspx?linterid=" + value, true, "");
                break;
            case "HPOOrderBill"://采购订单打印
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPOOrderBill.aspx?linterid=" + value, true, "");
                break;

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_ICMOBillListTK.aspx

New file
@@ -0,0 +1,29 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Sc_ICMOBillListTK.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Sc_ICMOBillListTK" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <script runat="server"> 
        protected void Page_Load(object sender, EventArgs e)
        {
            //★特别提示★：
            //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
            //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

            //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
            //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781");
            
            SqlXMLReportData.GenOneRecordset(this, "select * from h_v_IF_ICMOBillList where hmainid in(" + Request.Params["linterid"] + ")");
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
        </div>
    </form>
</body>
</html>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_ICMOBillListTK.aspx.cs

New file
@@ -0,0 +1,17 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebTM.views.基础资料.公用基础资料
{
    public partial class xmlLBM_Sc_ICMOBillListTK : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_ICMOBillListTK.aspx.designer.cs

New file
@@ -0,0 +1,26 @@
//------------------------------------------------------------------------------
// <自动生成>
//     æ­¤ä»£ç ç”±å·¥å…·ç”Ÿæˆã€‚
//
//     å¯¹æ­¤æ–‡ä»¶çš„更改可能导致不正确的行为，如果
//     é‡æ–°ç”Ÿæˆä»£ç ï¼Œåˆ™æ‰€åšæ›´æ”¹å°†ä¸¢å¤±ã€‚
// </自动生成>
//------------------------------------------------------------------------------

namespace WebTM.views.基础资料.公用基础资料
{


    public partial class xmlLBM_Sc_ICMOBillListTK
    {

        /// <summary>
        /// form1 æŽ§ä»¶ã€‚
        /// </summary>
        /// <remarks>
        /// è‡ªåŠ¨ç”Ÿæˆçš„字段。
        /// è‹¥è¦è¿›è¡Œä¿®æ”¹ï¼Œè¯·å°†å­—段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlForm form1;
    }
}

 WebTM/views/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillList.html

@@ -293,9 +293,9 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushProductionReturnBill" id="btn-PushProductionReturnBill"><i class="layui-icon layui-icon-delete"></i>下推(生产退库单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushWorkLinkBill" id="btn-PushWorkLinkBill"><i class="layui-icon layui-icon-delete"></i>联系单</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_AddNew" id="AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Edit" id="Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_copy" id="copy"><i class="layui-icon layui-icon-form"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_AddNew_NT" id="AddNew_NT"><i class="layui-icon layui-icon-file-b"></i>新增(无列表)</button>-->
    <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Edit" id="Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
    <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_copy" id="copy"><i class="layui-icon layui-icon-form"></i>复制</button>
    <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_AddNew_NT" id="AddNew_NT"><i class="layui-icon layui-icon-file-b"></i>新增(无列表)</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Edit_NT" id="Edit_NT"><i class="layui-icon layui-icon-form"></i>编辑(无列表)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_copy_NT" id="copy_NT"><i class="layui-icon layui-icon-form"></i>复制(无列表)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
@@ -308,6 +308,7 @@
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Excel" id="Excel"><i class="layui-icon layui-icon-file-b"></i>Excel导入</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get-view" id="view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get-print" id="print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get-printTK" id="printTK"><i class="layui-icon layui-icon-print"></i>打印追溯码</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_export" id="export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-FirstPieceCheck" id="btn-FirstPieceCheck">首检</button>
@@ -515,6 +516,8 @@
                    case 'get-view': get_ViewReport();
                        break;
                    case 'get-print': get_PrintReport();
                        break
                    case 'get-printTK': get_PrintReportTK();//打印追溯码
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -2260,8 +2263,19 @@
                    layer.msg('请选择至少一行数据打印！');
                }
            }


            //tk打印追溯码
            function get_PrintReportTK() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                var hmainid = "";
                if (checkStatus.data.length == 1) {
                    hmainid = data[0].hmainid
                    window.open("../../基础资料/公用基础资料/HBarPlanPrint.html?linterid=" + hmainid.toString() + "&Type=HIcmoBillTK" +"&OpenTmp=追溯码");
                }
                else {
                    layer.msg('请选择一行数据打印！');
                }
            }