public static Pager <DeptEmpInfo> GetDeptEmpInfo(DeptEmpParameter parameter)
{
StringBuilder sqlLayout = new StringBuilder(@"
SELECT dep.DepartmentID ,
dep.DepartmentName ,
dep.Manager ,
dep.Depart_Description AS DepartDescription,
emp.EmployeeID ,
emp.EmployeeName ,
emp.Sex ,
emp.BirthDate ,
emp.HireDate ,
emp.Salary ,
emp.DepartmentID
FROM dbo.Department dep
LEFT JOIN dbo.Employee emp ON emp.DepartmentID = dep.DepartmentID
WHERE 1 = 1
");
// 动态查询条件的拼接
List <SqlParameter> paramList = new List <SqlParameter>();
if (!string.IsNullOrEmpty(parameter.DepartmentName))
{
sqlLayout.Append($" AND dep.DepartmentName like @DepartmentName ");
paramList.Add(new SqlParameter("@DepartmentName", $"%{parameter.DepartmentName}%"));
}
if (!string.IsNullOrEmpty(parameter.EmployeeName))
{
sqlLayout.Append($" AND emp.EmployeeName like @EmployeeName ");
paramList.Add(new SqlParameter("@EmployeeName", $"%{parameter.EmployeeName}%"));
}
Pager <DeptEmpInfo> result = new Pager <DeptEmpInfo>();
result.Rows = EFUtility.GetList <DeptEmpInfo>(sqlLayout.ToString(), paramList, parameter);
// 统计数目，需要判断是否开启分页，区分判断
if (parameter.IsPage)
{
result.Total = EFUtility.GetCount(sqlLayout.ToString(), paramList);
}
else
{
result.Total = result.Rows.Count;
}
return(result);
}
/// <summary>
/// 分页获取员工数据
/// </summary>
/// <returns></returns>
public JsonResult GetEmployeeData(DeptEmpParameter parameter)
{
Pager <DeptEmpInfo> res = DepartmentMgr.GetDeptEmpInfo(parameter);
return(Json(res));
}
public static Pager <DeptEmpInfo> GetDeptEmpInfo(DeptEmpParameter parameter)
{
return(DepartmentDAO.GetDeptEmpInfo(parameter));
}
