生产订单打印

zzr99

2022-04-07 b8390ccbc4b35c4fedb02cc4c0bcc4879a49028f

生产订单打印

 WebTM/WebTM.csproj

@@ -188,6 +188,7 @@
    <Content Include="views\grf\器具档案.grf" />
    <Content Include="views\grf\销售退货单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\物料条码.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\生产单.grf" />
    <None Include="Web.Debug.config">
      <DependentUpon>Web.config</DependentUpon>
    </None>
@@ -619,6 +620,7 @@
    <Content Include="views\基础资料\公用基础资料\xmlLBM_MouldProdMoveStockBill.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_MouldProdOutStockBill.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_MouldTypeBill.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillList.aspx" />
    <Content Include="views\基础资料\基础资料\Gy_ConkReasonEdit.html" />
    <Content Include="views\基础资料\基础资料\Gy_ConkReasonList.html" />
    <Content Include="views\基础资料\基础资料\Gy_DotCheckEdit.html" />
@@ -1210,6 +1212,13 @@
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_MouldTypeBill.aspx.designer.cs">
      <DependentUpon>xmlLBM_MouldTypeBill.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillList.aspx.cs">
      <DependentUpon>xmlLBM_Sc_ICMOBillList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Sc_ICMOBillList.aspx.designer.cs">
      <DependentUpon>xmlLBM_Sc_ICMOBillList.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\生产工序管理\工序汇报单\xmlLBM_ProcessReport.aspx.cs">
      <DependentUpon>xmlLBM_ProcessReport.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

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

@@ -149,6 +149,8 @@
                break;
            case "HGy_BarCodeBill"://条码打印
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HGy_BarCodeBill.aspx?linterid=" + value, true, "");
            case "HIcmoBill"://生产订单打印
                CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ICMOBillList.aspx?linterid=" + value, true, "");
                break;
           
        }

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Éú²úµ¥.grf

New file
@@ -0,0 +1,405 @@
Object Report
    Version='6.8.2.5'
    Object Font
        Name='宋体'
        Size=105000,0
        Weight=400
        Charset=134
    End
    Object Printer
        Oriention=Landscape
        LeftMargin=1.5
        TopMargin=0.5
        RightMargin=1.5
        BottomMargin=0.5
    End
    Object DetailGrid
        Object Recordset
            Items Field
                Item
                    Name='日期'
                End
                Item
                    Name='单据编号'
                End
                Item
                    Name='销售物料名称'
                End
                Item
                    Name='包装方式'
                End
                Item
                    Name='销售数量'
                End
                Item
                    Name='购货单位'
                End
                Item
                    Name='收货方联系人'
                End
                    End
    End
    Items Column
        Item
            Name='序号'
            Width=0.767292
        End
        Item
            Name='计划跟踪单号'
            Width=2.80458
        End
        Item
            Name='物料代码'
            Width=3.99521
        End
        Item
            Name='物料'
            Width=3.41313
        End
        Item
            Name='规格型号'
            Width=3.41313
        End
        Item
            Name='Column2'
            Width=2.61938
        End
        Item
            Name='Column6'
            Width=2.93688
        End
        Item
            Name='Column7'
            Width=2.59292
        End
        Item
            Name='Column8'
            Width=2.19604
        End
        Item
            Name='Column9'
            Width=2.77813
        End
    End
Object ColumnContent
    Height=2.59292
    Items ColumnContentCell
        Item
            Column='序号'
            FreeCell=T
            Items Control
                Item
                    Type=SystemVarBox
                    Name='SystemVarBox1'
                    Dock=Fill
                    Object Font
                        Name='宋体'
                        Weight=400
                        Charset=134
                    End
                    TextAlign=MiddleCenter
                    SystemVar=RowNo
                End
                    End
    End
    Item
        Column='计划跟踪单号'
        Object Font
            Name='宋体'
            Weight=400
            Charset=134
        End
        WordWrap=T
        ShrinkFontToFit=T
        DataField='日期'
    End
    Item
        Column='物料代码'
        Object Font
            Name='宋体'
            Weight=400
            Charset=134
        End
        WordWrap=T
        ShrinkFontToFit=T
        DataField='单据编号'
    End
    Item
        Column='物料'
        Object Font
            Name='宋体'
            Weight=400
            Charset=134
        End
        WordWrap=T
        ShrinkFontToFit=T
        DataField='销售物料名称'
    End
    Item
        Column='规格型号'
        Object Font
            Name='宋体'
            Weight=400
            Charset=134
        End
        WordWrap=T
        ShrinkFontToFit=T
        DataField='包装方式'
    End
    Item
        Column='Column2'
        FreeCell=T
        Items Control
            Item
                Type=FieldBox
                Name='FieldBox1'
                Dock=Fill
                Object Font
                    Name='宋体'
                    Weight=400
                    Charset=134
                End
                TextAlign=MiddleCenter
                DataField='销售数量'
            End
            End
End
Item
    Column='Column6'
    Object Font
        Name='宋体'
        Weight=400
        Charset=134
    End
    FreeCell=T
    Items Control
        Item
            Type=FieldBox
            Name='FieldBox2'
            Dock=Fill
            DataField='收货方联系人'
        End
    End
End
Item
    Column='Column7'
    Object Font
        Name='宋体'
        Weight=400
        Charset=134
    End
    FreeCell=T
    Items Control
        Item
            Type=Barcode
            Name='Barcode3'
            Left=22.1985
            Top=0.105833
            Width=2.75167
            Height=1.79917
            BarcodeType=QRCode
            CaptionPosition=None
            Text='[#单据编号#]'
        End
        Item
            Type=Barcode
            Name='Barcode4'
            Left=0.185208
            Top=0.343958
            Width=2.19604
            Height=1.98438
            BarcodeType=QRCode
            CaptionPosition=None
            Text='[#单据编号#]'
        End
    End
End
Item
    Column='Column8'
    Object Font
        Name='宋体'
        Weight=400
        Charset=134
    End
    FreeCell=T
End
Item
    Column='Column9'
    TextAlign=MiddleCenter
End
End
End
Object ColumnTitle
    Height=1.00542
    RepeatStyle=OnPage
    Items ColumnTitleCell
        Item
            GroupTitle=F
            Column='序号'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            TextAlign=MiddleCenter
            Text='序号'
        End
        Item
            GroupTitle=F
            Column='计划跟踪单号'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            TextAlign=MiddleCenter
            Text='日期'
        End
        Item
            GroupTitle=F
            Column='物料代码'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='单据编号'
        End
        Item
            GroupTitle=F
            Column='物料'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='销售物料名称'
        End
        Item
            GroupTitle=F
            Column='规格型号'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='包装方式'
        End
        Item
            GroupTitle=F
            Column='Column2'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='销售数量'
        End
        Item
            GroupTitle=F
            Column='Column6'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='收货方联系人'
        End
        Item
            GroupTitle=F
            Column='Column7'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='（二维码）'
        End
        Item
            GroupTitle=F
            Column='Column8'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            WordWrap=T
            TextAlign=MiddleCenter
            Text='已生产'
        End
        Item
            GroupTitle=F
            Column='Column9'
            Object Font
                Name='宋体'
                Weight=400
                Charset=134
            End
            TextAlign=MiddleCenter
            Text='备注'
        End
    End
End
Items Group
    Item
        Name='Group1'
        Object GroupHeader
            Height=0
            RepeatOnPage=T
            NewPageColumn=Before
        End
        Object GroupFooter
            Height=0
            RepeatOnPage=T
        End
    End
End
End
Items ReportHeader
    Item
        Name='ReportHeader1'
        Height=1.79917
        Items Control
            Item
                Type=MemoBox
                Name='MemoBox3'
                Left=7.64646
                Top=0.502708
                Width=11.6152
                Height=0.873125
                Object Border
                    Styles=[DrawBottom]
                End
                Object Font
                    Name='宋体'
                    Size=180000,0
                    Bold=T
                    Charset=134
                End
                TextAlign=TopCenter
                Text='生    äº§    å•\r\n'
            End
            End
    RepeatOnPage=T
End
End
Items ReportFooter
    Item
        Name='ReportFooter1'
        Height=0.211667
        RepeatOnPage=T
    End
End
End

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

@@ -4,20 +4,20 @@

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <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例子数据库中获取报表数据
        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_Gy_EquipFileMainList where hmainid=" + Request.Params["linterid"]);
    }
</script>
            //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_Gy_EquipFileMainList where hmainid=" + Request.Params["linterid"]);
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">

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

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

<!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 a.HDate æ—¥æœŸ,a.HBillNo å•æ®ç¼–号,M.HName é”€å”®ç‰©æ–™åç§°,c.HName æ”¶è´§æ–¹è”系人,a.HBZFS åŒ…装方式,a.HQty é”€å”®æ•°é‡,u.HName è´­è´§å•ä½ from Sc_ICMOBillMain a left join Gy_Material m on a.HMaterID=m.HItemID left join Gy_Customer c on a.HCusID=c.HItemID left join Gy_Unit u on a.HUnitID=u.HItemID where a.HUnitID=" + Request.Params["linterid"]);
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
        </div>
    </form>
</body>
</html>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_Sc_ICMOBillList.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_ICMOBillList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}

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

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

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


    public partial class xmlLBM_Sc_ICMOBillList
    {

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

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

@@ -81,6 +81,8 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>下推</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
@@ -127,6 +129,10 @@
                        break;
                    //删除
                    case 'set_DeleteBill': set_DeleteBill();
                        break;
                    case 'get-view': get_ViewReport();
                        break;
                    case 'get-print': get_PrintReport();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -405,12 +411,7 @@
                });
            }
            //#endregion
            //laydate.render({
            //    elem: '#HDate'
            //    , type: 'datetime'
            //    , trigger: 'click'
            //    , format:'yyyy-MM-dd HH:mm'
            //});
           
            //#region åˆ·æ–°
            function get_Refresh() {
                set_ClearQuery();
@@ -418,6 +419,50 @@
            }
            //#endregion

            //#region æ‰“印
            //预览
            function get_ViewReport() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    layer.open({
                        type: 2
                        , area: ['50%', '50%']
                        , title: '打印模版选择'
                        , shade: 0.6 //遮罩透明度
                        , maxmin: false //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HIcmoBill', 'yes']
                        , resize: false
                    })
                }
                else {
                    layer.msg('请选择一行数据打印！');
                }
            }

            //打印
            function get_PrintReport() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    layer.open({
                        type: 2
                        , area: ['50%', '50%']
                        , title: '打印模版选择'
                        , shade: 0.6 //遮罩透明度
                        , maxmin: false //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HIcmoBill', 'yes']
                        , resize: false
                    })
                }
                else {
                    layer.msg('请选择一行数据打印！');
                }
            }

            //#endregion
            //以上是layui模块
        });


 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Sc_StationInBillList.html

@@ -485,6 +485,7 @@
                $("#HEndDate").val("");
                $("#HICMOBillNo").val("");
                $("#HProcExchBillNo").val("");
                $("#HName").val("");
                sWhere = " where 1 = 1 ";
                get_Display(sWhere);
            }