/// <summary> /// 初始化请假leaveList、补班workDayList、节假日holidayList、周末信息usuallyDay /// </summary> private void initPanelDate() { if (dateLabel[dateLabel.Count - 1].Parent.Tag != null && dateLabel[0].Parent.Tag != null) { DateTime startTime = (DateTime)dateLabel[0].Parent.Tag; DateTime endTime = (DateTime)dateLabel[dateLabel.Count - 1].Parent.Tag; holidayList = baseService.loadEntityList("from Holiday where STATE=" + (int)IEntity.stateEnum.Normal + " and ((StartTime>=" + startTime.Date.Ticks + " and StartTime<=" + endTime.Date.Ticks + ") or (EndTime>=" + startTime.Date.Ticks + " and EndTime<=" + endTime.Date.Ticks + ") or (StartTime>=" + startTime.Date.Ticks + " and EndTime<=" + endTime.Date.Ticks + ") or (StartTime<=" + startTime.Date.Ticks + " and EndTime>=" + endTime.Date.Ticks + "))"); workDayList = baseService.loadEntityList("from WorkDay where STATE=" + (int)IEntity.stateEnum.Normal + " and workDateTime>=" + startTime.Date.Ticks + " and workDateTime<=" + endTime.Date.Ticks); leaveList = baseService.loadEntityList("from LeaveManage l where l.State=" + (int)IEntity.stateEnum.Normal + " and l.Ku_Id.KuName like '%" +comboBox2.Text.Trim()+ "%' and ((l.StartTime>=" + startTime.Date.Ticks + " and l.StartTime<=" + endTime.Date.Ticks + ") or (l.EndTime>=" + startTime.Date.Ticks + " and l.EndTime<=" + endTime.Date.Ticks + ") or (l.StartTime>=" + startTime.Date.Ticks + " and l.EndTime<=" + endTime.Date.Ticks + ") or (l.StartTime<=" + startTime.Date.Ticks + " and l.EndTime>=" + endTime.Date.Ticks + "))"); IList usuallyDayList = baseService.loadEntityList("from UsuallyDay where STATE=" + (int)IEntity.stateEnum.Normal + " and StartTime<=" + dateTimePicker5.Value.Date.Ticks + " order by StartTime desc"); if (usuallyDayList != null && usuallyDayList.Count != 0) { usuallyDay = (UsuallyDay)usuallyDayList[0]; usuallyDayChar = usuallyDay.WorkDay.ToCharArray(); } } }
private void work_submit_button_Click(object sender, EventArgs e) { if (work_startDate_dateTimePicker.Value.Date.Ticks <= DateTime.Now.Ticks) { MessageBox.Show("不可设置今日之前(包括今日)的工作时间!"); return; } UsuallyDay usuallDay = new UsuallyDay(); if (work_name_comboBox.Tag != null) { usuallDay = (UsuallyDay)work_name_comboBox.Tag; } String workDay = ""; workDay += checkBox1.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox2.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox3.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox4.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox5.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox6.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); workDay += checkBox7.Checked ? ((char)UsuallyDay.workDayEnum.WorkDay).ToString() : ((char)UsuallyDay.workDayEnum.Holiday).ToString(); usuallDay.Name = work_name_comboBox.Text.Trim(); usuallDay.StartTime = work_startDate_dateTimePicker.Value.Date.Ticks; usuallDay.WorkTimeStart = work_start_dateTimePicker.Value.TimeOfDay.Ticks; usuallDay.WorkTimeEnd = work_end_dateTimePicker.Value.TimeOfDay.Ticks; usuallDay.WorkDay = workDay; usuallDay.State = (int)IEntity.stateEnum.Normal; usuallDay.TimeStamp = DateTime.Now.Ticks; try { baseService.SaveOrUpdateEntity(usuallDay); } catch { MessageBox.Show("设置失败!"); return; } MessageBox.Show("设置成功!"); initWorkDayData(); }