private void btnDepSearch_Click(object sender, EventArgs e) { listDepartment.Items.Clear(); //初始一个查询表达式 Expression <Func <department, bool> > expression = x => x.departmentId == x.departmentId; if (cboxDepSearchId.Checked == true) { expression = LambdaHelper.And(expression, x => x.departmentId == nudDepSearchId.Value); } if (cboxDepSearchName.Checked == true) { if (txtDepSearchName.Text != "") { expression = LambdaHelper.And(expression, x => x.departmentName == txtDepSearchName.Text); } } department[] deps = dataTools.selectTools.selectDepartment(expression, x => x.departmentId); MessageBox.Show("成功查询到" + deps.Length + "条数据"); for (int count = 0; count < deps.Length; count++) { ListViewItem item = new ListViewItem(); item.Text = deps[count].departmentId.ToString(); item.SubItems.Add(deps[count].departmentName); listDepartment.Items.Add(item); } }
/// <summary> /// 查询公司就职表中的信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPerSearch_Click(object sender, EventArgs e) { //清空 Performance.Items.Clear(); //初始一个查询表达式 Expression <Func <employeePerformance, bool> > expression = x => x.employeeId == x.employeeId; //如果某个查询项选中的话 加入查询表达式 //职工Id if (cboxPerSearchId.Checked == true) { expression = LambdaHelper.And <employeePerformance>(expression, x => x.employeeId == nudPerSearchId.Value); } //职位Id if (cboxPerSearchPosId.Checked == true) { //name的值可能为空 所以要判断 expression = LambdaHelper.And <employeePerformance>(expression, x => x.positionId == nudPosSearchId.Value); } //业绩 if (cboxPerSearchPerformance.Checked == true) { double pNumber = Convert.ToDouble(nudPerSearchPerformance.Value); expression = LambdaHelper.And <employeePerformance>(expression, x => x.performance == pNumber); } employeePerformance[] info = dataTools.selectTools.selectEmployeePerformance(expression, x => x.employeeId); MessageBox.Show("成功查询到" + info.Length + "条数据"); for (int count = 0; count < info.Length; count++) { ListViewItem item = new ListViewItem(); item.Text = info[count].employeeId.ToString(); int eId = info[count].employeeId; //根据职工Id找到职工的名字 string epName = dataTools.selectTools.selectEmployeeInfo(u => u.employeeId == eId, u => u.employeeId)[0].employeeName; item.SubItems.Add(epName); item.SubItems.Add(info[count].positionId.ToString()); int pId = info[count].positionId; //根据职位ID找到职位名字 string pName = dataTools.selectTools.selectCompanyPosition(u => u.positionId == pId, u => u.positionId)[0].positionName; item.SubItems.Add(pName); item.SubItems.Add(info[count].performance.ToString()); Performance.Items.Add(item); } }
//查询 private void btnPosSearch_Click(object sender, EventArgs e) { listPosition.Items.Clear(); //初始一个查询表达式 Expression <Func <companyPosition, bool> > expression = x => x.positionId == x.positionId; if (cboxPosSearchId.Checked == true) { expression = LambdaHelper.And(expression, x => x.positionId == nudPosSearchId.Value); } if (cboxPosSearchName.Checked == true) { if (txtPosSearchName.Text != "") { expression = LambdaHelper.And(expression, x => x.positionName == txtPosSearchName.Text); } } if (cboxPosSearchDepId.Checked == true) { expression = LambdaHelper.And(expression, x => x.departmentId == nudPosSearchDepId.Value); } if (cboxPosSearchMoney.Checked == true) { double tmp = double.Parse(nudPosSearchMoney.Value.ToString()); expression = LambdaHelper.And(expression, x => x.positionSalary == tmp); } companyPosition[] pos = dataTools.selectTools.selectCompanyPosition(expression, x => x.positionId); MessageBox.Show("成功查询到" + pos.Length + "条数据"); for (int count = 0; count < pos.Length; count++) { ListViewItem item = new ListViewItem(); item.Text = pos[count].positionId.ToString(); item.SubItems.Add(pos[count].departmentId.ToString()); item.SubItems.Add(pos[count].positionName); item.SubItems.Add(pos[count].positionSalary.ToString()); listPosition.Items.Add(item); } }
//查询员工信息 private void btnInfoSearch_Click(object sender, EventArgs e) { //清空 listInfo.Items.Clear(); //初始一个查询表达式 Expression <Func <employeeInfo, bool> > expression = x => x.employeeId == x.employeeId; //如果某个查询项选中的话 加入查询表达式 if (cboxInfoId.Checked == true) { //nud的Value不可能为空 所以直接查询即可 expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeId == nudInfoSearchId.Value); } //姓名 if (cboxInfoName.Checked == true) { //name的值可能为空 所以要判断 if (txtInfoSearchName.Text != "") { expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeName == txtInfoSearchName.Text); } } //电话 if (cboxInfoTel.Checked == true) { if (txtInfoSearchTel.Text != "") { expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeePhone == txtInfoSearchTel.Text); } } //身份证 if (cboxInfoIdCard.Checked == true) { if (txtInfoSearchIdCard.Text != "") { expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeIdentity == txtInfoSearchIdCard.Text); } } //性别 if (cboxInfoSex.Checked == true) { if (rbtnInfoSearchMale.Checked == true) { expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeSex == 1); } else { expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeSex == 0); } } //生日 if (cboxInfoBirth.Checked == true) { DateTime birth = new DateTime(int.Parse(nudInfoSearchYear.Value.ToString()), int.Parse(nudInfoSearchMonth.Value.ToString()), int.Parse(nudInfoSearchDay.Value.ToString())); expression = LambdaHelper.And <employeeInfo>(expression, x => x.employeeBir == birth); } employeeInfo[] info = dataTools.selectTools.selectEmployeeInfo(expression, x => x.employeeId); MessageBox.Show("成功查询到" + info.Length + "条数据"); for (int count = 0; count < info.Length; count++) { ListViewItem item = new ListViewItem(); item.Text = info[count].employeeId.ToString(); item.SubItems.Add(info[count].employeeName); if (info[count].employeeSex == 0) { item.SubItems.Add("女"); } else { item.SubItems.Add("男"); } item.SubItems.Add(info[count].employeePhone); DateTime birth = (DateTime)info[count].employeeBir; item.SubItems.Add(birth.ToString("D")); item.SubItems.Add(info[count].employeeIdentity); listInfo.Items.Add(item); } }