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