313 lines
5.7 KiB
Plaintext
313 lines
5.7 KiB
Plaintext
{
|
|
"Version":"6.3.0.1",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Weight":400,
|
|
"Charset":134
|
|
},
|
|
"Printer":{
|
|
"Oriention":"Landscape"
|
|
},
|
|
"DetailGrid":{
|
|
"CenterView":true,
|
|
"PrintAdaptMethod":"ResizeToFit",
|
|
"Recordset":{
|
|
"QuerySQL":"SELECT \r\n cl.`row_no` AS drawerNo,\r\n cl.`col_no` AS colNo,\r\n cl.`quantity` AS quantity,\r\n cl.`manu_no` AS manuNo,\r\n cl.`eff_date` AS effDate,\r\n di.`drug_name` AS drugName,\r\n di.`drug_spec` AS drugSpec,\r\n di.`pack_unit` AS packUnit,\r\n di.`manufactory` AS manuFactory,\r\n di.`max_stock` AS baseQuantity,\r\n cl.`drug_id` AS drugId\r\nFROM\r\n channel_stock cl\r\nINNER JOIN drug_info di ON di.`drug_id` = cl.`drug_id`\r\nWHERE cl.`machine_id` = :machine_id\r\n AND cl.`drawer_type` = 1\r\n ORDER BY cl.`drug_id`",
|
|
"Field":[
|
|
{
|
|
"Name":"drugName"
|
|
},
|
|
{
|
|
"Name":"drugSpec"
|
|
},
|
|
{
|
|
"Name":"manuFactory"
|
|
},
|
|
{
|
|
"Name":"quantityCount",
|
|
"Type":"Integer"
|
|
},
|
|
{
|
|
"Name":"manuNo"
|
|
},
|
|
{
|
|
"Name":"effDate"
|
|
},
|
|
{
|
|
"Name":"quantity",
|
|
"Type":"Integer",
|
|
"Format":"0"
|
|
},
|
|
{
|
|
"Name":"drawerNo"
|
|
},
|
|
{
|
|
"Name":"drugId"
|
|
},
|
|
{
|
|
"Name":"baseQuantity",
|
|
"Type":"Integer"
|
|
},
|
|
{
|
|
"Name":"manuquantity",
|
|
"Type":"Integer"
|
|
},
|
|
{
|
|
"Name":"optDate",
|
|
"DBFieldName":"optdate"
|
|
}
|
|
]
|
|
},
|
|
"Column":[
|
|
{
|
|
"Name":"optDate",
|
|
"Width":4.20688
|
|
},
|
|
{
|
|
"Name":"drugName",
|
|
"Width":4.57729
|
|
},
|
|
{
|
|
"Name":"drugSpec"
|
|
},
|
|
{
|
|
"Name":"manuFactory",
|
|
"Width":4.60375
|
|
},
|
|
{
|
|
"Name":"quantityCount",
|
|
"Width":2.19604
|
|
},
|
|
{
|
|
"Name":"manuNo"
|
|
},
|
|
{
|
|
"Name":"effDate",
|
|
"Width":2.61938
|
|
},
|
|
{
|
|
"Name":"quantity",
|
|
"Width":1.42875
|
|
}
|
|
],
|
|
"ColumnContent":{
|
|
"Height":0.79375,
|
|
"ColumnContentCell":[
|
|
{
|
|
"Column":"optDate",
|
|
"DataField":"optDate"
|
|
},
|
|
{
|
|
"Column":"drugName",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"drugName"
|
|
},
|
|
{
|
|
"Column":"drugSpec",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"drugSpec"
|
|
},
|
|
{
|
|
"Column":"manuFactory",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"manuFactory"
|
|
},
|
|
{
|
|
"Column":"quantityCount",
|
|
"FreeCell":true,
|
|
"Control":[
|
|
{
|
|
"Type":"MemoBox",
|
|
"Name":"MemoBox1",
|
|
"Dock":"Fill",
|
|
"Text":"[#Sum(manuquantity)#]"
|
|
}
|
|
]
|
|
},
|
|
{
|
|
"Column":"manuNo",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"manuNo"
|
|
},
|
|
{
|
|
"Column":"effDate",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"effDate"
|
|
},
|
|
{
|
|
"Column":"quantity",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"manuquantity"
|
|
}
|
|
]
|
|
},
|
|
"ColumnTitle":{
|
|
"Height":1.19063,
|
|
"RepeatStyle":"OnPage",
|
|
"ColumnTitleCell":[
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"optDate",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"盘点日期"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"drugName",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"药品名称"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"drugSpec",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"规格"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"manuFactory",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"厂家"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"quantityCount",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"总库存"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"manuNo",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"批次"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"effDate",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"效期"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"quantity",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":142500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"数量"
|
|
}
|
|
]
|
|
},
|
|
"Group":[
|
|
{
|
|
"Name":"Group2",
|
|
"ByFields":"optDate",
|
|
"GroupHeader":{
|
|
"Height":0.635,
|
|
"OccupyColumn":true,
|
|
"OccupiedColumns":"optDate",
|
|
"VAlign":"Middle"
|
|
},
|
|
"GroupFooter":{
|
|
"Visible":false,
|
|
"Height":0
|
|
}
|
|
},
|
|
{
|
|
"Name":"drugId",
|
|
"ByFields":"drugId",
|
|
"GroupHeader":{
|
|
"Visible":false,
|
|
"Height":0.79375,
|
|
"RepeatOnPage":true,
|
|
"OccupyColumn":true,
|
|
"IncludeFooter":true,
|
|
"OccupiedColumns":"drugName;drugSpec;manuFactory;quantityCount",
|
|
"VAlign":"Middle"
|
|
},
|
|
"GroupFooter":{
|
|
"Visible":false,
|
|
"Height":0
|
|
}
|
|
}
|
|
]
|
|
},
|
|
"Parameter":[
|
|
{
|
|
"Name":"machine_id",
|
|
"Value":"DM1"
|
|
}
|
|
],
|
|
"ReportHeader":[
|
|
{
|
|
"Name":"ReportHeader1",
|
|
"Height":2.40771,
|
|
"Control":[
|
|
{
|
|
"Type":"StaticBox",
|
|
"Name":"StaticBox1",
|
|
"Center":"Horizontal",
|
|
"Left":8.22854,
|
|
"Top":0.608542,
|
|
"Width":9.18104,
|
|
"Height":1.21708,
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":217500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"毒麻药品盘点后库存信息"
|
|
}
|
|
],
|
|
"RepeatOnPage":true
|
|
}
|
|
]
|
|
} |