public List <EmailNeedSend> GetEmailNeedSends(string reportName)
{
List <EmailNeedSend> listEmailsend = new List <EmailNeedSend>();
try
{
DataTable dt = new DataTable();
StringBuilder sqllistmail = new StringBuilder();
sqllistmail.Append("select emailaddress, deptcode, status, usingfunction from m_email where status = 'YES' and usingfunction = '" + reportName + "'");
sqlCON tf = new sqlCON();
tf.sqlDataAdapterFillDatatable(sqllistmail.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
EmailNeedSend item = new EmailNeedSend();
item.EmailReceive = dt.Rows[i]["emailaddress"].ToString();
item.DepartmentCode = dt.Rows[i]["deptcode"].ToString();
item.Status = dt.Rows[i]["status"].ToString();
item.Function = dt.Rows[i]["usingfunction"].ToString();
listEmailsend.Add(item);
}
dt = null;
}
catch (Exception ex)
{
Logfile.Output(StatusLog.Error, "Load list email send fail ", ex.Message);
}
return(listEmailsend);
}
private List <EmailNeedSend> ListEmailNeedSend(DataTable dt)
{
List <EmailNeedSend> list = new List <EmailNeedSend>();
for (int i = 0; i < dt.Rows.Count; i++)
{
EmailNeedSend item = new EmailNeedSend();
item.EmailReceive = dt.Rows[i]["emailaddress"].ToString();
item.DepartmentCode = dt.Rows[i]["deptcode"].ToString();
item.Status = dt.Rows[i]["status"].ToString();
item.Function = dt.Rows[i]["usingfunction"].ToString();
list.Add(item);
}
return(list);
}
