private void 修改ToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count < 0) { MessageDialog.ShowPromptMessage("请选择需要修改的一行数据!"); return; } if (!CheckControl()) { return; } HR_Holiday holiday = new HR_Holiday(); holiday.ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["编号"].Value); holiday.HolidayTypeID = m_holidayServer.GetHolidayType(cmbHolidayType.Text); holiday.ApplicableDeptCode = deptName; holiday.ApplicableSex = cmbApplicableSex.Text; holiday.Days = Convert.ToDecimal(txtDays.Text); holiday.BeginTime = dtpStarTime.Value; holiday.EndTime = dtpEndTime.Value; holiday.Remark = txtRemark.Text; holiday.Recorder = BasicInfo.LoginID; holiday.RecordTime = ServerTime.Time; if (!m_holidayServer.UpdateHoliday(holiday, out error)) { MessageDialog.ShowPromptMessage(error); return; } RefreshControl(); PositioningRecord(holiday.ID.ToString()); }
public SystemMessage SaveHR_Holiday(HR_Holiday HR_Holiday) { SystemMessage systemMessage = new SystemMessage(); try { var param1 = new DynamicParameters(); param1.Add("@HolidayID ", HR_Holiday.HolidayID); param1.Add("@FromDate ", HR_Holiday.FromDate); param1.Add("@ToDate ", HR_Holiday.ToDate); param1.Add("@Type ", HR_Holiday.Type); param1.Add("@Note ", HR_Holiday.Note); param1.Add("@WorkingDayMachineID ", HR_Holiday.WorkingDayMachineID); UnitOfWork.ProcedureExecute("SaveHR_Holiday", param1); systemMessage.IsSuccess = true; if (Global.CurrentLanguage == 5) { systemMessage.Message = "Cập nhật thành công"; } else { systemMessage.Message = "Update successful"; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public ActionResult DeleteHolidaySetup(HR_Holiday holi, HR_Holiday holi2, DateTime ToDate) { holi = db.HR_Holiday.FirstOrDefault(x => x.ToDate == ToDate); var checkAttend = (from item1 in db.HR_Attendance where item1.Attendance_Date == holi.FromDate select item1).FirstOrDefault(); if (checkAttend.Attendance_Date != null) { // show message var jsonData = new { success = true, message = "Already exists this day in attendance table. Could not delete." }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } else { var Info2 = (from item in db.HR_Holiday where item.ToDate == holi.ToDate select item).ToList(); if (Info2.Count > 0) { foreach (var it in Info2) { holi2 = db.HR_Holiday.FirstOrDefault(x => x.HoilidayId == it.HoilidayId); db.HR_Holiday.Remove(holi2); } db.SaveChanges(); } var jsonData = new { success = true, message = "Delete Successfully." }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
private void 添加ToolStripMenuItem_Click(object sender, EventArgs e) { if (!CheckControl()) { return; } HR_Holiday holiday = new HR_Holiday(); holiday.HolidayTypeID = m_holidayServer.GetHolidayType(cmbHolidayType.Text); holiday.ApplicableDeptCode = deptName; holiday.ApplicableSex = cmbApplicableSex.Text; holiday.Days = Convert.ToDecimal(txtDays.Text); holiday.BeginTime = dtpStarTime.Value; holiday.EndTime = dtpEndTime.Value; holiday.Remark = txtRemark.Text; holiday.Recorder = BasicInfo.LoginID; holiday.RecordTime = ServerTime.Time; if (!m_holidayServer.AddHoliday(holiday, out error)) { MessageDialog.ShowPromptMessage(error); return; } RefreshControl(); PositioningRecord("0"); }
/// <summary> /// 新增节假日信息 /// </summary> /// <param name="holiday">节假日数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True 失败返回False</returns> public bool AddHoliday(HR_Holiday holiday, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_Holiday where a.BeginTime < holiday.EndTime && holiday.BeginTime < a.EndTime select a; if (result.Count() == 0) { dataContxt.HR_Holiday.InsertOnSubmit(holiday); } else { error = "节假日存在【休假日期】重复的现象,请重新确认!"; return(false); } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 修改节假日信息 /// </summary> /// <param name="holiday">节假日数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True 失败返回False</returns> public bool UpdateHoliday(HR_Holiday holiday, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var temp1 = from a in dataContxt.HR_Holiday where a.BeginTime < holiday.EndTime && holiday.BeginTime < a.EndTime && a.ID != holiday.ID select a; if (temp1.Count() > 0) { error = "节假日存在【休假日期】重复的现象,请重新确认!"; return(false); } var result = from a in dataContxt.HR_Holiday where a.ID == holiday.ID select a; if (result.Count() > 0) { HR_Holiday holidayList = result.Single(); holidayList.HolidayTypeID = holiday.HolidayTypeID; holidayList.ApplicableDeptCode = holiday.ApplicableDeptCode; holidayList.ApplicableSex = holiday.ApplicableSex; holidayList.Days = holiday.Days; holidayList.BeginTime = holiday.BeginTime; holidayList.EndTime = holiday.EndTime; holidayList.Remark = holiday.Remark; holidayList.Recorder = holiday.Recorder; holidayList.RecordTime = holiday.RecordTime; } else { error = "此记录不存在,请重新确认!"; return(false); } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
public ActionResult UpdateHolidaySetup(HR_Holiday holi, int Id, string HolidayName, string HolidayType, DateTime FromDate, DateTime ToDate, float TotalDay) { holi = db.HR_Holiday.FirstOrDefault(x => x.HoilidayId == Id); if (holi == null) { return(HttpNotFound()); } holi.HolidayName = HolidayName; holi.HolidayTypeCode = HolidayType; holi.FromDate = FromDate; holi.ToDate = ToDate; holi.TotalDay = TotalDay; db.SaveChanges(); return(PartialView()); }
public JsonResult AddHolidaySetup(HR_Holiday holi, string HolidayName, string HolidayTypeCode, DateTime FromDate, DateTime ToDate, float TotalDay) { for (int i = 0; i < TotalDay; i++) { holi.HolidayName = HolidayName; holi.HolidayTypeCode = HolidayTypeCode; holi.Holiday_Date = FromDate; holi.FromDate = FromDate.AddDays(i); holi.ToDate = Convert.ToDateTime(ToDate.ToString("yyyy-MM-dd")); holi.TotalDay = TotalDay; db.HR_Holiday.Add(holi); db.SaveChanges(); } var jsonData = new { success = true, message = "Holiday Added Successfully" }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public ActionResult _SaveHR_Holiday(HR_Holiday HR_Holiday) { var db = new HR_HolidayDAL(); var result = db.SaveHR_Holiday(HR_Holiday); if (result.IsSuccess == true && HR_Holiday.HolidayID == 0) { result.Message = AppRes.MSG_INSERT_SUCCESSFUL; } else if (result.IsSuccess == true && HR_Holiday.HolidayID != 0) { result.Message = AppRes.MS_Update_success; } return(Content(JsonConvert.SerializeObject(new { result }))); }