/// <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();
         }
     }
 }
Esempio n. 2
0
 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();
 }