Linq操作DataTable
来源:互联网 发布:网络代写小说 编辑:程序博客网 时间:2024/04/30 17:58
List<string> employeeCodeList = new List<string>();
List<string> projectCodeList = new List<string>();
DataTable dt = GetDataTable("select * from SalaryDaily", "SalaryDaily");
DataTable dtEmployee = GetDataTable("select sEmployeeCode, sProjectCode from SalaryDaily group by sEmployeeCode, sProjectCode", "EmployeeInfo");
DataTable dtProject = GetDataTable("select sProjectCode from SalaryDaily group by sProjectCode", "ProjectInfo");
if (dtEmployee.Rows.Count > 0)
{
for (int i = 0; i < dtEmployee.Rows.Count; i++)
{
//for (int j = 0; j < dtProject.Rows.Count; j++)
//{
// string sEmployeeCode = dtEmployee.Rows[i]["sEmployeeCode"].ToString();
// string sProjectCode = dtProject.Rows[j]["sProjectCode"].ToString();
// var result = from c in dt.AsEnumerable()
// where c.Field<string>("sEmployeeCode").Equals(sEmployeeCode) && c.Field<string>("sProjectCode").Equals(sProjectCode)
// select c;
// //var result2 = from c in dt.AsEnumerable()
// // where c.Field<DateTime>("dtBegin") >= Convert.ToDateTime("2012-01-01")
// // select c;
//}
//}
for (int j = 0; j < dtEmployee.Rows.Count; j++)
{
employeeCodeList.Add(dtEmployee.Rows[j]["sEmployeeCode"].ToString());
projectCodeList.Add(dtEmployee.Rows[j]["sProjectCode"].ToString());
}
if (employeeCodeList.Count > 0 && projectCodeList.Count > 0)
{
IEnumerable<string> disEmployddCode = employeeCodeList.Distinct().ToList();
IEnumerable<string> disProejctCode = projectCodeList.Distinct().ToList();
foreach (string employeeCode in disEmployddCode)
{
foreach (string projectCode in disProejctCode)
{
var result = from c in dt.AsEnumerable()
where c.Field<string>("sEmployeeCode").Equals(employeeCode) && c.Field<string>("sProjectCode").Equals(projectCode)
select c;
}
}
}
}
}
}
List<string> projectCodeList = new List<string>();
DataTable dt = GetDataTable("select * from SalaryDaily", "SalaryDaily");
DataTable dtEmployee = GetDataTable("select sEmployeeCode, sProjectCode from SalaryDaily group by sEmployeeCode, sProjectCode", "EmployeeInfo");
DataTable dtProject = GetDataTable("select sProjectCode from SalaryDaily group by sProjectCode", "ProjectInfo");
if (dtEmployee.Rows.Count > 0)
{
for (int i = 0; i < dtEmployee.Rows.Count; i++)
{
//for (int j = 0; j < dtProject.Rows.Count; j++)
//{
// string sEmployeeCode = dtEmployee.Rows[i]["sEmployeeCode"].ToString();
// string sProjectCode = dtProject.Rows[j]["sProjectCode"].ToString();
// var result = from c in dt.AsEnumerable()
// where c.Field<string>("sEmployeeCode").Equals(sEmployeeCode) && c.Field<string>("sProjectCode").Equals(sProjectCode)
// select c;
// //var result2 = from c in dt.AsEnumerable()
// // where c.Field<DateTime>("dtBegin") >= Convert.ToDateTime("2012-01-01")
// // select c;
//}
//}
for (int j = 0; j < dtEmployee.Rows.Count; j++)
{
employeeCodeList.Add(dtEmployee.Rows[j]["sEmployeeCode"].ToString());
projectCodeList.Add(dtEmployee.Rows[j]["sProjectCode"].ToString());
}
if (employeeCodeList.Count > 0 && projectCodeList.Count > 0)
{
IEnumerable<string> disEmployddCode = employeeCodeList.Distinct().ToList();
IEnumerable<string> disProejctCode = projectCodeList.Distinct().ToList();
foreach (string employeeCode in disEmployddCode)
{
foreach (string projectCode in disProejctCode)
{
var result = from c in dt.AsEnumerable()
where c.Field<string>("sEmployeeCode").Equals(employeeCode) && c.Field<string>("sProjectCode").Equals(projectCode)
select c;
}
}
}
}
}
}
- Linq to datatable 操作
- Linq操作DataTable
- c# Linq操作DataTable
- Linq 操作DataTable
- Linq 操作DataTable
- Linq to DataTable 操作
- Linq 操作DataTable
- Linq 操作DataTable
- C# 中 Linq 操作 DataTable
- LINQ to DataSet的DataTable操作
- LINQ系列:LINQ to DataSet的DataTable操作
- LINQ系列:LINQ to DataSet的DataTable操作
- Linq Datatable
- datatable linq
- Linq To DataTable
- LINQ To DataTable
- Datatable中linq查询
- Linq To DataTable
- source insight 技巧3
- 2012-06-13
- 搜索引擎入口
- Android FrameWork——Touch事件派发过程详解
- 修改项目名字
- Linq操作DataTable
- 关于学习c++和编程的50个观点(学什么都适用)
- Lustre可靠性增强系统MTFS:第3篇 系统结构
- 黑马程序员-Java语言基础– 集合框架 第14天
- Android 学习小结
- extern linux用法详解
- 黑马程序员-Java语言基础– 泛型 第15天
- source insight 添加宏定义
- OSPF原理学习自我小结