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