private void btn_submit_Click(object sender, EventArgs e) { Entity.Leave le = new Entity.Leave(); //员工编号 le.pID = int.Parse(this.textBox4.Text); //开始时间 string Ls = this.dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss.ffff"); le.lStart = DateTime.Parse(Ls); //结束时间 string lsp = this.dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss.ffff"); le.lStop = DateTime.Parse(lsp); //请假原因 le.lWhy = this.textBox2.Text; le.lBoss = users.uName; //审核状态 le.lState = "通过"; if (BLL.LeaveBLL.Leaves1(le) == true) { Msg.Box.Show("恭喜您,添加成功!"); clear(); } }
private void btn_submit_Click(object sender, EventArgs e) { Entity.Leave l = new Entity.Leave(); try { l.pID = p.pID; l.lWhy = this.txt_reason.Text; l.lStart = this.dtp_start.Value; l.lStop = this.dtp_stop.Value; } catch (Exception ex) { MessageBox.Show(ex.Message); return; } string msg = ""; if (EBLL.WorkBLL.SubLeave(l, out msg) == true) { MessageBox.Show(msg); this.dtp_start.Value = System.DateTime.Now; this.dtp_stop.Value = System.DateTime.Now; this.txt_reason.Clear(); this.dgv_main.DataSource = EBLL.WorkBLL.LoadLeave(p); } else { MessageBox.Show(msg); } }
/// <summary> /// 按开始时间查询 /// </summary> /// <param name="leave6"></param> /// <returns></returns> public static DataTable LeaveLstart(Entity.Leave leave6) { string sqlstr = "select LID,Leave.PID,PName,LWhy,LStart,LStop,LBoss,Lstate from Leave,Person where Leave.PID=Person.PID and year(LStart) = " + leave6.lStart.Year + " and month(LStart) = " + leave6.lStart.Month + " and day(LStart) = " + leave6.lStart.Day + ""; DataTable dt = (DataTable)DBHelper.GetDT(sqlstr); return(dt); }
//按员工姓名查询查询 public static DataTable LeavePName(Entity.Leave leave5, string name) { string sqlstr = "select LID,Leave.PID,PName,LWhy,LStart,LStop,LBoss,Lstate from Leave,Person where Leave.PID=Person.PID and PName like '%" + name + "%'"; DataTable dt = (DataTable)DBHelper.GetDT(sqlstr); return(dt); }
public Entity.Leave GetLeave(LeavePO leavePO) { var leave = new Entity.Leave(); leave.Id = leavePO.Id; var applicant = new Applicant() { PersonId = leavePO.ApplicantId, PersonName = leavePO.ApplicantName }; leave.Applicant = applicant; var approver = new Approver() { PersonId = leavePO.ApproverId, PersonName = leavePO.ApproverName }; leave.Approver = approver; leave.StartTime = leavePO.StartTime; leave.EndTime = leavePO.EndTime; leave.Duration = leavePO.Duration; leave.Status = leavePO.Status; leave.MaxLeaderLevel = leavePO.MaxLeaderLevel; if (leavePO.HistoryApprovalInfoPOList?.Count > 0) { leave.HistoryApprovalInfos = GetApprovalInfos(leavePO.HistoryApprovalInfoPOList); } return(leave); }
private void btn_find_Click(object sender, EventArgs e) { Entity.Leave le = new Entity.Leave(); Entity.Department dp = new Entity.Department(); try { if (this.radioButton1.Checked) { le.pID = int.Parse(this.textBox1.Text); dataGridView1.DataSource = BLL.LeaveBLL.LeavePID(le); int i = this.dataGridView1.Rows.Count; if (i == 0) { Msg.Box.Show("未查找到您所要的信息!"); } } else if (this.radioButton2.Checked) { dp.depID = int.Parse(this.comboBox1.SelectedValue.ToString()); dataGridView1.DataSource = BLL.LeaveBLL.LeaveDep(dp); int i = this.dataGridView1.Rows.Count; if (i == 0) { Msg.Box.Show("未查找到您所要的信息!"); } } else if (this.radioButton3.Checked) { string name = this.textBox2.Text; dataGridView1.DataSource = BLL.LeaveBLL.LeavePName(le, name); int i = this.dataGridView1.Rows.Count; if (i == 0) { Msg.Box.Show("未查找到您所要的信息!"); } } else if (this.radioButton4.Checked) { le.lStart = this.dateTimePicker1.Value; dataGridView1.DataSource = BLL.LeaveBLL.LeaveLstart(le); int i = this.dataGridView1.Rows.Count; if (i == 0) { Msg.Box.Show("未查找到您所要的信息!"); } } else { Msg.Box.Show("您还未勾选查询方式"); return; } } catch (Exception ex) { Msg.Box.Show(ex.Message); return; } }
private List <ApprovalInfoPO> ApprovalInfoPOListFromDO(Entity.Leave leave) { var approvalInfoPos = new List <ApprovalInfoPO>(); foreach (var approvalInfo in leave.HistoryApprovalInfos) { approvalInfoPos.Add(ApprovalInfoPOFromDO(approvalInfo)); } return(approvalInfoPos); }
public void UpdateLeaveInfo(Entity.Leave leave) { var po = _leaveRepository.FindById(leave.Id); if (null == po) { throw new Exception("leave does not exist"); } _leaveRepository.Save(_leaveFactory.CreateLeavePO(leave)); }
public void CreateLeave(Entity.Leave leave, int maxLeaderLevel, Approver approver) { leave.MaxLeaderLevel = maxLeaderLevel; leave.Approver = approver; leave.Create(); _leaveRepository.Save(_leaveFactory.CreateLeavePO(leave)); var @event = LeaveEvent.Create(LeaveEventType.CREATE_EVENT, leave); _leaveRepository.SaveEvent(_leaveFactory.CreateLeaveEventPO(@event)); _eventPublisher.Publish(@event); }
/// <summary> /// //更新请假详情 LWhy传递状态 /// </summary> /// <param name="le"></param> /// <returns></returns> public static bool UpLeave(Entity.Leave le) { if (DAL.LeaveDAL.UpLeave(le) > 0) { return(true); } else { return(false); } }
public static LeaveEvent Create(LeaveEventType eventType, Entity.Leave leave) { var @event = new LeaveEvent() { Id = IdGenerator.NextId(), LeaveEventType = eventType, Timestamp = DateTime.Now, Data = JsonConvert.SerializeObject(leave) }; return(@event); }
//添加请假信息 public static bool Leave1(Entity.Leave leave) { string sqlstr = string.Format("insert into Leave values({0},'{1}','{2}','{3}','{4}','{5}')", leave.pID, leave.lWhy, leave.lStart, leave.lStop, leave.lBoss, leave.lState); int i = (int)DBHelper.GetLine(sqlstr); if (i > 0) { return(true); } else { return(false); } }
public void SubmitApproval(Entity.Leave leave, Approver approver) { if (leave.CurrentApprovalInfo != null) { //根据当前审批信息,确定案件状态 switch (leave.CurrentApprovalInfo.ApprovalType) { case ApprovalType.REJECT: leave.Status = Status.REJECTED; break; case ApprovalType.AGREE: leave.Status = Status.APPROVED; break; } } LeaveEvent @event; if (ApprovalType.REJECT == leave.CurrentApprovalInfo.ApprovalType) { //拒约后保持原来批准人 leave.Reject(leave.Approver); @event = LeaveEvent.Create(LeaveEventType.REJECT_EVENT, leave); } else { if (approver != null) { //通过后更换下一审批人 leave.Agree(approver); @event = LeaveEvent.Create(LeaveEventType.AGREE_EVENT, leave); } else { leave.Finish(); @event = LeaveEvent.Create(LeaveEventType.APPROVED_EVENT, leave); } } leave.AddHistoryApprovalInfo(leave.CurrentApprovalInfo); var leavePO = _leaveFactory.CreateLeavePO(leave); _leaveRepository.Submit(leavePO); _leaveRepository.SaveEvent(_leaveFactory.CreateLeaveEventPO(@event)); _eventPublisher.Publish(@event); }
private void btn_clear_Click(object sender, EventArgs e) { Entity.Leave l = new Entity.Leave(); try { l.lID = int.Parse(this.dgv_main.Rows[dgv_main.CurrentCell.RowIndex].Cells[0].Value.ToString()); } catch { MessageBox.Show("请先选择记录行!"); return; } if (EBLL.WorkBLL.UpLState(l) == true) { MessageBox.Show("恭喜您,销假成功!"); EBLL.WorkBLL.UpLState(l); this.dgv_main.DataSource = EBLL.WorkBLL.LoadLeave(p); } }
public LeavePO CreateLeavePO(Entity.Leave leave) { var leavePO = new LeavePO() { Id = leave.Id == null?Guid.NewGuid().ToString() : leave.Id, ApplicantId = leave.Applicant.PersonId, ApplicantName = leave.Applicant.PersonName, ApproverId = leave.Approver?.PersonId, ApproverName = leave.Approver?.PersonName, StartTime = leave.StartTime, EndTime = leave.EndTime, Duration = leave.Duration, Status = leave.Status, //生成请假条时没有当前批认信息 CurrentApprovalInfo = leave.CurrentApprovalInfo != null?ApprovalInfoPOFromDO(leave.CurrentApprovalInfo, leave.Applicant.PersonId, leave.Id) : null, HistoryApprovalInfoPOList = ApprovalInfoPOListFromDO(leave), MaxLeaderLevel = leave.MaxLeaderLevel, LeaveType = leave.LeaveType, ApplicantType = leave.Applicant.PersonType }; return(leavePO); }
//按员工编号查询查询 public static DataTable LeavePID(Entity.Leave leave3) { return(DAL.LeaveDAL.LeavePID(leave3)); }
/// <summary> /// 按开始时间查询 /// </summary> /// <param name="leave6"></param> /// <returns></returns> public static DataTable LeaveLstart(Entity.Leave leave6) { return(DAL.LeaveDAL.LeaveLstart(leave6)); }
//添加数据 public static bool Leaves1(Entity.Leave leaves1) { return(DAL.LeaveDAL.Leave1(leaves1)); }
/// <summary> /// 提交请假申请 /// </summary> /// <param name="l"></param> /// <returns></returns> public static int SubLeave(Entity.Leave l) { string sql = string.Format("insert into Leave values({0},'{1}','{2}','{3}','终端提交','待审核')", l.pID, l.lWhy, l.lStart.ToString("yyyy-MM-dd HH:mm:ss"), l.lStop.ToString("yyyy-MM-dd HH:mm:ss")); return((int)DBHelper.GetLine(sql)); }
//按员工姓名查询查询 public static DataTable LeavePName(Entity.Leave leave4, string name) { return(DAL.LeaveDAL.LeavePName(leave4, name)); }
/// <summary> /// 报到 /// </summary> /// <returns></returns> public static int UpLState(Entity.Leave l) { string sql = "update Leave set LState = '已销假' where LID = " + l.lID + ""; return((int)DBHelper.GetLine(sql)); }
/// <summary> /// 更新信息状态 /// </summary> /// <param name="p"></param> /// <returns></returns> public static int UpPState(Entity.Leave l) { string sql = "update Person set PState='正式' where PID=" + l.pID + ""; return(DBHelper.GetLine(sql)); }
/// <summary> /// //更新请假详情 LWhy传递状态 /// </summary> /// <param name="le"></param> /// <returns></returns> public static int UpLeave(Entity.Leave le) { string sql = "update Leave set LState='" + le.lWhy + "',LBoss='" + le.lBoss + "' where PID=" + le.pID + ""; return(DBHelper.GetLine(sql)); }