/// <summary>
/// 根据条件，获取考勤异常扣款信息
/// </summary>
/// <param name="strAttType"></param>
/// <param name="strFineType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public IQueryable <T_HR_ATTENDANCEDEDUCTMASTER> GetAllAttendanceDeductMasterRdListByMultSearch(string strOwnerID, string strAttType, string strSortKey)
{
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strAttType))
{
strfilter.Append(" ATTENDABNORMALTYPE == @0");
objArgs.Add(strAttType);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " DEDUCTMASTERID ";
}
string filterString = strfilter.ToString();
SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDANCEDEDUCTMASTER");
var q = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray());
return(q);
}
/// <summary>
/// 新增考勤异常扣款主表信息
/// </summary>
/// <param name="entLTRd"></param>
/// <returns></returns>
public string AddDeductMaster(T_HR_ATTENDANCEDEDUCTMASTER entTemp)
{
string strMsg = string.Empty;
try
{
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
bool flag = false;
strfilter.Append(" ATTENDABNORMALNAME == @0");
strfilter.Append(" && ATTENDABNORMALTYPE == @1");
objArgs.Add(entTemp.ATTENDABNORMALNAME);
objArgs.Add(entTemp.ATTENDABNORMALTYPE);
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
flag = dalAttendanceDeductMaster.IsExistsRd(strfilter.ToString(), objArgs.ToArray());
if (flag)
{
return("{ALREADYEXISTSRECORD}");
}
dalAttendanceDeductMaster.Add(entTemp);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
public EntityObject[] GetLookupData(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID)
{
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
strOrderBy = " DEDUCTMASTERID ";
objArgs.AddRange(paras);
SetOrganizationFilter(ref filterString, ref objArgs, userID, "T_HR_ATTENDANCEDEDUCTMASTER");
IQueryable <T_HR_ATTENDANCEDEDUCTMASTER> ents = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray());
T_HR_ATTENDANCEDEDUCTMASTER[] temp = ents.Count() > 0 ? ents.ToArray() : null;
return(temp);
}
/// <summary>
/// 修改考勤异常扣款主表信息
/// </summary>
/// <param name="entLTRd"></param>
/// <returns></returns>
public string ModifyDeductMaster(T_HR_ATTENDANCEDEDUCTMASTER entTemp)
{
string strMsg = string.Empty;
try
{
if (entTemp == null)
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" DEDUCTMASTERID == @0");
objArgs.Add(entTemp.DEDUCTMASTERID);
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
flag = dalAttendanceDeductMaster.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
//dalAttendanceDeductMaster.DataContext.SaveChanges();
T_HR_ATTENDANCEDEDUCTMASTER entUpdate = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
Utility.CloneEntity(entTemp, entUpdate);
dalAttendanceDeductMaster.Update(entUpdate);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 获取考勤异常扣款信息
/// </summary>
/// <param name="strAttendanceDeductMasterId">主键索引</param>
/// <returns></returns>
public T_HR_ATTENDANCEDEDUCTMASTER GetAttendanceDeductMasterByID(string strAttendanceDeductMasterId)
{
if (string.IsNullOrEmpty(strAttendanceDeductMasterId))
{
return(null);
}
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strAttendanceDeductMasterId))
{
strfilter.Append(" DEDUCTMASTERID == @0");
objArgs.Add(strAttendanceDeductMasterId);
}
T_HR_ATTENDANCEDEDUCTMASTER entRd = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strfilter.ToString(), objArgs.ToArray());
return(entRd);
}
/// <summary>
/// 根据主键索引，删除考勤异常扣款信息(注：暂定为物理删除)
/// </summary>
/// <param name="strVacationId">主键索引</param>
/// <returns></returns>
public string DeleteDeductMaster(string strAttendanceDeductMasterId)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strAttendanceDeductMasterId))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strAttDedFilter = new StringBuilder();
List <string> objAttDedArgs = new List <string>();
strAttDedFilter.Append(" DEDUCTMASTERID == @0");
objAttDedArgs.Add(strAttendanceDeductMasterId);
AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL();
flag = dalAttendanceDeductMaster.IsExistsRd(strAttDedFilter.ToString(), objAttDedArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
StringBuilder strAttDetailFilter = new StringBuilder();
List <string> objAttDetailArgs = new List <string>();
strAttDetailFilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0");
objAttDetailArgs.Add(strAttendanceDeductMasterId);
AttendanceDeductDetailBLL bllAttendanceDeductDetail = new AttendanceDeductDetailBLL();
bllAttendanceDeductDetail.DeleteDeductDetailByMasterID(strAttendanceDeductMasterId);
StringBuilder strAttSolDedFilter = new StringBuilder();
List <string> objAttSolDedArgs = new List <string>();
strAttSolDedFilter.Append(" T_HR_ATTENDANCESOLUTION.CHECKSTATE != @0");
strAttSolDedFilter.Append(" && T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @1");
objAttSolDedArgs.Add(Convert.ToInt32(CheckStates.UnSubmit).ToString());
objAttSolDedArgs.Add(strAttendanceDeductMasterId);
AttendanceSolutionDeductBLL bllAttendanceSolutionDeduct = new AttendanceSolutionDeductBLL();
flag = bllAttendanceSolutionDeduct.IsExistsRd(strAttSolDedFilter.ToString(), objAttSolDedArgs.ToArray());
if (flag)
{
return("已存在进入审核状态的考勤方案与当前的考勤异常扣款设置有关联，不能直接删除");
}
T_HR_ATTENDANCEDEDUCTMASTER entDel = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strAttDedFilter.ToString(), objAttDedArgs.ToArray());
dalAttendanceDeductMaster.Delete(entDel);
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
