/// <summary>
/// 轮训数据库的消息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void timerOfreceiveMessageInThisWin_Tick(object sender, EventArgs e)
{
#region 接受聊天信息
try
{
KjqbService.ChatInService[] lists7;
lists7 = ser.SearchChatInfo((int)this.user.Id);
for (int i = 0; i < lists7.Length; i++)
{
WkTUser ww = new WkTUser();
ww = (WkTUser)baseService.loadEntity(ww, lists7[i].SendUserId);
if (!chatwindowsusers.Contains(ww))
{
Panel pp = IsInFlowPanel2(ww);
if (pp == null)
{
CreateWktuserInPanel(ww);
Panel pp1 = IsInFlowPanel2(ww);
Label ll = (Label)pp1.Controls[1];
ll.Text = "1";
}
else
{
Label ll = (Label)pp.Controls[1];
ll.Text = (int.Parse(ll.Text) + 1).ToString();
}
}
}
}
catch { }
#endregion
}
/// <summary>
/// 弹出聊天窗口 创建临时的聊天快捷label
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView1_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
TreeNode node = e.Node;
if (node.Tag.GetType() == typeof(WkTUser))
{
WkTUser receuser = (WkTUser)node.Tag;
if (!chatwindowsusers.Contains(receuser))
{
Panel pp = IsInFlowPanel2(receuser);
if (pp == null)
{
CreateWktuserInPanel(receuser);
}
this.chatwindowsusers.Add(receuser);
ChatWindows chat = new ChatWindows();
chat.ReceiveUser = receuser;
chat.SendUser = this.user;
chat.Chatwindwosuser = chatwindowsusers;
chat.Show();
}
else
{
}
}
}
private void InstantMessenger_Load(object sender, EventArgs e)
{
if (this.formLocation != null)
{
this.Location = formLocation;
}
createTree(treeView1);
if (Chattinguserlist != null && Chattinguserlist.Count > 0)
{
foreach (KjqbService.ChatInService chat in chattinguserlist)
{
WkTUser ww = new WkTUser();
ww = (WkTUser)baseService.loadEntity(ww, chat.SendUserId);
if (!chatwindowsusers.Contains(ww))
{
Panel pp = IsInFlowPanel2(ww);
if (pp == null)
{
CreateWktuserInPanel(ww);
Panel pp1 = IsInFlowPanel2(ww);
Label ll = (Label)pp1.Controls[1];
ll.Text = "1";
}
else
{
Label ll = (Label)pp.Controls[1];
ll.Text = (int.Parse(ll.Text) + 1).ToString();
}
}
}
}
}
private void BusinessChange_Load(object sender, EventArgs e)
{
beList = (ArrayList)this.Tag;
origin = (ArrayList)beList.Clone();
user = ((BusinessEmployee)beList[0]).EmployeeId;
dept = user.Kdid;
business = ((BusinessEmployee)beList[0]).BusinessId;
foreach (BusinessEmployee be in beList)
{
ListViewItem item = new ListViewItem();
item.Text = be.EmployeeId.KuName;
item.Tag = be;
listView1.Items.Add(item);
}
IList udList = getUserByDept(dept);
foreach (WkTUser ud in udList)
{
ListViewItem item = new ListViewItem();
item.Text = ud.KuName;
item.Tag = ud;
listView2.Items.Add(item);
}
}
public ChatWindows()
{
InitializeComponent();
initialWindow();
receiveUser = new WkTUser();
sendUser = new WkTUser();
}
private long getOverTimeOfMonth(WkTUser user, DateTime date)//获取当月加班时间
{
DateTime d1 = date.AddDays(-date.Day).Date;
DateTime d2 = d1.AddMonths(1);
string query2 = "from WorkOverTime w where w.Date>" + d1.Ticks + "and w.Date<=" + d2.Ticks + " and w.State=" + (int)WorkOverTime.stateEnum.Normal;
IList result2 = baseService.loadEntityList(query2);
long sum = 0;
bool flag = false;
if (result2 != null && result2.Count != 0)
{
foreach (WorkOverTime wkot in result2)
{
foreach (WkTUser u in wkot.WorkManId)
{
if (u.Id == user.Id)
{
flag = true;
}
}
if (flag)
{
sum += wkot.DayTime;
flag = false;
}
}
}
return(sum);
}
private long getOverTimeOfDay(WkTUser user, DateTime date)//获取当日加班时间
{
string query1 = "from WorkOverTime w where w.Date like '%" + date.Date.Ticks + "%'" + " and w.State=" + (int)WorkOverTime.stateEnum.Normal;
IList result1 = baseService.loadEntityList(query1);
bool flag = false;
long sum = 0;
if (result1 != null && result1.Count != 0)
{
foreach (WorkOverTime wkot in result1)
{
foreach (WkTUser u in wkot.WorkManId)
{
if (u.Id == user.Id)
{
flag = true;
}
}
if (flag)
{
sum += wkot.DayTime;
flag = false;
}
}
}
return(sum);
}
private void initListView(ListView listView, IList userList)
{
if (userList != null && userList.Count > 0)
{
foreach (Object o in userList)
{
WkTUser u = (WkTUser)o;
ListViewItem item = new ListViewItem();
item.Tag = u;
ListViewItem.ListViewSubItem name = new ListViewItem.ListViewSubItem();
ListViewItem.ListViewSubItem dept = new ListViewItem.ListViewSubItem();
ListViewItem.ListViewSubItem role = new ListViewItem.ListViewSubItem();
name.Text = u.KuName.Trim();
dept.Text = u.Kdid.KdName.Trim();
foreach (WkTRole r in u.UserRole)
{
if (r.KrDESC.Trim().Equals("工作小秘书角色"))
{
role.Text = r.KrName;
}
}
item.SubItems.Add(name);
item.SubItems.Add(dept);
item.SubItems.Add(role);
listView.Items.Add(item);
}
}
}
private void button2_Click(object sender, EventArgs e)
{
WkTUser u = (WkTUser)this.listView2.SelectedItems[0].Tag;
empList.Remove(u);
listView2.Items.Remove(this.listView2.SelectedItems[0]);
}
private void CreateWktuserInPanel(WkTUser w)
{
Panel p1 = new Panel();
p1.Width = 123;
p1.Height = 42;
p1.Parent = flowLayoutPanel1;
p1.Tag = w;
p1.Cursor = Cursors.Hand;
Label l1 = new Label();
l1.Font = new Font("微软雅黑", 13, FontStyle.Bold);
l1.Text = w.KuName;
l1.AutoSize = true;
l1.Location = new Point(1, 11);
l1.Parent = p1;
Label l2 = new Label();
l2.Font = new Font("微软雅黑", 13, FontStyle.Bold);
l2.Text = "";
l2.ForeColor = Color.Red;
l2.AutoSize = true;
l2.Location = new Point(l1.Width + 5, 11);
l2.Parent = p1;
l1.DoubleClick += l1_DoubleClick;
}
void l1_DoubleClick(object sender, EventArgs e)
{
Label ll1 = (Label)sender;
Panel node = (Panel)ll1.Parent;
if (node.Tag.GetType() == typeof(WkTUser))
{
WkTUser receuser = (WkTUser)node.Tag;
if (!chatwindowsusers.Contains(receuser))
{
Label ll = (Label)node.Controls[1];
ll.Text = "0";
this.chatwindowsusers.Add(receuser);
ChatWindows chat = new ChatWindows();
chat.ReceiveUser = receuser;
chat.SendUser = this.user;
chat.Chatwindwosuser = chatwindowsusers;
chat.Show();
}
else
{
}
}
}
public ArrangeDuty()
{
InitializeComponent();
initialWindow();
duser = new WkTUser();
buser = new WkTUser();
yuser = new WkTUser();
}
/// <summary>
/// 从时间安排表中按时间与负责人查找
/// </summary>
/// <param name="user"></param>
/// <param name="t1"></param>
/// <param name="t2"></param>
/// <returns></returns>
public IList SelectManagerTime(WkTUser user, long t1, long t2)
{
IList i;
string sql = "from TimeArrangeForManager u.Startime <= " + t1 +
" and u.Endtime > " + t2 +
" and u.UserId = " + user.Id;
i = loadEntityList(sql);
return(i);
}
public NewMessageWindow()
{
InitializeComponent();
loglist = new List <KjqbService.LogInService>();
schedulelist = new List <KjqbService.ScheduleInService>();
commentList = new List <KjqbService.CommentInService>();
tfmlist = new List <KjqbService.TimeArrangeForManagerInService>();
levlist = new List <KjqbService.LeaveInService>();
buslist = new List <KjqbService.BusinessService>();
user = new WkTUser();
initialWindow();
}
private void button1_Click(object sender, EventArgs e)//添加人员
{
if (listView4.SelectedItems.Count != 0)
{
WkTUser u = (WkTUser)listView4.SelectedItems[0].Tag;
ListViewItem item = new ListViewItem();
item.Text = u.KuName.Trim();
item.SubItems.Add(u.Kdid.KdName.Trim());
item.Tag = u;
listView1.Items.Add(item);
}
}
private void button1_Click(object sender, EventArgs e)
{
WkTUser u = (WkTUser)this.listView1.SelectedItems[0].Tag;
empList.Add(u);
ListViewItem item = new ListViewItem();
item.Text = u.KuName;
item.SubItems.Add(u.Kdid.KdName.Trim());
item.Tag = u;
listView2.Items.Add(item);
}
private bool roleInUser(WkTUser u, string roleName)
{
IList <WkTRole> roleList = u.UserRole;
foreach (WkTRole rr in roleList)
{
if (rr.KrName.Trim() == roleName && rr.KrDESC == "工作小秘书角色")
{
return(true);
}
}
return(false);
}
private void button3_Click(object sender, EventArgs e)
{
if (listView2.Items.Count == 0 && listView2.Items == null)
{
MessageBox.Show("未作人员修改");
}
else
{
WkTUser user = new WkTUser();
foreach (ListViewItem item in listView2.Items)
{
user = (WkTUser)item.Tag;
BusinessEmployee be = new BusinessEmployee();
be.EmployeeId = user;
be.BusinessId = business;
be.PassExam = (int)BusinessEmployee.ExamState.pass;
business.BusinessEmployee.Add(be);
}
foreach (ListViewItem item in listView3.Items)
{
BusinessEmployee be = (BusinessEmployee)item.Tag;;
if (be.PassExam == (int)BusinessEmployee.ExamState.redo)
{
business.BusinessEmployee.Remove(be);
}
}
business.PassExam = (int)Business.ExamState.pass;
baseService.SaveOrUpdateEntity(business);
#region 务器通信
KjqbService.Service1Client ser = new KjqbService.Service1Client();
KjqbService.BusinessService bs = new KjqbService.BusinessService();
bs.BusinessID = business.Id;
bs.ReceiveID = business.Boss.Id;
bs.Type = 0;
bs.TimeStamp = DateTime.Now.Ticks;
ser.SaveInBusinessListInService(bs);
#endregion
MessageBox.Show("成功提交");
this.DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 日程偏好保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
TreeNode t = treeView2.Nodes[0];
//表中是否有存 如果有先删除原来的
if (hobbysList != null)
{
foreach (Hobby h in hobbysRiChenglist)
{
h.State = (int)IEntity.stateEnum.Deleted;
baseService.SaveOrUpdateEntity(h);
}
}
ri_cheng_hobby = new Hobby();
ri_cheng_hobby.Staff = user;
ri_cheng_hobby.State = (int)IEntity.stateEnum.Normal;
ri_cheng_hobby.TimeStamp = DateTime.Now.Ticks;
ri_cheng_hobby.TypeFlag = (int)Hobby.hobbyTypeEnum.RiCheng;
if (ri_cheng_hobby.SharedStaffs == null)
{
ri_cheng_hobby.SharedStaffs = new List <WkTUser>();
}
else
{
ri_cheng_hobby.SharedStaffs.Clear();
}
foreach (TreeNode t1 in t.Nodes)
{
foreach (TreeNode t2 in t1.Nodes)
{
if (t2.Checked == true)
{
WkTUser u = (WkTUser)t2.Tag;
ri_cheng_hobby.SharedStaffs.Add(u);
}
}
}
baseService.SaveOrUpdateEntity(ri_cheng_hobby);
MessageBox.Show("保存成功！");
}
/// <summary>
/// 不显示的时候则关闭线程
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void InstantMessenger_VisibleChanged(object sender, EventArgs e)
{
if (this.Visible == true)
{
if (this.timerOfreceiveMessageInThisWin.Enabled == false)
{
if (Chattinguserlist != null && Chattinguserlist.Count > 0)
{
foreach (KjqbService.ChatInService chat in chattinguserlist)
{
WkTUser ww = new WkTUser();
ww = (WkTUser)baseService.loadEntity(ww, chat.SendUserId);
if (!chatwindowsusers.Contains(ww))
{
Panel pp = IsInFlowPanel2(ww);
if (pp == null)
{
CreateWktuserInPanel(ww);
Panel pp1 = IsInFlowPanel2(ww);
Label ll = (Label)pp1.Controls[1];
ll.Text = "1";
}
else
{
Label ll = (Label)pp.Controls[1];
ll.Text = (int.Parse(ll.Text) + 1).ToString();
}
}
}
}
timerOfreceiveMessageInThisWin.Enabled = true;
timerofrefreshOnlineTree.Enabled = true;
}
}
else
{
if (this.timerOfreceiveMessageInThisWin.Enabled == true)
{
timerOfreceiveMessageInThisWin.Enabled = false;
timerofrefreshOnlineTree.Enabled = false;
}
}
}
/// <summary>
/// 向flow1中添加message消息
/// </summary>
/// <param name="content"></param>
public void AddMessageLabelInFlowPanel1(WkTUser user)
{
Label label = new Label();
label.Font = new Font(new FontFamily("微软雅黑"), 10, FontStyle.Regular);
label.ForeColor = Color.DarkRed;
label.AutoSize = true;
label.Text = user.KuName;
label.Margin = new System.Windows.Forms.Padding(0);
label.Parent = flowLayoutPanel1;
label.Cursor = Cursors.Hand;
label.Tag = user;
label.Click += label_Click;
if (this.flowLayoutPanel1.Controls.Count > 4)
{
this.linkLabel1.Visible = true;
this.flowLayoutPanel1.Controls.RemoveAt(0);
}
}
private string getOverTime(WkTUser user, DateTime d1, DateTime d2)//获取两段时间内加班时间
{
//string query3 = "from WorkOverTime w where w.WorkManId =" + user.Id + "and w.Date>" + d1.ToString("yyyyMMdd000000") + "and w.Date<=" + d2.ToString("yyyyMMdd235959");
string query3 = "from WorkOverTime w where w.WorkManId =" + user.Id + "and w.Date>=" + d1.Ticks + "and w.Date<=" + d2.Ticks;
IList result3 = baseService.loadEntityList(query3);
long sum = 0;
if (result3 != null && result3.Count != 0)
{
foreach (WorkOverTime wkot in result3)
{
sum += wkot.DayTime;
}
}
TimeSpan tt = new TimeSpan(sum);
return((int)tt.TotalHours + "小时 " + tt.Minutes + "分");
}
private Panel IsInFlowPanel2(WkTUser w)
{
if (flowLayoutPanel1.Controls != null && flowLayoutPanel1.Controls.Count > 0)
{
foreach (Control c in flowLayoutPanel1.Controls)
{
Panel p = (Panel)c;
WkTUser t = (WkTUser)c.Tag;
if (t.Id == w.Id)
{
return(p);
}
}
return(null);
}
else
{
return(null);
}
}
void label_Click(object sender, EventArgs e)
{
WkTUser w = (WkTUser)(((Label)sender).Tag);
ChatListSubItem cha = main.GetTheUserById(int.Parse(w.Id.ToString()));
if (cha.IsTwinkle)
{
cha.IsTwinkle = !cha.IsTwinkle;
main.RemoveFromChaterList(cha.userid);
main.meaaageCountLabelOfXiaoXI.MessageCount = 0;
}
if (main.chatwindowsusers == null)
{
main.chatwindowsusers = new List <WkTUser>();
}
if (!main.chatwindowsusers.Contains(w))
{
ChatWindows chat = new ChatWindows();
chat.ReceiveUser = w;
chat.SendUser = main.user;
chat.Chatwindwosuser = main.chatwindowsusers;
chat.Show();
}
else
{
}
Label l = (Label)sender;
this.flowLayoutPanel1.Controls.Remove(l);
l.Dispose();
if (this.flowLayoutPanel1.Controls.Count == 0)
{
this.Close();
}
}
public void PrintDutyPersonName(Panel p, WkTUser DaiBan, WkTUser Baiban, WkTUser Yeban, int Type)
{
if (DaiBan == null)
{
DaiBan = new WkTUser();
DaiBan.Id = 0;
DaiBan.KuName = "";
}
if (Baiban == null)
{
Baiban = new WkTUser();
Baiban.Id = 0;
Baiban.KuName = "";
}
if (Yeban == null)
{
Yeban = new WkTUser();
Yeban.Id = 0;
Yeban.KuName = "";
}
#region
if (Type == 0) //行政班
{
Label Duser = GetTheLabelByLocation(p, 51, 29);
if (Duser == null)
{
Duser = new Label();
Duser.Text = DaiBan.KuName;
Duser.Location = new Point(51, 29);
Duser.Font = new Font("微软雅黑", 9);
Duser.Parent = p;
Duser.ForeColor = DaiBan.Id == user.Id ? Color.Red : Color.Black;
Duser.AutoSize = true;
}
else
{
Duser.Text = DaiBan.KuName;
Duser.ForeColor = DaiBan.Id == user.Id ? Color.Red : Color.Black;
}
Label Buser = GetTheLabelByLocation(p, 51, 49);
if (Buser == null)
{
Buser = new Label();
Buser.Text = Baiban.KuName;
Buser.Location = new Point(51, 49);
Buser.Font = new Font("微软雅黑", 9);
Buser.Parent = p;
Buser.ForeColor = Baiban.Id == user.Id ? Color.Red : Color.Black;
Buser.AutoSize = true;
}
else
{
Buser.Text = Baiban.KuName;
Buser.ForeColor = Baiban.Id == user.Id ? Color.Red : Color.Black;
}
Label Yuser = GetTheLabelByLocation(p, 51, 67);
if (Yuser == null)
{
Yuser = new Label();
Yuser.Text = Yeban.KuName;
Yuser.Location = new Point(51, 67);
Yuser.Font = new Font("微软雅黑", 9);
Yuser.Parent = p;
Yuser.ForeColor = Yeban.Id == user.Id ? Color.Red : Color.Black;
Yuser.AutoSize = true;
}
else
{
Yuser.Text = Yeban.KuName;
Yuser.ForeColor = Yeban.Id == user.Id ? Color.Red : Color.Black;
}
}
#endregion
#region 网络班
else
{
Label Duser = GetTheLabelByLocation(p, 91, 29);
if (Duser == null)
{
Duser = new Label();
Duser.Text = DaiBan.KuName;
Duser.Location = new Point(91, 29);
Duser.Font = new Font("微软雅黑", 9);
Duser.ForeColor = DaiBan.Id == user.Id ? Color.Red : Color.Black;
Duser.Parent = p;
Duser.AutoSize = true;
}
else
{
Duser.Text = DaiBan.KuName;
Duser.ForeColor = DaiBan.Id == user.Id ? Color.Red : Color.Black;
}
Label Buser = GetTheLabelByLocation(p, 91, 49);
if (Buser == null)
{
Buser = new Label();
Buser.Text = Baiban.KuName;
Buser.Location = new Point(91, 49);
Buser.Font = new Font("微软雅黑", 9);
Buser.Parent = p;
Buser.ForeColor = Baiban.Id == user.Id ? Color.Red : Color.Black;
Buser.AutoSize = true;
}
else
{
Buser.Text = Baiban.KuName;
Buser.ForeColor = Baiban.Id == user.Id ? Color.Red : Color.Black;
}
Label Yuser = GetTheLabelByLocation(p, 91, 67);
if (Yuser == null)
{
Yuser = new Label();
Yuser.Text = Yeban.KuName;
Yuser.Location = new Point(91, 67);
Yuser.Font = new Font("微软雅黑", 9);
Yuser.Parent = p;
Yuser.ForeColor = Yeban.Id == user.Id ? Color.Red : Color.Black;
Yuser.AutoSize = true;
}
else
{
Yuser.ForeColor = Yeban.Id == user.Id ? Color.Red : Color.Black;
Yuser.Text = Yeban.KuName;
}
}
#endregion
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
this.duser = theuserDai[this.comboBox2.SelectedIndex];
}
/// <summary>
/// 登录函数 其中包括查库操作
/// </summary>
private string loginMethod()
{
try
{
#region 将用户信息存入临时文件
if (pictureBoxOfRememberPwd.BackgroundImage != null)
{
IniReadAndWrite.IniWriteValue("temp", "rem", CommonStaticParameter.YES);
}
else
{
IniReadAndWrite.IniWriteValue("temp", "rem", CommonStaticParameter.NO);
}
if (pictureBoxofAutoLogin.BackgroundImage != null)
{
IniReadAndWrite.IniWriteValue("temp", "auto", CommonStaticParameter.YES);
}
else
{
IniReadAndWrite.IniWriteValue("temp", "auto", CommonStaticParameter.NO);
}
IniReadAndWrite.IniWriteValue("temp", "un", Securit.DES(textBox1.Text.Trim()));
IniReadAndWrite.IniWriteValue("temp", "pw", Securit.DES(textBox2.Text.Trim()));
#endregion
//判断是否加密成功
IList pwd = baseService.ExecuteSQL("select right(sys.fn_VarBinToHexStr(hashbytes('MD5', '" + textBox2.Text.Trim() + "')),32)"); // 数据库属性，跟具体表无关
if (pwd == null || pwd.Count <= 0)
{
return("登录异常！");
}
object[] pwdArray = (object[])pwd[0];
//因为是共用表 选择是工作小秘书相关的角色
IList userList = baseService.loadEntityList("select u from WkTUser u right join u.UserRole role where role.KrDESC='工作小秘书角色' and u.KuLid='" + textBox1.Text.Trim() + "' and u.KuPassWD='" + pwdArray[0] + "'");
if (userList == null || userList.Count <= 0)
{
return("用户名或密码错误！");
}
else if (userList.Count > 1)
{
return("用户异常，请联系管理员！");
}
else
{
WkTUser u = (WkTUser)userList[0];
foreach (WkTRole r in u.UserRole)
{
if (r.KrDESC.Trim().Equals("工作小秘书角色")) //是本系统的用户角色
{
role = r;
}
}
this.User = (WkTUser)userList[0];
IniReadAndWrite.IniWriteValue("temp", "myid", User.Id.ToString());
return("登录成功！");
}
// }
}
catch
{
return("未能与服务器建立连接……");
}
}
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
this.buser = this.theuserBai[this.comboBox4.SelectedIndex];
}
private void comboBox6_SelectedIndexChanged(object sender, EventArgs e)
{
this.yuser = this.theuserYe[this.comboBox6.SelectedIndex];
}
/// <summary>
/// 提交请假信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
//提交请假信息
LeaveManage lev = new LeaveManage();
KjqbService.LeaveInService levinser = new KjqbService.LeaveInService();
KjqbService.Service1Client ser = new KjqbService.Service1Client();
levinser.SendUserId = leaveman.Id;
levinser.ExamineOrExamineresult = 0;
//对请假信息的填写状况进行判断
if (dateTimePicker1.Value.Date.Ticks > dateTimePicker2.Value.Date.Ticks)
{
MessageBox.Show("请假开始时间必须早于或等于结束时间！");
return;
}
if (comboBox2.Text == null || comboBox2.Text == "")
{
MessageBox.Show("请选择请假类型！");
return;
}
if (textBox7.Text == null || textBox7.Text == "")
{
MessageBox.Show("请填写请假原因！");
return;
}
lev.StartTime = dateTimePicker1.Value.Date.Ticks;
lev.EndTime = dateTimePicker2.Value.Date.Ticks;
string query = "from LeaveManage leave where leave.Ku_Id=" + this.Leaveman.Id + " and ((leave.StartTime>=" + lev.StartTime + " and leave.StartTime<=" + lev.EndTime + ") or (leave.EndTime>=" + lev.StartTime + " and leave.EndTime<=" + lev.EndTime + ")) and leave.State=" + (int)LeaveManage.stateEnum.Normal;
IList levList = baseService.loadEntityList(query);
if (levList != null && levList.Count != 0)
{
MessageBox.Show("此时间段已有请假记录");
return;
}
lev.LeaveType = comboBox2.Text.Trim(); //请假类型
lev.LeaveReason = textBox7.Text.Trim(); //请假原因
// role.KrOrder含义，0：院长，1：副院长，2：负责人，3：员工
if (role.KrOrder == 3) //员工提交请假信息
{
lev.LeaveResult = "3"; //审核结果,3表示未审核的
lev.LeaveStage = "0"; //审批阶段，属于未审批
string ssql1 = "select u from WkTUser u left join u.UserRole role where role.KrDESC='工作小秘书角色' and role.KrOrder = 2 and u.Kdid.Id = " + leaveman.Kdid.Id;
IList list = baseService.loadEntityList(ssql1);
if (list != null && list.Count > 0)
{
WkTUser theuser = (WkTUser)list[0];
levinser.UserId = theuser.Id;
}
else
{
levinser.UserId = 0;
}
}
else if (role.KrOrder == 2)//负责人提交请假
{
if (comboBox2.Text.Trim() == "病假" || comboBox2.Text.Trim() == "事假")
{
lev.LeaveResult = "1";
lev.LeaveStage = "1";
Wktuser_M_Dept wmd = new Wktuser_M_Dept();
//wmd.DeptId.Id
string ssql1 = "select u from Wktuser_M_Dept u where u.DeptId.Id = " + leaveman.Kdid.Id;
IList ll = baseService.loadEntityList(ssql1);
if (ll != null && ll.Count > 0)
{
wmd = (Wktuser_M_Dept)ll[0];
levinser.UserId = wmd.WktuserId.Id;
}
else
{
levinser.UserId = 0;
}
}
else
{ //婚假、产假、年休假、探亲假；负责人请假后，由院长直接审批就可以
lev.LeaveResult = "1";
lev.LeaveStage = "2";
string ssql1 = "select u from WkTUser u left join u.UserRole role where role.KrDESC='工作小秘书角色' and role.KrOrder = 0";
IList list = baseService.loadEntityList(ssql1);
if (list != null && list.Count > 0)
{
WkTUser theuser = (WkTUser)list[0];
levinser.UserId = theuser.Id;
}
else
{
levinser.UserId = 0;
}
}
}
else if (role.KrOrder == 1 || role.KrOrder == 0)//副院长和院长提交请假,都由院长审批
{
//默认负责人审批通过，待副院长审批
lev.LeaveResult = "1";
lev.LeaveStage = "2";
string ssql1 = "select u from WkTUser u left join u.UserRole role where role.KrDESC='工作小秘书角色' and role.KrOrder = 0";
IList list = baseService.loadEntityList(ssql1);
if (list != null && list.Count > 0)
{
WkTUser theuser = (WkTUser)list[0];
levinser.UserId = theuser.Id;
}
else
{
levinser.UserId = 0;
}
}
lev.Ku_Id = leaveman; //请假人信息
lev.LeaveChargeId = chargeman; //指定的负责人列表
lev.State = (int)IEntity.stateEnum.Normal;
lev.TimeStamp = DateTime.Now.Ticks;
try
{
object be = baseService.saveEntity(lev);
#region 向服务器推送消息
levinser.LeaveId = int.Parse(be.ToString());
ser.SaveInLeaveInfoInService(levinser);
#endregion
}
catch
{
MessageBox.Show("保存失败！");
return;
}
MessageBox.Show("保存成功！");
comboBox2.Text = "";
textBox7.Clear();
chargeman.Clear();//每次用完之后清空全局变量chargeman中的数据
}
