仓位打印；条码档案左右包含查询修复；关键件绑定点换产品按钮及保存上一产品绑定记录；流转卡批量打印；发货通知单报错修复

yusijie

2024-09-24 6c08da9c29f9ce7f0ebf36aa118606c3f0697bdd

仓位打印；条码档案左右包含查询修复；关键件绑定点换产品按钮及保存上一产品绑定记录；流转卡批量打印；发货通知单报错修复

 WebTM/App_Data/MssqlReportData.cs

@@ -31,6 +31,7 @@
    //public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//凯贝奈特
    //public const string SqlConnStr = "Data Source=192.168.0.199;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//瑞琪
    //public const string SqlConnStr = "Data Source=192.168.2.10;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//九菱电机
    //public const string SqlConnStr = "Data Source=192.168.1.8;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//添康科技

    //public string sServer;
    //public string sDataBase;

 WebTM/WebTM.csproj

@@ -362,6 +362,7 @@
    <Content Include="views\基础资料\公用基础资料\Gy_PreventErrMould.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_WorkCenter_Excel.html" />
    <Content Include="views\基础资料\公用基础资料\Gy_UnitConvertRateList.html" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_Gy_StockPlaceList.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_HPayMentBill.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_HPOOrderBillByID.aspx" />
    <Content Include="views\基础资料\公用基础资料\xmlLBM_HPOStockInBillByID.aspx" />
@@ -529,6 +530,7 @@
    <Content Include="views\车间管理\产线\Sc_ProcessReportList_Last.html" />
    <Content Include="views\车间管理\产线\Sc_StationInBillList.html" />
    <Content Include="views\车间管理\产线\test.html" />
    <Content Include="views\车间管理\关键件绑定\Sc_KeyElementBinding.html" />
    <Content Include="views\车间管理\单品过站\SingleItemTransitList.html" />
    <Content Include="views\车间管理\启动点检单\Sc_WorkBeginDotCheckBill.html" />
    <Content Include="views\车间管理\启动点检单\Sc_WorkBeginDotCheckBillList.html" />
@@ -1103,6 +1105,7 @@
    <Content Include="views\grf\送货单%28标签纸%29.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>
@@ -2225,6 +2228,13 @@
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_EquipTypeBill.aspx.designer.cs">
      <DependentUpon>xmlLBM_EquipTypeBill.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Gy_StockPlaceList.aspx.cs">
      <DependentUpon>xmlLBM_Gy_StockPlaceList.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_Gy_StockPlaceList.aspx.designer.cs">
      <DependentUpon>xmlLBM_Gy_StockPlaceList.aspx</DependentUpon>
    </Compile>
    <Compile Include="views\基础资料\公用基础资料\xmlLBM_HGy_CardChangeType.aspx.cs">
      <DependentUpon>xmlLBM_HGy_CardChangeType.aspx</DependentUpon>
      <SubType>ASPXCodeBehind</SubType>

 WebTM/layuiadmin/PageTitle.js

@@ -5,7 +5,7 @@
    $.ajax({
        type: "GET",
        async: false,
        url: GetWEBURL() + "Web/GetModuleName", //方法所在页面和方法名
        url: GetWEBURL() + "/Web/GetModuleName", //方法所在页面和方法名
        data: { "HModuleType": HModuleType },
        success: function (result) {
            if (result.count == 1) {

 WebTM/views/grf/Á÷ת¿¨JSON.grf

New file
@@ -0,0 +1,662 @@
{
    "Version":"6.8.2.5",
    "Font":{
        "Name":"宋体",
        "Size":105000,
        "Weight":400,
        "Charset":134
    },
    "Printer":{
        "Size":11,
        "Width":14.8,
        "Height":21,
        "Oriention":"Landscape",
        "LeftMargin":1.5,
        "TopMargin":1.5,
        "RightMargin":1.5,
        "BottomMargin":1.5
    },
    "DetailGrid":{
        "Recordset":{
            "Field":[
                {
                    "Name":"单据号"
                },
                {
                    "Name":"日期",
                    "Type":"DateTime",
                    "Format":"yyyy/MM/dd"
                },
                {
                    "Name":"生产订单号"
                },
                {
                    "Name":"派工单号"
                },
                {
                    "Name":"生产车间"
                },
                {
                    "Name":"产品代码"
                },
                {
                    "Name":"产品名称"
                },
                {
                    "Name":"规格型号"
                },
                {
                    "Name":"流转卡数量"
                },
                {
                    "Name":"卡数量"
                },
                {
                    "Name":"批号"
                },
                {
                    "Name":"流水号"
                },
                {
                    "Name":"工序代码"
                },
                {
                    "Name":"工序名称"
                },
                {
                    "Name":"班组"
                },
                {
                    "Name":"机台"
                },
                {
                    "Name":"实作数量"
                },
                {
                    "Name":"工序说明"
                },
                {
                    "Name":"班号"
                },
                {
                    "Name":"工段名称"
                },
                {
                    "Name":"工艺工作中心"
                },
                {
                    "Name":"工艺工艺参数"
                }
            ]
        },
        "Column":[
            {
                "Name":"Column14",
                "Width":1.16417
            },
            {
                "Name":"Column1",
                "Width":2.01083
            },
            {
                "Name":"Column2",
                "Width":2.40771
            },
            {
                "Name":"Column16",
                "Width":2.19604
            },
            {
                "Name":"Column3",
                "Width":1.19063
            },
            {
                "Name":"Column8",
                "Width":2.59292
            },
            {
                "Name":"Column9",
                "Width":1.19063
            },
            {
                "Name":"Column12",
                "Width":3.22792
            },
            {
                "Name":"Column15",
                "Width":1.98438
            }
        ],
        "ColumnContent":{
            "Height":1.19063,
            "AdjustRowHeight":false,
            "RowsPerPage":6,
            "ColumnContentCell":[
                {
                    "Column":"Column14",
                    "FreeCell":true,
                    "Control":[
                        {
                            "Type":"SystemVarBox",
                            "Name":"SystemVarBox3",
                            "Left":0.5,
                            "Top":-0.8,
                            "Width":1.5875,
                            "Height":0.608542,
                            "SystemVar":"RowNo"
                        },
                        {
                            "Type":"FieldBox",
                            "Name":"FieldBox14",
                            "Dock":"Fill",
                            "DataField":"流水号"
                        }
                    ]
                },
                {
                    "Column":"Column1",
                    "DataField":"工序代码"
                },
                {
                    "Column":"Column2",
                    "CanGrow":true,
                    "CanShrink":true,
                    "ShrinkFontToFit":true,
                    "DataField":"工序名称"
                },
                {
                    "Column":"Column16",
                    "DataField":"工段名称"
                },
                {
                    "Column":"Column3",
                    "DataField":"班组"
                },
                {
                    "Column":"Column8",
                    "WordWrap":true,
                    "DataField":"工艺工作中心"
                },
                {
                    "Column":"Column9",
                    "WordWrap":true,
                    "ShrinkFontToFit":true,
                    "DataField":"实作数量"
                },
                {
                    "Column":"Column12",
                    "DataField":"工艺工艺参数"
                },
                {
                    "Column":"Column15",
                    "DataField":"班号"
                }
            ]
        },
        "ColumnTitle":{
            "Height":1.19063,
            "RepeatStyle":"OnPage",
            "ColumnTitleCell":[
                {
                    "GroupTitle":false,
                    "Column":"Column14",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"工序号"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column1",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"工序代码"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column2",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"工序名称"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column16",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"工段名称"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column3",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"班组"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column8",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"机台"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column9",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"实作数量"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column12",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"工序说明"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column15",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"班号"
                }
            ]
        }
    },
    "Parameter":[
        {
            "Name":"页码"
        }
    ],
    "ReportHeader":[
        {
            "Name":"ReportHeader1",
            "CanGrow":true,
            "CanShrink":true,
            "Height":4.60375,
            "Font":{
                "Name":"宋体",
                "Size":105000,
                "Bold":true,
                "Charset":134
            },
            "Control":[
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox1",
                    "Center":"Horizontal",
                    "Left":7.96396,
                    "Width":2.06375,
                    "Height":0.687917,
                    "Font":{
                        "Name":"宋体",
                        "Size":180000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"流转卡"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox3",
                    "Left":10.6098,
                    "Top":2.19604,
                    "Width":2.61938,
                    "Height":0.608542,
                    "Text":"生产车间"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox4",
                    "Left":4.39208,
                    "Top":1.00542,
                    "Width":2.98979,
                    "Height":0.608542,
                    "TextAlign":"MiddleCenter",
                    "Text":"QC检查方式："
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox8",
                    "Left":5.3975,
                    "Top":2.19604,
                    "Width":1.40229,
                    "Height":0.608542,
                    "Text":"日期："
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox1",
                    "Left":12.1973,
                    "Top":2.19604,
                    "Width":3.99521,
                    "Height":0.608542,
                    "DataField":"生产车间"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox6",
                    "Left":6.40292,
                    "Top":2.19604,
                    "Width":3.78354,
                    "Height":0.608542,
                    "DataField":"日期"
                },
                {
                    "Type":"SystemVarBox",
                    "Name":"SystemVarBox1",
                    "Left":15.6104,
                    "Top":1.40229,
                    "Width":1.79917,
                    "Height":0.423333,
                    "Format":"共0页",
                    "SystemVar":"PageCount"
                },
                {
                    "Type":"SystemVarBox",
                    "Name":"SystemVarBox2",
                    "Left":14.3933,
                    "Top":1.40229,
                    "Width":1.21708,
                    "Height":0.423333,
                    "Format":"第0页"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox18",
                    "Left":0.211667,
                    "Top":2.98979,
                    "Width":2.61938,
                    "Height":0.608542,
                    "Text":"产品代码："
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox19",
                    "Left":0.211667,
                    "Top":2.19604,
                    "Width":2.80458,
                    "Height":0.582083,
                    "Text":"派工单"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox9",
                    "Left":1.5875,
                    "Top":2.19604,
                    "Width":3.20146,
                    "Height":0.582083,
                    "DataField":"派工单号"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox10",
                    "Left":1.79917,
                    "Top":2.98979,
                    "Width":2.80458,
                    "Height":0.608542,
                    "DataField":"产品代码"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox21",
                    "Left":10.6098,
                    "Top":3.81,
                    "Width":2.80458,
                    "Height":0.582083,
                    "Text":"批次："
                },
                {
                    "Type":"Barcode",
                    "Name":"Barcode1",
                    "Left":12.2502,
                    "Top":0.899583,
                    "Width":1.98438,
                    "Height":1.21708,
                    "BarcodeType":"QRCode",
                    "CaptionPosition":"None",
                    "CaptionAlignment":"Far",
                    "CheckSum":true,
                    "Text":"[#单据号#]"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox11",
                    "Left":11.8004,
                    "Top":3.81,
                    "Width":4.60375,
                    "Height":0.582083,
                    "DataField":"批号"
                },
                {
                    "Type":"Barcode",
                    "Name":"Barcode2",
                    "Left":0.211667,
                    "Top":0.608542,
                    "Width":2.59292,
                    "Height":1.40229,
                    "BarcodeType":"QRCode",
                    "CaptionPosition":"None",
                    "Text":"[#生产订单号#]"
                },
                {
                    "Type":"StaticBox",
                    "Name":"StaticBox1",
                    "Left":12.0121,
                    "Top":0.211667,
                    "Width":1.79917,
                    "Height":0.582083,
                    "Text":"流转卡号"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox13",
                    "Left":13.8113,
                    "Top":0.211667,
                    "Width":4.20688,
                    "Height":0.582083,
                    "DataField":"单据号"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox24",
                    "Left":0.211667,
                    "Width":5.79438,
                    "Height":0.582083,
                    "Text":"任务单号：[#生产订单号#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox25",
                    "Left":7.19667,
                    "Top":1.00542,
                    "Width":1.19063,
                    "Height":0.608542,
                    "Font":{
                        "Name":"宋体",
                        "Size":90000,
                        "Bold":true,
                        "Charset":134
                    },
                    "Text":"抽检"
                },
                {
                    "Type":"ShapeBox",
                    "Name":"ShapeBox1",
                    "Left":8.38729,
                    "Top":1.00542,
                    "Width":0.608542,
                    "Height":0.582083
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox26",
                    "Left":9.2075,
                    "Top":1.00542,
                    "Width":1.40229,
                    "Height":0.608542,
                    "Font":{
                        "Name":"宋体",
                        "Size":90000,
                        "Bold":true,
                        "Charset":134
                    },
                    "Text":"抽检"
                },
                {
                    "Type":"ShapeBox",
                    "Name":"ShapeBox2",
                    "Left":10.2129,
                    "Top":1.00542,
                    "Width":0.79375,
                    "Height":0.582083
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox27",
                    "Left":5.3975,
                    "Top":2.98979,
                    "Width":4.60375,
                    "Height":0.608542,
                    "Text":"产品名称：[#产品名称#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox28",
                    "Left":10.6098,
                    "Top":2.98979,
                    "Width":6.21771,
                    "Height":0.608542,
                    "Text":"规格型号：[#规格型号#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox29",
                    "Left":0.211667,
                    "Top":3.81,
                    "Width":5.18583,
                    "Height":0.608542,
                    "Text":"生产数量：[#流转卡数量#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox30",
                    "Left":5.3975,
                    "Top":3.81,
                    "Width":3.99521,
                    "Height":0.608542,
                    "Text":"卡数量：[#流转卡数量#]"
                }
            ],
            "RepeatOnPage":true
        }
    ],
    "ReportFooter":[
        {
            "Name":"ReportFooter1",
            "Height":2.01083,
            "Control":[
                {
                    "Type":"FreeGrid",
                    "Name":"FreeGrid1",
                    "Dock":"Left",
                    "Border":{
                        "Styles":"[DrawLeft|DrawRight|DrawBottom]"
                    },
                    "ColumnCount":7,
                    "RowCount":2,
                    "FreeGridColumn":[
                        {
                            "index":1,
                            "Width":3.175
                        },
                        {
                            "index":2,
                            "Width":2.38125
                        },
                        {
                            "index":3,
                            "Width":2.2225
                        },
                        {
                            "index":4,
                            "Width":1.16417
                        },
                        {
                            "index":5,
                            "Width":2.61938
                        },
                        {
                            "index":6,
                            "Width":1.19063
                        },
                        {
                            "index":7,
                            "Width":5.2123
                        }
                    ],
                    "FreeGridRow":[
                    ],
                    "FreeGridCell":[
                        {
                            "row":1,
                            "col":1,
                            "Text":"入库记录"
                        },
                        {
                            "row":2,
                            "col":1,
                            "Text":"领用记录"
                        }
                    ]
                }
            ]
        }
    ]
}

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

@@ -1,4 +1,4 @@
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Gy_StockPlaceList.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Gy_StockPlaceList" %>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Gy_StockPlaceList.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Gy_StockPlaceList4" %>

<!DOCTYPE html>

@@ -7,14 +7,15 @@
<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例子数据库中获取报表数据

        SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Gy_StockPlaceList where HItemID in(" + Request.Params["linterid"] + ")");
    }
            //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
            SqlXMLReportData.GenEntireData(this, "select * from h_v_Gy_StockPlaceList where HItemID in(" + Request.Params["linterid"] + ")","select 1");
        }
    </script>
</head>
<body>

 WebTM/views/Ä£Öξ߹ÜÀí/Ä£Öξ߹ÜÀí/Gy_BarCodeBillList.html

@@ -415,10 +415,10 @@
                            com = "like '%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like '%" + ColContent + "'";
                            com = "like '" + ColContent + "%'";
                            break;
                        case "9":
                            com = "like '" + ColContent + "%'";
                            com = "like '%" + ColContent + "'";
                            break;
                        case "10":
                            com = "not like '%" + ColContent + "%'";
@@ -437,10 +437,10 @@
                            com1 = "like '%" + ColContent1 + "%'";
                            break;
                        case "8":
                            com1 = "like '%" + ColContent1 + "'";
                            com = "like '" + ColContent1 + "%'";
                            break;
                        case "9":
                            com1 = "like '" + ColContent1 + "%'";
                            com = "like '%" + ColContent1 + "'";
                            break;
                        case "10":
                            com1 = "not like '%" + ColContent1 + "%'";
@@ -459,10 +459,10 @@
                            com2 = "like '%" + ColContent2 + "%'";
                            break;
                        case "8":
                            com2 = "like '%" + ColContent2 + "'";
                            com = "like '" + ColContent2 + "%'";
                            break;
                        case "9":
                            com2 = "like '" + ColContent2 + "%'";
                            com = "like '%" + ColContent2 + "'";
                            break;
                        case "10":
                            com2 = "not like '%" + ColContent2 + "%'";

 WebTM/views/³µ¼ä¹ÜÀí/¹Ø¼ü¼þ°ó¶¨/Sc_KeyElementBinding.html

@@ -344,7 +344,12 @@
                    layer.alert("第<span style='color: red;'>" + (i + 1) + "</span>行，配件 <span style='color: blue;'>" + option.data[i].HMaterName + "</span> æœªç»‘定齐整！")
                    return;
                }
            } 
            }

            //保存关键件
            if (AllowLoadData(data)) {
                set_SaveBill(data);
            }

            //启用输入框,背景色恢复
            $("#HBarCode_P").removeAttr("disabled"); //产品码文本框启用
@@ -361,6 +366,20 @@
            //清除绑定信息网格扫码记录
            option.data = [];
            table.render(option);

            //重新获取单据号
            $.ajax({
                url: GetWEBURL() + "/Web/GetMAXNumPDA",
                type: "GET",
                data: { "HBillType": '3727' },
                success: function (d) {
                    $("#HInterID").val(d.data[0].HInterID);
                    $("#HBillNo").val(d.data[0].HBillNo);
                    $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));  //默认为当前日期
                    //重新启用保存按钮
                    $("#btnSave").removeClass("layui-btn-disabled").attr("disabled", false);
                }
            });           

            //历史绑定记录查询
            //get_Display();
@@ -493,13 +512,13 @@
        //#region ä¿å­˜æ–¹æ³•
        function set_SaveBill(data) {
            //把最后一个产品的绑定信息写入到历史记录明细网格
            for (var i = 0; i < option.data.length; i++) {
                option_detail.data.push(option.data[i])
            }
            //for (var i = 0; i < option.data.length; i++) {
            //    option_detail.data.push(option.data[i])
            //}

            //序列化表头信息和子表信息            
            var sMainStr = JSON.stringify(data.field);
            var sSubStr = JSON.stringify(option_detail.data);
            var sSubStr = JSON.stringify(option.data);
            //拼接参数
            var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"];

@@ -512,7 +531,7 @@
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                        layer.msg(data.Message, { icon: 1 });
                        layer.msg(data.Message, { icon: 1, time: 1000 });

                        $("#btnSave").addClass("layui-btn-disabled").attr("disabled", true);
                        layer.close(index);
@@ -743,7 +762,7 @@

                    //刷新表格数据
                    option.data[rowIndex].HBarCode = "";
                    option.data[rowIndex].HBindingQty = option.data[rowIndex].HBindingQty - 1;
                    option.data[rowIndex].HBindingQty = 0;
                    //option.data[rowIndex].HMaterID = 0;
                    option.data[rowIndex].HMaterNumber = "";
                    option.data[rowIndex].HMaterName = "";
@@ -930,6 +949,9 @@
                        return Result = false;
                    }
                }
            } else {
                layer.msg("配件绑定信息不允许为空!", { icon: 5, btn: ['确认'], time: 4000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                return Result = false;
            }

            return true;

 WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/Sc_ProcessExchangeBill_BatchSplit.html

@@ -16,6 +16,7 @@
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/grwebapp.js"></script>
    <style type="text/css">
        .layui-form-item .layui-inline {
            margin-right: 0;
@@ -51,7 +52,8 @@
                    <div class="layui-card-header">
                        <div class="layui-btn-group">
                            <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">保存</button>
                            <button type="button" id="print-btn" class="layui-btn layui-btn-normal layui-btn-radius layui-btn-disabled" lay-submit="" lay-filter="get_BatchPrint" disabled>打印</button>
                            <button type="button" id="print-btn" class="layui-btn layui-btn-normal layui-btn-radius layui-btn-disabled" lay-submit="" lay-filter="get_Print" disabled>打印</button>
                            <button type="button" id="batchPrint-btn" class="layui-btn layui-btn-normal layui-btn-radius layui-btn-disabled" lay-submit="" lay-filter="get_BatchPrint" disabled>批量打印</button>
                            <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit" style="margin-left:50px !important;">退出</button>
                        </div>
                    </div>
@@ -239,10 +241,15 @@
            });

            //打印
            form.on('submit(get_Print)', function () {
                get_Print();
            })

            //批量打印
            form.on('submit(get_BatchPrint)', function () {
                get_BatchPrint();
            })

           
            //退出按钮
            form.on('submit(Exit)', function () {
                if (params[1] != null) {
@@ -267,7 +274,8 @@
                        , { type: 'numbers', title: '序号', width: 100, totalRow: true }
                        , { field: 'HICMOInterID', title: '生产订单内码', width: 100, hide: true }//生产订单内码
                        , { field: 'HICMOEntryID', title: '生产订单子内码', width: 100, hide: true }//生产订单子内码
                        , { field: 'HICMOBillNo', title: '生产订单', width: 120 }//生产订单号
                        , { field: 'HICMOBillNo', title: '生产订单内码', width: 120 }//生产订单号
                        , { field: 'HWorkShopID', title: '生产车间', width: 100, hide: true }//生产车间内码
                        , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true }
                        , { field: '物料代码', title: '物料代码', width: 150 }
                        , { field: '物料名称', title: '物料名称', width: 150 }
@@ -291,7 +299,7 @@

                //初始表格数据
                var rowdata = [{
                    "HICMOInterID": 0, "HICMOEntryID": 0, "HICMOBillNo": "", "HMaterID": 0, "物料代码": ""
                    "HICMOInterID": 0, "HICMOEntryID": 0, "HICMOBillNo": "", "HWorkShopID": 0, "HMaterID": 0, "物料代码": ""
                    , "物料名称": "", "规格型号": "", "HQty": 0, "HFinishQty": 0, "HUsableQty": 0
                    , "HProQty": 0, "HRoutingInterID": 0, "HRoutingName": "", "HSheetQty": 0
                    , "HInterID": 0, "HBillNo": "", "HBatchNo": "", "HBatchManager": "", "HGroupNumber": ""
@@ -332,7 +340,8 @@
                                rowdata.push(
                                    {
                                        "HICMOInterID": subdata[i].HICMOInterID, "HICMOEntryID": subdata[i].HICMOEntryID, "HICMOBillNo": subdata[i].HICMOBillNo
                                        , "HMaterID": subdata[i].HMaterID, "物料代码": subdata[i].物料代码, "物料名称": subdata[i].物料名称
                                        , "HWorkShopID": subdata[i].HWorkShopID, "HMaterID": subdata[i].HMaterID, "物料代码": subdata[i].物料代码
                                        , "物料名称": subdata[i].物料名称
                                        , "规格型号": subdata[i].规格型号, "HQty": subdata[i].HQty, "HFinishQty": subdata[i].HFinishQty
                                        , "HUsableQty": subdata[i].HUsableQty, "HProQty": subdata[i].HProQty, "HRoutingInterID": subdata[i].HRoutingInterID
                                        , "HRoutingName": subdata[i].HRoutingName, "HSheetQty": subdata[i].HSheetQty, "HDate": formatDate(subdata[i].HDate)
@@ -352,6 +361,7 @@
                                    , { field: 'HICMOInterID', title: '生产订单内码', width: 100, hide: true }//生产订单内码
                                    , { field: 'HICMOEntryID', title: '生产订单子内码', width: 100, hide: true }//生产订单子内码
                                    , { field: 'HICMOBillNo', title: '生产订单', width: 120 }//生产订单号
                                    , { field: 'HWorkShopID', title: '生产车间内码', width: 100, hide: true }//生产车间内码
                                    , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true }
                                    , { field: '物料代码', title: '物料代码', width: 150 }
                                    , { field: '物料名称', title: '物料名称', width: 150 }
@@ -439,6 +449,7 @@
                        if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            layer.msg(data.Message, { icon: 1 });
                            $('#print-btn').removeClass("layui-btn-disabled").attr("disabled", false);//打印按钮启用
                            $('#batchPrint-btn').removeClass("layui-btn-disabled").attr("disabled", false);//批量打印按钮启用                            
                            layer.close(index);
                        }
                        else {
@@ -499,7 +510,7 @@
            }

            //打印
            function get_BatchPrint() {
            function get_Print() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length >= 1) {
@@ -525,6 +536,91 @@
                }
            }

            
            //批量打印
            var time;
            var num = 0;
            function get_BatchPrint() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;

                if (checkStatus.data.length > 0) {
                    //逻辑删除方法
                    layer.confirm("确认要批量打印吗?", { title: "确认" }, function (index) {
                        time = setInterval(function () {
                            dy_PL(data);
                        }, 1000);
                        //关闭当前frame
                        layer.close(index);
                    })
                }
                else {
                    layer.msg('请选择数据打印！');
                }
            }

            function dy_PL(rest) {
                var HInterID = rest[num].HInterID.toString();
                var sWhere = "select cast( b.流水号 as float) æµæ°´å·,生产订单号,a.生产数量,a.流转卡数量,a.产品代码,a.单据号,case when ISNULL(a.生产规格,'')='' then a.产品规格 else a.生产规格 end äº§å“è§„æ ¼,a.产品名称,a.日期,a.单据号,b.工序代码,b.工序名称,a.批号,b.工艺工作中心,b.工艺工艺参数,a.生产车间,b.工段名称 from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid   where b.hmainid in(" + HInterID + ") and b.工序代码 != '9999' order by cast(b.流水号 as int)"

                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", //方法所在页面和方法名
                    async: false,
                    data: { "sWhere": sWhere },
                    success: function (data) {
                        if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ

                            if (data.data.length != 0) {
                                var dataPrint = [];
                                for (var i = 0; i < data.data.length; i++) {
                                    data.data[i]["流水号"] = data.data[i]["流水号"].toFixed(1);
                                    dataPrint.push(data.data[i])
                                }

                                var Customer = {
                                    "Table": dataPrint
                                }

                                var args = {
                                    type: "print",//打印模式
                                    //type: "preview",//预览模式
                                    showOptionDlg: false, //如果不显示打印对话框而直接打印，将此行注释去掉即可
                                    report: urlAddRandomNo("../../grf/流转卡JSON.grf"),
                                    data: Customer
                                };
                              
                                console.log(data.data[0].单据号);
                                //var args = {
                                //    report: urlAddRandomNo("../../grf/cs10.grf"),
                                //    data: Customer
                                //};
                                webapp_ws_ajax_run(args);

                                if (rest.length <= num + 1) {
                                    num = 0;
                                    clearInterval(time);
                                } else {
                                    num++;
                                }

                            } else {
                                layer.msg("查无数据!");
                            }

                        }
                        else {
                            layer.msg(data.Message, { icon: 5 });
                        }
                        layer.closeAll("loading");
                    },
                    error: function (err) {
                        layer.msg("错误:" + err, { icon: 5 });
                    }
                })

            }

            //表格行内事件删除
            function set_GridDelete(obj) {
                var data = obj.data;

 WebTM/views/ÏúÊÛ¹ÜÀí/·¢»õ֪ͨµ¥/Xs_SeOutStockBillList.html

@@ -1314,7 +1314,9 @@
                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                                var dataCols = dataCol[i].split('|');
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }                               
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;