/// <summary> /// 审核不通过 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { DateTime tt = new DateTime(this.dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, 1); string sql = "select u from TimeArrangeForManager u where " + " u.TimeMonth = " + tt.Ticks + " and u.State = " + (int)IEntity.stateEnum.Normal + " and u.IsDone = 1 "; IList timemananer = baseService.loadEntityList(sql); if (timemananer != null && timemananer.Count > 0) { TimeArrangeForManager timeman = (TimeArrangeForManager)timemananer[0]; if (timeman.ExamineState == 0) { if (MessageBox.Show("确定要不通过吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { timeman.ExamineState = 2; baseService.SaveOrUpdateEntity(timeman); try { KjqbService.Service1Client ser = new KjqbService.Service1Client(); KjqbService.TimeArrangeForManagerInService tfmservice = new KjqbService.TimeArrangeForManagerInService(); tfmservice.ExamineOrExamineresult = 2; tfmservice.SendUserId = this.user.Id; tfmservice.UserId = timeman.UserId.Id; tfmservice.TimeArrangeForManagerId = timeman.Id; ser.SaveInTimeArrangeForManagerInService(tfmservice); } catch { } this.CheckState.Text = "审核状态:审核不通过"; } } else { MessageBox.Show("您已经审核过了"); } } else { MessageBox.Show("值班尚未安排!"); } }
/// <summary> /// 点击排班的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void panban_Click(object sender, EventArgs e) { ArrangeDuty ad = new ArrangeDuty(); ad.ShowDialog(); if (ad.DialogResult == DialogResult.OK) { if (TfM != null) { OnDutyTable ot; DateTime dt = new DateTime(((DateTime)((((LinkLabel)sender).Parent).Tag)).Ticks); string sql = "select u from OnDutyTable u where u.Time = " + dt.Ticks + " and u.State = " + (int)IEntity.stateEnum.Normal; IList i = baseService.loadEntityList(sql); if (i != null && i.Count > 0) { ot = (OnDutyTable)i[0]; } else { ot = new OnDutyTable(); } ot.TFMId = TfM; ot.Time = dt.Ticks; ot.DaiBanID = ad.Duser; ot.BaiBanID = ad.Buser; ot.YeBanID = ad.Yuser; ot.State = (int)IEntity.stateEnum.Normal; ot.TimeStamp = DateTime.Now.Ticks; TfM.IsDone = 1; TfM.ExamineState = 0; this.CheckState.Text = "审核状态:未审核"; baseService.SaveOrUpdateEntity(TfM); #region 向服务器发送消息 try { KjqbService.Service1Client ser = new KjqbService.Service1Client(); string ssql1 = "select u from WkTUser u left join u.UserRole role where role.KrDESC='工作小秘书角色' and role.KrOrder = 2 and (u.Kdid.KdName like '%"+affairsDept+"%') "; string ssql2 = "select u from WkTUser u left join u.UserRole role where role.KrDESC='工作小秘书角色' and role.KrOrder = 2 and (u.Kdid.KdName like '%"+netDept+"%') "; if (TfM.DutyType == 0) { IList users = baseService.loadEntityList(ssql1); KjqbService.TimeArrangeForManagerInService tfminservice = new KjqbService.TimeArrangeForManagerInService(); tfminservice.ExamineOrExamineresult = 0; tfminservice.UserId = ((WkTUser)users[0]).Id; tfminservice.SendUserId = this.user.Id; tfminservice.TimeArrangeForManagerId = TfM.Id; ser.SaveInTimeArrangeForManagerInService(tfminservice); } else if (TfM.DutyType == 1) { IList users = baseService.loadEntityList(ssql2); KjqbService.TimeArrangeForManagerInService tfminservice = new KjqbService.TimeArrangeForManagerInService(); tfminservice.ExamineOrExamineresult = 0; tfminservice.UserId = ((WkTUser)users[0]).Id; tfminservice.SendUserId = this.user.Id; tfminservice.TimeArrangeForManagerId = TfM.Id; ser.SaveInTimeArrangeForManagerInService(tfminservice); } } catch { } #endregion #region 行政班 if (TfM.DutyType == 0) //行政班 { PrintDutyPersonName((Panel)((LinkLabel)sender).Parent, ad.Duser, ad.Buser, ad.Yuser, 0); ot.Type = 0; } #endregion #region 网络班 else { PrintDutyPersonName((Panel)((LinkLabel)sender).Parent, ad.Duser, ad.Buser, ad.Yuser, 1); ot.Type = 1; } baseService.SaveOrUpdateEntity(ot); #endregion } } }
/// <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; }