public List <HRContract> FindByWhere(HRContract vo) { string whereSql = ""; if (!EmptyUtils.EmptyStr(vo.Id)) { whereSql += " and c.id=@Id"; } if (vo.Salary > 0) { whereSql += " and c.Salary=@Salary"; } if (vo.Probation > 0) { whereSql += " and c.Probation=@Probation"; } if (!EmptyUtils.EmptyStr(vo.EmpId)) { whereSql += " and c.EMP_ID=@EmpId"; } string sql = "SELECT c.*, e.name as EMP_NAME FROM HR_CONTRACT c ,HR_EMPLOYEE e where c.EMP_ID = e.ID"; return(conn.Query <HRContract>(sql + whereSql, new { Id = vo.Id, Salary = vo.Salary, Probation = vo.Probation, EmpId = vo.EmpId }).ToList()); }
private void InitData() { // 合同类型 cboContractType.DataSource = DataDictionaryUtils.GetContractTypeDict(); cboContractType.SelectedIndex = -1; empList = empDao.FindAll(); cboEmp.DataSource = empList; cboEmp.SelectedIndex = -1; if (GlobalInfo.loginEmp != null) { HRContract vo = dao.FindByEmpId(GlobalInfo.loginEmp.Id); if (vo != null) { txtId.Text = vo.Id; txtProbation.Text = vo.Probation.ToString(); txtSalary.Text = vo.Salary.ToString(); cboEmp.SelectedValue = vo.EmpId; dtETime.Text = vo.EndTime; dtSTime.Text = vo.StartTime; } } }
private void btnFind_Click(object sender, EventArgs e) { HRContract vo = InputToVo(); list = dao.FindByWhere(vo); var bindingList = new BindingList <HRContract>(list); listSource = new BindingSource(bindingList, null); grid.DataSource = null; grid.DataSource = listSource; }
/// <summary> /// 更新 /// </summary> /// <returns></returns> public int Update(HRContract vo) { return(conn.Execute(@"update HR_CONTRACT SET EMP_ID=@EmpId,START_TIME=@StartTime,END_TIME=@EndTime,PROBATION=@Probation,SALARY=@Salary WHERE id = @Id", new { Id = vo.Id, EmpId = vo.EmpId, StartTime = vo.StartTime, EndTime = vo.EndTime, Probation = vo.Probation, Salary = vo.Salary })); }
/// <summary> /// 输入转VO /// </summary> /// <returns></returns> private HRContract InputToVo() { HRContract vo = new HRContract(); vo.Id = txtId.Text; vo.Probation = !EmptyUtils.EmptyStr(txtProbation.Text) ? int.Parse(txtProbation.Text) : -1; vo.Salary = !EmptyUtils.EmptyStr(txtSalary.Text) ? float.Parse(txtSalary.Text) : -1; vo.EmpId = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? cboEmp.SelectedValue.ToString() : ""; vo.EmpName = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? ((HREmployee)cboEmp.SelectedItem).Name : ""; vo.EndTime = dtETime.Text; vo.StartTime = dtSTime.Text; return(vo); }
/// <summary> /// 判断是否在试用期 /// </summary> /// <returns></returns> private int JudgeIsProbationStatus(HRContract vo) { DateTime dt = Convert.ToDateTime(vo.StartTime); if(dt.Year < dtTime.Value.Year) { return 0; } if(dt.Year == dtTime.Value.Year && (dtTime.Value.Month - dt.Month) > vo.Probation) { return 1; } // vo.StartTime return 0; }
// 新增 public int Add(HRContract vo) { var ret = conn.Execute(@"insert HR_CONTRACT(ID,EMP_ID,START_TIME,END_TIME,PROBATION,SALARY) " + "values (@Id,@EmpId,@StartTime,@EndTime,@Probation,@Salary)", new[] { new { Id = vo.Id, EmpId = vo.EmpId, StartTime = vo.StartTime, EndTime = vo.EndTime, Probation = vo.Probation, Salary = vo.Salary } }); Console.WriteLine(string.Format("插入数据库成功{0}", ret)); return(ret); }
private void btnDelete_Click(object sender, EventArgs e) { if (grid.CurrentRow.Index < 0) { MessageBox.Show("请选择一条数据,在进行操作"); return; } DialogResult result = MessageBox.Show(this, "确认要删除吗?", "", MessageBoxButtons.YesNo); //如果点击的是"YES"按钮,将form关闭. if (result == DialogResult.Yes) { HRContract vo = list[grid.CurrentRow.Index]; dao.Delete(vo.Id); list.RemoveAt(grid.CurrentRow.Index); CleanData(); InitData(); } }
private void grid_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } btnDelete.Enabled = true; btnUpdate.Enabled = true; HRContract vo = list[e.RowIndex]; txtId.Text = vo.Id; txtProbation.Text = vo.Probation.ToString(); txtSalary.Text = vo.Salary.ToString(); cboEmp.SelectedValue = vo.EmpId; dtETime.Text = vo.EndTime; dtSTime.Text = vo.StartTime; }
private void btnSave_Click(object sender, EventArgs e) { if (!validateInput()) { return; } btnSaveEnbaled(false); if (opration == OP_ADD) { HRContract vo = InputToVo(); int ret = dao.Add(vo); if (ret > 0) { listSource.Add(vo); } } else if (opration == OP_UPDATE) { HRContract vo = list[grid.CurrentRow.Index]; vo.Probation = !EmptyUtils.EmptyStr(txtProbation.Text) ? int.Parse(txtProbation.Text) : -1; vo.Salary = !EmptyUtils.EmptyStr(txtSalary.Text) ? float.Parse(txtSalary.Text) : -1; vo.EmpId = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? cboEmp.SelectedValue.ToString() : ""; vo.EmpName = !EmptyUtils.EmptyObj(cboEmp.SelectedValue) ? ((HREmployee)cboEmp.SelectedItem).Name : ""; vo.EndTime = dtETime.Text; vo.StartTime = dtSTime.Text; dao.Update(vo); grid.Refresh(); } CleanData(); }