01 2024 档案

获取DataTable值
摘要：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 阅读(162) 评论(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 阅读(12) 评论(0) 推荐(0)