public ArrayList GetOtherRoleList(DatabaseConnection dbConn, RoleFilterOptionEnum roleFilterOptionEnum)
{
DBFilter masterEmpIDFilter = new DBFilter();
masterEmpIDFilter.add(new Match("EmpID", "<>", m_EmpID));
OR orMasterEmpIDTerm = new OR();
orMasterEmpIDTerm.add(new Match("MasterEmpID", m_EmpID));
if (m_MasterEmpID > 0)
{
orMasterEmpIDTerm.add(new Match("MasterEmpID", m_MasterEmpID));
}
masterEmpIDFilter.add(orMasterEmpIDTerm);
if (roleFilterOptionEnum == RoleFilterOptionEnum.MPF)
{
masterEmpIDFilter.add(new Match("EmpIsCombineMPF", true));
}
if (roleFilterOptionEnum == RoleFilterOptionEnum.Payslip)
{
masterEmpIDFilter.add(new Match("EmpIsCombinePaySlip", true));
}
if (roleFilterOptionEnum == RoleFilterOptionEnum.Tax)
{
masterEmpIDFilter.add(new Match("EmpIsCombineTax", true));
}
return(EEmpPersonalInfo.db.select(dbConn, masterEmpIDFilter));
}
public DBTerm GetAllRoleEmpIDTerms(DatabaseConnection dbConn, string EmpIDFieldName, RoleFilterOptionEnum roleFilterOptionEnum)
{
System.Collections.Generic.List <string> EmpIDGroupList = new System.Collections.Generic.List <string>();
EmpIDGroupList.Add(m_EmpID.ToString());
//if (m_MasterEmpID > 0)
// EmpIDGroupList.Add(MasterEmpID.ToString());
ArrayList list = GetOtherRoleList(dbConn, roleFilterOptionEnum);
foreach (EEmpPersonalInfo tmpEmpInfo in list)
{
if (!EmpIDGroupList.Contains(tmpEmpInfo.EmpID.ToString()))
{
//if (roleFilterOptionEnum == RoleFilterOptionEnum.MPF && !tmpEmpInfo.EmpIsCombineMPF)
// continue;
//if (roleFilterOptionEnum == RoleFilterOptionEnum.Payslip && !tmpEmpInfo.EmpIsCombinePaySlip)
// continue;
//if (roleFilterOptionEnum == RoleFilterOptionEnum.Tax && !tmpEmpInfo.EmpIsCombineTax)
// continue;
EmpIDGroupList.Add(tmpEmpInfo.EmpID.ToString());
}
}
return(new IN(EmpIDFieldName, string.Join(",", EmpIDGroupList.ToArray()), null));
}
