/// <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); }