工序流转卡打印sql语句添加已汇报数量

wtt

2024-10-17 57933560e36eaa4629345b5ee9341eb269422cd3

工序流转卡打印sql语句添加已汇报数量

 WebTM/views/grf/·µ¹¤Á÷ת¿¨ - A5.grf

New file
@@ -0,0 +1,683 @@
{
    "Version":"6.8.9.1",
    "Font":{
        "Name":"宋体",
        "Size":105000,
        "Weight":400,
        "Charset":134
    },
    "Printer":{
        "Size":11,
        "Width":14.8,
        "Height":21,
        "Oriention":"Landscape",
        "LeftMargin":1.5,
        "TopMargin":0,
        "RightMargin":1.5,
        "BottomMargin":0,
        "PrintOffsetY":0.55
    },
    "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":"工艺工艺参数"
                },
                {
                    "Name":"生产订单数量"
                },
                {
                    "Name":"已汇报数量"
                }
            ]
        },
        "Column":[
            {
                "Name":"Column14",
                "Width":0.978958
            },
            {
                "Name":"Column1",
                "Width":1.61396
            },
            {
                "Name":"Column2",
                "Width":2.19604
            },
            {
                "Name":"Column16",
                "Width":2.01083
            },
            {
                "Name":"Column3",
                "Width":1.98438
            },
            {
                "Name":"Column8",
                "Width":2.38125
            },
            {
                "Name":"Column9",
                "Width":1.64042
            },
            {
                "Name":"Column17",
                "Width":1.6404
            },
            {
                "Name":"Column12",
                "Width":2.35479
            },
            {
                "Name":"Column15",
                "Width":0.978958
            }
        ],
        "ColumnContent":{
            "Height":0.79375,
            "AdjustRowHeight":false,
            "RowsPerPage":10,
            "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",
                    "ShrinkFontToFit":true,
                    "DataField":"工段名称"
                },
                {
                    "Column":"Column3",
                    "ShrinkFontToFit":true,
                    "DataField":"班组"
                },
                {
                    "Column":"Column8",
                    "WordWrap":true,
                    "DataField":"工艺工作中心"
                },
                {
                    "Column":"Column9",
                    "WordWrap":true,
                    "ShrinkFontToFit":true,
                    "DataField":"实作数量"
                },
                {
                    "Column":"Column17",
                    "DataField":"已汇报数量"
                },
                {
                    "Column":"Column12",
                    "ShrinkFontToFit":true,
                    "DataField":"工艺工艺参数"
                },
                {
                    "Column":"Column15",
                    "DataField":"班号"
                }
            ]
        },
        "ColumnTitle":{
            "Height":0.608542,
            "RepeatStyle":"OnPage",
            "ColumnTitleCell":[
                {
                    "GroupTitle":false,
                    "Column":"Column14",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "ShrinkFontToFit":true,
                    "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",
                    "ShrinkFontToFit":true,
                    "Text":"数量"
                },
                {
                    "GroupTitle":false,
                    "Column":"Column17",
                    "Font":{
                        "Name":"宋体",
                        "Size":105000,
                        "Bold":true,
                        "Charset":134
                    },
                    "WordWrap":true,
                    "TextAlign":"MiddleCenter",
                    "ShrinkFontToFit":true,
                    "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":3.99521,
            "Font":{
                "Name":"宋体",
                "Size":105000,
                "Bold":true,
                "Charset":134
            },
            "Control":[
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox1",
                    "Center":"Horizontal",
                    "Left":7.19667,
                    "Width":3.59833,
                    "Height":0.687917,
                    "Font":{
                        "Name":"宋体",
                        "Size":180000,
                        "Bold":true,
                        "Charset":134
                    },
                    "TextAlign":"MiddleCenter",
                    "Text":"返工流转卡"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox3",
                    "Left":5.60917,
                    "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":0.396875,
                    "Top":2.19604,
                    "Width":1.19063,
                    "Height":0.608542,
                    "Text":"日期："
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox1",
                    "Left":7.40833,
                    "Top":2.19604,
                    "Width":3.99521,
                    "Height":0.608542,
                    "DataField":"生产车间"
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox6",
                    "Left":1.5875,
                    "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":11.2713,
                    "Top":2.19604,
                    "Width":2.61938,
                    "Height":0.608542,
                    "Text":"产品代码："
                },
                {
                    "Type":"FieldBox",
                    "Name":"FieldBox10",
                    "Left":13.2027,
                    "Top":2.19604,
                    "Width":4.33917,
                    "Height":0.608542,
                    "DataField":"产品代码"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox21",
                    "Left":11.43,
                    "Top":3.33375,
                    "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":12.5677,
                    "Top":3.33375,
                    "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.58,
                    "Height":0.58
                },
                {
                    "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.58,
                    "Height":0.58
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox27",
                    "Left":0.396875,
                    "Top":2.75167,
                    "Width":9.60438,
                    "Height":0.608542,
                    "Text":"产品名称：[#产品名称#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox28",
                    "Left":11.2713,
                    "Top":2.77813,
                    "Width":6.21771,
                    "Height":0.608542,
                    "Text":"规格型号：[#产品规格#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox29",
                    "Left":0.396875,
                    "Top":3.30729,
                    "Width":5.18583,
                    "Height":0.608542,
                    "Text":"生产数量：[#生产订单数量#]"
                },
                {
                    "Type":"MemoBox",
                    "Name":"MemoBox30",
                    "Left":5.76792,
                    "Top":3.30729,
                    "Width":4.81542,
                    "Height":0.608542,
                    "Text":"卡数量：[#流转卡数量#]"
                }
            ],
            "RepeatOnPage":true
        }
    ],
    "ReportFooter":[
        {
            "Name":"ReportFooter1",
            "Height":1.19063,
            "Control":[
                {
                    "Type":"FreeGrid",
                    "Name":"FreeGrid1",
                    "AlignColumn":"(GridLeft)",
                    "AlignColumnEx":"(GridRight)",
                    "Border":{
                        "Styles":"[DrawLeft|DrawRight|DrawBottom]"
                    },
                    "ColumnCount":7,
                    "RowCount":2,
                    "FreeGridColumn":[
                        {
                            "index":1,
                            "Width":2.593
                        },
                        {
                            "index":2,
                            "Width":2.19604
                        },
                        {
                            "index":3,
                            "Width":2.0108
                        },
                        {
                            "index":4,
                            "Width":1.98438
                        },
                        {
                            "index":5,
                            "Width":2.38125
                        },
                        {
                            "index":6,
                            "Width":1.6404
                        },
                        {
                            "index":7,
                            "Width":4.9744
                        }
                    ],
                    "FreeGridRow":[
                        {
                            "index":1,
                            "Height":0.449792
                        }
                    ],
                    "FreeGridCell":[
                        {
                            "row":1,
                            "col":1,
                            "Text":"入库记录"
                        },
                        {
                            "row":2,
                            "col":1,
                            "Text":"领用记录"
                        }
                    ]
                }
            ]
        }
    ]
}

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

@@ -14,7 +14,7 @@
            //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

            //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
            SqlXMLReportData.GenEntireData(this, "select  cast((cast( b.流水号 as float)/10) as decimal(6,1)) æµæ°´å·,生产订单号,a.生产数量,a.拆分号,a.流转卡数量,a.交货日期,a.产品代码,a.单据号,case when ISNULL(a.生产规格,'')='' then a.产品规格 else a.生产规格 end äº§å“è§„æ ¼,a.产品名称,a.日期,a.计划完工日期,a.单据号,b.工序名称,b.模具编号,b.工艺参数,b.加工说明,case when ISNULL(a.生产幅宽,0)=0 then a.幅宽 else a.生产幅宽 end å¹…宽,case when ISNULL(a.生产克重,0) = 0 then a.克重 else a.生产克重 end å…‹é‡,a.白坯要求,a.底部备注,a.客户,a.业务员,a.毛高,a.寸数组织,a.全毛长,a.坯布密度,a.毛纱名称及规格,a.底丝,a.辅数量,a.辅助单位,a.定型浆料,a.交货日期,a.染色要求,a.辅数量2,a.HAuxUnit2,a.辅助单位2 from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid   where b.hmainid in("+Request.Params["linterid"] +") order by cast(b.流水号 as int)","select 1");
            SqlXMLReportData.GenEntireData(this, "select  cast((cast( b.流水号 as float)/10) as decimal(6,1)) æµæ°´å·,生产订单号,a.生产数量,a.拆分号,a.流转卡数量,a.交货日期,a.产品代码,a.单据号,case when ISNULL(a.生产规格,'')='' then a.产品规格 else a.生产规格 end äº§å“è§„æ ¼,a.产品名称,a.日期,a.计划完工日期,a.单据号,b.工序名称,b.模具编号,b.工艺参数,b.加工说明,case when ISNULL(a.生产幅宽,0)=0 then a.幅宽 else a.生产幅宽 end å¹…宽,case when ISNULL(a.生产克重,0) = 0 then a.克重 else a.生产克重 end å…‹é‡,a.白坯要求,a.底部备注,a.客户,a.业务员,a.毛高,a.寸数组织,a.全毛长,a.坯布密度,a.毛纱名称及规格,a.底丝,a.辅数量,a.辅助单位,a.定型浆料,a.交货日期,a.染色要求,a.辅数量2,a.HAuxUnit2,a.辅助单位2,b.HRelationQty_Out å·²æ±‡æŠ¥æ•°é‡ from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid   where b.hmainid in("+Request.Params["linterid"] +") order by cast(b.流水号 as int)","select 1");
        }
    </script>
</head>

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

@@ -11,7 +11,7 @@
{


    public partial class xmlLBM_QC_TakeSampleCheckBillMainList
    public partial class xmlLBM_Sc_ProcessExchangeBillList
    {

        /// <summary>