private void 审核toolStripButton1_Click(object sender, EventArgs e) { if (txtDirector.Text.Trim() != "") { MessageDialog.ShowPromptMessage("异常信息主管已经审核!"); return; } HR_BatchException batchException = new HR_BatchException(); batchException.ID = Convert.ToInt32(m_billNo); batchException.HR_Director = BasicInfo.LoginID; batchException.HR_SignatureDate = ServerTime.Time; try { m_batchServer.AuditingBatchException(batchException); MessageDialog.ShowPromptMessage("审核成功"); RefreshDataGridView(); } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
/// <summary> /// 主管审核修改集体考勤异常信息 /// </summary> /// <param name="batchException">集体考勤异常信息</param> public void AuditingBatchException(HR_BatchException batchException) { try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_BatchException where a.ID == batchException.ID select a; if (result.Count() != 1) { throw new Exception("该异常信息有误,请确认异常信息"); } HR_BatchException batchExceptionLinq = result.Single(); batchExceptionLinq.HR_Director = batchException.HR_Director; batchExceptionLinq.HR_SignatureDate = batchException.HR_SignatureDate; dataContxt.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 删除集体考勤异常信息 /// </summary> /// <param name="billID">单据号</param> public void DeleteBatchException(int billID) { try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var varData = from a in dataContxt.HR_BatchException where a.ID == billID select a; if (varData.Count() == 0) { return; } HR_BatchException tempLnq = varData.Single(); if (tempLnq.HR_Director != null && tempLnq.HR_Director.Trim().Length > 0) { throw new Exception("已审核的单据无法删除"); } else { dataContxt.HR_BatchException.DeleteAllOnSubmit(varData); } dataContxt.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void 添加toolStripButton1_Click(object sender, EventArgs e) { if (txtDirector.Text.Trim() != "") { MessageDialog.ShowPromptMessage("异常信息主管已经审核,不能重复添加"); return; } if (txtDescription.Text.Trim() == "") { MessageDialog.ShowPromptMessage("请填写异常描述"); return; } if (dtpBeginTime.Value > dtpEndTime.Value) { MessageDialog.ShowPromptMessage("异常起始时间不能大于截止时间"); return; } MessageDialog.ShowPromptMessage("开始设置【相关人员】"); UniversalControlLibrary.FormSelectPersonnel2 frm = new FormSelectPersonnel2(); if (frm.ShowDialog() != DialogResult.OK) { return; } if (frm.SelectedNotifyPersonnelInfo.UserType != BillFlowMessage_ReceivedUserType.用户.ToString()) { return; } List <PersonnelBasicInfo> lstPersonnelInfo = frm.SelectedNotifyPersonnelInfo.PersonnelBasicInfoList; HR_BatchException batchException = new HR_BatchException(); batchException.BeginTime = dtpBeginTime.Value; batchException.Date = dtpDate.Value; batchException.EndTime = dtpEndTime.Value; batchException.RecordTime = dtpRecordTime.Value; batchException.Recorder = BasicInfo.LoginID; batchException.Description = txtDescription.Text; try { m_batchServer.AddBatchException(batchException, lstPersonnelInfo); MessageDialog.ShowPromptMessage("提交成功"); RefreshDataGridView(); } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
/// <summary> /// 新增集体考勤异常信息 /// </summary> /// <param name="batchException">集体考勤异常信息</param> /// <param name="lstPersonnel">人员信息集合</param> /// <returns>成功返回True失败返回False</returns> public void AddBatchException(HR_BatchException batchException, List <PersonnelBasicInfo> lstPersonnel) { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; dataContxt.Connection.Open(); dataContxt.Transaction = dataContxt.Connection.BeginTransaction(); try { var result = from a in dataContxt.HR_BatchException where a.Date == batchException.Date && a.Description == batchException.Description select a; if (result.Count() == 1) { throw new Exception("该异常已经存在,请确认异常信息"); } dataContxt.HR_BatchException.InsertOnSubmit(batchException); dataContxt.SubmitChanges(); int billID = (from a in dataContxt.HR_BatchException select a.ID).Max(); foreach (PersonnelBasicInfo personnel in lstPersonnel) { HR_BatchException_Personnel detail = new HR_BatchException_Personnel(); detail.BillID = billID; detail.WorkID = personnel.工号; //new AttendanceAnalysis().DataTimeIsRepeat<HR_BatchException>(dataContxt, batchException, detail.WorkID); dataContxt.HR_BatchException_Personnel.InsertOnSubmit(detail); } dataContxt.SubmitChanges(); dataContxt.Transaction.Commit(); } catch (Exception ex) { dataContxt.Transaction.Rollback(); throw new Exception(ex.Message); } }