销售出库明细报表：导出excel文件中，合计行数据后加单位，增加总合计行

duhe

2024-03-28 34a0367a73048e99b07c7e3f8b45a4bddef75ac7

销售出库明细报表：导出excel文件中，合计行数据后加单位，增加总合计行

 WebTM/Properties/PublishProfiles/JFTM.pubxml.user

Diff too large

 WebTM/WebTM.csproj.user

@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\MES-WEB\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\网站发布\后端代码\MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ProjectFiles</ProjectView>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Kf_SellOutEntryReport.html

@@ -478,14 +478,16 @@
                            HQtyTotalSum = HQtySum + HQtySum_YM;
                            HMoneyTotalSum = HMoneySum + HMoneySum_YM;
                            $("#HPieceQtySum").val(fixed(HPieceQtySum*1));
                            $("#HQtySum").val(fixed(HQtySum.toFixed(2)*1));
                            $("#HMoneySum").val(fixed(HMoneySum.toFixed(2)*1));
                            $("#HQtySum").val(fixed(HQtySum.toFixed(6)*1));
                            $("#HMoneySum").val(fixed(HMoneySum.toFixed(6)*1));
                            $("#HPieceQtySum_YM").val(fixed(HPieceQtySum_YM*1));
                            $("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(2)*1));
                            $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(2)*1));
                            $("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(6)*1));
                            $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6)*1));
                            $("#HPieceQtyTotalSum").val(fixed(HPieceQtyTotalSum*1));
                            $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(2)*1));
                            $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(2)*1));
                            $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(6)*1));
                            $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));



                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
@@ -825,6 +827,9 @@

                //获取行数据
                var listData = [];                             //获取行数据
                var HPieceQtyTotalSum = 0;
                var HQtyTotalSum = 0;
                var HTaxMoneyTotalSum = 0;
                if (option.data.length > 0) {
                    var HEmpID = option.data[0]["HEmpID"];          //用于区分不同业务员
                    var HCusID = option.data[0]["HCusID"];          //用于区分不同客户
@@ -833,7 +838,11 @@
                    var HTaxMoneySum = 0;                           //金额合计
                    for (var i = 0; i < option.data.length; i++) {
                        if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum, "米数": HQtySum, "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            HPieceQtyTotalSum += HPieceQtySum;
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum + "件", "米数": HQtySum + "ç±³", "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "金额": "金额", "业务员": "业务员" };
                            listData.push(sumTemp);
@@ -857,8 +866,20 @@
                        HTaxMoneySum += option.data[i]["金额"] * 1;

                        if (i == option.data.length - 1) {
                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum, "米数": HQtySum, "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            HPieceQtyTotalSum += HPieceQtySum;
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;
                            HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
                            HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
                            HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum + "件", "米数": HQtySum + "ç±³", "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var totalTemp = { "购货单位": "总合计", "产品名称": "", "件数": HPieceQtyTotalSum + "件", "米数": HQtyTotalSum + "ç±³", "单价": "", "金额": HTaxMoneyTotalSum, "业务员": "" };
                            listData.push(sumTemp);
                            listData.push(emptyTemp);
                            listData.push(emptyTemp);
                            listData.push(totalTemp);
                        }
                    }
                }
@@ -893,6 +914,9 @@

                //获取行数据
                var listData = [];                             //获取行数据
                var HPieceQtyTotalSum = 0;
                var HQtyTotalSum = 0;
                var HTaxMoneyTotalSum = 0;
                if (option.data.length > 0) {
                    var HEmpID = option.data[0]["HEmpID"];          //用于区分不同业务员
                    var HCusID = option.data[0]["HCusID"];          //用于区分不同客户
@@ -901,7 +925,11 @@
                    var HTaxMoneySum = 0;                           //金额合计
                    for (var i = 0; i < option.data.length; i++) {
                        if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum, "米数": HQtySum, "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            HPieceQtyTotalSum += HPieceQtySum;
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum + "件", "米数": HQtySum + "ç±³", "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "金额": "金额", "业务员": "业务员" };
                            listData.push(sumTemp);
@@ -925,8 +953,20 @@
                        HTaxMoneySum += option.data[i]["金额"] * 1;

                        if (i == option.data.length - 1) {
                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum, "米数": HQtySum, "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            HPieceQtyTotalSum += HPieceQtySum;
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;
                            HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
                            HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
                            HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": HPieceQtySum + "件", "米数": HQtySum + "ç±³", "单价": "", "金额": HTaxMoneySum, "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var totalTemp = { "购货单位": "总合计", "产品名称": "", "件数": HPieceQtyTotalSum + "件", "米数": HQtyTotalSum + "ç±³", "单价": "", "金额": HTaxMoneyTotalSum, "业务员": "" };
                            listData.push(sumTemp);
                            listData.push(emptyTemp);
                            listData.push(emptyTemp);
                            listData.push(totalTemp);
                        }
                    }
                }