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