private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedTab.Text == "安排概览")
{
string query = "from WkTDept";
IList depList = baseService.loadEntityList(query);
WkTDept dep = new WkTDept();
dep.KdName = "所有部门";
depList.RemoveAt(0);
depList.Insert(0, dep);
comboBox2.DataSource = depList;
comboBox2.DisplayMember = "KdName";
comboBox2.ValueMember = "Itself";
upDateListView2(new DateTime(1900, 1, 1), new DateTime(2099, 1, 1), "");
}
if (tabControl1.SelectedTab.Text == "加班统计")
{
string query = "from WkTDept";
IList depList = baseService.loadEntityList(query);
//WkTDept dep = new WkTDept();
depList.RemoveAt(0);
comboBox1.DataSource = depList;
comboBox1.DisplayMember = "KdName";
comboBox1.ValueMember = "Itself";
initPage3();
}
if (tabControl1.SelectedTab.Text == "加班取消")
{
initPage4();
}
}
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);
}
}
private void BusinessManagement_Load(object sender, EventArgs e)
{
Dept = User.Kdid;
initTabPage1();
switch (Role.KrOrder)
{
case 0:
tabControl1.TabPages.RemoveAt(1);
break;
case 1:
tabControl1.TabPages.RemoveAt(1);
break;
case 2:
tabControl1.TabPages.RemoveAt(2);
break;
case 3:
tabControl1.TabPages.RemoveAt(1);
tabControl1.TabPages.RemoveAt(1);
break;
}
}
/// <summary>
/// 按部门与名字查询员工
/// </summary>
/// <param name="name"></param>
/// <param name="seldetp"></param>
/// <returns></returns>
public IList GetSelectYuanGong(string name, WkTDept seldetp)
{
IList i;
string sql = "from WkTUser u where u.KuName like '%" + name + "%' and u.Kdid = " + seldetp.Id;
i = loadEntityList(sql);
return(i);
}
/// <summary>
/// 查询部门负责人
/// </summary>
/// <param name="seldetp"></param>
/// <returns></returns>
public IList GetDeptLeader(WkTDept seldetp)
{
IList i;
string sql = "select u from WkTUser u left join u.UserRole r where u.Kdid = " + seldetp.Id +
" and r.KrOrder = 2 ";
i = loadEntityList(sql);
return(i);
}
private void WorkOvertime_Load(object sender, EventArgs e)
{
Dept = User.Kdid;
userrole = User.UserRole;
if (Role.KrOrder == 2)
{
textBox1.Text = User.KuName;
textBox3.Text = Dept.KdName;
upDateListView1(Dept);
}
else
{
tabControl1.TabPages.RemoveAt(2);
tabControl1.TabPages.RemoveAt(0);
}
}
private void upDateListView1(WkTDept dep)
{
listView1.Items.Clear();
IList subUsers = getUserByDept(dep);
DateTime date = dateTimePicker1.Value;
foreach (WkTUser u in subUsers)
{
TimeSpan tOfDay = new TimeSpan(getOverTimeOfDay(u, date));
TimeSpan tOfMonth = new TimeSpan(getOverTimeOfMonth(u, date));
ListViewItem item = new ListViewItem();
//item.Checked = true;
item.SubItems.Add(u.KuName);
item.SubItems.Add(tOfDay.Hours.ToString() + "小时" + tOfDay.Minutes.ToString() + "分");
item.SubItems.Add(tOfMonth.Hours.ToString() + "小时" + tOfMonth.Minutes.ToString() + "分");
item.Tag = u;
listView1.Items.Add(item);
}
}
private void initTabPage1()
{
textBox1.Text = User.KuName;
string query = "from WkTDept";
IList depList = baseService.loadEntityList(query);
WkTDept dep = new WkTDept();
depList.Remove(depList[0]);
comboBox1.DataSource = depList;
comboBox1.DisplayMember = "KdName";
comboBox1.ValueMember = "Itself";
listView9.Items.Clear();
IList Boss = getBoss();
foreach (WkTUser b in Boss)
{
ListViewItem item = new ListViewItem();
item.Text = b.KuName;
item.Tag = b;
listView9.Items.Add(item);
}
listView9.SelectedItems.Clear();
}
private void redoForm_Load(object sender, EventArgs e)
{
this.MaximizeBox = false;
string query = "from WkTDept";
IList depList = baseService.loadEntityList(query);
WkTDept dep = new WkTDept();
depList.Remove(depList[0]);
comboBox1.DataSource = depList;
comboBox1.DisplayMember = "KdName";
comboBox1.ValueMember = "Itself";
empList = new List <WkTUser>();
int i = 1;
foreach (BusinessEmployee be in business.BusinessEmployee)
{
ListViewItem item = new ListViewItem();
item.Text = i.ToString();
item.SubItems.Add(be.EmployeeId.KuName);
item.SubItems.Add(be.EmployeeId.Kdid.KdName.Trim());
switch (be.PassExam)
{
case (int)BusinessEmployee.ExamState.redo:
item.SubItems.Add("退回");
break;
case (int)BusinessEmployee.ExamState.pass:
item.SubItems.Add("通过审核");
break;
}
i++;
item.Tag = be;
listView3.Items.Add(item);
}
}
/// <summary>
/// 员工查询按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button6_Click(object sender, EventArgs e)
{
this.button6.Cursor = Cursors.WaitCursor;
if (this.comboBox2.Items.Count > 1)
{
#region 择全部
if (this.comboBox2.SelectedIndex == 0)
{
this.dataGridView2.Rows.Clear();
int i = 1;
foreach (WkTDept d in theDepts)
{
string sql0 = "select u from OnDutyTable u left join u.DaiBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql1 = "select u from OnDutyTable u left join u.BaiBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql2 = "select u from OnDutyTable u left join u.YeBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql = "";
switch (this.comboBox3.SelectedIndex)
{
case 0:
sql = sql0; break;
case 1:
sql = sql1; break;
case 2:
sql = sql2; break;
}
if (sql != "")
{
IList times = baseService.loadEntityList(sql);
if (times != null)
{
foreach (OnDutyTable o in times)
{
DateTime dt = new DateTime(o.Time);
switch (this.comboBox3.SelectedIndex)
{
case 0:
this.dataGridView2.Rows.Add(i,
o.DaiBanID.Kdid.KdName,
o.DaiBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
case 1:
this.dataGridView2.Rows.Add(i,
o.BaiBanID.Kdid.KdName,
o.BaiBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
case 2:
this.dataGridView2.Rows.Add(i,
o.YeBanID.Kdid.KdName,
o.YeBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
}
i++;
}
}
}
}
}
#endregion
#region 择某一个
else
{
this.dataGridView2.Rows.Clear();
int i = 1;
WkTDept d = theDepts[this.comboBox2.SelectedIndex - 1];
string sql0 = "select u from OnDutyTable u left join u.DaiBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql1 = "select u from OnDutyTable u left join u.BaiBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql2 = "select u from OnDutyTable u left join u.YeBanID user where user.KuName like '%" + textBox1.Text.Trim() + "%' and"
+ " user.Kdid = " + d.Id + " and u.Time >= " + this.dateTimePicker4.Value.Ticks + " and u.Time <= " + this.dateTimePicker5.Value.Ticks
+ " and u.State = " + (int)IEntity.stateEnum.Normal;
string sql = "";
switch (this.comboBox3.SelectedIndex)
{
case 0:
sql = sql0; break;
case 1:
sql = sql1; break;
case 2:
sql = sql2; break;
}
if (sql != "")
{
IList times = baseService.loadEntityList(sql);
if (times != null)
{
foreach (OnDutyTable o in times)
{
DateTime dt = new DateTime(o.Time);
switch (this.comboBox3.SelectedIndex)
{
case 0:
this.dataGridView2.Rows.Add(i,
o.DaiBanID.Kdid.KdName,
o.DaiBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
case 1:
this.dataGridView2.Rows.Add(i,
o.BaiBanID.Kdid.KdName,
o.BaiBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
case 2:
this.dataGridView2.Rows.Add(i,
o.YeBanID.Kdid.KdName,
o.YeBanID.KuName,
dt.ToString("yyyy年MM月dd日") + EnglishToChinese(dt),
this.comboBox3.Text, o.Type == 0 ? "行政班" : "网络班");
break;
}
i++;
}
}
}
}
#endregion
}
this.button6.Cursor = Cursors.Hand;
}
private IList getUserByDept(WkTDept dept)//获取登陆人所在部门
{
string queryUser = "******" + dept.Id;
return(baseService.loadEntityList(queryUser));
}
