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.
222 lines
4.1 KiB
222 lines
4.1 KiB
{
|
|
"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('A2477305603','A2477305403','A2477305803') 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.396875,
|
|
"Width":2.01083,
|
|
"Height":0.582083,
|
|
"Text":"规格型号："
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox1",
|
|
"Top":0.79375,
|
|
"Width":6.00604,
|
|
"Height":0.396875,
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":120000,
|
|
"Weight":400,
|
|
"Charset":134
|
|
},
|
|
"DataField":"PartNo"
|
|
},
|
|
{
|
|
"Type":"StaticBox",
|
|
"Name":"StaticBox2",
|
|
"Left":0.211667,
|
|
"Top":3.81,
|
|
"Width":0.978958,
|
|
"Height":0.582083,
|
|
"Text":"批次："
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox2",
|
|
"Left":1.21708,
|
|
"Top":3.81,
|
|
"Width":1.79917,
|
|
"Height":0.396875,
|
|
"DataField":"BatchNo"
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox3",
|
|
"Left":-0.15875,
|
|
"Top":1.19063,
|
|
"Width":5.37104,
|
|
"Height":0.582083,
|
|
"DataField":"PartName"
|
|
},
|
|
{
|
|
"Type":"StaticBox",
|
|
"Name":"StaticBox3",
|
|
"Top":2.19604,
|
|
"Width":1.00542,
|
|
"Height":0.608542,
|
|
"Text":"车型："
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox4",
|
|
"Left":1.24354,
|
|
"Top":2.19604,
|
|
"Width":4.20688,
|
|
"Height":0.608542,
|
|
"DataField":"PartType"
|
|
},
|
|
{
|
|
"Type":"StaticBox",
|
|
"Name":"StaticBox4",
|
|
"Top":2.61938,
|
|
"Width":2.40771,
|
|
"Height":0.79375,
|
|
"Text":"胶带有效期："
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox5",
|
|
"Left":2.80458,
|
|
"Top":2.80458,
|
|
"Width":2.98979,
|
|
"Height":0.396875,
|
|
"DataField":"Validity"
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox6",
|
|
"Left":-0.15875,
|
|
"Top":3.41313,
|
|
"Width":5.50333,
|
|
"Height":0.396875,
|
|
"DataField":"ValidityDate"
|
|
},
|
|
{
|
|
"Type":"StaticBox",
|
|
"Name":"StaticBox5",
|
|
"Top":5.00063,
|
|
"Width":1.19063,
|
|
"Height":0.608542,
|
|
"Text":"颜色："
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox7",
|
|
"Left":1.5875,
|
|
"Top":5.00063,
|
|
"Width":1.64042,
|
|
"Height":0.608542,
|
|
"DataField":"Color"
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox8",
|
|
"Left":-0.15875,
|
|
"Top":4.41854,
|
|
"Width":2.03729,
|
|
"Height":0.582083,
|
|
"DataField":"ColorNo"
|
|
},
|
|
{
|
|
"Type":"FieldBox",
|
|
"Name":"FieldBox9",
|
|
"Left":-0.15875,
|
|
"Top":1.77271,
|
|
"Width":5.00063,
|
|
"Height":0.423333,
|
|
"DataField":"Des"
|
|
},
|
|
{
|
|
"Type":"Barcode",
|
|
"Name":"Barcode1",
|
|
"Left":3.41313,
|
|
"Top":3.81,
|
|
"Width":2.38125,
|
|
"Height":2.01083,
|
|
"BarcodeType":"QRCode",
|
|
"CaptionPosition":"None",
|
|
"Text":"[#PartNo#]"
|
|
}
|
|
]
|
|
}
|
|
]
|
|
}
|