/// <summary>
/// 通过名字找请假
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public LeaveRequestType GetLeaveRequestTypeByName(string name)
{
LeaveRequestType leave = null;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 50).Value = name;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetLeaveRequestTypeByName", cmd))
{
while (sdr.Read())
{
leave = new LeaveRequestType(Convert.ToInt32(sdr[_DBPKID]),
sdr[_DBName].ToString(),
sdr[_DBDescription] == DBNull.Value
? null
: sdr[_DBDescription].ToString(),
(LegalHoliday)sdr[_DBIncludeNationalHolidays],
(RestDay)sdr[_DBIncludeRestDay],
Convert.ToDecimal(sdr[_DBLeastHour]));
break;
}
}
return(leave);
}
public List <LeaveRequestType> GetLeaveRequestTypeByNameLike(string namelike)
{
List <LeaveRequestType> leaveTypeList = new List <LeaveRequestType>();
SqlCommand cmd = new SqlCommand();
if (!String.IsNullOrEmpty(namelike))
{
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 50).Value = namelike;
}
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetLeaveRequestTypeByNameLike", cmd))
{
while (sdr.Read())
{
LeaveRequestType leave = new LeaveRequestType(Convert.ToInt32(sdr[_DBPKID]),
sdr[_DBName].ToString(),
sdr[_DBDescription] == DBNull.Value
? null
: sdr[_DBDescription].ToString(),
(LegalHoliday)sdr[_DBIncludeNationalHolidays],
(RestDay)sdr[_DBIncludeRestDay],
Convert.ToDecimal(sdr[_DBLeastHour]));
leaveTypeList.Add(leave);
}
}
return(leaveTypeList);
}
private List <LeaveRequestType> GetLeaveRequestTypeList(List <Employee> employeeAttendenceList)
{
List <LeaveRequestType> leaveRequestTypeList = new List <LeaveRequestType>();
foreach (Employee employee in employeeAttendenceList)
{
if (employee.EmployeeAttendance == null || employee.EmployeeAttendance.MonthAttendance == null ||
employee.EmployeeAttendance.MonthAttendance.LeaveRequestStatisticsList == null)
{
continue;
}
foreach (
LeaveRequestStatistics leaveRequestStatistics in
employee.EmployeeAttendance.MonthAttendance.LeaveRequestStatisticsList)
{
if (
LeaveRequestType.FindLeaveRequestType(leaveRequestTypeList,
leaveRequestStatistics.LeaveRequestType.LeaveRequestTypeID) ==
null)
{
leaveRequestTypeList.Add(leaveRequestStatistics.LeaveRequestType);
}
}
}
LeaveRequestType.OrderLeaveRequestType(leaveRequestTypeList);
return(leaveRequestTypeList);
}
/// <summary>
///
/// </summary>
public JudgeProbation(List <LeaveRequestItem> itemList, int AccountID, LeaveRequestType type,
IEmployee dalEmployee)
{
_DalEmployee = dalEmployee;
_ItemList = itemList;
_Type = type;
_Employee = _DalEmployee.GetEmployeeByAccountID(AccountID);
}
/// <summary>
///
/// </summary>
public DeleteVacationByLeaveReuqest(int accountid, List <LeaveRequestItem> leaveRequestitems,
LeaveRequestType type)
{
_AccountID = accountid;
_LeaveRequestItems = leaveRequestitems;
_Type = type;
_VacationList = _VacationDal.GetVacationByAccountID(_AccountID);
}
private static decimal GetLeaveRequestStatisticsData(LeaveRequestType leaveRequestType, Employee e, bool ishours)
{
foreach (LeaveRequestStatistics item in e.EmployeeAttendance.MonthAttendance.LeaveRequestStatisticsList)
{
if (item.LeaveRequestType.LeaveRequestTypeID == leaveRequestType.LeaveRequestTypeID)
{
return(ishours ? item.Hours : item.Days);
}
}
return(0);
}
private void Init()
{
LeaveRequestType leaveRequestType = _LeaveRequestTypeDal.GetLeaveRequestTypeByPkid(_LeaveRequestTypeID);
//_LeaveRequests=_leaveRequestDal.GetLeaveRequestByCondition(_AccountID, _From.Date, _To.Date.AddHours(24), RequestStatus.All);
_LeaveRequestTypeName = leaveRequestType.Name;
_LeastHour = leaveRequestType.LeastHour;
_IncludeLegalHoliday = leaveRequestType.IncludeLegalHoliday == LegalHoliday.Include;
_IncludeRestDay = leaveRequestType.IncludeRestDay == RestDay.Include;
_PlanDutyDetailList = _PlanDutyDal.GetPlanDutyDetailByAccount(_AccountID, _From, _To);
_CalculateDays = new CalculateDays(_SpecialDateBll.GetAllSpecialDate(null));
}
/// <summary>
/// 用于测试
/// </summary>
public void TestExcute(int accountid, List <LeaveRequestItem> leaveRequestitems, LeaveRequestType type,
List <Vacation> VacationList, List <DayAttendance> dayAttendanceList,
IVacation mockvacation)
{
_AccountID = accountid;
_LeaveRequestItems = leaveRequestitems;
_Type = type;
_VacationList = VacationList;
_DayAttendanceList = dayAttendanceList;
_IsTest = true;
_VacationDal = mockvacation;
Excute();
}
protected override void Validation()
{
if (_LeaveRequestTypeDal.GetLeaveRequestTypeByPkid(_LeaveRequestType.LeaveRequestTypeID) == null)
{
HrmisUtility.ThrowException(HrmisUtility._LeaveRequestType_Name_NotExist);
}
LeaveRequestType leaveRequestType = _LeaveRequestTypeDal.GetLeaveRequestTypeByName(_LeaveRequestType.Name);
if (leaveRequestType != null && leaveRequestType.LeaveRequestTypeID != _LeaveRequestType.LeaveRequestTypeID)
{
HrmisUtility.ThrowException(HrmisUtility._LeaveRequestType_Name_Repeat);
}
}
/// <summary>
/// 修改请假类型
/// </summary>
/// <param name="leaveRequestType"></param>
public void UpdateLeaveRequestType(LeaveRequestType leaveRequestType)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = leaveRequestType.LeaveRequestTypeID;
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 50).Value = leaveRequestType.Name;
if (String.IsNullOrEmpty(leaveRequestType.Description))
{
cmd.Parameters.Add(_Description, SqlDbType.Text).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(_Description, SqlDbType.Text).Value = leaveRequestType.Description;
}
cmd.Parameters.Add(_IncludeNationalHolidays, SqlDbType.Int).Value = leaveRequestType.IncludeLegalHoliday;
cmd.Parameters.Add(_IncludeRestDay, SqlDbType.Int).Value = leaveRequestType.IncludeRestDay;
cmd.Parameters.Add(_LeastHour, SqlDbType.Decimal).Value = leaveRequestType.LeastHour;
SqlHelper.ExecuteNonQuery("LeaveRequestTypeUpdate", cmd);
}
private bool ValidateAndInitLeaveType(string type)
{
List <LeaveRequestType> allLeaveType = _GetLeaveRequestType.GetAllLeaveRequestType();
if (allLeaveType == null || allLeaveType.Count < 1)
{
return(false);
}
else
{
foreach (LeaveRequestType leaveType in allLeaveType)
{
if (leaveType.Name == type)
{
_LeaveRequestType = leaveType;
return(true);
}
}
}
return(false);
}
/// <summary>
/// 添加请假类型
/// </summary>
public int InsertLeaveRequestType(LeaveRequestType leaveRequestType)
{
int pkid;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 50).Value = leaveRequestType.Name;
if (String.IsNullOrEmpty(leaveRequestType.Description))
{
cmd.Parameters.Add(_Description, SqlDbType.Text).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(_Description, SqlDbType.Text).Value = leaveRequestType.Description;
}
cmd.Parameters.Add(_IncludeNationalHolidays, SqlDbType.Int).Value = leaveRequestType.IncludeLegalHoliday;
cmd.Parameters.Add(_IncludeRestDay, SqlDbType.Int).Value = leaveRequestType.IncludeRestDay;
cmd.Parameters.Add(_LeastHour, SqlDbType.Decimal).Value = leaveRequestType.LeastHour;
SqlHelper.ExecuteNonQueryReturnPKID("LeaveRequestTypeInsert", cmd, out pkid);
return(leaveRequestType.LeaveRequestTypeID = pkid);
}
/// <summary>
///
/// </summary>
/// <param name="leaveRequestType"></param>
public void UpdateLeaveRequestType(LeaveRequestType leaveRequestType)
{
new UpdateLeaveRequestType(leaveRequestType).Excute();
}
/// <summary>
///
/// </summary>
/// <param name="leaveRequestType"></param>
public void AddLeaveRequestType(LeaveRequestType leaveRequestType)
{
new AddLeaveRequestType(leaveRequestType).Excute();
}
/// <summary>
///
/// </summary>
/// <param name="leaveRequestType"></param>
public UpdateLeaveRequestType(LeaveRequestType leaveRequestType)
{
_LeaveRequestType = leaveRequestType;
}
/// <summary>
/// test
/// </summary>
/// <param name="leaveRequestType"></param>
/// <param name="iLeaveRequestType"></param>
public UpdateLeaveRequestType(LeaveRequestType leaveRequestType, ILeaveRequestType iLeaveRequestType)
: this(leaveRequestType)
{
_LeaveRequestTypeDal = iLeaveRequestType;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="leaveRequestType"></param>
public LeaveRequestStatistics(LeaveRequestType leaveRequestType)
{
_LeaveRequestType = leaveRequestType;
}
