//添加或更新 确定按钮
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());
}
}
}
