如何记录投诉时如何发出警报 [英] How can i make an alert whenever a complaint is logged

问题描述

嗨
我正在尝试建立一个基于网络的投诉记录系统。

每当用户提出投诉时，投诉详情将保存在数据库中。

我怎样才能提醒相关人你有投诉？

任何人都可以帮助我。

Hi I am trying to make a web based complaint logging system.
Whenever user makes a complaint, complaint details will be saved in database.
How can i alert the respective person that u have got complaint?
can anyone help me in it.

推荐答案

一个选项是在插入记录时，使用数据库上的触发器向适当的人发送电子邮件。



另一种选择是使用定时器作业定期检查表对于未发送的警报，收集它们并发送它们（将它们标记为已发送）。



另一种选择是更新您的网站，以便它发送一封电子邮件给适当的人根据需要......

One option would be to use a trigger on your database to send an email to the appropriate person when a record is inserted.

Another option would be to have a timer job that periodically checks the table for unsent alerts, gathers them up and sends them (flagging them as having been sent).

Yet another option is to update your website so that it sends an email to the appropriate person as needed...

选中此链接发送邮件。从您要发送消息的位置调用此方法。为此，您需要在服务器上配置SMTP。您可以使用Outlook设置在开发期间进行测试。将此信息保存在配置文件中，以便管理员/网站管理员根据部署区域对其进行修改。



http://social.msdn.microsoft.com/Forums / en-US / a75533eb-131b-4ff3-a3b2-b6df87c25cc8 / how-do-i-send-mail-using-c [ ^ ]

Check this link to send a Mail. Call this method from where you wnat the message to be sent. For this to work you need have a SMTP configured on server. You can use your outlook settings to do test during development. Keep this information in config file so that it can be modified by admin / web master as per area of deployment.

http://social.msdn.microsoft.com/Forums/en-US/a75533eb-131b-4ff3-a3b2-b6df87c25cc8/how-do-i-send-mail-using-c[^]

（可选）在数据库中添加新列（TrueFalse）HaveToAlert...

当发现任何相关投诉时将特定单元格更新为True



每当用户登录检查时，他的行的HaveToAlert单元格是True还是什么？如果为真，则可以提醒特定的人。



警告后，再次将其更新为False。

Optionally, Add new column in database (TrueFalse) "HaveToAlert"...
When Any related complaint found Update PArticular cell to "True"

Whenever User Log In Check If "HaveToAlert" cell for his row is True or what? If true then You can Alert particular person.

After Alert, Again update it to False.

这篇关于如何记录投诉时如何发出警报的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！