采购订单等模块测试修改

wtt

2024-07-17 5e807ffc4667c3e3d7ccc079044fa8f4ea91fdaa

采购订单等模块测试修改

 WebTM/Vlog/webapi20240717.txt

New file
@@ -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

 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>

 WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_BarCodeOutInReport.html

@@ -418,68 +418,67 @@
                    async: false,    //async用于控制（false）同步和（true）异步，默认的是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;
                                }
                        //无论有无数据先加载col
                        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);

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/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;

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBill.aspx

New file
@@ -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)
        {
            //★特别提示★：
            //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
            //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

            //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>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBill.aspx.cs

New file
@@ -0,0 +1,17 @@
using 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)
        {

        }
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBill.aspx.designer.cs

New file
@@ -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;
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBillByID.aspx

New file
@@ -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)
        {
            //★特别提示★：
            //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
            //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

            //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>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBillByID.aspx.cs

New file
@@ -0,0 +1,17 @@
using 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)
        {

        }
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPOStockInBillByID.aspx.designer.cs

New file
@@ -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;
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPayMentBill.aspx

New file
@@ -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)
        {
            //★特别提示★：
            //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
            //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据

            //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>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPayMentBill.aspx.cs

New file
@@ -0,0 +1,17 @@
using 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)
        {

        }
    }
}

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_HPayMentBill.aspx.designer.cs

New file
@@ -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;
    }
}

 WebTM/views/²É¹º¹ÜÀí/¸¶¿îµ¥/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
                    })
                }

 WebTM/views/²É¹º¹ÜÀí/ÊÕÁÏ֪ͨµ¥/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')

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/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
                })
            }

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/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
                    })
                }