yxj
2025-08-07 5256514b68b10ddea93055f737c1ec80420a6b1f
新增海诚物料打印模版
1个文件已添加
1个文件已修改
586 ■■■■■ 已修改文件
WebTM/App_Data/MssqlReportData.cs 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/grf/物料条码_海诚.grf 585 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/App_Data/MssqlReportData.cs
@@ -34,6 +34,7 @@
    //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 const string SqlConnStr = "Data Source=192.168.6.5;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//舜成
    //public const string SqlConnStr = "Data Source=172.16.1.89;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//迦南
    //public const string SqlConnStr = "Data Source=172.16.1.30;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//海诚
    //public string sServer;
    //public string sDataBase;
WebTM/views/grf/ÎïÁÏÌõÂë_º£³Ï.grf
New file
@@ -0,0 +1,585 @@
Object Report
    Version='6.0.0.6'
    Title='生产任务单'
    PrintAsDesignPaper=F
    Object Font
        Name='宋体'
        Size=135000,0
        Weight=400
        Charset=134
    End
    Object Printer
        Size=256
        Width=8
        Height=5
        LeftMargin=0
        TopMargin=0
        RightMargin=0
        BottomMargin=0
    End
    Object DetailGrid
        CenterView=T
        ShowColLine=F
        ShowRowLine=F
        Object Border
            Styles=[]
        End
        Object Recordset
            Items Field
                Item
                    Name='条码编号'
                End
                Item
                    Name='供应商'
                End
                Item
                    Name='物料代码'
                End
                Item
                    Name='物料名称'
                End
                Item
                    Name='规格型号'
                End
                Item
                    Name='数量'
                    Type=Float
                    Format='0'
                End
                Item
                    Name='日期'
                    Type=DateTime
                    Format='yyyy/MM/dd'
                End
                Item
                    Name='客户编号'
                End
                Item
                    Name='款号'
                End
                Item
                    Name='分组'
                End
                Item
                    Name='采购单号'
                End
            End
        End
        Items Column
            Item
                Name='Column3'
                Width=7.99042
            End
        End
        Object ColumnContent
            Height=4.9
            RowsPerPage=1
            Items ColumnContentCell
                Item
                    Column='Column3'
                    FreeCell=T
                    CanGrow=T
                    Items Control
                        Item
                            Type=FreeGrid
                            Name='FreeGrid1'
                            Left=0.264583
                            Top=0.15875
                            Locked=T
                            ColumnCount=2
                            RowCount=16
                            ShowColLine=F
                            ShowRowLine=F
                            Items FreeGridColumn
                                Item[1]
                                    Width=3.7
                                End
                                Item[2]
                                    Width=3.7
                                End
                            End
                            Items FreeGridRow
                                Item[1]
                                    Height=0.38
                                End
                                Item[2]
                                    Height=0.2
                                End
                                Item[3]
                                    Height=0.38
                                End
                                Item[4]
                                    Height=0.2
                                End
                                Item[5]
                                    Height=0.38
                                End
                                Item[6]
                                    Height=0.2
                                End
                                Item[7]
                                    Height=0.38
                                End
                                Item[8]
                                    Height=0.2
                                End
                                Item[9]
                                    Height=0.38
                                End
                                Item[10]
                                    Height=0.2
                                End
                                Item[11]
                                    Height=0.38
                                End
                                Item[12]
                                    Height=0.2
                                End
                                Item[13]
                                    Height=0.38
                                End
                                Item[14]
                                    Height=0.2
                                End
                                Item[15]
                                    Height=0.38
                                End
                                Item[16]
                                    Height=0.2
                                End
                            End
                            Items FreeGridCell
                                Item[1,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='供应商:'
                                End
                                Item[2,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Supplier)'
                                End
                                Item[3,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='供应商料号:'
                                End
                                Item[4,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Supplier Sku No.)'
                                End
                                Item[5,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='物料名称:'
                                End
                                Item[6,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Material Code)'
                                End
                                Item[7,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='款号:'
                                End
                                Item[7,2]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='客户编号:'
                                End
                                Item[8,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Style No.)'
                                End
                                Item[8,2]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Consumer No.)'
                                End
                                Item[9,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='分组:'
                                End
                                Item[9,2]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='规格:'
                                End
                                Item[10,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Group)'
                                End
                                Item[10,2]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(SKU NO.)'
                                End
                                Item[11,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='数量:'
                                End
                                Item[11,2]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='日期:'
                                End
                                Item[12,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Quantity)'
                                End
                                Item[12,2]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Date)'
                                End
                                Item[13,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='检验员:'
                                End
                                Item[13,2]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='采购单号:'
                                End
                                Item[14,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(QC)'
                                End
                                Item[14,2]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Purchase Order No.)'
                                End
                                Item[15,1]
                                    Object Font
                                        Name='宋体'
                                        Size=90000,0
                                        Weight=400
                                        Charset=134
                                    End
                                    Text='检验结果:'
                                End
                                Item[16,1]
                                    Object Font
                                        Name='Arial'
                                        Size=52500,0
                                        Weight=400
                                    End
                                    Text='(Inspection status)'
                                End
                            End
                        End
                        Item
                            Type=Barcode
                            Name='Barcode1'
                            Left=6.00604
                            Top=0.211667
                            Width=1.5875
                            Height=1.5
                            BarcodeType=QRCode
                            CaptionPosition=None
                            Text='[#订单号#]'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox9'
                            Left=1.5875
                            Top=0.15875
                            Width=4.20688
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='供应商'
                        End
                        Item
                            Type=StaticBox
                            Name='StaticBox5'
                            Left=3.20146
                            Top=4.20688
                            Width=3.99521
                            Height=0.396875
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            Text='□合格 â–¡ä¸åˆæ ¼ â–¡ç‰¹é‡‡'
                        End
                        Item
                            Type=StaticBox
                            Name='StaticBox6'
                            Left=3.41313
                            Top=4.60375
                            Width=3.99521
                            Height=0.211667
                            Object Font
                                Name='Arial'
                                Size=52500,0
                                Weight=400
                            End
                            Text='(Pass)               (Fail)             (Spec.accepted)'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox10'
                            Left=2.19604
                            Top=0.714375
                            Width=3.59833
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='物料代码'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox11'
                            Left=1.79917
                            Top=1.29646
                            Width=3.99521
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='物料名称'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox12'
                            Left=1.19063
                            Top=1.905
                            Width=2.61938
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='款号'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox13'
                            Left=1.19063
                            Top=2.48708
                            Width=2.61938
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='分组'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox14'
                            Left=5.60917
                            Top=1.87854
                            Width=1.98438
                            Height=0.396875
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='客户编号'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox15'
                            Left=5.00063
                            Top=2.46063
                            Width=2.59292
                            Height=0.396875
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='规格型号'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox16'
                            Left=5.00063
                            Top=3.04271
                            Width=2.59292
                            Height=0.423333
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='日期'
                        End
                        Item
                            Type=FieldBox
                            Name='FieldBox17'
                            Left=5.60917
                            Top=3.62479
                            Width=1.98438
                            Height=0.396875
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            ShrinkFontToFit=T
                            DataField='采购单号'
                        End
                        Item
                            Type=MemoBox
                            Name='MemoBox1'
                            Left=1.19063
                            Top=3.06917
                            Width=2.61938
                            Height=0.38
                            Object Font
                                Name='宋体'
                                Size=90000,0
                                Weight=400
                                Charset=134
                            End
                            Text='[#数量#] (对/付)'
                        End
                    End
                End
            End
        End
        Object ColumnTitle
            Height=0
            Items ColumnTitleCell
                Item
                    GroupTitle=F
                    Column='Column3'
                    Text='Column1'
                End
            End
        End
    End
    Items ReportHeader
        Item
            Name='ReportHeader1'
            Height=0
            RepeatOnPage=T
        End
    End
    Items ReportFooter
        Item
            Name='ReportFooter1'
            Height=0
        End
    End
End