/// <summary>
/// 查询部门根据ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HRDept FindById(string id)
{
List <HRDept> list = conn.Query <HRDept>("SELECT * FROM HR_DEPT where Id = @Id", new { Id = id }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
/// <summary>
/// 查询部门根据ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HREmployee FindById(string id)
{
List <HREmployee> list = conn.Query <HREmployee>("SELECT e.*, d.name as DEPT_NAME, j.name as JOB_NAME FROM HR_EMPLOYEE e, HR_DEPT d, HR_JOB j where e.Dept_Id = d.ID and e.JOB_ID = j.ID and e.Id = @Id", new { Id = id }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
/// <summary>
/// 查询部门根据ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HRWorkLog FindById(string id)
{
List <HRWorkLog> list = conn.Query <HRWorkLog>("SELECT * FROM HR_WORK_LOG where Id = @Id", new { Id = id }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
/// <summary>
/// 查询部门根据ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HRLeave FindById(string id)
{
List <HRLeave> list = conn.Query <HRLeave>("SELECT l.*, e.name as EMP_NAME FROM HR_LEAVE l, HR_EMPLOYEE e where l.EMP_ID = e.ID and Id = @Id", new { Id = id }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
/// <summary>
/// 查询部门根据ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HRRewardsPunishments FindById(string id)
{
List <HRRewardsPunishments> list = conn.Query <HRRewardsPunishments>("SELECT * FROM HR_REWARDS_PUNISHMENTS where Id = @Id", new { Id = id }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
public HRUser Login(string UserName, string Pwd)
{
List <HRUser> list = conn.Query <HRUser>("SELECT * FROM HR_USER where UserName=@Username and Password=@Password",
new { Username = UserName, Password = Pwd }).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}
public HRContract FindByEmpId(string EmpId)
{
string sql = "SELECT c.*, e.name as EMP_NAME FROM HR_CONTRACT c ,HR_EMPLOYEE e where c.EMP_ID = e.ID and c.EMP_ID = @EmpId";
List <HRContract> list = conn.Query <HRContract>(sql, new
{
EmpId = EmpId
}).ToList();
if (EmptyUtils.EmptyList(list))
{
return(null);
}
else
{
return(list[0]);
}
}