From 66059e4bba8c0056eebe6c7f9cc4e7df7563270c Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 25 十一月 2022 10:34:09 +0800
Subject: [PATCH] nothing
---
WebAPI/App_Data/LogService.cs | 71 +++++++++++++++++++++++++++++++++++
WebAPI/Controllers/Sc_PackUnionBillController.cs | 25 +++++++-----
WebAPI/WebAPI.csproj | 2
3 files changed, 86 insertions(+), 12 deletions(-)
diff --git a/WebAPI/App_Data/LogService.cs b/WebAPI/App_Data/LogService.cs
new file mode 100644
index 0000000..90a7c0b
--- /dev/null
+++ b/WebAPI/App_Data/LogService.cs
@@ -0,0 +1,71 @@
+锘縰sing Newtonsoft.Json;
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+public class LogService
+{
+ private static readonly object lockObj = new object();
+
+ public static void WriteAsync(object obj, string filePath = "Vlog", bool isAppend = true)
+ {
+ Task.Run(() =>
+ {
+ Write(obj, filePath, isAppend);
+ });
+ }
+
+ public static void WriteAsync<T>(object obj, string filePath = "Vlog", bool isAppend = true)
+ {
+ Task.Run(() =>
+ {
+ Write(obj, $@"{filePath}\{typeof(T).Name}", isAppend);
+ });
+ }
+
+ #region 鏃ュ織
+ public static void Write(object obj, string filePath = "Vlog", bool isAppend = true)
+ {
+ try
+ {
+ lock (lockObj)
+ {
+ filePath = $@"{filePath}\webapi{DateTime.Now.ToString("yyyyMMdd")}.txt";
+
+ filePath = AppDomain.CurrentDomain.BaseDirectory + filePath;
+
+ if (!System.IO.Directory.Exists(Path.GetDirectoryName(filePath)))
+ {
+ System.IO.Directory.CreateDirectory(Path.GetDirectoryName(filePath));
+ }
+
+ bool fileExists = System.IO.File.Exists(filePath);
+ //涓嶅瓨鍦� 鍒欏垱寤鸿鏂囦欢
+ if (!fileExists)
+ {
+ System.IO.File.Create(filePath).Close();
+ }
+
+ using (StreamWriter writer = new StreamWriter(filePath, isAppend))
+ {
+ //瀛樺湪鐨勬椂鍊欐墠鍐欎竴琛�
+ if (fileExists && isAppend)
+ {
+ writer.WriteLine();
+ }
+
+ var content = obj is string ? obj : JsonConvert.SerializeObject(obj);
+ writer.WriteLine($"{DateTime.Now} {content}");
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ }
+ }
+ #endregion
+}
+
diff --git a/WebAPI/Controllers/Sc_PackUnionBillController.cs b/WebAPI/Controllers/Sc_PackUnionBillController.cs
index c248c09..11bde88 100644
--- a/WebAPI/Controllers/Sc_PackUnionBillController.cs
+++ b/WebAPI/Controllers/Sc_PackUnionBillController.cs
@@ -84,8 +84,11 @@
sheet.SetColumnWidth(10, 5000);
sheet.SetColumnWidth(11, 5000);
sheet.SetColumnWidth(12, 5000);
-
- DataSet ds = oCn.RunProcReturn("select * from h_v_Sc_StationInBillListMain "+sWhere+ " order by hmainid desc", "h_v_Sc_StationInBillListMain");
+ sheet.SetColumnWidth(13, 5000);
+ LogService.Write("swhere锛�" + sWhere);
+ string sql = "select * from h_v_Sc_StationInBillListMain" + sWhere + " order by hmainid desc";
+ DataSet ds = oCn.RunProcReturn(sql, "h_v_Sc_StationInBillListMain");
+ LogService.Write("sql璇彞锛�" +sql);
for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
{
IRow row1 = sheet.CreateRow(i + 1);
@@ -93,15 +96,15 @@
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());
- row1.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["鍑虹珯鏁伴噺"].ToString());
- row1.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["鍑虹珯鏃堕棿"].ToString());
- row1.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["杩涚珯鏃堕棿"].ToString());
- row1.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["鍒跺崟浜�"].ToString());
- row1.CreateCell(11).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());
+ row1.CreateCell(7).SetCellValue(ds.Tables[0].Rows[i]["杩涚珯鏁伴噺"].ToString());
+ row1.CreateCell(8).SetCellValue(ds.Tables[0].Rows[i]["鍑虹珯鏁伴噺"].ToString());
+ row1.CreateCell(9).SetCellValue(ds.Tables[0].Rows[i]["鍑虹珯鏃堕棿"].ToString());
+ row1.CreateCell(10).SetCellValue(ds.Tables[0].Rows[i]["杩涚珯鏃堕棿"].ToString());
+ row1.CreateCell(11).SetCellValue(ds.Tables[0].Rows[i]["鍒跺崟浜�"].ToString());
+ row1.CreateCell(12).SetCellValue(ds.Tables[0].Rows[i]["鍒跺崟鏃ユ湡"].ToString());
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
workbook.Write(ms);
diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj
index 9c099ae..14e122f 100644
--- a/WebAPI/WebAPI.csproj
+++ b/WebAPI/WebAPI.csproj
@@ -326,6 +326,7 @@
</Content>
</ItemGroup>
<ItemGroup>
+ <Compile Include="App_Data\LogService.cs" />
<Compile Include="App_Start\BundleConfig.cs" />
<Compile Include="App_Start\FilterConfig.cs" />
<Compile Include="App_Start\RouteConfig.cs" />
@@ -406,7 +407,6 @@
</None>
</ItemGroup>
<ItemGroup>
- <Folder Include="App_Data\" />
<Folder Include="Views\MoveStockBill\" />
</ItemGroup>
<ItemGroup>
--
Gitblit v1.9.1