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