/// <summary>
/// 员 工 考 勤 历 史 记 录 查 询
/// </summary>
/// <param name="beginTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="branchId">机构</param>
/// <param name="departId">部门</param>
/// <param name="userId">用户Id</param>
/// <param name="userName">用户名</param>
/// <returns>历史记录集合</returns>
public static IList <ManualSign> SearchManualSignByCondition(string beginTime, string endTime, string branchId, string departId, string userId, string userName)
{
if (beginTime != null && !beginTime.Equals("") && endTime != null && !endTime.Equals(""))
{
#region
string sqlview = "select * from viewManualSignHistory where SignTime between '" + string.Format("{0:yyyy-MM-dd 0:00:00}", DateTime.Parse(beginTime.Trim())) + "' and '" + string.Format("{0:yyyy-MM-dd 23:59:59}", DateTime.Parse(endTime.Trim())) + "' ";
if (userId != null && !userId.Equals(""))
{
sqlview += " and UserId = '" + userId + "'";
}
if (userName != null && !userName.Equals(""))
{
sqlview += " and UserName like '" + userName + "%'";
}
//当机构部门用户名都不为空时
if (branchId != null && !branchId.Equals("") && departId != null && !departId.Equals("") && userName != null && !userName.Equals(""))
{
sqlview += " and BranchId = '" + branchId + "' and DepartId='" + departId + "' and UserName like'" + userName + "%'";
}
//当机构部门都不为空时
if (branchId != null && !branchId.Equals("") && departId != null && !departId.Equals(""))
{
sqlview += " and BranchId = '" + branchId + "' and DepartId='" + departId + "'";
}
//当机构，姓名不为空时
if (branchId != null && !branchId.Equals("") && userName != null && !userName.Equals(""))
{
sqlview += " and BranchId = '" + branchId + "' and UserName like '" + userName + "%'";
}
//当机构不为空时
if (branchId != null && !branchId.Equals(""))
{
sqlview += " and BranchId = '" + branchId + "'";
}
#endregion
return(ManualSignService.GetManualSignBySql(sqlview));
}
return(null);
}
public static int GetManualSignState(bool sign, string userId)
{
return(ManualSignService.GetManualSignState(sign, userId));
}
public static void ModifyManualSign(ManualSign manualSign)
{
ManualSignService.ModifyManualSign(manualSign);
}
public static void DeleteManualSignBySignId(int signId)
{
ManualSignService.DeleteManualSignBySignId(signId);
}
public static ManualSign GetManualSignById(int newId)
{
return(ManualSignService.GetManualSignById(newId));
}
public static ManualSign AddManualSign(ManualSign manualSign)
{
return(ManualSignService.AddManualSign(manualSign));
}
