/// <summary>
/// 根据条件，获取考勤异常扣款明细信息
/// </summary>
/// <param name="strOwnerID">登录用户的员工ID(权限控制)</param>
/// <param name="strDeductMasterID">外键索引</param>
/// <param name="strSortKey">排序字段</param>
/// <returns></returns>
public IQueryable <T_HR_ATTENDANCEDEDUCTDETAIL> GetAllAttendanceDeductDetailRdListByMultSearch(string strOwnerID, string strDeductMasterID, string strSortKey)
{
AttendanceDeductDetailDAL dalAttendanceDeductDetail = new AttendanceDeductDetailDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strDeductMasterID))
{
strfilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0");
objArgs.Add(strDeductMasterID);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " DEDUCTDETAILID ";
}
string filterString = strfilter.ToString();
//SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDANCEDEDUCTDETAIL");
var q = dalAttendanceDeductDetail.GetAttendanceDeductDetailRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray());
return(q);
}
public string DeleteDeductDetailByMasterID(string strAttendanceDeductMasterId)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strAttendanceDeductMasterId))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0");
objArgs.Add(strAttendanceDeductMasterId);
AttendanceDeductDetailDAL dalDeductDetail = new AttendanceDeductDetailDAL();
flag = dalDeductDetail.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
string strOrderBy = " DEDUCTMASTERID ";
var q = dalDeductDetail.GetAttendanceDeductDetailRdListByMultSearch(strOrderBy, strFilter.ToString(), objArgs.ToArray());
if (q == null)
{
return(strMsg);
}
if (q.Count() == 0)
{
return(strMsg);
}
foreach (T_HR_ATTENDANCEDEDUCTDETAIL item in q)
{
dalDeductDetail.Delete(item);
}
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}