摘要: DECLARE @defect_condition_TB TABLE (DefectName NVARCHAR(100)); INSERT INTO @defect_condition_TB (DefectName) VALUES (N'耐久'), (N'光学测定'); SELECT DefectN 阅读全文
posted @ 2024-09-26 12:09 妖狐鬼魅 阅读(8) 评论(0) 推荐(0) 编辑
摘要: public class ExcelHelper { private readonly IHostingEnvironment _hostingEnvironment; public ExcelHelper(IHostingEnvironment hostingEnvironment) { _hos 阅读全文
posted @ 2024-08-02 15:30 妖狐鬼魅 阅读(7) 评论(0) 推荐(0) 编辑
摘要: //插件网址//http://excel.wj2015.com/_book/docs/%E5%BF%AB%E9%80%9F%E4%B8%8A%E6%89%8B.html //表格单元格相同值合并//使用://引用插件库 excel.js//var columsName = ['ModuleCName 阅读全文
posted @ 2024-04-12 16:40 妖狐鬼魅 阅读(13) 评论(0) 推荐(0) 编辑
摘要: 单选框设置选中: $("#rbtnPercent").prop("checked", true); form.render("radio"); 阅读全文
posted @ 2024-02-25 13:53 妖狐鬼魅 阅读(7) 评论(0) 推荐(0) 编辑
摘要: 原SQLselect * from A aleft join B b on a.id=b.id 优化SQLselect * from (select aa,bb from A where aa='') aleft join (select aa,bb from B where aa='') b on 阅读全文
posted @ 2024-01-17 16:13 妖狐鬼魅 阅读(16) 评论(0) 推荐(0) 编辑
摘要: table tbody { display: block; height: 500px; overflow-y: scroll; } table thead, tbody tr { display: table; width: 100%; table-layout: fixed; box-sizin 阅读全文
posted @ 2023-10-30 12:13 妖狐鬼魅 阅读(59) 评论(0) 推荐(0) 编辑
摘要: SELECT COUNT(*) FROM ( SELECT * FROM table1 UNION SELECT * FROM table2 ) AS combined GROUP BY column1, column2, ...;我们首先将两个表的数据内容进行UNION操作,然后使用GROUP B 阅读全文
posted @ 2023-09-17 15:57 妖狐鬼魅 阅读(339) 评论(0) 推荐(0) 编辑
摘要: @{ ViewData["Title"] = "Login"; Layout = "~/Views/Shared/_Layout_default.cshtml"; } @section Css { <style> body { /* 加载背景图 */ background-image: url(.. 阅读全文
posted @ 2023-06-26 12:21 妖狐鬼魅 阅读(48) 评论(0) 推荐(0) 编辑
摘要: @{ ViewData["Title"] = "Edit"; Layout = "~/Views/Shared/_Layout_default.cshtml"; } <form class="layui-form layui-form-pane" lay-filter="DataForm" styl 阅读全文
posted @ 2023-06-26 12:19 妖狐鬼魅 阅读(9) 评论(0) 推荐(0) 编辑
摘要: @{ ViewData["Title"] = "IPList"; Layout = "~/Views/Shared/_Layout_layui.cshtml"; } @section Css { } <div class="demoTable layui-form" style="padding: 阅读全文
posted @ 2023-06-26 12:18 妖狐鬼魅 阅读(9) 评论(0) 推荐(0) 编辑