public FormPayroll(string empId) { InitializeComponent(); Initialize(); EmpSearchTerm term = new EmpSearchTerm(); term.EmpId = empId; term.MultiStatusKBN = null; searchTermManager.SetSearchTerm(term); }
public static Hashtable EmpMultiFilterToHashTable(EmpSearchTerm filter) { UtilService utilService = new UtilService(); Hashtable hashTable = new Hashtable(); if (!(filter.EmpName == null || filter.EmpName.Equals(""))) { hashTable.Add("@EmpName", utilService.buildWildSearchFilter(filter.EmpName)); } if (!(filter.IdCard == null || filter.IdCard.Equals(""))) { hashTable.Add("@IdCard", utilService.buildWildSearchFilter(filter.IdCard)); } if (!(filter.MultiEmpTypeId == null || filter.MultiEmpTypeId.Equals(""))) { hashTable.Add("@EmpTypeID", filter.MultiEmpTypeId); } if (!(filter.MultiDeptId == null || filter.MultiDeptId.Equals(""))) { hashTable.Add("@DeptID", filter.MultiDeptId); } if (!(filter.MultiStatusKBN == null || filter.MultiStatusKBN.Equals(""))) { hashTable.Add("@StatusKBN", filter.MultiStatusKBN); } if (filter.EntryTimeStart != DateTime.MinValue) { hashTable.Add("@EntryTimeStart", filter.EntryTimeStart); } if (filter.EntryTimeEnd != DateTime.MinValue) { hashTable.Add("@EntryTimeEnd", filter.EntryTimeEnd); } if (filter.LeaveTimeStart != DateTime.MinValue) { hashTable.Add("@LeaveTimeStart", filter.LeaveTimeStart); } if (filter.LeaveTimeEnd != DateTime.MinValue) { hashTable.Add("@LeaveTimeEnd", filter.LeaveTimeEnd); } return hashTable; }
private void SetSearchContent(EmpSearchTerm term) { form.sTxtName.Text = searchTerm.EmpName; form.sTxtIdCard.Text = searchTerm.IdCard; form.sDtEntryStart.Value = searchTerm.EntryTimeStart; form.sDtEntryEnd.Value = searchTerm.EntryTimeEnd; form.sDtLeaveStart.Value = searchTerm.LeaveTimeStart; form.sDtLeaveEnd.Value = searchTerm.LeaveTimeEnd; SetChkListChecked(form.sLstDept, searchTerm.MultiDeptId); SetChkListChecked(form.sLstEmpType, searchTerm.MultiEmpTypeId); SetChkListChecked(form.sLstWorkStatus, searchTerm.MultiStatusKBN); }
public void SetSearchContentToInit() { searchTerm = new EmpSearchTerm(); SetSearchContent(searchTerm); }
public EmpTypeEmpTree(TreeView tv, IEmployee iemployee, EmpSearchTerm searchTerm) : base(tv, iemployee, searchTerm) { }
public EmployeeTree(TreeView tv, IEmployee iemployee, EmpSearchTerm searchTerm) : base(tv) { this.iemployee = iemployee; this.searchTerm = searchTerm; }
public DeptEmpTree(TreeView tv, ICompany icompany, IEmployee iemployee, EmpSearchTerm searchTerm) : base(tv, iemployee, searchTerm) { deptEmpTree = new DepartmentTree(icompany, tv); }
public void getEmpByMultiFilterTest() { EmployeeImpl target = new EmployeeImpl(); // TODO: Initialize to an appropriate value EmpSearchTerm empSearchTerm = new EmpSearchTerm(); empSearchTerm.EmpName = "李"; empSearchTerm.MultiEmpTypeId = "HR,Tester,Developer"; empSearchTerm.MultiDeptId = "D_01,D_02,D_03,D_03_01"; empSearchTerm.MultiStatusKBN = "1,2"; empSearchTerm.LeaveTimeStart = Convert.ToDateTime("2100-02-03"); List<Employee> actual; actual = target.getEmpByMultiFilter(empSearchTerm); Assert.AreEqual(1, actual.Count); Assert.AreEqual("N004", actual[0].EmpID); }
public void getFormEmpEntityListTest() { EmployeeImpl target = new EmployeeImpl(); // TODO: Initialize to an appropriate value EmpSearchTerm empSearchTerm = new EmpSearchTerm(); empSearchTerm.EmpName = "李"; empSearchTerm.MultiEmpTypeId = "HR,Tester,Developer"; empSearchTerm.MultiDeptId = "D_01,D_02,D_03,D_03_01"; empSearchTerm.MultiStatusKBN = "1,2"; //empSearchTerm.LeaveTimeStart = Convert.ToDateTime("2100-02-03"); List<EmpFormEntity> actual; actual = target.getFormEmpEntityList(empSearchTerm, EmpFormEntityMask.EmpType | EmpFormEntityMask.EmpDept | EmpFormEntityMask.MonFix | EmpFormEntityMask.BonusFix); Assert.AreEqual(3, actual.Count); Assert.AreEqual("N001", actual[0].Employee.EmpID); }
public List<EmpFormEntity> getFormEmpEntityList(EmpSearchTerm filter, EmpFormEntityMask mask) { try { List<Employee> empList = this.getEmpByMultiFilter(filter); List<EmpFormEntity> formEmpEntityList = new List<EmpFormEntity>(); foreach(Employee emp in empList) { // employee EmpFormEntity formEmpEntity = new EmpFormEntity(); formEmpEntity.Employee = emp; // emptype if ((mask & EmpFormEntityMask.EmpType) == EmpFormEntityMask.EmpType) { EmpType empType = this.getEmpTypeByEmpTypeID(emp.EmpTypeID); formEmpEntity.EmpType = empType; } // empdept if ((mask & EmpFormEntityMask.EmpDept) == EmpFormEntityMask.EmpDept) { List<EmpDept> deptList = empDAO.searchDeptByEmpID(emp.EmpID); formEmpEntity.EmpDept = (EmpDept[])deptList.ToArray(); } // monthfix if ((mask & EmpFormEntityMask.MonFix) == EmpFormEntityMask.MonFix) { List<FixedAmountItem> mfs = empDAO.getEmpFixedAmountItem(emp.EmpID, false); formEmpEntity.MonthFixItem = (FixedAmountItem[])mfs.ToArray(); } // bonusfix if ((mask & EmpFormEntityMask.BonusFix) == EmpFormEntityMask.BonusFix) { List<FixedAmountItem> bfs = empDAO.getEmpFixedAmountItem(emp.EmpID, true); formEmpEntity.BonusFixItem = (FixedAmountItem[])bfs.ToArray(); } formEmpEntityList.Add(formEmpEntity); } return formEmpEntityList; } catch (DAOException) { throw; } }
public List<Employee> getEmpByMultiFilter(EmpSearchTerm filter) { try { Hashtable hashTable = EmpMultiFilterToHashTable(filter); return empDAO.searchEmpByMultiFilter(hashTable); } catch (DAOException) { throw; } }
public void SetSearchTerm(EmpSearchTerm searchTerm) { this.searchTerm = searchTerm; SetSearchContent(searchTerm); }
private void DoSearch(EmpSearchTerm term) { empList = iemp.getEmpByMultiFilter(term); if (empList == null) { return; } ReBuildListView("", false); }
public List<PayrollEmp> getPayrollEmpsByMultiFilter(EmpSearchTerm filter) { List<PayrollEmp> prEmpList = new List<PayrollEmp>(); Hashtable hashTable = EmployeeImpl.EmpMultiFilterToHashTable(filter); DataSet resultSet = null; try { //resultSet = empDAO.searchEmpByMultiFilter(hashTable); // foreach (DataTable dt in resultSet.Tables) // { // foreach (DataRow dr in dt.Rows) // { // Employee emp = new Employee(); // emp.EmpID = dr["EmpID"].ToString(); // emp.LastName = dr["LastName"].ToString(); // emp.FirstName = dr["FirstName"].ToString(); // emp.TelNum = dr["TelNum"].ToString(); // emp.Address = dr["Address"].ToString(); // emp.ZipCode = dr["ZipCode"].ToString(); // emp.IdCardNum = dr["IdCardNum"].ToString(); // if (Convert.IsDBNull(dr["EntryTime"]) || dr["EntryTime"].ToString().Equals("")) // { // emp.EntryTime = DateTime.MinValue; // } // else // { // emp.EntryTime = Convert.ToDateTime(dr["EntryTime"].ToString()); // } // if (Convert.IsDBNull(dr["LeaveTime"]) || dr["LeaveTime"].ToString().Equals("")) // { // emp.LeaveTime = DateTime.MinValue; // } // else // { // emp.LeaveTime = Convert.ToDateTime(dr["LeaveTime"].ToString()); // } // emp.EmpTypeID = dr["EmpTypeID"].ToString(); // empList.Add(emp); // } // } } catch (Exception ex) { prEmpList.Clear(); } return prEmpList; }
private void InitTerm() { searchTerm = null; searchTerm = new EmpSearchTerm(); }