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