如何从两个列表的结果中列出一个列表? [英] How to make a list from the result of two list?
问题描述
在c#中,我正在使用查询:
SELECT格式(Trans.Dt,MM / dd / yyyy HH:mm:ss),Trans.InOut,Trans.EmpID FROM Trans其中(格式((Trans.DT),'短日期')('8/25/2014'))由Trans.EmpID ASC订购;
来自我正在创建两个单独的列表
列表1:
var objList = from list in list element.InOut ==0&& element.EmpID == empIds [j] .ToString()orderby element.DateInOut升序选择元素;
List< employeedata> listquery0 = objList.ToList< employeedata>();
清单2:
var objList1 = from列表中的元素,其中element.InOut ==1&& element.EmpID == empIds [j] .ToString()orderby element.DateInOut升序选择元素;
List< employeedata> listquery1 = objList1.ToList< employeedata>();
现在,
我想创建一个包含两个列表输出的新列表。
先谢谢!!
In c#, I am using a query:
SELECT format( Trans.Dt,"MM/dd/yyyy HH:mm:ss") , Trans.InOut , Trans.EmpID FROM Trans where( format((Trans.DT),'Short Date') in('8/25/2014')) order by Trans.EmpID ASC;
from which I am creating two separate list
List 1:
var objList = from element in list where element.InOut == "0" && element.EmpID == empIds[j].ToString() orderby element.DateInOut ascending select element;
List<employeedata> listquery0 = objList.ToList<employeedata>();
List 2:
var objList1 = from element in list where element.InOut == "1" && element.EmpID == empIds[j].ToString() orderby element.DateInOut ascending select element;
List<employeedata> listquery1 = objList1.ToList<employeedata>();
Now,
I want to create a new list that contains the output of two lists.
Thanks in Advance!!
推荐答案
如果绝对无法在一个查询中获取所有内容,制作复合列表的方法非常简单。
从您的代码看起来您使用相同的数据类型,所以......
If you absolutely cannot get everything in one query, the way to make a compound list is very easy.
From your code it looks like you are using the same data type, so....
listquery.AddRange(listquery1);
这篇关于如何从两个列表的结果中列出一个列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!