From 65e7f280e59558e5f08c066b66e7b9dd65fdf1ef Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期三, 18 十月 2023 09:42:15 +0800
Subject: [PATCH] 报表打印
---
WebTM/views/车间管理/报表分析/Sc_WorkShopProcessWIPSumReport.html | 59 +++++++++
WebTM/views/grf/工序在制报表.grf | 191 +++++++++++++++++++++++++++++++
WebTM/views/车间管理/报表分析/Kf_MateOutSumReport_QiaoYi.html | 58 +++++++++
WebTM/views/Baseset/SRM_OpenTmpList.html | 26 +++
WebTM/WebTM.csproj | 1
5 files changed, 326 insertions(+), 9 deletions(-)
diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj
index 31b8a2c..cdc6c79 100644
--- a/WebTM/WebTM.csproj
+++ b/WebTM/WebTM.csproj
@@ -472,6 +472,7 @@
<Content Include="views\grf\cs10.grf" />
<Content Include="views\grf\鎸囧紩鍗�1.grf" />
<Content Include="views\grf\鐢熶骇棰嗘枡鍗�.grf" />
+ <Content Include="views\grf\宸ュ簭鍦ㄥ埗鎶ヨ〃.grf" />
<None Include="Web.Debug.config">
<DependentUpon>Web.config</DependentUpon>
</None>
diff --git a/WebTM/views/Baseset/SRM_OpenTmpList.html b/WebTM/views/Baseset/SRM_OpenTmpList.html
index 42c44c5..0e31bc1 100644
--- a/WebTM/views/Baseset/SRM_OpenTmpList.html
+++ b/WebTM/views/Baseset/SRM_OpenTmpList.html
@@ -22,6 +22,7 @@
<button type="button" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="Del">鍒犻櫎</button>
<button type="button" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="Reload">鍒锋柊</button>
<button type="button" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="Select">閫夋嫨</button>
+ <button type="button" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="ReportPrint">鎶ヨ〃鎵撳嵃</button>
<button type="button" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="Exit">閫�鍑�</button>
<button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="HideColumn" id="HideColumn">闅愯棌鍒楄缃�</button>
</div>
@@ -56,7 +57,7 @@
var option = [];
var HModName = "SRM_OpenTmpList";
- option={
+ option = {
elem: '#mainTable'
// , url: '/demo/table/user/'
, data: []
@@ -116,7 +117,7 @@
ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
//table.reload('mainTable', {
// data: ajaxReturnData
-
+
//});
option.data = ajaxReturnData;
table.render(option);
@@ -236,7 +237,7 @@
element.tabDelete('tabDemo', '2'); //鍒犻櫎
});
- form.on('submit(Select)', function (data) {//閫夋嫨
+ form.on('submit(Select)', function (data) {//鎶ヨ〃鎵撳嵃
var checkStatus = table.checkStatus('mainTable')
, data = checkStatus.data;
var OpenTmp = data[0].妯℃澘鍚嶇О;
@@ -253,6 +254,7 @@
url = "UpdatePOInStockBillPrintQty"
break;
}
+
//鏇存柊鎵撳嵃鏁伴噺
//$.ajax(
// {
@@ -270,10 +272,24 @@
// }
// });
+
//鍏抽棴褰撳墠绐楀彛
var index = parent.layer.getFrameIndex(window.name);
parent.layer.close(index);
});
+
+ form.on('submit(ReportPrint)', function (data) {//閫夋嫨
+ var checkStatus = table.checkStatus('mainTable')
+ , data = checkStatus.data;
+
+ if (data.length == 0) {
+ return layer.msg("璇烽�夋嫨妯＄増!");
+ }
+ parent.ReportPrint(data);
+ //鍏抽棴褰撳墠绐楀彛
+ var index = parent.layer.getFrameIndex(window.name);
+ parent.layer.close(index);
+ })
//闅愯棌鍒楄缃�
form.on('submit(HideColumn)', function (data) {
@@ -291,7 +307,7 @@
function get_HideColumn() {
var colName = "";
var contentUrl = "";
- for (var i = 1; i < option.cols[0].length ; i++) {
+ for (var i = 1; i < option.cols[0].length; i++) {
colName += option.cols[0][i]["title"] + ",";
}
var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞
@@ -302,7 +318,7 @@
colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
-
+
layer.open({
type: 2
, skin: "layui-layer-rim" //鍔犱笂杈规
diff --git "a/WebTM/views/grf/\345\267\245\345\272\217\345\234\250\345\210\266\346\212\245\350\241\250.grf" "b/WebTM/views/grf/\345\267\245\345\272\217\345\234\250\345\210\266\346\212\245\350\241\250.grf"
new file mode 100644
index 0000000..546bafa
--- /dev/null
+++ "b/WebTM/views/grf/\345\267\245\345\272\217\345\234\250\345\210\266\346\212\245\350\241\250.grf"
@@ -0,0 +1,191 @@
+锘縶
+ "Version":"6.0.0.6",
+ "Title":"1a.绠�鍗曡〃鏍�",
+ "Author":"閿愭氮鎶ヨ〃杞欢",
+ "Description":"婕旂ず涓�涓渶鍩烘湰鐨勫垪琛ㄦ姤琛ㄣ��",
+ "Font":{
+ "Name":"瀹嬩綋",
+ "Size":90000,
+ "Weight":400,
+ "Charset":134
+ },
+ "Printer":{
+ "Size":256,
+ "Height":33,
+ "TopMargin":1.5,
+ "BottomMargin":1.5
+ },
+ "DetailGrid":{
+ "Recordset":{
+ "Field":[
+ {
+ "Name":"鏃ユ湡",
+ "Type":"DateTime"
+ },
+ {
+ "Name":"鐗╂枡浠ｇ爜",
+ "DBFieldName":"HMaterNumber"
+ },
+ {
+ "Name":"鐗╂枡鍚嶇О",
+ "DBFieldName":"HMaterName"
+ },
+ {
+ "Name":"鐢ㄩ噺锛堚�帮級",
+ "DBFieldName":"HRate"
+ },
+ {
+ "Name":"閲嶉噺锛堝厠锛�",
+ "DBFieldName":"HQty"
+ },
+ {
+ "Name":"鍗曚綅",
+ "DBFieldName":"HUnitName"
+ },
+ {
+ "Name":"鏌撴枡鎬婚噺锛堝叕鏂わ級锛�"
+ },
+ {
+ "Name":"鍔╁墏鎬婚噺锛堝叕鏂わ級锛�"
+ }
+ ]
+ },
+ "Column":[
+ {
+ "Name":"Column1",
+ "Width":3.57188
+ },
+ {
+ "Name":"Column2",
+ "Width":4.39208
+ },
+ {
+ "Name":"Column3",
+ "Width":4.41854
+ },
+ {
+ "Name":"Column4",
+ "Width":4.60375
+ },
+ {
+ "Name":"Column5",
+ "Width":2.59292
+ }
+ ],
+ "ColumnContent":{
+ "Height":0.608542,
+ "ColumnContentCell":[
+ {
+ "Column":"Column1",
+ "TextAlign":"MiddleCenter",
+ "DataField":"鐗╂枡浠ｇ爜"
+ },
+ {
+ "Column":"Column2",
+ "TextAlign":"MiddleCenter",
+ "DataField":"鐗╂枡鍚嶇О"
+ },
+ {
+ "Column":"Column3",
+ "TextAlign":"MiddleCenter",
+ "DataField":"鐢ㄩ噺锛堚�帮級"
+ },
+ {
+ "Column":"Column4",
+ "TextAlign":"MiddleCenter",
+ "DataField":"閲嶉噺锛堝厠锛�"
+ },
+ {
+ "Column":"Column5",
+ "TextAlign":"MiddleCenter",
+ "DataField":"鍗曚綅"
+ }
+ ]
+ },
+ "ColumnTitle":{
+ "Height":0.608542,
+ "ColumnTitleCell":[
+ {
+ "GroupTitle":false,
+ "Column":"Column1",
+ "TextAlign":"TopCenter",
+ "Text":"鐗╂枡浠ｇ爜\r\n"
+ },
+ {
+ "GroupTitle":false,
+ "Column":"Column2",
+ "TextAlign":"TopCenter",
+ "Text":"鐗╂枡鍚嶇О\r\n"
+ },
+ {
+ "GroupTitle":false,
+ "Column":"Column3",
+ "TextAlign":"TopCenter",
+ "Text":"鐢ㄩ噺锛堚�帮級"
+ },
+ {
+ "GroupTitle":false,
+ "Column":"Column4",
+ "TextAlign":"TopCenter",
+ "Text":"閲嶉噺锛堝厠锛�"
+ },
+ {
+ "GroupTitle":false,
+ "Column":"Column5",
+ "TextAlign":"TopCenter",
+ "Text":"鍗曚綅"
+ }
+ ]
+ }
+ },
+ "ReportHeader":[
+ {
+ "Name":"ReportHeader2",
+ "Height":2.59292,
+ "Control":[
+ {
+ "Type":"MemoBox",
+ "Name":"MemoBox1",
+ "Left":6.00604,
+ "Top":0.396875,
+ "Width":5.18583,
+ "Height":0.608542,
+ "Font":{
+ "Name":"瀹嬩綋",
+ "Size":157500,
+ "Weight":400,
+ "Charset":134
+ },
+ "Text":"鐢熶骇棰嗘枡姹囨��"
+ },
+ {
+ "Type":"MemoBox",
+ "Name":"MemoBox5",
+ "Left":0.79375,
+ "Top":1.19063,
+ "Width":7.19667,
+ "Height":0.608542,
+ "Text":"鏃ユ湡锛歔#鏃ユ湡#]"
+ },
+ {
+ "Type":"MemoBox",
+ "Name":"MemoBox6",
+ "Left":0.79375,
+ "Top":1.79917,
+ "Width":7.19667,
+ "Height":0.608542,
+ "Text":"[#鏌撴枡鎬婚噺锛堝叕鏂わ級锛�#]"
+ },
+ {
+ "Type":"MemoBox",
+ "Name":"MemoBox4",
+ "Left":7.99042,
+ "Top":1.79917,
+ "Width":8.20208,
+ "Height":0.608542,
+ "Text":"[#鍔╁墏鎬婚噺锛堝叕鏂わ級锛�#]"
+ }
+ ]
+ }
+ ]
+}
\ No newline at end of file
diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_MateOutSumReport_QiaoYi.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_MateOutSumReport_QiaoYi.html"
index 7cd9543..4b03ac1 100644
--- "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_MateOutSumReport_QiaoYi.html"
+++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_MateOutSumReport_QiaoYi.html"
@@ -15,6 +15,7 @@
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
<script src="../../../layuiadmin/PubCustom.js"></script>
<script src="../../../layuiadmin/HideButton.js"></script>
+ <script src="../../../layuiadmin/grwebapp.js"></script>
<style>
.layui-form-select .layui-input {
padding-right: 15px;
@@ -86,6 +87,7 @@
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>淇濆瓨鍒楀</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>榛樿鍒楀</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Print" id="get_Print"><i class="layui-icon layui-icon-form"></i>鎵撳嵃</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
</div>
</script>
@@ -95,6 +97,9 @@
</div>
</div>
<script>
+
+ var OptionData = [];
+
//#region 鎶樺彔娉ㄩ噴
//#endregion
layui.config({
@@ -282,6 +287,9 @@
break;
//鍒楄缃�
case 'btn_HideColumn': get_HideColumn();
+ break;
+ case 'get_Print':
+ get_Print();
break;
};
});
@@ -491,6 +499,49 @@
}
//#endregion
+ //鎵撳嵃鎶ヨ〃
+ function get_Print() {
+ layer.open({
+ type: 2
+ , area: ['80%', '80%']
+ , title: '鎵撳嵃妯＄増閫夋嫨'
+ , shade: 0.6 //閬僵閫忔槑搴�
+ , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+ , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+ , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=0&MyMsg=0&Type=Sc_WorkShopProcessWIPSumReport', 'yes']
+ , resize: false
+ , end: function () {
+ console.log(OptionData);
+ if (OptionData.length > 0) {
+ var GrfName = OptionData[0].HName;
+ if (option.data.length != 0) {
+ var dataPrint = [];
+ for (var i = 0; i < option.data.length; i++) {
+ dataPrint.push(option.data[i])
+ }
+
+ var Customer = {
+ "Table": dataPrint
+ }
+
+ var args = {
+ type: "preview",
+ //showOptionDlg: false, //濡傛灉涓嶆樉绀烘墦鍗板璇濇鑰岀洿鎺ユ墦鍗帮紝灏嗘琛屾敞閲婂幓鎺夊嵆鍙�
+ report: urlAddRandomNo("../../grf/" + GrfName + ".grf"),
+ data: Customer
+ };
+
+ //var args = {
+ // report: urlAddRandomNo("../../grf/cs10.grf"),
+ // data: Customer
+ //};
+ webapp_ws_ajax_run(args);
+ }
+ }
+ }
+ })
+ }
+
//#region 闅愯棌鍒楄缃�
function get_HideColumn() {
var colName = "";
@@ -524,9 +575,10 @@
});
-
-
-
+ //鍙屽嚮杩斿洖鐢熶骇璧勬簮
+ function ReportPrint(data) {
+ OptionData = data
+ }
</script>
</body>
diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopProcessWIPSumReport.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopProcessWIPSumReport.html"
index f70e663..5c47b2d 100644
--- "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopProcessWIPSumReport.html"
+++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_WorkShopProcessWIPSumReport.html"
@@ -14,6 +14,7 @@
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
<script src="../../../layuiadmin/PubCustom.js"></script>
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
+ <script src="../../../layuiadmin/grwebapp.js"></script>
<style type="text/css">
input.layui-input.layui-unselect {
padding-right: 0;
@@ -118,6 +119,7 @@
<script type="text/html" id="toolbarDemo">
<div class="layui-btn-container">
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Print"><i class="layui-icon layui-icon-return"></i>鎵撳嵃</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>闅愯棌鍒楄缃�</button>
</div>
</script>
@@ -128,6 +130,7 @@
</div>
<script>
+ var OptionData = [];
layui.config({
base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
@@ -168,6 +171,11 @@
case 'HideColumn':
get_HideColumn();
break;
+ //闅愯棌鍒楄缃�
+ case 'btn-Print':
+ get_Print();
+ break;
+
};
});
//閲嶇疆鎸夐挳
@@ -224,7 +232,7 @@
$.ajax({
url: GetWEBURL() + '/Mes_OrderProcFlowAllReport/WorkShopProcessWIPSumReport',
type: "GET",
- data: { "sWhere": sWhere },
+ data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]},
success: function (data1) {
var col = [];
if (data1.count == 1) {
@@ -375,6 +383,50 @@
})
}
+ //鎵撳嵃鎶ヨ〃
+ function get_Print() {
+ layer.open({
+ type: 2
+ , area: ['80%', '80%']
+ , title: '鎵撳嵃妯＄増閫夋嫨'
+ , shade: 0.6 //閬僵閫忔槑搴�
+ , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
+ , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
+ , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=0&MyMsg=0&Type=Sc_WorkShopProcessWIPSumReport', 'yes']
+ , resize: false
+ , end: function () {
+ console.log(OptionData);
+ if (OptionData.length > 0) {
+ var GrfName = OptionData[0].HName;
+ if (option.data.length != 0) {
+ var dataPrint = [];
+ for (var i = 0; i < option.data.length; i++) {
+ dataPrint.push(option.data[i])
+ }
+
+ var Customer = {
+ "Table": dataPrint
+ }
+
+ var args = {
+ type: "preview",
+ //showOptionDlg: false, //濡傛灉涓嶆樉绀烘墦鍗板璇濇鑰岀洿鎺ユ墦鍗帮紝灏嗘琛屾敞閲婂幓鎺夊嵆鍙�
+ report: urlAddRandomNo("../../grf/" + GrfName + ".grf"),
+ data: Customer
+ };
+
+ console.log(option.data[0].鍗曟嵁鍙�);
+ //var args = {
+ // report: urlAddRandomNo("../../grf/cs10.grf"),
+ // data: Customer
+ //};
+ webapp_ws_ajax_run(args);
+ }
+ }
+ }
+ })
+ }
+
//鏄剧ず鍒楁暟鎹�
function DisPlay_HideColumn() {
$.ajax({
@@ -454,6 +506,11 @@
//#endregion
});
+
+ //鍙屽嚮杩斿洖鐢熶骇璧勬簮
+ function ReportPrint(data) {
+ OptionData = data
+ }
</script>
</body>
</html>
\ No newline at end of file
--
Gitblit v1.9.1