/// <summary>
/// 新增请假类别
/// </summary>
/// <param name="leaveType">请假类别数据集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool AddLeaveType(HR_LeaveType leaveType, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_LeaveType
where a.TypeCode == leaveType.TypeCode
select a;
if (result.Count() != 0)
{
error = "【" + leaveType.TypeCode + "】请假编号已经存在，请查证后再操作！";
return(false);
}
dataContxt.HR_LeaveType.InsertOnSubmit(leaveType);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public ActionResult AddLeaveType(HR_LeaveType leave, string LeaveType, string LeaveTypeCode, float LeaveDay)
{
leave.LeaveType = LeaveType;
leave.LeaveTypeCode = LeaveTypeCode;
leave.LeaveDay = LeaveDay;
db.HR_LeaveType.Add(leave);
db.SaveChanges();
return(PartialView());
}
public ActionResult UpdateLeaveType(HR_LeaveType leave, int Id, string LeaveType, string LeaveTypeCode, float LeaveDay)
{
leave = db.HR_LeaveType.FirstOrDefault(x => x.LeaveTypeId == Id);
if (leave == null)
{
return(HttpNotFound());
}
leave.LeaveType = LeaveType;
leave.LeaveTypeCode = LeaveTypeCode;
leave.LeaveDay = LeaveDay;
db.SaveChanges();
return(PartialView());
}
/// <summary>
/// 修改请假类别
/// </summary>
/// <param name="leaveType">请假类别数据集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true,失败返回False</returns>
public bool UpdateLeaveType(HR_LeaveType leaveType, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_LeaveType
where a.TypeCode == leaveType.TypeCode
select a;
if (result.Count() != 1)
{
error = "【" + leaveType.TypeCode + "】请假编号已经存在，请查证后再操作！";
return(false);
}
HR_LeaveType leaveList = result.Single();
leaveList.TypeName = leaveType.TypeName;
leaveList.ParentTypeCode = leaveType.ParentTypeCode;
leaveList.IncludeHoliday = leaveType.IncludeHoliday;
leaveList.LeaveMode = leaveType.LeaveMode;
leaveList.MaxHours = leaveType.MaxHours;
leaveList.MaxTimes = leaveType.MaxTimes;
leaveList.MinHours = leaveType.MinHours;
leaveList.PaidLeave = leaveType.PaidLeave;
leaveList.Remark = leaveType.Remark;
leaveList.Recorder = leaveType.Recorder;
leaveList.RecordTime = leaveType.RecordTime;
leaveList.NeedAnnex = leaveType.NeedAnnex;
leaveList.DeleteFlag = leaveType.DeleteFlag;
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public void Check_LeaveType(string typeCode, decimal hours, int?billID)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
IDBOperate m_dbOperate = CommentParameter.GetDBOperatorOfDepotManagement();
HR_LeaveType leaveType = GetLeaveType(ctx, typeCode);
Hashtable paramTable = new Hashtable();
paramTable.Add("@TypeCode", leaveType.TypeCode);
paramTable.Add("@Hours", hours);
paramTable.Add("@WorkID", BasicInfo.LoginID);
paramTable.Add("@BillID", billID == null ? 0 : billID);
Dictionary <OperateCMD, object> dicOperateCMD = m_dbOperate.RunProc_CMD("HR_LeaveBill_Type_Check", paramTable);
if (!Convert.ToBoolean(dicOperateCMD[OperateCMD.Return_OperateResult]))
{
throw new Exception(Convert.ToString(dicOperateCMD[OperateCMD.Return_Errmsg]));
}
}
/// <summary>
/// 获取HR_LeaveType数据集
/// </summary>
/// <returns></returns>
HR_LeaveType GetLeaveType()
{
string[] type = cmbParentTypeCode.Text.Split(' ');
HR_LeaveType leaveType = new HR_LeaveType();
leaveType.TypeCode = txtTypeCode.Text;
leaveType.TypeName = txtTypeName.Text;
leaveType.ParentTypeCode = type[0].ToString();
leaveType.Remark = txtRemark.Text;
leaveType.RecordTime = ServerTime.Time;
leaveType.Recorder = BasicInfo.LoginID;
leaveType.PaidLeave = cbPaidLeave.Checked;
leaveType.MinHours = numMinHours.Value;
leaveType.MaxTimes = Convert.ToInt32(numMaxTimes.Value);
leaveType.MaxHours = numMaxHours.Value;
leaveType.LeaveMode = cmbLeaveMode.Text;
leaveType.IncludeHoliday = cbIncludeHoliday.Checked;
leaveType.NeedAnnex = cbNeedAnnex.Checked;
leaveType.DeleteFlag = chbIsDelete.Checked;
return(leaveType);
}
