From 3539ec908704e7884fcfb882d67579ae35e5a3a8 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 20 四月 2022 10:44:09 +0800
Subject: [PATCH] 丸景打印报错
---
WebTM/App_Data/MssqlReportData.cs | 4 ++--
WebTM/views/基础资料/公用基础资料/xmlLBM_MouldScrapOutStockBill.aspx | 24 ++++++++++++------------
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/WebTM/App_Data/MssqlReportData.cs b/WebTM/App_Data/MssqlReportData.cs
index cea7777..47fd479 100644
--- a/WebTM/App_Data/MssqlReportData.cs
+++ b/WebTM/App_Data/MssqlReportData.cs
@@ -20,8 +20,8 @@
//public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//ch娴嬭瘯
//public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//YL娴嬭瘯
//public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//涓镐簳
- //public const string SqlConnStr = "Data Source=192.168.0.200;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//涓镐簳鍦板潃
- public const string SqlConnStr = "Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//闆呯惇璇烘祴璇�
+ public const string SqlConnStr = "Data Source=192.168.0.200;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//涓镐簳鍦板潃
+ //public const string SqlConnStr = "Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//闆呯惇璇烘祴璇�
//public string sServer;
//public string sDataBase;
diff --git "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/xmlLBM_MouldScrapOutStockBill.aspx" "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/xmlLBM_MouldScrapOutStockBill.aspx"
index a9d79d1..e68c0d5 100644
--- "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/xmlLBM_MouldScrapOutStockBill.aspx"
+++ "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/xmlLBM_MouldScrapOutStockBill.aspx"
@@ -4,20 +4,20 @@
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
-<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
+ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
- <script runat="server">
- protected void Page_Load(object sender, EventArgs e)
- {
- //鈽呯壒鍒彁绀衡槄锛�
- //涓嶅悓鐨勬暟鎹簱搴旇閫夌敤涓嶅悓鐨勬姤琛╔ML鏁版嵁鐢熸垚绫伙紝SQL Server鏁版嵁搴撶敤SqlXMLReportData锛孫racle鏁版嵁搴撶敤OracleXMLReportData
- //OledbXMLReportData閫傚悎浜嶢ccess绛夋湰鍦版暟鎹簱锛屼负浜嗘紨绀烘柟渚匡紝杩欓噷浠嶨rid++Report鐨凙ccess渚嬪瓙鏁版嵁搴撲腑鑾峰彇鎶ヨ〃鏁版嵁
+ <script runat="server">
+ protected void Page_Load(object sender, EventArgs e)
+ {
+ //鈽呯壒鍒彁绀衡槄锛�
+ //涓嶅悓鐨勬暟鎹簱搴旇閫夌敤涓嶅悓鐨勬姤琛╔ML鏁版嵁鐢熸垚绫伙紝SQL Server鏁版嵁搴撶敤SqlXMLReportData锛孫racle鏁版嵁搴撶敤OracleXMLReportData
+ //OledbXMLReportData閫傚悎浜嶢ccess绛夋湰鍦版暟鎹簱锛屼负浜嗘紨绀烘柟渚匡紝杩欓噷浠嶨rid++Report鐨凙ccess渚嬪瓙鏁版嵁搴撲腑鑾峰彇鎶ヨ〃鏁版嵁
- //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
- //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781");
- SqlXMLReportData.GenOneRecordset(this, "select MAX(搴撳瓨缁勭粐)搴撳瓨缁勭粐,max(閮ㄩ棬鍚嶇О) 閮ㄩ棬,max(鍗曟嵁鍙�)鍗曟嵁鍙�,浠撳簱鍚嶇О,max(鏃ユ湡)鏃ユ湡,鐗╂枡浠ｇ爜,max(鐗╂枡鍚嶇О)鐗╂枡鍚嶇О,瑙勬牸鍨嬪彿,sum(瀹炲彂鏁伴噺)瀹炲彂鏁伴噺,max(璁￠噺鍗曚綅鍚嶇О)璁￠噺鍗曚綅,瀛愬娉�,瀹℃牳浜� from h_v_Sc_MouldScrapOutHouseBillList where hmainid=" + Request.Params["linterid"]+ " group by 鐗╂枡浠ｇ爜,瑙勬牸鍨嬪彿,鎵规,浠撳簱鍚嶇О,瀹℃牳浜� order by 鍗曟嵁鍙�");
- }
-</script>
+ //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
+ //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781");
+ SqlXMLReportData.GenOneRecordset(this, "select MAX(搴撳瓨缁勭粐)搴撳瓨缁勭粐,max(閮ㄩ棬鍚嶇О) 閮ㄩ棬,max(鍗曟嵁鍙�)鍗曟嵁鍙�,浠撳簱鍚嶇О,max(鏃ユ湡)鏃ユ湡,鐗╂枡浠ｇ爜,max(鐗╂枡鍚嶇О)鐗╂枡鍚嶇О,瑙勬牸鍨嬪彿,sum(瀹炲彂鏁伴噺)瀹炲彂鏁伴噺,max(璁￠噺鍗曚綅鍚嶇О)璁￠噺鍗曚綅,瀛愬娉�,瀹℃牳浜� from h_v_Sc_MouldScrapOutHouseBillList where hmainid=" + Request.Params["linterid"] + " group by 鐗╂枡浠ｇ爜,瑙勬牸鍨嬪彿,鎵规,浠撳簱鍚嶇О,瀛愬娉�,瀹℃牳浜� order by 鍗曟嵁鍙�");
+ }
+ </script>
</head>
<body>
<form id="form1" runat="server">
--
Gitblit v1.9.1