public List <HRLeave> FindByWhereForMgr(HRLeave vo, string mgrDeptId, string mgrEmpId) { string whereSql = ""; if (!EmptyUtils.EmptyStr(vo.Id)) { whereSql += " and id=@Id"; } if (vo.Status > 0) { whereSql += " and Status=@Status"; } if (!EmptyUtils.EmptyStr(vo.EmpId)) { whereSql += " and EMP_ID=@EmpId"; } string sql = "SELECT * FROM HR_LEAVE WHERE EMP_ID != @MgrEmpId "; sql = sql += whereSql; sql = sql += " AND EMP_ID IN (SELECT EMP_ID FROM HR_EMPLOYEE WHERE DEPT_ID = @mgrDeptId) "; return(conn.Query <HRLeave>(sql, new { Id = vo.Id, Status = vo.Status, EmpId = vo.EmpId, MgrEmpId = mgrDeptId, mgrDeptId = mgrDeptId }).ToList()); }
private void btnCommit_Click(object sender, EventArgs e) { if (!validateInput()) { return; } if (dao.FindByDate(dtStartDate.Text).Count > 0) { MessageBoxEx.Show(this, dtStartDate.Text + "已经请过假了,请选择其他日期"); return; } HRLeave vo = new HRLeave(); vo.Id = UidUtils.GGuidPrefix(); vo.EmpId = GlobalInfo.loginEmp.Id; vo.Cause = txtCause.Text; vo.Type = !EmptyUtils.EmptyObj(cboLeaveType.SelectedValue) ? int.Parse(cboLeaveType.SelectedValue.ToString()) : -1; vo.LeaveDay = int.Parse(txtLeaveDay.Text); vo.LeaveDate = dtStartDate.Text; vo.Status = 1;// 提交申请 dao.Add(vo); DialogResult ret = MessageBoxEx.Show(this, "请假提交成功"); Close(); }
public List <HRLeave> FindByWhereForAdmin(HRLeave vo) { string whereSql = ""; if (!EmptyUtils.EmptyStr(vo.Id)) { whereSql += " and id=@Id"; } if (vo.Status > 0) { whereSql += " and Status=@Status"; } if (!EmptyUtils.EmptyStr(vo.EmpId)) { whereSql += " and EMP_ID=@EmpId"; } string sql = "SELECT * FROM HR_LEAVE WHERE 1=1 "; sql = sql += whereSql; sql = sql += " AND EMP_ID IN(SELECT EMP_ID FROM HR_USER WHERE USER_TYPE = 2)"; return(conn.Query <HRLeave>(sql, new { Id = vo.Id, Status = vo.Status, EmpId = vo.EmpId }).ToList()); }
/// <summary> /// 输入转VO /// </summary> /// <returns></returns> private HRLeave InputToVo() { HRLeave vo = new HRLeave(); vo.Id = txtId.Text; vo.EmpId = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? cboEmp.SelectedValue.ToString() : ""; vo.EmpName = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? ((HREmployee)cboEmp.SelectedItem).Name : ""; vo.Status = !EmptyUtils.EmptyObj(cboStatus.SelectedValue) ? int.Parse(cboStatus.SelectedValue.ToString()) : -1; return(vo); }
private void btnFail_Click(object sender, EventArgs e) { if (grid.CurrentRow.Index >= 0) { HRLeave vo = list[grid.CurrentRow.Index]; dao.Update(vo.Id, 3); // 通过 initData(); } }
/// <summary> /// 更新 /// </summary> /// <returns></returns> public int Update(HRLeave vo) { //return conn.Execute(@"update HR_LEAVE SET NAME=@Name,CREATE_TIME=@CreateTime WHERE id = @Id", // new // { // Id = vo.Id, // Name = vo.Name, // CreateTime = vo.CreateTime // }); return(0); }
// 新增 public int Add(HRLeave vo) { int ret = conn.Execute(@"insert HR_LEAVE(ID,EMP_ID,TYPE,LEAVE_DATE,LEAVE_DAY,CAUSE,STATUS) values (@Id,@EmpId,@Type, @LeaveDate, @LeaveDay,@Cause,@Status)", new[] { new { Id = vo.Id, EmpId = vo.EmpId, Type = vo.Type, LeaveDate = vo.LeaveDate, LeaveDay = vo.LeaveDay, Cause = vo.Cause, Status = vo.Status } }); Console.WriteLine(string.Format("插入数据库成功{0}", ret)); return(ret); }
private void grid_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } HRLeave vo = list[e.RowIndex]; if (vo.Status == 1) { btnPass.Enabled = true; btnFail.Enabled = true; } else { btnPass.Enabled = false; btnFail.Enabled = false; } }
private void btnFind_Click(object sender, EventArgs e) { HRLeave vo = InputToVo(); if (GlobalInfo.loginUser.UserType == GlobalInfo.ADMIN) { list = dao.FindByWhereForAdmin(vo); var bindingList = new BindingList <HRLeave>(list); listSource = new BindingSource(bindingList, null); grid.DataSource = listSource; } else if (GlobalInfo.loginUser.UserType == GlobalInfo.DEPT_MGR) { list = dao.FindByWhereForMgr(vo, GlobalInfo.loginEmp.DeptId, GlobalInfo.loginEmp.Id); var bindingList = new BindingList <HRLeave>(list); listSource = new BindingSource(bindingList, null); grid.DataSource = listSource; } }