private void 提交toolStripButton_Click(object sender, EventArgs e)
{
if (!CheckControl())
{
return;
}
HR_CultivateStatistics cultivate = new HR_CultivateStatistics();
cultivate.CourseName = txtCourseName.Text.Trim();
cultivate.CultivateLecturer = txtCultivateLecturer.Text.Trim();
cultivate.CultivateType = cmbCultivateType.Text;
cultivate.Dept = txtDept.Text;
cultivate.EndTime = dtpEndTime.Value;
cultivate.IsCourseware = cbIsCourseware.Checked;
//cultivate.Person = txtPerson.Text;
cultivate.Recorder = BasicInfo.LoginID;
cultivate.RecordTime = ServerTime.Time;
cultivate.StartTime = dtpStartTime.Value;
cultivate.IsWorkTime = cbIsWorkTime.Checked;
cultivate.SumHours = Convert.ToDecimal(txtSumHours.Text);
if (!m_cultivateServer.InsertBill(cultivate, m_lstPerson, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
else
{
MessageDialog.ShowPromptMessage("提交成功！");
}
RefreshDataGridView();
}
/// <summary>
/// 修改培训统计的信息
/// </summary>
/// <param name="id">需要修改的序号</param>
/// <param name="cultivate">更新后的培训统计数据集</param>
/// <param name="list">人员列表</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true失败返回false</returns>
public bool UpdatetBill(int id, HR_CultivateStatistics cultivate, List <ServerModule.View_SelectPersonnel> list, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_CultivateStatistics
where a.ID == id
select a;
if (result.Count() != 1)
{
error = "数据有误，请检查数据";
return(false);
}
HR_CultivateStatistics cultivateList = result.Single();
cultivateList.CourseName = cultivate.CourseName;
cultivateList.CultivateLecturer = cultivate.CultivateLecturer;
cultivateList.CultivateType = cultivate.CultivateType;
cultivateList.Dept = cultivate.Dept;
cultivateList.EndTime = cultivate.EndTime;
cultivateList.IsCourseware = cultivate.IsCourseware;
cultivateList.StartTime = cultivate.StartTime;
cultivateList.SumHours = cultivate.SumHours;
cultivateList.IsWorkTime = cultivate.IsWorkTime;
var resultList = from c in dataContxt.HR_CultivateStatisticsPerson
where c.BillID == id
select c;
dataContxt.HR_CultivateStatisticsPerson.DeleteAllOnSubmit(resultList);
dataContxt.SubmitChanges();
foreach (View_SelectPersonnel item in list)
{
HR_CultivateStatisticsPerson person = new HR_CultivateStatisticsPerson();
person.BillID = id;
person.Person = item.员工姓名;
dataContxt.HR_CultivateStatisticsPerson.InsertOnSubmit(person);
}
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 新增一条培训统计的信息
/// </summary>
/// <param name="cultivate">培训统计数据集</param>
/// <param name="list">人员列表</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true失败返回false</returns>
public bool InsertBill(HR_CultivateStatistics cultivate, List <ServerModule.View_SelectPersonnel> list, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.HR_CultivateStatistics
where a.CourseName == cultivate.CourseName &&
a.StartTime == cultivate.StartTime && a.EndTime == cultivate.EndTime
select a;
if (result.Count() > 0)
{
error = "数据重复，请检查数据";
return(false);
}
dataContxt.HR_CultivateStatistics.InsertOnSubmit(cultivate);
dataContxt.SubmitChanges();
var resultList = from a in dataContxt.HR_CultivateStatistics
where a.CourseName == cultivate.CourseName &&
a.StartTime == cultivate.StartTime && a.EndTime == cultivate.EndTime
select a;
foreach (View_SelectPersonnel item in list)
{
HR_CultivateStatisticsPerson person = new HR_CultivateStatisticsPerson();
person.BillID = resultList.Single().ID;
person.Person = item.员工姓名;
dataContxt.HR_CultivateStatisticsPerson.InsertOnSubmit(person);
dataContxt.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
private void 修改toolStripButton_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.Cells["记录人员"].Value.ToString() != BasicInfo.LoginName)
{
MessageDialog.ShowPromptMessage("只有记录人才能修改！");
return;
}
if (!CheckControl())
{
return;
}
HR_CultivateStatistics cultivate = new HR_CultivateStatistics();
cultivate.CourseName = txtCourseName.Text.Trim();
cultivate.CultivateLecturer = txtCultivateLecturer.Text.Trim();
cultivate.CultivateType = cmbCultivateType.Text;
cultivate.Dept = txtDept.Text;
cultivate.EndTime = dtpEndTime.Value;
cultivate.IsCourseware = cbIsCourseware.Checked;
cultivate.Recorder = BasicInfo.LoginID;
cultivate.RecordTime = ServerTime.Time;
cultivate.StartTime = dtpStartTime.Value;
cultivate.SumHours = Convert.ToDecimal(txtSumHours.Text);
cultivate.IsWorkTime = cbIsWorkTime.Checked;
if (!m_cultivateServer.UpdatetBill((int)(dataGridView1.CurrentRow.Cells["序号"].Value), cultivate, m_lstPerson, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
return;
}
else
{
MessageDialog.ShowPromptMessage("修改成功！");
RefreshDataGridView();
}
}
