From 330fb0fa0c0cc61b52857771f3875268c8b190c0 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期三, 20 四月 2022 14:31:52 +0800
Subject: [PATCH] 数据导出
---
WebAPI/Controllers/Sc_PackUnionBillController.cs | 26 +++++++++++++++-----------
WebAPI/WebAPI.csproj | 6 +++++-
WebAPI/BLL/WebServer.cs | 4 ++--
3 files changed, 22 insertions(+), 14 deletions(-)
diff --git a/WebAPI/BLL/WebServer.cs b/WebAPI/BLL/WebServer.cs
index 03695f6..dae5cac 100644
--- a/WebAPI/BLL/WebServer.cs
+++ b/WebAPI/BLL/WebServer.cs
@@ -4,8 +4,8 @@
using System.Data;
using System.Linq;
using System.Web;
-using Kingdee.BOS.WebApi.Client;
-
+//using Kingdee.BOS.WebApi.Client;
+using Alex.Kingdee.Cloud.WebAPI.Client;
namespace WebAPI.BLL
{
diff --git a/WebAPI/Controllers/Sc_PackUnionBillController.cs b/WebAPI/Controllers/Sc_PackUnionBillController.cs
index 2819c19..c248c09 100644
--- a/WebAPI/Controllers/Sc_PackUnionBillController.cs
+++ b/WebAPI/Controllers/Sc_PackUnionBillController.cs
@@ -51,7 +51,7 @@
#region 鏍囧噯宸ユ椂瀵煎嚭Excel琛ㄦ牸鏁版嵁
[Route("Sc_PackUnionBill/Sc_StationInBillSetExcel")]
[HttpGet]
- public HttpResponseMessage Sc_StationInBillSetExcel()
+ public HttpResponseMessage Sc_StationInBillSetExcel(string sWhere)
{
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet = workbook.CreateSheet("sheet1");
@@ -62,14 +62,15 @@
row.CreateCell(1).SetCellValue("娴佽浆鍗″彿");
row.CreateCell(2).SetCellValue("杩涘嚭绔欐墍鐢ㄦ椂闂�");
row.CreateCell(3).SetCellValue("宸ユ椂");
- row.CreateCell(4).SetCellValue("涓嶈壇鏁伴噺");
- row.CreateCell(5).SetCellValue("鎶ュ簾鏁伴噺");
- row.CreateCell(6).SetCellValue("杩涚珯鏁伴噺");
- row.CreateCell(7).SetCellValue("鍑虹珯鏁伴噺");
- row.CreateCell(8).SetCellValue("鍑虹珯鏃堕棿");
- row.CreateCell(9).SetCellValue("杩涚珯鏃堕棿");
- row.CreateCell(10).SetCellValue("鍒跺崟浜�");
- row.CreateCell(11).SetCellValue("鍒跺崟鏃ユ湡");
+ row.CreateCell(4).SetCellValue("宸ュ簭鍚�");
+ row.CreateCell(5).SetCellValue("涓嶈壇鏁伴噺");
+ row.CreateCell(6).SetCellValue("鎶ュ簾鏁伴噺");
+ row.CreateCell(7).SetCellValue("杩涚珯鏁伴噺");
+ row.CreateCell(8).SetCellValue("鍑虹珯鏁伴噺");
+ row.CreateCell(9).SetCellValue("鍑虹珯鏃堕棿");
+ row.CreateCell(10).SetCellValue("杩涚珯鏃堕棿");
+ row.CreateCell(11).SetCellValue("鍒跺崟浜�");
+ row.CreateCell(12).SetCellValue("鍒跺崟鏃ユ湡");
//绮剧‘鎺у埗鍒楀
sheet.SetColumnWidth(1, 5000);
sheet.SetColumnWidth(2, 5000);
@@ -81,8 +82,10 @@
sheet.SetColumnWidth(8, 5000);
sheet.SetColumnWidth(9, 5000);
sheet.SetColumnWidth(10, 5000);
+ sheet.SetColumnWidth(11, 5000);
+ sheet.SetColumnWidth(12, 5000);
- DataSet ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain order by hmainid desc", "h_v_Sc_StationInBillListMain");
+ DataSet ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain "+sWhere+ " order by hmainid desc", "h_v_Sc_StationInBillListMain");
for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
{
IRow row1 = sheet.CreateRow(i + 1);
@@ -90,6 +93,7 @@
row1.CreateCell(1).SetCellValue(ds.Tables[0].Rows[i]["娴佽浆鍗″彿"].ToString());
row1.CreateCell(2).SetCellValue(ds.Tables[0].Rows[i]["杩涘嚭绔欐墍鐢ㄦ椂闂�"].ToString());
row1.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["宸ユ椂"].ToString());
+ row1.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["宸ュ簭鍚�"].ToString());
row1.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["涓嶈壇鏁伴噺"].ToString());
row1.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["鎶ュ簾鏁伴噺"].ToString());
row1.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["杩涚珯鏁伴噺"].ToString());
@@ -107,7 +111,7 @@
response.Content = new StreamContent(ms);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
- var fileName = "鏍囧噯宸ユ椂_.xls";
+ var fileName = "鏍囧噯宸ユ椂.xls";
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj
index a9b263c..71184ff 100644
--- a/WebAPI/WebAPI.csproj
+++ b/WebAPI/WebAPI.csproj
@@ -72,6 +72,7 @@
<Reference Include="Kingdee.BOS.WebApi.Client, Version=7.2.904.6, Culture=neutral, processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\WebService\MESWMS-WEBS\CLOUDWEB\bin\Kingdee.BOS.WebApi.Client.dll</HintPath>
+ <Private>True</Private>
</Reference>
<Reference Include="Kingdee.BOS.WebApi.FormService, Version=7.2.904.6, Culture=neutral, processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
@@ -80,6 +81,7 @@
<Reference Include="Kingdee.BOS.WebApi.ServicesStub, Version=7.2.904.6, Culture=neutral, processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\娆цWMS鏉＄爜绯荤粺20201016\CLOUDWEB1\DLL\Kingdee.BOS.WebApi.ServicesStub.dll</HintPath>
+ <Private>True</Private>
</Reference>
<Reference Include="Microsoft.Azure.AppService.ApiApps.Service, Version=0.9.16.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
<HintPath>..\packages\Microsoft.Azure.AppService.ApiApps.Service.0.9.16\lib\net45\Microsoft.Azure.AppService.ApiApps.Service.dll</HintPath>
@@ -88,7 +90,9 @@
<Reference Include="Microsoft.CSharp">
<Private>True</Private>
</Reference>
- <Reference Include="Microsoft.QualityTools.Testing.Fakes, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" />
+ <Reference Include="Microsoft.QualityTools.Testing.Fakes, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">
+ <Private>True</Private>
+ </Reference>
<Reference Include="Microsoft.Web.Infrastructure, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
<HintPath>..\packages\Microsoft.Web.Infrastructure.1.0.0.0\lib\net40\Microsoft.Web.Infrastructure.dll</HintPath>
<Private>True</Private>
--
Gitblit v1.9.1