- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
IList<Hashtable> records = crit.List<Hashtable>();
Guid[] personsId = records.Select(item => (Guid)item["PersonID"]).Distinct().ToArray();
List<EmployeeData> empDatas = new List<EmployeeData>();
foreach(Guid personId in personsId) {
IEnumerable<Hashtable> employeeRecords = records.Where(item => (Guid)item["PersonID"] == personId);
Hashtable employeeRecord = employeeRecords.FirstOrDefault(item => !(bool)item["IsLoad"] || (DateTime)item["EventDate"] == employeeRecords.Max(unit => (DateTime)unit["EventDate"]));
Hashtable employeeRecordAddition = new GenericNHibernateDao<BaseDocument>().CreateCriteria()
.CreateAlias("Department", "department")
.CreateAlias("Employee", "employee")
.CreateAlias("WorkDescription.Schedule", "schedule", JoinType.LeftOuterJoin)
.CreateAlias("WorkDescription.EmployeeApperance", "employeeApperance", JoinType.LeftOuterJoin)
.Add(Restrictions.Eq("EmployeeStamp.TabNo", employeeRecord["TabNo"]))
.Add(Restrictions.Eq("IsHalf", false))
...
}
IsHalf
TabNo