public static AddressList GetAddressList(long[] Keys) { QueryBuilder query = new QueryBuilder(@"SELECT e.ID, e.NAME, cat.USERID as ID, cat.USERNAME, e.EMAIL FROM USER_CAT cat left join DM_NHAN_VIEN e on e.ID=cat.EMPLOYEE_ID WHERE 1=1"); query.addBoolean("e.VISIBLE_BIT", true); query.addCondition("(EMAIL<>'')"); if (Keys.Length > 0) query.addID("e.ID", Keys); DataSet dsTo = HelpDB.getDatabase().LoadDataSet(query, "CAT"); AddressList to = new AddressList(); foreach (DataRow row in dsTo.Tables[0].Rows) { if (!to.ToAddressListString().Contains(row["EMAIL"].ToString())) to.Add(new MailboxAddress(row["NAME"].ToString(), row["EMAIL"].ToString())); } return to; }