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