摘要: 1 打开依赖所在的文件夹地址,找一个好说话的同事让他把不存在的依赖发给你 将该依赖粘贴入文件夹内 阅读全文
posted @ 2024-04-02 10:12 lixia64 阅读(1) 评论(0) 推荐(0) 编辑
摘要: /// <summary> /// 导出Excel(使用模板) /// </summary> /// <returns></returns> [HttpGet] public IActionResult ExportExcelByTemplate() { try { IWorkbook wb = n 阅读全文
posted @ 2024-03-22 15:10 lixia64 阅读(16) 评论(0) 推荐(0) 编辑
摘要: 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:02 lixia64 阅读(1) 评论(0) 推荐(0) 编辑
摘要: 1.根据列类型以及列名,取出dataTable某列所有的值 //验证通过 DataTable dt = Pub.mDB_MES.ExcuteForTable(querySQL); // (from d in dt.AsEnumerable() select d.Field<int>("ID")).T 阅读全文
posted @ 2024-01-24 16:47 lixia64 阅读(31) 评论(0) 推荐(0) 编辑
摘要: 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-01-24 13:41 lixia64 阅读(1) 评论(0) 推荐(0) 编辑
摘要: microsoft sql server:SELECT * FROM ( SELECT t.*, ROWNUM rn FROM hr.bi_history t ) WHERE rn BETWEEN 5 AND 10;navicat sql server: select * from ( select 阅读全文
posted @ 2023-12-26 09:36 lixia64 阅读(3) 评论(0) 推荐(0) 编辑
摘要: select qh.CaseId ,(select sh.CaseId from ServiceQuot.dbo.Header sh where qh.QutoNo = sh.HeaderNo) ,qh.ApplierDate ,qh.BU ,qh.Site , qh.HeaderNo , qh.C 阅读全文
posted @ 2023-12-01 09:52 lixia64 阅读(13) 评论(0) 推荐(0) 编辑
摘要: 阅读全文
posted @ 2023-11-23 11:58 lixia64 阅读(25) 评论(0) 推荐(0) 编辑
摘要: ddlRc.SelectedValue = ((DataTable)((BaseDataBoundControl)sender).DataSource).Rows[e.Row.DataItemIndex]["reason_code"].ToString(); //DataItemIndex list 阅读全文
posted @ 2023-10-30 17:14 lixia64 阅读(3) 评论(0) 推荐(0) 编辑
摘要: ((DropDownList)e.Row.FindControl("ddlRc")).Visible = false; ((Button)e.Row.FindControl("btnApprove")).Visible = false; ((Button)e.Row.FindControl("btn 阅读全文
posted @ 2023-09-27 10:53 lixia64 阅读(25) 评论(0) 推荐(0) 编辑