1

zzr99

2022-07-05 b113fe5f433ad00e0dd0375c3b7d49c9961d2307

1

 WebAPI/App_Data/LogService.cs

New file
@@ -0,0 +1,71 @@
using 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
}


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

 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" />
@@ -404,7 +405,6 @@
    </None>
  </ItemGroup>
  <ItemGroup>
    <Folder Include="App_Data\" />
    <Folder Include="Views\MoveStockBill\" />
  </ItemGroup>
  <ItemGroup>