You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
225 lines
4.2 KiB
225 lines
4.2 KiB
2 months ago
|
{
|
||
|
|
"Version":"6.6.2.0",
|
||
|
|
"Font":{
|
||
|
|
"Name":"宋体",
|
||
|
|
"Size":105000,
|
||
|
|
"Weight":400,
|
||
|
|
"Charset":134
|
||
|
|
},
|
||
|
|
"Printer":{
|
||
|
|
"Size":256,
|
||
|
|
"Width":6,
|
||
|
|
"Height":7,
|
||
|
|
"LeftMargin":0,
|
||
|
|
"TopMargin":0,
|
||
|
|
"RightMargin":0,
|
||
|
|
"BottomMargin":0
|
||
|
|
},
|
||
|
|
"DetailGrid":{
|
||
|
|
"Recordset":{
|
||
|
|
"ConnectionString":"Provider=SQLOLEDB.1;Password=a1+;Persist Security Info=True;User ID=sa;Initial Catalog=BBMPT;Data Source=10.60.101.9;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AMW-PC;Use Encryption for Data=False;Tag with column collation when possible=False",
|
||
|
|
"QuerySQL":"SELECT * FROM [dbo].[tb_Assembly_247] WHERE substring(PartNo,1,11 ) in('A2477305303','A2477305503','A2477305703') AND PrintTime IS NULL ORDER BY CreateTime",
|
||
|
|
"Field":[
|
||
|
|
{
|
||
|
|
"Name":"ID"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"PartNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"PartName"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"BatchNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"Color"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"ColorNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"PartType"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"Validity"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"ValidityDate"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"CreateTime",
|
||
|
|
"Type":"DateTime"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"PrintTime",
|
||
|
|
"Type":"DateTime"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"TapeBatchNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Name":"Des"
|
||
|
|
}
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"ColumnContent":{
|
||
|
|
"Height":0
|
||
|
|
},
|
||
|
|
"ColumnTitle":{
|
||
|
|
"Height":0
|
||
|
|
}
|
||
|
|
},
|
||
|
|
"PageFooter":{
|
||
|
|
"Height":0
|
||
|
|
},
|
||
|
|
"ReportHeader":[
|
||
|
|
{
|
||
|
|
"Name":"ReportHeader1",
|
||
|
|
"Height":5.79438,
|
||
|
|
"Control":[
|
||
|
|
{
|
||
|
|
"Type":"StaticBox",
|
||
|
|
"Name":"StaticBox1",
|
||
|
|
"Top":0.185208,
|
||
|
|
"Width":1.5875,
|
||
|
|
"Height":0.608542,
|
||
|
|
"Text":"规格型号："
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox1",
|
||
|
|
"Left":0.211667,
|
||
|
|
"Top":0.79375,
|
||
|
|
"Width":5.58271,
|
||
|
|
"Height":0.396875,
|
||
|
|
"Font":{
|
||
|
|
"Name":"宋体",
|
||
|
|
"Size":120000,
|
||
|
|
"Weight":400,
|
||
|
|
"Charset":134
|
||
|
|
},
|
||
|
|
"DataField":"PartNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"StaticBox",
|
||
|
|
"Name":"StaticBox2",
|
||
|
|
"Top":3.70417,
|
||
|
|
"Width":1.19063,
|
||
|
|
"Height":0.608542,
|
||
|
|
"Text":"批次："
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox2",
|
||
|
|
"Left":1.40229,
|
||
|
|
"Top":3.70417,
|
||
|
|
"Width":1.79917,
|
||
|
|
"Height":0.396875,
|
||
|
|
"DataField":"BatchNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox3",
|
||
|
|
"Left":0.211667,
|
||
|
|
"Top":1.19063,
|
||
|
|
"Width":5.97958,
|
||
|
|
"Height":0.582083,
|
||
|
|
"DataField":"PartName"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"StaticBox",
|
||
|
|
"Name":"StaticBox3",
|
||
|
|
"Left":0.0264583,
|
||
|
|
"Top":2.19604,
|
||
|
|
"Width":1.19063,
|
||
|
|
"Height":0.608542,
|
||
|
|
"Text":"车型："
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox4",
|
||
|
|
"Left":1.40229,
|
||
|
|
"Top":2.19604,
|
||
|
|
"Width":4.20688,
|
||
|
|
"Height":0.608542,
|
||
|
|
"DataField":"PartType"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"StaticBox",
|
||
|
|
"Name":"StaticBox4",
|
||
|
|
"Left":0.0264583,
|
||
|
|
"Top":2.51354,
|
||
|
|
"Width":2.38125,
|
||
|
|
"Height":0.79375,
|
||
|
|
"Text":"胶带有效期："
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox5",
|
||
|
|
"Left":2.40771,
|
||
|
|
"Top":2.69875,
|
||
|
|
"Width":2.98979,
|
||
|
|
"Height":0.396875,
|
||
|
|
"DataField":"Validity"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox6",
|
||
|
|
"Left":0.0264583,
|
||
|
|
"Top":3.41313,
|
||
|
|
"Width":5.00063,
|
||
|
|
"Height":0.396875,
|
||
|
|
"DataField":"ValidityDate"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"StaticBox",
|
||
|
|
"Name":"StaticBox5",
|
||
|
|
"Left":-0.0529167,
|
||
|
|
"Top":4.89479,
|
||
|
|
"Width":0.820208,
|
||
|
|
"Height":0.608542,
|
||
|
|
"Text":"颜色："
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox7",
|
||
|
|
"Left":1.21708,
|
||
|
|
"Top":4.89479,
|
||
|
|
"Width":2.19604,
|
||
|
|
"Height":0.608542,
|
||
|
|
"DataField":"Color"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox8",
|
||
|
|
"Left":0.0264583,
|
||
|
|
"Top":4.31271,
|
||
|
|
"Width":2.59292,
|
||
|
|
"Height":0.582083,
|
||
|
|
"DataField":"ColorNo"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"FieldBox",
|
||
|
|
"Name":"FieldBox9",
|
||
|
|
"Left":0.211667,
|
||
|
|
"Top":1.5875,
|
||
|
|
"Width":5.58271,
|
||
|
|
"Height":0.502708,
|
||
|
|
"DataField":"Des"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"Type":"Barcode",
|
||
|
|
"Name":"Barcode1",
|
||
|
|
"Left":3.04271,
|
||
|
|
"Top":3.70417,
|
||
|
|
"Width":2.38125,
|
||
|
|
"Height":2.01083,
|
||
|
|
"BarcodeType":"QRCode",
|
||
|
|
"CaptionPosition":"None",
|
||
|
|
"Text":"[#PartNo#]"
|
||
|
|
}
|
||
|
|
]
|
||
|
|
}
|
||
|
|
]
|
||
|
|
}
|