From 5e807ffc4667c3e3d7ccc079044fa8f4ea91fdaa Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期三, 17 七月 2024 13:14:06 +0800
Subject: [PATCH] 采购订单等模块测试修改
---
WebTM/views/仓存管理/条码报表/Kf_BarCodeOutInReport.html | 105 ++++----
WebTM/views/采购管理/付款单/YF_PayMentBillList.html | 16
WebTM/views/基础资料/公用基础资料/xmlLBM_HPayMentBill.aspx.designer.cs | 26 ++
WebTM/views/采购管理/收料通知单/Cg_POInStockBillList.html | 13
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBillByID.aspx.cs | 17 +
WebTM/views/基础资料/公用基础资料/xmlLBM_HPayMentBill.aspx.cs | 17 +
WebTM/Vlog/webapi20240717.txt | 265 ++++++++++++++++++++++++
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBill.aspx | 27 ++
WebTM/views/验收入库/外购入库/Kf_POStockInBillList.html | 2
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBill.aspx.cs | 17 +
WebTM/views/基础资料/公用基础资料/HBarPlanPrint.html | 9
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBill.aspx.designer.cs | 26 ++
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBillByID.aspx | 27 ++
WebTM/views/基础资料/公用基础资料/xmlLBM_HPOStockInBillByID.aspx.designer.cs | 26 ++
WebTM/views/验收入库/外购入库/Add_Edit_Kf_POStockInBillList.html | 2
WebTM/WebTM.csproj | 24 ++
WebTM/views/基础资料/公用基础资料/xmlLBM_HPayMentBill.aspx | 27 ++
17 files changed, 580 insertions(+), 66 deletions(-)
diff --git a/WebTM/Vlog/webapi20240717.txt b/WebTM/Vlog/webapi20240717.txt
new file mode 100644
index 0000000..6e42254
--- /dev/null
+++ b/WebTM/Vlog/webapi20240717.txt
@@ -0,0 +1,265 @@
+2024/7/17 8:14:12 鎵撳嵃sql:select * from h_v_IF_POOrderBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(135800102413) order by hmainid desc
+
+2024/7/17 8:14:12 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 8:14:12 ReportDataSet:1
+
+2024/7/17 8:18:41 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(10070000101161) order by hmainid desc
+
+2024/7/17 8:18:41 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 8:18:41 ReportDataSet:1
+
+2024/7/17 8:19:24 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(1373459300100818) order by hmainid desc
+
+2024/7/17 8:19:24 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 8:19:24 ReportDataSet:0
+
+2024/7/17 8:47:51 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid = order by hmainid desc
+
+2024/7/17 8:49:12 鎵撳嵃sql:select * from h_v_Kf_POStockInBillList where where cast( hmainid as bigint)*POWER(10,8)+hsubid in(1373459300100818) order by hmainid desc
+
+2024/7/17 8:51:56 鎵撳嵃sql:select * from h_v_Kf_POStockInBillList where where cast( hmainid as bigint)*POWER(10,8)+hsubid in(1373459300100818) order by hmainid desc
+
+2024/7/17 8:54:32 鎵撳嵃sql:select * from h_v_Kf_POStockInBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(1373459300100818) order by hmainid desc
+
+2024/7/17 8:54:32 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 8:54:32 ReportDataSet:1
+
+2024/7/17 8:54:47 鎵撳嵃sql:select * from h_v_Kf_POStockInBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(1373459300100818) order by hmainid desc
+
+2024/7/17 8:54:48 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 8:54:48 ReportDataSet:1
+
+2024/7/17 9:05:35 鎵撳嵃sql:select * from h_v_Kf_POStockInBillList where hmainid = 13734593 order by hmainid desc
+
+2024/7/17 9:05:35 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:05:35 ReportDataSet:4
+
+2024/7/17 9:16:03 鎵撳嵃sql:select * from h_v_IF_SellOutBillList_EditInit where hmainid = 13734823
+
+2024/7/17 9:16:03 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:16:03 ReportDataSet:3
+
+2024/7/17 9:16:55 鎵撳嵃sql:select * from h_v_IF_SellOutBillList_EditInit where hmainid = 13734823
+
+2024/7/17 9:16:55 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:16:55 ReportDataSet:3
+
+2024/7/17 9:23:39 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in() order by hmainid desc
+
+2024/7/17 9:24:51 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:24:52 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:24:52 ReportDataSet:0
+
+2024/7/17 9:29:24 鎵撳嵃sql:select * from h_v_IF_SeOutStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(56500100123,56500100125) order by hmainid desc
+
+2024/7/17 9:29:24 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:29:24 ReportDataSet:2
+
+2024/7/17 9:30:41 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:30:41 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:30:41 ReportDataSet:0
+
+2024/7/17 9:32:38 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:32:38 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:32:38 ReportDataSet:4
+
+2024/7/17 9:33:27 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 9:33:27 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:33:27 ReportDataSet:0
+
+2024/7/17 9:38:00 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 9:38:00 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:38:00 ReportDataSet:0
+
+2024/7/17 9:38:21 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:38:21 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:38:21 ReportDataSet:0
+
+2024/7/17 9:38:33 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:38:33 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:38:33 ReportDataSet:0
+
+2024/7/17 9:39:37 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:39:37 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:39:37 ReportDataSet:4
+
+2024/7/17 9:39:42 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:39:42 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:39:42 ReportDataSet:4
+
+2024/7/17 9:42:44 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 9:42:44 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:42:44 ReportDataSet:0
+
+2024/7/17 9:43:17 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:43:17 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:43:17 ReportDataSet:0
+
+2024/7/17 9:44:02 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:44:03 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:44:03 ReportDataSet:0
+
+2024/7/17 9:44:16 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:44:16 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:44:16 ReportDataSet:0
+
+2024/7/17 9:44:48 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:44:48 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:44:48 ReportDataSet:0
+
+2024/7/17 9:45:12 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:45:12 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:45:12 ReportDataSet:0
+
+2024/7/17 9:45:16 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 9:45:16 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:45:16 ReportDataSet:0
+
+2024/7/17 9:46:26 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:46:27 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:46:27 ReportDataSet:4
+
+2024/7/17 9:47:15 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:47:15 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:47:15 ReportDataSet:4
+
+2024/7/17 9:47:31 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:47:31 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:47:31 ReportDataSet:4
+
+2024/7/17 9:47:38 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:47:38 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:47:38 ReportDataSet:4
+
+2024/7/17 9:47:40 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:47:40 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:47:40 ReportDataSet:4
+
+2024/7/17 9:47:41 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:47:41 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:47:41 ReportDataSet:4
+
+2024/7/17 9:48:38 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:48:38 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:48:38 ReportDataSet:4
+
+2024/7/17 9:48:39 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:48:39 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:48:39 ReportDataSet:4
+
+2024/7/17 9:49:55 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 9:49:55 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:49:55 ReportDataSet:0
+
+2024/7/17 9:51:21 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where hmainid =1000308593 order by hmainid desc
+
+2024/7/17 9:51:21 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 9:51:21 ReportDataSet:4
+
+2024/7/17 10:04:06 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(42200000000) order by hmainid desc
+
+2024/7/17 10:04:06 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:04:06 ReportDataSet:0
+
+2024/7/17 10:08:40 鎵撳嵃sql:select * from h_v_YF_PayMentBillList where hmainid = 422 order by hmainid desc
+
+2024/7/17 10:08:40 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:08:40 ReportDataSet:1
+
+2024/7/17 10:10:03 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 10:10:03 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:10:03 ReportDataSet:0
+
+2024/7/17 10:13:11 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 10:13:11 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:13:11 ReportDataSet:0
+
+2024/7/17 10:16:39 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 10:16:39 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:16:39 ReportDataSet:0
+
+2024/7/17 10:18:57 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 10:18:57 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:18:57 ReportDataSet:0
+
+2024/7/17 10:19:11 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101150) order by hmainid desc
+
+2024/7/17 10:19:11 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:19:11 ReportDataSet:0
+
+2024/7/17 10:29:18 鎵撳嵃sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100030859300101157) order by hmainid desc
+
+2024/7/17 10:29:18 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
+
+2024/7/17 10:29:18 ReportDataSet:1
diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj
index 879eb76..1b3d8d9 100644
--- a/WebTM/WebTM.csproj
+++ b/WebTM/WebTM.csproj
@@ -349,6 +349,9 @@
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\Gy_PreventErrMould.html" />
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\Gy_WorkCenter_Excel.html" />
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\Gy_UnitConvertRateList.html" />
+ <Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPayMentBill.aspx" />
+ <Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBillByID.aspx" />
+ <Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBill.aspx" />
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOInStockBillByID.aspx" />
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HSeOutStockBillListByID.aspx" />
<Content Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_Kf_SellOutBillListByID.aspx" />
@@ -2157,6 +2160,27 @@
<Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HGy_FixCard.aspx.designer.cs">
<DependentUpon>xmlLBM_HGy_FixCard.aspx</DependentUpon>
</Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPayMentBill.aspx.cs">
+ <DependentUpon>xmlLBM_HPayMentBill.aspx</DependentUpon>
+ <SubType>ASPXCodeBehind</SubType>
+ </Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPayMentBill.aspx.designer.cs">
+ <DependentUpon>xmlLBM_HPayMentBill.aspx</DependentUpon>
+ </Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBillByID.aspx.cs">
+ <DependentUpon>xmlLBM_HPOStockInBillByID.aspx</DependentUpon>
+ <SubType>ASPXCodeBehind</SubType>
+ </Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBillByID.aspx.designer.cs">
+ <DependentUpon>xmlLBM_HPOStockInBillByID.aspx</DependentUpon>
+ </Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBill.aspx.cs">
+ <DependentUpon>xmlLBM_HPOStockInBill.aspx</DependentUpon>
+ <SubType>ASPXCodeBehind</SubType>
+ </Compile>
+ <Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOStockInBill.aspx.designer.cs">
+ <DependentUpon>xmlLBM_HPOStockInBill.aspx</DependentUpon>
+ </Compile>
<Compile Include="views\鍩虹璧勬枡\鍏敤鍩虹璧勬枡\xmlLBM_HPOInStockBillByID.aspx.cs">
<DependentUpon>xmlLBM_HPOInStockBillByID.aspx</DependentUpon>
<SubType>ASPXCodeBehind</SubType>
diff --git "a/WebTM/views/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\346\212\245\350\241\250/Kf_BarCodeOutInReport.html" "b/WebTM/views/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\346\212\245\350\241\250/Kf_BarCodeOutInReport.html"
index c5d468f..583d5d6 100644
--- "a/WebTM/views/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\346\212\245\350\241\250/Kf_BarCodeOutInReport.html"
+++ "b/WebTM/views/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\346\212\245\350\241\250/Kf_BarCodeOutInReport.html"
@@ -418,68 +418,67 @@
async: false, //async鐢ㄤ簬鎺у埗锛坒alse锛夊悓姝ュ拰锛坱rue锛夊紓姝ワ紝榛樿鐨勬槸true锛屽嵆璇锋眰榛樿鐨勬槸寮傛璇锋眰
data: { "sWhere": sWhere },
success: function (data1) {
- if (data1.count == 1) {
- var data = [];
- var col = [];
- //缁欑┖鐨勬暟缁勮祴鍊�
- for (var key in data1.list) {
- //鍔ㄦ�佽幏鍙栧垪琛ㄦ墍鏈夊垪鍚�
- data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
- //鑾峰彇涓嶉渶瑕佹樉绀虹殑鍒楋紙H寮�澶寸殑鍒椾笉鏄剧ず锛�
- var patrn = new RegExp(/^h/i);
- if (patrn.test(data1.list[key].ColmCols)) {
- titleData[key] = data1.list[key].ColmCols;
- }
+ //鏃犺鏈夋棤鏁版嵁鍏堝姞杞絚ol
+ var data = [];
+ var col = [];
+ //缁欑┖鐨勬暟缁勮祴鍊�
+ for (var key in data1.list) {
+ //鍔ㄦ�佽幏鍙栧垪琛ㄦ墍鏈夊垪鍚�
+ data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
+ //鑾峰彇涓嶉渶瑕佹樉绀虹殑鍒楋紙H寮�澶寸殑鍒椾笉鏄剧ず锛�
+ var patrn = new RegExp(/^h/i);
+ if (patrn.test(data1.list[key].ColmCols)) {
+ titleData[key] = data1.list[key].ColmCols;
}
+ }
- //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
- col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
- for (var i = 0; i < data.length; i++) {
- if ($.inArray(data[i].name, titleData) > -1) {
- col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
- }
- else {
- switch (data[i].Type) {
- //int
- case 'DateTime':
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
- break;
- case 'long':
- case 'Int32':
- case 'Int64':
- case 'double':
- case 'Decimal':
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
- break;
- default:
- if (data[i].name == '鏁伴噺') {
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
- } else {
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
- }
- }
- }
- }
-
- columns = col;
-
- //璁剧疆璧嬪�煎垪瀹�
- var colWidth = getColumnsWidth();
- if (colWidth == "" || colWidth == []) {
-
+ //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
+ col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
+ for (var i = 0; i < data.length; i++) {
+ if ($.inArray(data[i].name, titleData) > -1) {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
}
else {
- $.each(columns, function (x, m) {
- m["width"] = colWidth[x];
- });
+ switch (data[i].Type) {
+ //int
+ case 'DateTime':
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
+ break;
+ case 'long':
+ case 'Int32':
+ case 'Int64':
+ case 'double':
+ case 'Decimal':
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
+ break;
+ default:
+ if (data[i].name == '鏁伴噺') {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
+ } else {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
+ }
+ }
}
- option.cols = [columns];
+ }
+
+ columns = col;
+
+ //璁剧疆璧嬪�煎垪瀹�
+ var colWidth = getColumnsWidth();
+ if (colWidth == "" || colWidth == []) {
+
+ }
+ else {
+ $.each(columns, function (x, m) {
+ m["width"] = colWidth[x];
+ });
+ }
+ option.cols = [columns];
+ if (data1.count == 1) {
option.data = data1.data;
option.totalRow = true;
table.render(option);
ins = table.render(option);
- //鍒锋柊琛ㄦ牸鏁版嵁
- DisPlay_HideColumn();
layer.close(ajaxLoad);
} else {
layer.close(ajaxLoad);
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/HBarPlanPrint.html" "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/HBarPlanPrint.html"
index 08abc55..696cee9 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/HBarPlanPrint.html"
+++ "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/HBarPlanPrint.html"
@@ -149,6 +149,9 @@
case "ICStockBill"://閿�鍞��璐у崟鎵撳嵃
CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_ICStockBill.aspx?linterid=" + value, true, "");
break;
+ case "HPayMentBill"://浠樻鍗�
+ CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPayMentBill.aspx?linterid=" + value, true, "");
+ break;
case "HGy_BarCodeBill"://鏉＄爜鎵撳嵃
CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HGy_BarCodeBill.aspx?linterid=" + value, true, "");
break;
@@ -164,6 +167,12 @@
case "HPOInStockBillByID"://鏀舵枡閫氱煡鍗�2鎵撳嵃
CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPOInStockBillByID.aspx?linterid=" + value, true, "");
break;
+ case "HPOStockInBill"://閲囪喘鍏ュ簱鍗�
+ CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPOStockInBill.aspx?linterid=" + value, true, "");
+ break;
+ case "HPOStockInBillByID"://閲囪喘鍏ュ簱鍗�2缂栬緫鎵撳嵃
+ CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPOStockInBillByID.aspx?linterid=" + value, true, "");
+ break;
case "HICMOBillList"://鐢熶骇璁㈠崟鎵撳嵃
CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HICMOBillList.aspx?linterid=" + value, true, "");
break;
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_HPOStockInBill.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_HPOStockInBill.aspx"
new file mode 100644
index 0000000..db805ce
--- /dev/null
+++ "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_HPOStockInBill.aspx"
@@ -0,0 +1,27 @@
+锘�<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_HPOStockInBill.aspx.cs" Inherits="WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡.xmlLBM_HPOStockInBill" %>
+
+<!DOCTYPE html>
+
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head runat="server">
+<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渚嬪瓙鏁版嵁搴撲腑鑾峰彇鎶ヨ〃鏁版嵁
+
+ //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
+ SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(" + Request.Params["linterid"] + ") order by hmainid desc");
+ }
+ </script>
+</head>
+<body>
+ <form id="form1" runat="server">
+ <div>
+ </div>
+ </form>
+</body>
+</html>
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_HPOStockInBill.aspx.cs" "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_HPOStockInBill.aspx.cs"
new file mode 100644
index 0000000..292380f
--- /dev/null
+++ "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_HPOStockInBill.aspx.cs"
@@ -0,0 +1,17 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+using System.Web.UI;
+using System.Web.UI.WebControls;
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+ public partial class xmlLBM_HPOStockInBill : System.Web.UI.Page
+ {
+ protected void Page_Load(object sender, EventArgs e)
+ {
+
+ }
+ }
+}
\ No newline at end of file
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_HPOStockInBill.aspx.designer.cs" "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_HPOStockInBill.aspx.designer.cs"
new file mode 100644
index 0000000..e228c8f
--- /dev/null
+++ "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_HPOStockInBill.aspx.designer.cs"
@@ -0,0 +1,26 @@
+锘�//------------------------------------------------------------------------------
+// <鑷姩鐢熸垚>
+// 姝や唬鐮佺敱宸ュ叿鐢熸垚銆�
+//
+// 瀵规鏂囦欢鐨勬洿鏀瑰彲鑳藉鑷翠笉姝ｇ‘鐨勮涓猴紝濡傛灉
+// 閲嶆柊鐢熸垚浠ｇ爜锛屽垯鎵�鍋氭洿鏀瑰皢涓㈠け銆�
+// </鑷姩鐢熸垚>
+//------------------------------------------------------------------------------
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+
+
+ public partial class xmlLBM_HPOStockInBill
+ {
+
+ /// <summary>
+ /// form1 鎺т欢銆�
+ /// </summary>
+ /// <remarks>
+ /// 鑷姩鐢熸垚鐨勫瓧娈点��
+ /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛０鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+ /// </remarks>
+ protected global::System.Web.UI.HtmlControls.HtmlForm form1;
+ }
+}
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_HPOStockInBillByID.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_HPOStockInBillByID.aspx"
new file mode 100644
index 0000000..e3bf481
--- /dev/null
+++ "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_HPOStockInBillByID.aspx"
@@ -0,0 +1,27 @@
+锘�<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_HPOStockInBillByID.aspx.cs" Inherits="WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡.xmlLBM_HPOStockInBillByID" %>
+
+<!DOCTYPE html>
+
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head runat="server">
+<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渚嬪瓙鏁版嵁搴撲腑鑾峰彇鎶ヨ〃鏁版嵁
+
+ //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
+ SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList where hmainid = " + Request.Params["linterid"] + " order by hmainid desc");
+ }
+ </script>
+</head>
+<body>
+ <form id="form1" runat="server">
+ <div>
+ </div>
+ </form>
+</body>
+</html>
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_HPOStockInBillByID.aspx.cs" "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_HPOStockInBillByID.aspx.cs"
new file mode 100644
index 0000000..d351d28
--- /dev/null
+++ "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_HPOStockInBillByID.aspx.cs"
@@ -0,0 +1,17 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+using System.Web.UI;
+using System.Web.UI.WebControls;
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+ public partial class xmlLBM_HPOStockInBillByID : System.Web.UI.Page
+ {
+ protected void Page_Load(object sender, EventArgs e)
+ {
+
+ }
+ }
+}
\ No newline at end of file
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_HPOStockInBillByID.aspx.designer.cs" "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_HPOStockInBillByID.aspx.designer.cs"
new file mode 100644
index 0000000..f74dd5c
--- /dev/null
+++ "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_HPOStockInBillByID.aspx.designer.cs"
@@ -0,0 +1,26 @@
+锘�//------------------------------------------------------------------------------
+// <鑷姩鐢熸垚>
+// 姝や唬鐮佺敱宸ュ叿鐢熸垚銆�
+//
+// 瀵规鏂囦欢鐨勬洿鏀瑰彲鑳藉鑷翠笉姝ｇ‘鐨勮涓猴紝濡傛灉
+// 閲嶆柊鐢熸垚浠ｇ爜锛屽垯鎵�鍋氭洿鏀瑰皢涓㈠け銆�
+// </鑷姩鐢熸垚>
+//------------------------------------------------------------------------------
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+
+
+ public partial class xmlLBM_HPOStockInBillByID
+ {
+
+ /// <summary>
+ /// form1 鎺т欢銆�
+ /// </summary>
+ /// <remarks>
+ /// 鑷姩鐢熸垚鐨勫瓧娈点��
+ /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛０鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+ /// </remarks>
+ protected global::System.Web.UI.HtmlControls.HtmlForm form1;
+ }
+}
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_HPayMentBill.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_HPayMentBill.aspx"
new file mode 100644
index 0000000..e05f12c
--- /dev/null
+++ "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_HPayMentBill.aspx"
@@ -0,0 +1,27 @@
+锘�<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_HPayMentBill.aspx.cs" Inherits="WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡.xmlLBM_HPayMentBill" %>
+
+<!DOCTYPE html>
+
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head runat="server">
+<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渚嬪瓙鏁版嵁搴撲腑鑾峰彇鎶ヨ〃鏁版嵁
+
+ //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
+ SqlXMLReportData.GenOneRecordset(this, "select * from h_v_YF_PayMentBillList where hmainid = " + Request.Params["linterid"] + " order by hmainid desc");
+ }
+ </script>
+</head>
+<body>
+ <form id="form1" runat="server">
+ <div>
+ </div>
+ </form>
+</body>
+</html>
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_HPayMentBill.aspx.cs" "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_HPayMentBill.aspx.cs"
new file mode 100644
index 0000000..0a401ee
--- /dev/null
+++ "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_HPayMentBill.aspx.cs"
@@ -0,0 +1,17 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+using System.Web.UI;
+using System.Web.UI.WebControls;
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+ public partial class xmlLBM_HPayMentBill : System.Web.UI.Page
+ {
+ protected void Page_Load(object sender, EventArgs e)
+ {
+
+ }
+ }
+}
\ No newline at end of file
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_HPayMentBill.aspx.designer.cs" "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_HPayMentBill.aspx.designer.cs"
new file mode 100644
index 0000000..4570d0f
--- /dev/null
+++ "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_HPayMentBill.aspx.designer.cs"
@@ -0,0 +1,26 @@
+锘�//------------------------------------------------------------------------------
+// <鑷姩鐢熸垚>
+// 姝や唬鐮佺敱宸ュ叿鐢熸垚銆�
+//
+// 瀵规鏂囦欢鐨勬洿鏀瑰彲鑳藉鑷翠笉姝ｇ‘鐨勮涓猴紝濡傛灉
+// 閲嶆柊鐢熸垚浠ｇ爜锛屽垯鎵�鍋氭洿鏀瑰皢涓㈠け銆�
+// </鑷姩鐢熸垚>
+//------------------------------------------------------------------------------
+
+namespace WebTM.views.鍩虹璧勬枡.鍏敤鍩虹璧勬枡
+{
+
+
+ public partial class xmlLBM_HPayMentBill
+ {
+
+ /// <summary>
+ /// form1 鎺т欢銆�
+ /// </summary>
+ /// <remarks>
+ /// 鑷姩鐢熸垚鐨勫瓧娈点��
+ /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛０鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+ /// </remarks>
+ protected global::System.Web.UI.HtmlControls.HtmlForm form1;
+ }
+}
diff --git "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBillList.html" "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBillList.html"
index 4c67dfb..45d91c8 100644
--- "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBillList.html"
+++ "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\344\273\230\346\254\276\345\215\225/YF_PayMentBillList.html"
@@ -498,7 +498,7 @@
, limit: 50
, limits: [50, 500, 5000, 20000]
, done: function (res, curr, count) {
- soulTable.render(this);
+
}
}
option.cols = [col];
@@ -736,15 +736,15 @@
var checkStatus = table.checkStatus('mainTable')
, data = checkStatus.data;
- if (checkStatus.data.length === 0) {
- return layer.msg('璇烽�夋嫨鏁版嵁鎵撳嵃锛�');
+ if (checkStatus.data.length != 1) {
+ return layer.msg('璇蜂竴琛屾暟鎹墦鍗帮紒');
}
else {
- var hmainid = [];
- for (var i = 0; i < checkStatus.data.length; i++) {
- hmainid.push((data[i].hmainid * (10 ** 8)) + data[i].hsubid)
- }
+ //var hmainid = [];
+ //for (var i = 0; i < checkStatus.data.length; i++) {
+ // hmainid.push((data[i].hmainid * (10 ** 8)) + data[i].hsubid)
+ //}
layer.open({
type: 2
@@ -753,7 +753,7 @@
, shade: 0.6 //閬僵閫忔槑搴�
, maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
, anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
- , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + hmainid.toString() + '&MyMsg=' + hmainid.toString() + '&Type=HPayMentBill', 'yes']
+ , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HPayMentBill', 'yes']
, resize: false
})
}
diff --git "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\346\224\266\346\226\231\351\200\232\347\237\245\345\215\225/Cg_POInStockBillList.html" "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\346\224\266\346\226\231\351\200\232\347\237\245\345\215\225/Cg_POInStockBillList.html"
index 8093dbe..b7ee0f5 100644
--- "a/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\346\224\266\346\226\231\351\200\232\347\237\245\345\215\225/Cg_POInStockBillList.html"
+++ "b/WebTM/views/\351\207\207\350\264\255\347\256\241\347\220\206/\346\224\266\346\226\231\351\200\232\347\237\245\345\215\225/Cg_POInStockBillList.html"
@@ -1134,9 +1134,8 @@
var hmainid = [];
for (var i = 0; i < checkStatus.data.length; i++) {
- hmainid.push((data[i].hmainid * (10 ** 8)) + data[i].hsubid)
+ hmainid.push(data[i].hmainid.toString() + padStart(data[i].hsubid.toString(),8))
}
-
layer.open({
type: 2
, area: ['50%', '50%']
@@ -1149,7 +1148,15 @@
})
}
}
-
+ //瀛楃涓茶ˉ闆�
+ function padStart(str, targetLength, padString) {
+ padString = padString || '0';
+ targetLength = targetLength || 8;
+ while (str.length < targetLength) {
+ str = padString + str;
+ }
+ return str;
+ }
//鎵撳嵃1鏀舵枡鍗�
function get_PrintReport1() {
var checkStatus = table.checkStatus('mainTable')
diff --git "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Add_Edit_Kf_POStockInBillList.html" "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Add_Edit_Kf_POStockInBillList.html"
index 84d39d3..f01268e 100644
--- "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Add_Edit_Kf_POStockInBillList.html"
+++ "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Add_Edit_Kf_POStockInBillList.html"
@@ -837,7 +837,7 @@
, shade: 0.6 //閬僵閫忔槑搴�
, maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
, anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
- , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + linterid.toString() + '&MyMsg=' + linterid.toString() + '&Type=HPOStockInBillList', 'yes']
+ , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + linterid.toString() + '&MyMsg=' + linterid.toString() + '&Type=HPOStockInBillByID', 'yes']
, resize: false
})
}
diff --git "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Kf_POStockInBillList.html" "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Kf_POStockInBillList.html"
index 70c8e66..41583a4 100644
--- "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Kf_POStockInBillList.html"
+++ "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\244\226\350\264\255\345\205\245\345\272\223/Kf_POStockInBillList.html"
@@ -854,7 +854,7 @@
, shade: 0.6 //閬僵閫忔槑搴�
, maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
, anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
- , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + hmainid.toString() + '&MyMsg=' + hmainid.toString() + '&Type=HPOInStockBill', 'yes']
+ , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + hmainid.toString() + '&MyMsg=' + hmainid.toString() + '&Type=HPOStockInBill', 'yes']
, resize: false
})
}
--
Gitblit v1.9.1