//添加或更新 确定按钮 private void btnSure_Click(object sender, EventArgs e) { if (txtDuration.Text == "0" || txtDuration.Text == string.Empty) { MessageBox.Show("未添加,请检查时间输入"); return; } if (txtReason.Text == string.Empty) { MessageBox.Show("请你填写原因"); return; } if (Convert.ToDouble(txtDuration.Text) > Convert.ToDouble(txtRemainHours.Text))//可用时长不够时; { var result = MessageBox.Show("你的时长不够,继续?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.Cancel) { return; } } DateTime startD = DateTime.Parse(dateStart.Value.ToShortDateString()); //开始日期 DateTime endD = DateTime.Parse(dateEnd.Value.ToShortDateString()); //结束日期 DateTime startT = DateTime.Parse(cmbTimeStart.SelectedItem.ToString()); //开始时间 DateTime endT = DateTime.Parse(cmbTimeEnd.SelectedItem.ToString()); //结束时间 Leave leave = new Leave(); LeaveBll lb = new LeaveBll(); leave.EmployeeId = txtEmpId.Text; leave.DateTimeStart = DateTime.Parse(string.Format("{0} {1}", startD.ToShortDateString(), startT.ToShortTimeString())); leave.DateTimeEnd = DateTime.Parse(string.Format("{0} {1}", endD.ToShortDateString(), endT.ToShortTimeString())); leave.Duration = (float)Convert.ToDouble(txtDuration.Text); leave.Reason = txtReason.Text; leave.Status = "YES"; bool b = false; if (this.Text == "添加信息")//添加信息 { b = lb.Add(leave); } else//更新信息 { leave.Id = thisId; b = lb.Update(leave); } if (b) { MessageBox.Show("成功"); this.DialogResult = DialogResult.OK; return; } else { MessageBox.Show("这段时间已经存在记录"); return; } }
//按日期查询 private void btnQuery_Click(object sender, EventArgs e) { var start = datePickerStart.Value.ToString("yyyy-MM-dd 00:00:00"); var end = datePickerEnd.Value.ToString("yyyy-MM-dd 24:00:00"); if (start.CompareTo(end) > 0) { MessageBox.Show("请输入合适的时间"); return; } var data = new LeaveBll().QueryByEmpidBetween(start, end, this.Tag.ToString()).Tables[0]; if (data != null) { dataGridView1.DataSource = data; } }
//加载时自动填充 private void FrmLeaveAddOrUpdate_Load(object sender, EventArgs e) { txtEmpId.Text = thisEmpId; //员工号 txtEmpName.Text = new EmployeeBll().QueryById(txtEmpId.Text).Name; //姓名 float[] hours = new LeaveBll().Hour(txtEmpId.Text); txtAllHours.Text = hours[0].ToString(); // 总时长 txtUsedHours.Text = hours[1].ToString(); //已用时长 txtRemainHours.Text = hours[2].ToString(); //剩余时长 if (this.Text == "添加信息") { txtReason.Text = "世界这么大,想去溜溜"; //默认原因 time = 1; cmbTimeStart.SelectedItem = cmbTimeStart.Items[0]; //默认选择早上九点到晚上六点 cmbTimeEnd.SelectedItem = cmbTimeEnd.Items[18]; txtDuration.Text = "8.0"; } else { } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { int row = e.RowIndex; if (e.ColumnIndex == 0 && e.RowIndex > -1)//删除按钮操作 { int leaveId = Convert.ToInt32(dataGridView1.Rows[row].Cells["编号"].Value.ToString()); var result = MessageBox.Show("删除后不可恢复,继续?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { bool b = new LeaveBll().DeleteById(leaveId); if (b) { MessageBox.Show("删除成功!"); QueryAll(this.Tag.ToString()); return; } return; } } if (e.ColumnIndex == 1 && e.RowIndex > -1)//更新按钮操作 { Leave le = new Leave(); le.Id = Convert.ToInt32(dataGridView1.Rows[row].Cells["编号"].Value.ToString());; le.EmployeeId = dataGridView1.Rows[row].Cells["员工号"].Value.ToString(); le.DateTimeStart = Convert.ToDateTime(dataGridView1.Rows[row].Cells["开始时间"].Value.ToString()); le.DateTimeEnd = Convert.ToDateTime(dataGridView1.Rows[row].Cells["结束时间"].Value.ToString()); le.Duration = (float)Convert.ToDouble(dataGridView1.Rows[row].Cells["时长"].Value.ToString()); le.Status = dataGridView1.Rows[row].Cells["状态"].Value.ToString(); le.Reason = dataGridView1.Rows[row].Cells["原因"].Value.ToString(); FrmLeaveAddOrUpdate leave = new FrmLeaveAddOrUpdate(le); leave.ShowDialog(); if (leave.DialogResult == DialogResult.OK) { QueryAll(this.Tag.ToString()); } } }