select a.CardID,a.EmployeeID,a.EmployeeName,b.DateTimeBrush,a.SexID,c.DepartmentName from TC_Employee a
left join AT_CardBrushRecord b  on a.CardID=b.CardId
left join TC_Department c on a.DepartmentID=c.DepartmentID
where  c.Departmentname='asd' and b.DateTimeBrush between 2010-04-07 14:02:50.020 and 2016-04-07 14:02:50.020
group by a.CardID,a.EmployeeID,a.EmployeeName,b.DateTimeBrush,c.DepartmentName


select COUNT(a.CardID) from TC_Employee a
left join TC_Department b on a.DepartmentID=b.DepartmentID
where a.DepartmentID=1




        public DataTable GetEmp()
        {
            string sql = "select a.CardID,a.EmployeeID,a.EmployeeName,b.DateTimeBrush,c.DepartmentName,  from TC_Employee a  " +
                         "left join AT_CardBrushRecord b on a.CardID=b.CardId " +
                         " left join TC_Department c on a.DepartmentID=c.DepartmentID " ;
            
                                    
                        
          return  YC.Common.SqlDataAccess.GetDataTable(sql);
        }