打印条码进行汇总

zzr99

2021-11-09 744cbc7129d926e4a76f88203b8dfacd1d370992

打印条码进行汇总

 WebTM/WebTM.csproj

@@ -141,19 +141,19 @@
    <Content Include="views\grf\器具领用退库单.grf" />
    <Content Include="views\grf\器具领用出库单.grf" />
    <Content Include="views\grf\器具直接调拨单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具其他出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具处理出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具报废入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具改制入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具改制出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具采购入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具其他入库单.grf" />
    <Content Include="views\grf\器具其他入库单.grf" />
    <Content Include="views\grf\器具其他出库单.grf" />
    <Content Include="views\grf\器具处理出库单.grf" />
    <Content Include="views\grf\器具报废入库单.grf" />
    <Content Include="views\grf\器具改制入库单.grf" />
    <Content Include="views\grf\器具改制出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具其他入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具其他出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具处理出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具报废入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具改制入库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具改制出库单.grf" />
    <Content Include="views\基础资料\公用基础资料\grf\器具采购入库单.grf" />
    <None Include="Web.Debug.config">
      <DependentUpon>Web.config</DependentUpon>
    </None>

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ßÆäËûÈë¿âµ¥.grf

@@ -38,7 +38,7 @@
                End
                Item
                    Name='接收单位'
                    DBFieldName='调入组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='物料代码'
@@ -53,7 +53,7 @@
                    Name='计量单位'
                End
                Item
                    Name='实收数量'
                    Name='实发数量'
                End
                Item
                    Name='表体备注'
@@ -232,7 +232,7 @@
                    End
                    WordWrap=T
                    ShrinkFontToFit=T
                    DataField='实收数量'
                    DataField='实发数量'
                End
                Item
                    Column='Column12'
@@ -630,7 +630,7 @@
                                    Width=2.59292
                                    Height=0.396875
                                    TextAlign=MiddleCenter
                                    DataField='实收数量'
                                    DataField='实发数量'
                                End
                            End
                            ColSpan=2

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ßÆäËû³ö¿âµ¥.grf

@@ -34,7 +34,7 @@
                End
                Item
                    Name='发出单位'
                    DBFieldName='调出组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='接收单位'

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ß´¦Àí³ö¿âµ¥.grf

@@ -31,10 +31,11 @@
                End
                Item
                    Name='仓库'
                    DBFieldName='仓库名称'
                End
                Item
                    Name='发出单位'
                    DBFieldName='调出组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='接收单位'
@@ -53,10 +54,11 @@
                    Name='计量单位'
                End
                Item
                    Name='实收数量'
                    Name='实发数量'
                End
                Item
                    Name='表体备注'
                    DBFieldName='子备注'
                End
                Item
                    Name='制单人'
@@ -229,7 +231,7 @@
                    End
                    WordWrap=T
                    ShrinkFontToFit=T
                    DataField='实收数量'
                    DataField='实发数量'
                End
                Item
                    Column='Column12'
@@ -722,7 +724,7 @@
                                    Width=2.59292
                                    Height=0.396875
                                    TextAlign=MiddleCenter
                                    DataField='实收数量'
                                    DataField='实发数量'
                                End
                            End
                            ColSpan=2

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ß±¨·ÏÈë¿âµ¥.grf

@@ -31,6 +31,7 @@
                End
                Item
                    Name='收料仓库'
                    DBFieldName='收料仓库名称'
                End
                Item
                    Name='发出单位'
@@ -38,7 +39,7 @@
                End
                Item
                    Name='接收单位'
                    DBFieldName='调入组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='物料代码'

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ß¸ÄÖÆÈë¿âµ¥.grf

@@ -38,7 +38,7 @@
                End
                Item
                    Name='接收单位'
                    DBFieldName='调入组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='物料代码'
@@ -53,7 +53,7 @@
                    Name='计量单位'
                End
                Item
                    Name='实收数量'
                    Name='实发数量'
                End
                Item
                    Name='子备注'
@@ -232,7 +232,7 @@
                    End
                    WordWrap=T
                    ShrinkFontToFit=T
                    DataField='实收数量'
                    DataField='实发数量'
                End
                Item
                    Column='Column12'
@@ -630,7 +630,7 @@
                                    Width=2.59292
                                    Height=0.396875
                                    TextAlign=MiddleCenter
                                    DataField='实收数量'
                                    DataField='实发数量'
                                End
                            End
                            ColSpan=2

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/grf/Æ÷¾ß¸ÄÖƳö¿âµ¥.grf

@@ -34,7 +34,7 @@
                End
                Item
                    Name='发出单位'
                    DBFieldName='调出组织'
                    DBFieldName='库存组织'
                End
                Item
                    Name='接收单位'
@@ -391,7 +391,7 @@
                    Width=5.42396
                    Height=0.396875
                    TextAlign=MiddleCenter
                    Text='器具其他出库单'
                    Text='器具改制出库单'
                End
                Item
                    Type=MemoBox

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldOtherInBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        SqlXMLReportData.GenOneRecordset(this, "select MAX(库存组织)库存组织,max(部门)部门,max(单据号)单据号,仓库,max(日期)日期,物料代码,max(物料名称)物料名称,规格型号,sum(实发数量)实发数量,max(计量单位)计量单位,max(表体备注)表体备注 from h_v_Sc_MouldOtherInBillList where hmainid=" + Request.Params["linterid"]+ " group by ç‰©æ–™ä»£ç ,规格型号,批次,仓库,表体备注 order by å•æ®å·");
    }
</script>
</head>

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldOtherOutBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        SqlXMLReportData.GenOneRecordset(this, "select ç‰©æ–™ä»£ç ,max(物料名称)物料名称,max(部门)部门,规格型号,sum(实发数量)实发数量,max(计量单位)计量单位,MAX(库存组织)库存组织,max(单据号)单据号,仓库,max(日期)日期,max(表体备注)表体备注 from h_v_Sc_MouldOtherOutBillList where hmainid=" + Request.Params["linterid"]+ " group by ç‰©æ–™ä»£ç ,规格型号,批次,仓库,表体备注 order by å•æ®å·");
    }
</script>
</head>

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldRepairInBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        SqlXMLReportData.GenOneRecordset(this, "select MAX(库存组织)库存组织,max(部门)部门,max(单据号)单据号,仓库,max(日期)日期,物料代码,max(物料名称)物料名称,规格型号,sum(实收数量)实收数量,max(计量单位)计量单位,max(子备注)子备注 from h_v_Sc_MouldRepairInBillList where hmainid=" + Request.Params["linterid"]+ " group by ç‰©æ–™ä»£ç ,规格型号,批次,仓库,子备注 order by å•æ®å·");
    }
</script>
</head>

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldRepairOutBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        SqlXMLReportData.GenOneRecordset(this, "select MAX(库存组织)库存组织,max(部门)部门,max(单据号)单据号,仓库,max(日期)日期,物料代码,max(物料名称)物料名称,规格型号,sum(实收数量)实收数量,max(计量单位)计量单位,max(子备注)子备注 from h_v_Sc_MouldRepairOutBillList where hmainid=" + Request.Params["linterid"]+ " group by ç‰©æ–™ä»£ç ,规格型号,批次,仓库,子备注 order by å•æ®å·");
    }
</script>
</head>

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldScrapInHouseBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        SqlXMLReportData.GenOneRecordset(this, "select MAX(库存组织)库存组织,max(部门名称)部门,max(单据号)单据号,收料仓库名称,max(日期)日期,物料代码,max(物料名称)物料名称,规格型号,sum(实收数量)实收数量,max(计量单位名称)计量单位,max(子备注)子备注 from h_v_Sc_MouldScrapInHouseBillList where hmainid=" + Request.Params["linterid"]+ " group by ç‰©æ–™ä»£ç ,规格型号,批次,收料仓库名称,子备注 order by å•æ®å·");
    }
</script>
</head>

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

@@ -15,7 +15,7 @@

        //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 * from h_v_Sc_MouldScrapOutHouseBillList where hmainid=" + Request.Params["linterid"]+ " order by hsubid");
        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>