~yxj/MES-WEB-API.git

			@@ -14,6 +14,8 @@
			using NPOI.SS.UserModel;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Converters;
			using System.Web;
			using System.Net.Http.Headers;

			namespace WebAPI.Controllers.SCGL
			{
			@@ -103,7 +105,7 @@
			try
			{
			//编辑权限
			//if (!DBUtility.ClsPub.Security_Log_second("Sc_PackUnionBill", 1, true, user))
			//if (!DBUtility.ClsPub.Security_Log_second("Sc_PackUnionBill", 1, false, user))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			@@ -150,7 +152,7 @@
			objJsonResult.data = null;
			return objJsonResult;
			}
			ds = oCn.RunProcReturn("Select * from Sc_PackUnionBillMain where HinterID='" + lngBillKey, "Sc_PackUnionBillMain");
			ds = oCn.RunProcReturn("Select * from Sc_PackUnionBillMain where HinterID=" + lngBillKey, "Sc_PackUnionBillMain");
			var HBarCode_Pack = ds.Tables[0].Rows[0]["HBarCode_Pack"].ToString();
			if (ds.Tables.Count < 1)
			{
			@@ -269,81 +271,58 @@
			#endregion

			#region 标准工时导出Excel表格数据
			private System.IO.Stream ExcelStream()
			{
			HSSFWorkbook hssfworkbook = new HSSFWorkbook();
			ISheet sheet1 = hssfworkbook.CreateSheet("sheet1");
			IRow row1 = sheet1.CreateRow(0);
			ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain order by hmainid desc", "h_v_Sc_StationInBillListMain");
			row1.CreateCell(0).SetCellValue("进站生产订单号");
			row1.CreateCell(1).SetCellValue("流转卡号");
			row1.CreateCell(2).SetCellValue("进出站所用时间");
			row1.CreateCell(3).SetCellValue("工时");
			row1.CreateCell(4).SetCellValue("不良数量");
			row1.CreateCell(5).SetCellValue("报废数量");
			row1.CreateCell(6).SetCellValue("进站数量");
			row1.CreateCell(7).SetCellValue("出站数量");
			row1.CreateCell(8).SetCellValue("出站时间");
			row1.CreateCell(9).SetCellValue("进站时间");
			row1.CreateCell(10).SetCellValue("制单人");
			row1.CreateCell(11).SetCellValue("制单日期");
			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			{
			IRow row = sheet1.CreateRow(i + 1);
			row.CreateCell(0).SetCellValue(ds.Tables[0].Rows[i]["进站生产订单号"].ToString());
			row.CreateCell(1).SetCellValue(ds.Tables[0].Rows[i]["流转卡号"].ToString());
			row.CreateCell(2).SetCellValue(ds.Tables[0].Rows[i]["进出站所用时间"].ToString());
			row.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["工时"].ToString());
			row.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["不良数量"].ToString());
			row.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["报废数量"].ToString());
			row.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["进站数量"].ToString());
			row.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["出站数量"].ToString());
			row.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["出站时间"].ToString());
			row.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["进站时间"].ToString());
			row.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["制单人"].ToString());
			row.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["制单日期"].ToString());
			}

			MemoryStream file = new MemoryStream();
			hssfworkbook.Write(file);
			file.Seek(0, SeekOrigin.Begin);
			return file;
			}

			[Route("Sc_PackUnionBill/Sc_StationInBillSetExcel")]
			[HttpGet]
			public object Sc_StationInBillSetExcel()
			public HttpResponseMessage Sc_StationInBillSetExcel()
			{
			try
			{
			ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain order by hmainid desc", "h_v_Sc_StationInBillListMain");
			IWorkbook book = new HSSFWorkbook();
			ISheet sheet = book.CreateSheet("sheet1");
			IRow row1 = sheet.CreateRow(0);
			row1.CreateCell(0).SetCellValue("进站生产订单号");
			row1.CreateCell(1).SetCellValue("流转卡号");
			row1.CreateCell(2).SetCellValue("进出站所用时间");
			row1.CreateCell(3).SetCellValue("工时");
			row1.CreateCell(4).SetCellValue("不良数量");
			row1.CreateCell(5).SetCellValue("报废数量");
			row1.CreateCell(6).SetCellValue("进站数量");
			row1.CreateCell(7).SetCellValue("出站数量");
			row1.CreateCell(8).SetCellValue("出站时间");
			row1.CreateCell(9).SetCellValue("进站时间");
			row1.CreateCell(10).SetCellValue("制单人");
			row1.CreateCell(11).SetCellValue("制单日期");
			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			{
			IRow row = sheet.CreateRow(i + 1);
			row.CreateCell(0).SetCellValue(ds.Tables[0].Rows[i]["进站生产订单号"].ToString());
			row.CreateCell(1).SetCellValue(ds.Tables[0].Rows[i]["流转卡号"].ToString());
			row.CreateCell(2).SetCellValue(ds.Tables[0].Rows[i]["进出站所用时间"].ToString());
			row.CreateCell(3).SetCellValue(ds.Tables[0].Rows[i]["工时"].ToString());
			row.CreateCell(4).SetCellValue(ds.Tables[0].Rows[i]["不良数量"].ToString());
			row.CreateCell(5).SetCellValue(ds.Tables[0].Rows[i]["报废数量"].ToString());
			row.CreateCell(6).SetCellValue(ds.Tables[0].Rows[i]["进站数量"].ToString());
			row.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["出站数量"].ToString());
			row.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["出站时间"].ToString());
			row.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["进站时间"].ToString());
			row.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["制单人"].ToString());
			row.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["制单日期"].ToString());
			}
			string filename = "C:/Users/Administrator/Desktop/标准工时表" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";
			MemoryStream BookStream = new MemoryStream();
			book.Write(BookStream);
			BookStream.Seek(0,SeekOrigin.Begin);
			byte[] buffer = BookStream.ToArray();
			using (FileStream fs = new FileStream(filename, FileMode.CreateNew, FileAccess.Write))
			{
			try
			{
			fs.Write(buffer, 0, buffer.Length);
			fs.Flush();
			}
			catch
			{

			}
			finally
			{
			fs.Dispose();
			BookStream.Dispose();
			}
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "成功导出表格至桌面";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception ex)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "导出失败" + ex.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			var file = ExcelStream();
			HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
			result.Content = new StreamContent(file);
			result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel");
			result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
			result.Content.Headers.ContentDisposition.FileName = "标准工时表.xls";
			return result;
			}

			#endregion