public static void DeleteUserMail(this MSSqlHelper db, Mail mail)
{
try
{
db.ExcuteSQL("delete from mailItem where mailID = " + mail.MailID);
db.ExcuteSQL("delete from mail where mailID = " + mail.MailID);
}
catch (Exception)
{
}
}
public static void DeleteSendMail(this MSSqlHelper db, Mail mail)
{
try
{
db.ExcuteSQL("DELETE FROM QueuedItem Where RowID=" + mail.MailID);
}
catch (Exception)
{
}
}
public static bool ModMailItem(this MSSqlHelper db, Mail mail, string itemclass)
{
string sql = "update QueuedItem set ItemClassEx='" + itemclass + "' where RowID=" + mail.MailID;
return(db.ExcuteSQL(sql) > 0);
}
