From 8ec9fab52eea2b110ad4e1a0b2300fead0018cd1 Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期日, 21 十二月 2025 15:20:36 +0800
Subject: [PATCH] 1111
---
StandardPda/MES.Service/service/Warehouse/MesInvItemStocksManager.cs | 525 +++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 466 insertions(+), 59 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/MesInvItemStocksManager.cs b/StandardPda/MES.Service/service/Warehouse/MesInvItemStocksManager.cs
index 053c842..337b325 100644
--- a/StandardPda/MES.Service/service/Warehouse/MesInvItemStocksManager.cs
+++ b/StandardPda/MES.Service/service/Warehouse/MesInvItemStocksManager.cs
@@ -4,31 +4,76 @@
using SqlSugar;
using Newtonsoft.Json;
using System.Text;
+using OfficeOpenXml;
+using OfficeOpenXml.Style;
namespace MES.Service.service.Warehouse;
public class MesInvItemStocksManager : Repository<MesInvItemStocks>
{
/// <summary>
- /// 鏌ヨ鍙互閫�璐х殑鐗╂枡
+ /// 鏌ヨ鍙互閫�璐х殑鐗╂枡(甯﹀垎椤靛拰鎼滅储)
/// </summary>
- /// <returns>鍙��璐х墿鏂欏簱瀛樺垪琛�</returns>
- public List<ReturnableStockDto> GetReturnableStocks()
+ /// <param name="searchDto">鎼滅储璇锋眰鍙傛暟</param>
+ /// <returns>鍒嗛〉缁撴灉</returns>
+ public PagedResult<ReturnableStockDto> GetReturnableStocks(
+ ReturnableStockSearchDto searchDto)
{
- // 1. 鏌ヨXB_RACKING_TASK_SYXT_LOG涓墍鏈夌殑鏉＄爜骞跺幓閲�
- var distinctBarcodes = Db.Queryable<XbRackingTaskSyxtLog>()
- .Where(x => !string.IsNullOrEmpty(x.ItemBarcode))
- .Select(x => x.ItemBarcode)
- .Distinct()
- .ToList();
-
- if (distinctBarcodes == null || !distinctBarcodes.Any())
+ if (searchDto.PageIndex < 1)
{
- return new List<ReturnableStockDto>();
+ throw new Exception("椤电爜蹇呴』澶т簬0");
}
- // 2. 浣跨敤鏉＄爜鏌ヨMES_INV_ITEM_STOCKS涓殑鏁版嵁,鍏宠仈MES_ITEMS銆丮ES_DEPOTS銆丱RGANIZE銆丮ES_UNIT琛�
- var queryResult = Db.Queryable<MesInvItemStocks>()
+ // 浼樺寲鐐�1: 浣跨敤鍘熺敓SQL ROW_NUMBER()鍦ㄦ暟鎹簱绔畬鎴愬幓閲嶅拰鎺掑簭
+ var rackingTaskSql = @"
+ SELECT ITEM_BARCODE AS ItemBarcode, PALLETCODE AS PalletCode, CODE AS Code, TASKTYPE AS TaskType
+ FROM (
+ SELECT ITEM_BARCODE, PALLETCODE, CODE, TASKTYPE,
+ ROW_NUMBER() OVER (PARTITION BY ITEM_BARCODE ORDER BY ID DESC) AS RN
+ FROM XB_RACKING_TASK_SYXT_LOG
+ WHERE ITEM_BARCODE IS NOT NULL AND (CODE IS NULL OR CODE != '500')
+ ) WHERE RN = 1";
+
+ var rackingTaskData = Db.Ado.SqlQuery<RackingTaskDto>(rackingTaskSql);
+
+ if (rackingTaskData == null || !rackingTaskData.Any())
+ {
+ return new PagedResult<ReturnableStockDto>
+ {
+ TbBillList = new List<ReturnableStockDto>(),
+ Pagination = new PaginationInfo
+ {
+ CurrentPage = searchDto.PageIndex,
+ PageSize = searchDto.PageSize,
+ TotalRecords = 0,
+ TotalPages = 0
+ }
+ };
+ }
+
+ // 浼樺寲鐐�2: 杩囨护null鍊煎苟浣跨敤瀛楀吀鎻愰珮鏌ユ壘鏁堢巼
+ var validRackingData = rackingTaskData.Where(x => !string.IsNullOrEmpty(x.ItemBarcode)).ToList();
+
+ if (!validRackingData.Any())
+ {
+ return new PagedResult<ReturnableStockDto>
+ {
+ TbBillList = new List<ReturnableStockDto>(),
+ Pagination = new PaginationInfo
+ {
+ CurrentPage = searchDto.PageIndex,
+ PageSize = searchDto.PageSize,
+ TotalRecords = 0,
+ TotalPages = 0
+ }
+ };
+ }
+
+ var rackingTaskDict = validRackingData.ToDictionary(x => x.ItemBarcode);
+ var distinctBarcodes = validRackingData.Select(x => x.ItemBarcode).ToList();
+
+ // 浼樺寲鐐�3: 鏋勫缓鏌ヨ鏉′欢
+ var query = Db.Queryable<MesInvItemStocks>()
.LeftJoin<MesItems>((stock, item) => stock.ItemId == item.Id)
.LeftJoin<MesDepots>((stock, item, depot) =>
stock.DepotsCode == depot.DepotCode)
@@ -37,50 +82,282 @@
.LeftJoin<MesUnit>((stock, item, depot, org, unit) =>
item.ItemUnit == unit.Id.ToString())
.Where((stock, item, depot, org, unit) =>
- distinctBarcodes.Contains(stock.ItemBarcode) &&
- stock.Quantity > 0)
+ (distinctBarcodes.Contains(stock.ItemBarcode) ||
+ distinctBarcodes.Contains(stock.StackCode)) &&
+ stock.Quantity > 0);
+
+ var conditions = searchDto.Conditions;
+ if (conditions != null)
+ {
+ if (!string.IsNullOrEmpty(conditions.IqcStatus))
+ {
+ if (conditions.IqcStatus == "1")
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.IqcStatus == "鐗归噰鐩存帴浣跨敤" ||
+ stock.IqcStatus == "宸叉" ||
+ stock.IqcStatus == "鍏嶆");
+ }
+ else
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.IqcStatus == conditions.IqcStatus);
+ }
+ }
+
+ if (conditions.Quantity.HasValue)
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.Quantity == conditions.Quantity.Value);
+ }
+
+ if (!string.IsNullOrEmpty(conditions.DepotName))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ depot.DepotName != null &&
+ depot.DepotName.Contains(conditions.DepotName));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.DepotSectionsCode))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.DepotSectionsCode != null &&
+ stock.DepotSectionsCode.Contains(conditions
+ .DepotSectionsCode));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.ItemNo))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ item.ItemNo != null &&
+ item.ItemNo.Contains(conditions.ItemNo));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.ItemName))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ item.ItemName != null &&
+ item.ItemName.Contains(conditions.ItemName));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.ItemModel))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ item.ItemModel != null &&
+ item.ItemModel.Contains(conditions.ItemModel));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.ItemUnitName))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ unit.Fname != null &&
+ unit.Fname.Contains(conditions.ItemUnitName));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.OrgCode))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ org.Fnumber != null &&
+ org.Fnumber.Contains(conditions.OrgCode));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.OrgName))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ org.Fname != null &&
+ org.Fname.Contains(conditions.OrgName));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.ItemBarcode))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ (stock.ItemBarcode != null &&
+ stock.ItemBarcode.Contains(conditions.ItemBarcode)) ||
+ (stock.StackCode != null &&
+ stock.StackCode.Contains(conditions.ItemBarcode)));
+ }
+
+ if (!string.IsNullOrEmpty(conditions.IndepDateStart))
+ {
+ if (DateTime.TryParse(conditions.IndepDateStart,
+ out var startDate))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.IndepDate >= startDate);
+ }
+ }
+
+ if (!string.IsNullOrEmpty(conditions.IndepDateEnd))
+ {
+ if (DateTime.TryParse(conditions.IndepDateEnd, out var endDate))
+ {
+ query = query.Where((stock, item, depot, org, unit) =>
+ stock.IndepDate <= endDate);
+ }
+ }
+ }
+
+ // 浼樺寲鐐�4: 鏌ヨ鏁版嵁
+ var queryResult = query
+ .OrderByDescending((stock, item, depot, org, unit) =>
+ stock.IndepDate)
.Select((stock, item, depot, org, unit) => new
{
- IqcStatus = stock.IqcStatus,
- StackCode = stock.StackCode,
+ stock.IqcStatus,
+ stock.Visible,
DepotCode = stock.DepotsCode,
- DepotName = depot.DepotName,
- DepotSectionsCode = stock.DepotSectionsCode,
- ItemNo = item.ItemNo,
- ItemName = item.ItemName,
- ItemModel = item.ItemModel,
- Quantity = stock.Quantity,
- ItemUnit = item.ItemUnit,
+ depot.DepotName,
+ stock.DepotSectionsCode,
+ item.ItemNo,
+ item.ItemName,
+ item.ItemModel,
+ stock.Quantity,
+ item.ItemUnit,
ItemUnitName = unit.Fname,
- IndepDate = stock.IndepDate,
+ stock.IndepDate,
OrgCode = org.Fnumber,
OrgName = org.Fname,
- ItemBarcode = stock.ItemBarcode
+ stock.ItemBarcode,
+ StockStackCode = stock.StackCode
})
.ToList();
- // 3. 鍦ㄥ唴瀛樹腑杩涜鏁版嵁杞崲
- var result = queryResult.Select(x => new ReturnableStockDto
+ // 浼樺寲鐐�5: 浣跨敤瀛楀吀鏌ユ壘鏇夸唬Where().FirstOrDefault()
+ var tempDataList = queryResult.Select(x =>
{
- IqcStatus = x.IqcStatus == "宸叉" ? "1" : "0",
- ItemType = x.DepotName == "鍘熸潗鏂欎粨" ? "0" : "1",
- StackCode = x.StackCode,
- DepotCode = x.DepotCode,
- DepotName = x.DepotName,
- DepotSectionsCode = x.DepotSectionsCode,
- ItemNo = x.ItemNo,
- ItemName = x.ItemName,
- ItemModel = x.ItemModel,
- Quantity = x.Quantity,
- ItemUnit = x.ItemUnit,
- ItemUnitName = x.ItemUnitName,
- IndepDate = x.IndepDate,
- OrgCode = x.OrgCode,
- OrgName = x.OrgName,
- ItemBarcode = x.ItemBarcode
+ var barcodeToMatch = !string.IsNullOrEmpty(x.StockStackCode)
+ ? x.StockStackCode
+ : x.ItemBarcode;
+
+ rackingTaskDict.TryGetValue(barcodeToMatch, out var rackingTask);
+
+ string stockStatus;
+ if (rackingTask?.TaskType == "绔嬪簱鍑哄簱璇锋眰")
+ {
+ // 鍑哄簱璇锋眰锛欳ode=200琛ㄧず宸插嚭搴擄紝Code=null琛ㄧず鍑哄簱璺笂
+ stockStatus = rackingTask.Code == "200" ? "宸插嚭绔嬪簱" : "鍑虹珛搴撹矾涓�";
+ }
+ else
+ {
+ // 鍥炲簱璇锋眰锛堥粯璁わ級锛欳ode=200琛ㄧず宸插湪绔嬪簱涓紝Code=null琛ㄧず杩涘叆绔嬪簱鐨勮矾涓�
+ stockStatus = rackingTask?.Code == "200" ? "宸插湪绔嬪簱涓�" : "杩涘叆绔嬪簱鐨勮矾涓�";
+ }
+
+ // 鍐荤粨鏍囪瘑涓�1鏃讹紝IqcStatus涓�0锛涘惁鍒欐牴鎹甀qcStatus鍒ゆ柇
+ var iqcStatusValue = x.Visible == 1 ? "0" :
+ (x.IqcStatus == "鐗归噰鐩存帴浣跨敤" || x.IqcStatus == "宸叉" || x.IqcStatus == "鍏嶆" ? "1" : "0");
+
+ return new
+ {
+ IqcStatus = iqcStatusValue,
+ ItemType = x.DepotName == "鍘熸潗鏂欎粨" ? "0" : "1",
+ StackCode = rackingTask?.PalletCode,
+ x.DepotCode,
+ x.DepotName,
+ x.DepotSectionsCode,
+ x.ItemNo,
+ x.ItemName,
+ x.ItemModel,
+ x.Quantity,
+ x.ItemUnit,
+ x.ItemUnitName,
+ x.IndepDate,
+ x.OrgCode,
+ x.OrgName,
+ ItemBarcode = barcodeToMatch,
+ StockStatus = stockStatus
+ };
}).ToList();
- return result;
+ if (conditions != null && !string.IsNullOrEmpty(conditions.StackCode))
+ {
+ tempDataList = tempDataList
+ .Where(x =>
+ x.StackCode != null &&
+ x.StackCode.Contains(conditions.StackCode))
+ .ToList();
+ }
+
+ if (conditions != null && !string.IsNullOrEmpty(conditions.StockStatus))
+ {
+ tempDataList = tempDataList
+ .Where(x => x.StockStatus == conditions.StockStatus)
+ .ToList();
+ }
+
+ var dataList = tempDataList
+ .GroupBy(x => new
+ {
+ x.IqcStatus,
+ x.ItemType,
+ x.StackCode,
+ x.DepotCode,
+ x.DepotName,
+ x.DepotSectionsCode,
+ x.ItemNo,
+ x.ItemName,
+ x.ItemModel,
+ x.ItemUnit,
+ x.ItemUnitName,
+ x.OrgCode,
+ x.OrgName,
+ x.ItemBarcode,
+ x.StockStatus
+ })
+ .Select(g => new ReturnableStockDto
+ {
+ IqcStatus = g.Key.IqcStatus,
+ ItemType = g.Key.ItemType,
+ StackCode = g.Key.StackCode,
+ DepotCode = g.Key.DepotCode,
+ DepotName = g.Key.DepotName,
+ DepotSectionsCode = g.Key.DepotSectionsCode,
+ ItemNo = g.Key.ItemNo,
+ ItemName = g.Key.ItemName,
+ ItemModel = g.Key.ItemModel,
+ Quantity = g.Sum(x => x.Quantity),
+ ItemUnit = g.Key.ItemUnit,
+ ItemUnitName = g.Key.ItemUnitName,
+ IndepDate = g.Max(x => x.IndepDate),
+ OrgCode = g.Key.OrgCode,
+ OrgName = g.Key.OrgName,
+ ItemBarcode = g.Key.ItemBarcode,
+ StockStatus = g.Key.StockStatus
+ }).ToList();
+
+ if (conditions?.ItemType != null)
+ {
+ dataList = dataList.Where(x => x.ItemType == conditions.ItemType)
+ .ToList();
+ }
+
+ var totalRecords = dataList.Count;
+ var totalPages =
+ (int)Math.Ceiling((double)totalRecords / searchDto.PageSize);
+ var skip = (searchDto.PageIndex - 1) * searchDto.PageSize;
+
+ var pagedDataList =
+ dataList.Skip(skip).Take(searchDto.PageSize).ToList();
+
+ return new PagedResult<ReturnableStockDto>
+ {
+ TbBillList = pagedDataList,
+ Pagination = new PaginationInfo
+ {
+ CurrentPage = searchDto.PageIndex,
+ PageSize = searchDto.PageSize,
+ TotalRecords = totalRecords,
+ TotalPages = totalPages
+ }
+ };
+ }
+
+ private class RackingTaskDto
+ {
+ public string ItemBarcode { get; set; }
+ public string PalletCode { get; set; }
+ public string Code { get; set; }
+ public string TaskType { get; set; }
}
/// <summary>
@@ -103,8 +380,43 @@
// 瀵规瘡涓潯鐮佸崟鐙鐞�
foreach (var barcode in dto.ItemBarcodes)
{
+ // 妫�鏌ユ渶杩戜袱鍒嗛挓鍐呮槸鍚﹀凡缁忓瓨鍦ㄧ浉鍚岀殑 barcode 琚鐞嗚繃
+ var twoMinutesAgo = DateTime.Now.AddMinutes(-2);
+ var recentTask = Db.Queryable<XbRackingTaskSyxtLog>()
+ .Where(x =>
+ x.ItemBarcode == barcode &&
+ x.CreateDate >= twoMinutesAgo)
+ .First();
+
+ if (recentTask != null)
+ {
+ throw new Exception(
+ $"鐗╂枡鏉＄爜 {barcode} 鍦ㄤ袱鍒嗛挓鍐呭凡琚壂鎻忓鐞嗭紝璇峰嬁閲嶅鎿嶄綔銆備负閬垮厤绔嬪簱绯荤粺浠诲姟閲嶅涓嬪彂锛岀郴缁熼檺鍒跺悓涓�鐗╂枡鏉＄爜鍦ㄤ袱鍒嗛挓鍐呭彧鑳藉鐞嗕竴娆°��");
+ }
+
decimal messageId = 0;
string taskCode = "";
+
+ // 鏍规嵁鏉＄爜鏌ヨXB_RACKING_TASK_SYXT_LOG琛紝鏌ヨmax(PALLETCODE)鍜屽搴旂殑widthType
+ var rackingTaskInfo = Db.Queryable<XbRackingTaskSyxtLog>()
+ .Where(x => x.ItemBarcode == barcode)
+ .OrderByDescending(x => x.Id)
+ .Select(x => new { x.PalletCode, x.WidthType })
+ .First();
+
+ // 妫�鏌ユ槸鍚﹀瓨鍦ㄦ湭瀹屾垚鐨勪换鍔★紙鍩轰簬PalletCode锛孋ode涓簄ull锛�
+ if (!string.IsNullOrEmpty(rackingTaskInfo?.PalletCode))
+ {
+ var pendingTask = Db.Queryable<XbRackingTaskSyxtLog>()
+ .Where(x => x.PalletCode == rackingTaskInfo.PalletCode && x.Code == null)
+ .OrderByDescending(x => x.Id)
+ .First();
+
+ if (pendingTask != null)
+ {
+ throw new Exception($"鎵樼洏缂栧彿 {rackingTaskInfo.PalletCode} 宸插瓨鍦ㄦ湭瀹屾垚鐨勭珛搴撲换鍔★紝璇风瓑寰呬换鍔″畬鎴愬悗鍐嶆搷浣溿��");
+ }
+ }
try
{
@@ -113,7 +425,8 @@
.LeftJoin<MesItems>((stock, item) =>
stock.ItemId == item.Id)
.Where((stock, item) =>
- stock.ItemBarcode == barcode && stock.Quantity > 0)
+ (stock.ItemBarcode == barcode ||
+ stock.StackCode == barcode) && stock.Quantity > 0)
.GroupBy((stock, item) =>
new { stock.ItemId, stock.LotNo })
.Select((stock, item) => new
@@ -122,7 +435,8 @@
ItemName = SqlFunc.AggregateMax(item.ItemName),
LotNo = stock.LotNo ?? "",
Quantity = SqlFunc.AggregateSum(stock.Quantity),
- StackCode = SqlFunc.AggregateMax(stock.DepotSectionsCode)
+ StackCode =
+ SqlFunc.AggregateMax(stock.DepotSectionsCode)
})
.ToList();
@@ -144,17 +458,18 @@
{
taskCode = taskCode,
taskType = "1",
- palletCode = firstStock.StackCode ?? "",
- widthType = "180",
- station = "3"
+ palletCode = rackingTaskInfo?.PalletCode ?? "",
+ widthType = rackingTaskInfo?.WidthType?.ToString() ??
+ "2000",
+ station = dto.Station
};
var requestList = new[] { requestData };
var jsonRequest = JsonConvert.SerializeObject(requestList);
// 5. 璁板綍鍒癕essageCenter琛�(璇锋眰鍓�)
-
+
var messageCenter = new MessageCenter
- {
+ {
TableName = "XB_RACKING_TASK_SYXT_LOG",
Url =
"http://172.20.5.5:50080/Services/Wmcs/RetrieveTask",
@@ -168,7 +483,8 @@
Data = jsonRequest,
DataInserted = jsonRequest
};
- messageId = Db.Insertable(messageCenter).ExecuteReturnIdentity();
+ messageId = Db.Insertable(messageCenter)
+ .ExecuteReturnIdentity();
// 6. 璋冪敤HTTP鎺ュ彛
var apiUrl =
@@ -211,17 +527,15 @@
CreateDate = DateTime.Now,
TaskCode = taskCode,
TaskType = "绔嬪簱鍑哄簱璇锋眰",
- PalletCode = firstStock.StackCode,
- WidthType = 180,
+ PalletCode = rackingTaskInfo?.PalletCode ?? "",
+ WidthType = rackingTaskInfo?.WidthType ?? 2000,
MaterialName = firstStock.ItemName,
MaterialCode = firstStock.ItemNo,
BatchNo = firstStock.LotNo,
Quantity = firstStock.Quantity,
WarehousingJson = responseStr,
QcStatus = 2,
- ItemBarcode = barcode,
- Code = "200",
- JsonMessage = jsonMessage ?? "鎴愬姛"
+ ItemBarcode = barcode
};
Db.Insertable(taskLog).ExecuteCommand();
@@ -284,4 +598,97 @@
throw;
}
}
+
+ /// <summary>
+ /// 瀵煎嚭鍙��璐х墿鏂欏簱瀛樹负Excel
+ /// </summary>
+ /// <param name="searchDto">鎼滅储璇锋眰鍙傛暟</param>
+ /// <returns>Excel鏂囦欢瀛楄妭鏁扮粍</returns>
+ public byte[] ExportReturnableStocksToExcel(
+ ReturnableStockSearchDto searchDto)
+ {
+ // 璁剧疆 EPPlus 璁稿彲璇佷笂涓嬫枃(闈炲晢涓氱敤閫�)
+ ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
+
+ // 鑾峰彇鎵�鏈夋暟鎹�(涓嶅垎椤�)
+ var tempSearchDto = new ReturnableStockSearchDto
+ {
+ PageIndex = 1,
+ PageSize = int.MaxValue, // 鑾峰彇鎵�鏈夋暟鎹�
+ Conditions = searchDto.Conditions
+ };
+
+ // 璋冪敤鏌ヨ鏂规硶鑾峰彇鏁版嵁
+ var result = GetReturnableStocks(tempSearchDto);
+ var dataList = result.TbBillList;
+
+ // 鍒涘缓 Excel 鏂囦欢
+ using var package = new ExcelPackage();
+ var worksheet = package.Workbook.Worksheets.Add("鍙��璐х墿鏂欏簱瀛�");
+
+ // 璁剧疆琛ㄥご
+ var headers = new[]
+ {
+ "鑹搧鐘舵��",
+ "鏄惁鎴愬搧",
+ "姣嶆墭鐩樼紪鍙�",
+ "浠撳簱缂栫爜",
+ "浠撳簱鍚嶇О",
+ "铏氭嫙搴撲綅",
+ "鐗╂枡缂栧彿",
+ "鐗╂枡鍚嶇О",
+ "鐗╂枡瑙勬牸",
+ "鐗╂枡鏁伴噺",
+ "鐗╂枡鍗曚綅",
+ "鍏ュ簱鏃堕棿",
+ "缁勭粐缂栫爜",
+ "缁勭粐鍚嶇О",
+ "鐗╂枡鏉＄爜",
+ "搴撳瓨鐘舵��"
+ };
+
+ // 鍐欏叆琛ㄥご
+ for (int i = 0; i < headers.Length; i++)
+ {
+ worksheet.Cells[1, i + 1].Value = headers[i];
+ worksheet.Cells[1, i + 1].Style.Font.Bold = true;
+ worksheet.Cells[1, i + 1].Style.Fill.PatternType =
+ ExcelFillStyle.Solid;
+ worksheet.Cells[1, i + 1].Style.Fill.BackgroundColor
+ .SetColor(System.Drawing.Color.LightGray);
+ worksheet.Cells[1, i + 1].Style.HorizontalAlignment =
+ ExcelHorizontalAlignment.Center;
+ }
+
+ // 鍐欏叆鏁版嵁
+ int row = 2;
+ foreach (var item in dataList)
+ {
+ worksheet.Cells[row, 1].Value =
+ item.IqcStatus == "1" ? "鑹搧" : "涓嶈壇鍝�";
+ worksheet.Cells[row, 2].Value = item.ItemType == "1" ? "鎴愬搧" : "闈炴垚鍝�";
+ worksheet.Cells[row, 3].Value = item.StackCode;
+ worksheet.Cells[row, 4].Value = item.DepotCode;
+ worksheet.Cells[row, 5].Value = item.DepotName;
+ worksheet.Cells[row, 6].Value = item.DepotSectionsCode;
+ worksheet.Cells[row, 7].Value = item.ItemNo;
+ worksheet.Cells[row, 8].Value = item.ItemName;
+ worksheet.Cells[row, 9].Value = item.ItemModel;
+ worksheet.Cells[row, 10].Value = item.Quantity;
+ worksheet.Cells[row, 11].Value = item.ItemUnitName;
+ worksheet.Cells[row, 12].Value =
+ item.IndepDate?.ToString("yyyy-MM-dd HH:mm:ss");
+ worksheet.Cells[row, 13].Value = item.OrgCode;
+ worksheet.Cells[row, 14].Value = item.OrgName;
+ worksheet.Cells[row, 15].Value = item.ItemBarcode;
+ worksheet.Cells[row, 16].Value = item.StockStatus;
+ row++;
+ }
+
+ // 鑷姩璋冩暣鍒楀
+ worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
+
+ // 杩斿洖 Excel 鏂囦欢瀛楄妭鏁扮粍
+ return package.GetAsByteArray();
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3