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