03 2024 档案

C# 根据模板导出Excel
摘要：/// <summary> /// 导出Excel（使用模板） /// </summary> /// <returns></returns> [HttpGet] public IActionResult ExportExcelByTemplate() { try { IWorkbook wb = n 阅读全文
posted @ 2024-03-22 15:10 lixia64 阅读(326) 评论(0) 推荐(0)
sql case when, Exist ,group by ,聚合
摘要：select cm.heatno,cm.lotheatno,cm.heatorder ,max(cm.cutdate)cutdate,cm.cutdimensiona,cm.cutdimensionb,cm.length ,sum( cm.weight/1000)weight ,sum( cm.we 阅读全文
posted @ 2024-03-15 16:01 lixia64 阅读(60) 评论(0) 推荐(0)