斯莫尔后端代码
parent: af834f71 | 补丁 | 提交 | ignore whitespace
zzr99
2022-04-20 330fb0fa0c0cc61b52857771f3875268c8b190c0 
数据导出
3个文件已修改
36 ■■■■■ 已修改文件
WebAPI/BLL/WebServer.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/Sc_PackUnionBillController.cs 26 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 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


{




 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")


            {




 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>