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)); }