private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
DateTime tt = new DateTime(this.dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, 1);
string sql1 = "Select u from OnDutyTable u where u.State = "+(int)IEntity.stateEnum.Normal+
" and u.Time > " + tt.AddDays(-16).Ticks+
" and u.Time <= " + tt.AddDays(16).Ticks;
dutyDayLis = baseService.loadEntityList(sql1);
dateTimePicker1.Cursor = Cursors.WaitCursor;
if (this.dateTimePicker1.Value.Ticks > DateTime.Now.Ticks)
{
//查询这个月是否自己排班
string sql = "select u from TimeArrangeForManager u where u.UserId = " + user.Id +
" and u.TimeMonth = " + tt.Ticks +
" and u.State = " + (int)IEntity.stateEnum.Normal;
IList timemananer = baseService.loadEntityList(sql);
if(TfM == null)
TfM = new TimeArrangeForManager();
if (timemananer != null && timemananer.Count > 0)
{
TfM = (TimeArrangeForManager)timemananer[0];
this.initCalendar(this.dateTimePicker1.Value.Year, this.dateTimePicker1.Value.Month,true);
switch (TfM.ExamineState)
{
case 0:
this.CheckState.Text = "审核状态：未审核"; break;
case 1:
this.CheckState.Text = "审核状态：审核通过"; break;
case 2:
this.CheckState.Text = "审核状态：审核未通过"; break;
}
}
else
{
this.initCalendar(this.dateTimePicker1.Value.Year, this.dateTimePicker1.Value.Month, false);
this.CheckState.Text = "";
}
if (Therole != 0)
{
string sqll = "select u from TimeArrangeForManager u where u.TimeMonth = " + tt.Ticks +
" and u.State = " + (int)IEntity.stateEnum.Normal;
IList listss = baseService.loadEntityList(sqll);
if (listss != null && listss.Count > 0)
{
this.PanelOfTwoButtons.Visible = true;
switch (TfM.ExamineState)
{
case 0:
this.CheckState.Text = "审核状态：未审核"; break;
case 1:
this.CheckState.Text = "审核状态：审核通过"; break;
case 2:
this.CheckState.Text = "审核状态：审核未通过"; break;
}
}
else
{
this.PanelOfTwoButtons.Visible = false;
}
}
}
else
{
this.initCalendar(this.dateTimePicker1.Value.Year, this.dateTimePicker1.Value.Month,false);
this.CheckState.Text = "";
this.PanelOfTwoButtons.Visible = false;
}
dateTimePicker1.Cursor = Cursors.Hand;
}
public void DataGridView4RowsAdd(TimeArrangeForManager tgm)
{
if(tgm != null)
{
DateTime dt = new DateTime (tgm.TimeMonth);
if(tgm.ExamineState == 0)
{
this.dataGridView4.Rows.Add(dt.ToString("yyyy年MM月"), tgm.UserId.KuName, tgm.ArrangeUserId.KuName, tgm.DutyType == 0 ? "行政班" : "网络班","未审核", tgm.IsDone == 1 ? "" : "删除");
}
else if(tgm.ExamineState == 1)
{
this.dataGridView4.Rows.Add(dt.ToString("yyyy年MM月"), tgm.UserId.KuName, tgm.ArrangeUserId.KuName, tgm.DutyType == 0 ? "行政班" : "网络班","审核通过", tgm.IsDone == 1 ? "" : "删除");
}
else if(tgm.ExamineState == 2)
{
this.dataGridView4.Rows.Add(dt.ToString("yyyy年MM月"), tgm.UserId.KuName, tgm.ArrangeUserId.KuName, tgm.DutyType == 0 ? "行政班" : "网络班","审核为通过", tgm.IsDone == 1 ? "" : "删除");
}
this.dataGridView4.Rows[this.dataGridView4.Rows.Count - 1].Tag = tgm;
}
}
private void NewMessageWindow_Load(object sender, EventArgs e)
{
if (this.formLocation != null)
{
this.Location = formLocation;
}
if (loglist != null && loglist.Count > 0)
{
loglist.Reverse();
foreach (KjqbService.LogInService ll in Loglist)
{
StaffLog ss = new StaffLog();
ss = (StaffLog)baseService.loadEntity(ss, ll.LogId);
LinkLabel l1 = new LinkLabel();
l1.Text = ss.Staff.KuName + "分享给您的日志";
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = ll;
l1.Click += l1_Click;
l1.Parent = flowLayoutPanel1;
l1.DoubleClick +=l1_DoubleClick;
}
}
if (schedulelist != null && schedulelist.Count > 0)
{
schedulelist.Reverse();
foreach (KjqbService.ScheduleInService ll in schedulelist)
{
StaffSchedule ss = new StaffSchedule();
//string sql = "select u from StaffLog u where u.Id = " + ll.LogId;
ss = (StaffSchedule)baseService.loadEntity(ss, ll.ScheduleId);
LinkLabel l1 = new LinkLabel();
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = ll;
l1.Click += l1_Click;
l1.Parent = flowLayoutPanel1;
l1.DoubleClick+=l1_DoubleClick;
if(ss.Staff.Id == ss.ArrangeMan.Id)
{
l1.Text = ss.Staff.KuName + "分享给您的日程";
}
else if (ss.Staff.Id != ss.ArrangeMan.Id)
{
l1.Text = ss.ArrangeMan.KuName + "给您安排的日程";
}
}
}
if (commentList != null && commentList.Count > 0)
{
commentList.Reverse();
foreach (KjqbService.CommentInService ll in commentList)
{
StaffLog ss = new StaffLog();
//string sql = "select u from StaffLog u where u.Id = " + ll.LogId;
ss = (StaffLog)baseService.loadEntity(ss, ll.LogId);
LinkLabel l1 = new LinkLabel();
l1.Text = ll.CommentUserName + "评论了您的日志";
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = ll;
l1.Click += l1_Click;
l1.DoubleClick+=l1_DoubleClick;
l1.Parent = flowLayoutPanel1;
}
}
if(tfmlist != null && tfmlist.Count >0)
{
tfmlist.Reverse();
foreach(KjqbService.TimeArrangeForManagerInService tfm in tfmlist)
{
TimeArrangeForManager tt = new TimeArrangeForManager();
tt = (TimeArrangeForManager)baseService.loadEntity(tt,tfm.TimeArrangeForManagerId);
LinkLabel l1 = new LinkLabel();
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = tfm;
l1.Click += l1_Click;
l1.DoubleClick += l1_DoubleClick;
l1.Parent = flowLayoutPanel1;
DateTime dt = new DateTime(tt.TimeMonth);
if (tfm.ExamineOrExamineresult == 0)
{
l1.Text = dt.ToString("yyyy年MM月")+" "+"排班待您审核";
}
if (tfm.ExamineOrExamineresult == 1)
{
l1.Text = dt.ToString("yyyy年MM月") + " " + "排班审核通过";
}
if (tfm.ExamineOrExamineresult == 2)
{
l1.Text = dt.ToString("yyyy年MM月") + " " + "排班审核未通过";
}
if (tfm.ExamineOrExamineresult == 3)
{
l1.Text = "请您安排"+dt.ToString("yyyy年MM月")+"的值班";
}
}
}
if (levlist != null && levlist.Count > 0)
{
levlist.Reverse();
foreach (KjqbService.LeaveInService tfm in levlist)
{
LeaveManage tt = new LeaveManage();
tt = (LeaveManage)baseService.loadEntity(tt, tfm.LeaveId);
LinkLabel l1 = new LinkLabel();
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = tfm;
l1.Click += l1_Click;
l1.DoubleClick +=l1_DoubleClick;
l1.Parent = flowLayoutPanel1;
if (tfm.ExamineOrExamineresult == 0)
{
l1.Text = tt.Ku_Id.KuName + "请假申请待您审核";
}
DateTime dt1 = new DateTime(tt.StartTime);
DateTime dt2 = new DateTime(tt.EndTime);
if (tfm.ExamineOrExamineresult == 1)
{
l1.Text = "您提交的"+tt.LeaveType+"申请审核通过";
}
if (tfm.ExamineOrExamineresult == 2)
{
l1.Text = "您提交的" + tt.LeaveType + "申请审核未通过";
}
}
}
if (buslist != null && buslist.Count > 0)
{
buslist.Reverse();
foreach (KjqbService.BusinessService tfm in buslist)
{
// tt = new LeaveManage();
//tt = (LeaveManage)baseService.loadEntity(tt, tfm.LeaveId);
LinkLabel l1 = new LinkLabel();
l1.Width = this.flowLayoutPanel1.Width - 10;
l1.Height = 30;
l1.Top = 10;
l1.Tag = tfm;
l1.Click += l1_Click;
l1.DoubleClick += l1_DoubleClick;
l1.Parent = flowLayoutPanel1;
if (tfm.Type == 0)
{
l1.Text = "您有一条出差信息待审批";
}
else if(tfm.Type == 1)
{
l1.Text = "您的出差申请被退回";
}
else if(tfm.Type == 2)
{
l1.Text = "您的出差申请被撤销";
}
else if(tfm.Type == 3)
{
l1.Text = "您的出差申请审核通过";
}
}
}
}
/// <summary>
/// 确定按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
this.button3.Cursor = Cursors.WaitCursor;
DateTime dt = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, 1);
//判断这个月是否安排
string sql = "select u from TimeArrangeForManager u where u.TimeMonth = " + dt.Ticks +
" and u.DutyType = "+this.comboBox3.SelectedIndex+
" and u.State = "+ (int)IEntity.stateEnum.Normal;
IList i = baseService.loadEntityList(sql);
if(i!= null &&i.Count>0)
{
MessageBox.Show("该月份已经安排过了");
this.button3.Cursor = Cursors.Hand;
return;
}
if(this.comboBox1.Text != "" && this.comboBox2.Text != "")
{
TimeArrangeForManager tgm = new TimeArrangeForManager();
tgm.ArrangeUserId = User;
tgm.UserId = theusers[this.comboBox2.SelectedIndex];
tgm.State = (int)IEntity.stateEnum.Normal;
tgm.TimeStamp = DateTime.Now.Ticks;
tgm.TimeMonth = dt.Ticks;
tgm.IsDone = 0;
tgm.DutyType = this.comboBox3.SelectedIndex;
tgm.ExamineState = 0;
object be = baseService.saveEntity(tgm);
try
{
KjqbService.Service1Client ser = new KjqbService.Service1Client();
KjqbService.TimeArrangeForManagerInService tfmservice = new KjqbService.TimeArrangeForManagerInService();
tfmservice.TimeArrangeForManagerId = int.Parse(be.ToString());
tfmservice.UserId = tgm.UserId.Id;
tfmservice.SendUserId = user.Id;
tfmservice.ExamineOrExamineresult = 3;
ser.SaveInTimeArrangeForManagerInService(tfmservice);
}
catch { }
DataGridView4RowsAdd(tgm);
MessageBox.Show("添加成功！");
}
this.button3.Cursor = Cursors.Hand;
}