private void clsAltoButton1_Click(object sender, EventArgs e)
{
if (dateTimePicker2.Value > dateTimePicker1.Value && this.textBox1.Text.Trim() != "")
{
dbcontext.ReportTimeSystems.Add(
new BusinessSystemDBEntityModel.ReportTimeSystem
{
ReportName = textBox1.Text,
employeeID = ClassEmployee.LoginEmployeeID,
StartTime = dateTimePicker1.Value,
EndTime = dateTimePicker2.Value,
EventHours = dateTimePicker2.Value.Subtract(dateTimePicker1.Value).TotalHours,
EventID = FindID(comboBox1.Text),
Note = richTextBox1.Text,
ApplyDateTime = DateTime.Now,
Discontinue = true
});
dbcontext.SaveChanges();
MessageBox.Show("新增成功");
var q = from RTS in dbcontext.ReportTimeSystems
join emp in dbcontext.Employees
on RTS.employeeID equals emp.employeeID
join eve in dbcontext.Events
on RTS.EventID equals eve.EventID
where RTS.Discontinue == true && RTS.employeeID == ClassEmployee.LoginEmployeeID
select new
{
報表編號 = RTS.ReportID,
//員工名稱 = emp.EmployeeName,
活動名稱 = RTS.ReportName,
開始時間 = RTS.StartTime,
結束時間 = RTS.EndTime,
所需總時數 = RTS.EventHours,
活動類型 = eve.EventName,
備註 = RTS.Note,
申請時間 = RTS.ApplyDateTime
};
rts.dataGridView1.DataSource = q.ToList();
this.Close();
FormMainRTS form = new FormMainRTS();
form.Refresh();
}
else
{
if (dateTimePicker2.Value <= dateTimePicker1.Value)
{
errorProvider1.SetError(dateTimePicker2, "結束時間需大於開始時間");
}
else
{
errorProvider1.SetError(this.dateTimePicker2, String.Empty);
}
if (this.textBox1.Text.Trim() == "")
{
errorProvider1.SetError(textBox1, "請輸入活動名稱,名稱介於10個字內");
}
else
{
errorProvider1.SetError(this.textBox1, String.Empty);
}
MessageBox.Show("請更正警示欄位");
}
if (rts.dataGridView1.Rows.Count != 0)
{
for (int i = 0; i < rts.dataGridView1.Rows.Count;)
{
rts.dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.LightBlue;
i += 2;
}
}
}
public FormAdd(FormMainRTS ff)
{
InitializeComponent();
rts = ff;
}
