110,533
社区成员
发帖
与我相关
我的任务
分享
var q = from d in dataTable.AsEnumerable()
select new
{
d.ItemArray,
借用信息 = new string(' ', 100),
大类排序 = Convert.ToInt32(d["大类ID"]),
排序序号 = (Convert.ToInt32(d["序号"]) == 0) ? 9999 : d["序号"]
} into dr
orderby dr.大类排序, dr.排序序号
select dr;
var result = q.ToList();
using (LocalEntities localEntity = new LocalEntities())
{
var q = from d in localEntity.tableA
...
select d;
var result=q.tolist();
result里就是 tableA的所有字段
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ID");
dataTable.Columns.Add("名称");
dataTable.Columns.Add("数量", typeof(int));
dataTable.Columns.Add("大类ID");
dataTable.Columns.Add("序号", typeof(int));
dataTable.Rows.Add(1, "名1", 10, 1, 3);
dataTable.Rows.Add(1, "名2", 9, 2, 0);
dataTable.Rows.Add(1, "名3", 11, 1, 1);
//SELECT *, SPACE(100) AS 借用信息, CONVERT(int, 大类ID) AS 大类排序, (CASE WHEN 序号 = 0 THEN 9999 ELSE 序号 END)
// AS 排序序号
// FROM ware
// ORDER BY 大类排序, 排序序号
var q = from e in
from d in dataTable.AsEnumerable()
select new
{
ID = d["ID"],
名称 = d["名称"],
数量 = d["数量"],
大类ID = d["大类ID"],
序号ID = d["序号"],
借用信息 = new string(' ', 100),
大类排序 = Convert.ToInt32(d["大类ID"]),
排序序号 = (Convert.ToInt32(d["序号"]) == 0) ? 9999 : d["序号"]
} into dr
orderby dr.大类排序, dr.排序序号
select dr
select e;
var result = q.ToList();