/// <summary> 发送邮件 </summary>
private void SendEmail()
{
var mail = ExceptionEmailConfigs.ConfigEntity;
var smtp = new SmtpMail(mail.LoginName, mail.LoginPwd, mail.SendMail, "Farseer.Net SQL异常记录", mail.SmtpServer, 0, mail.SmtpPort);
var body = new StringBuilder();
body.AppendFormat("<b>发现时间：</b> {0}<br />", CreateAt.ToString("yyyy年MM月dd日 HH:mm:ss"));
body.AppendFormat("<b>程序文件：</b> <u>{0}</u> <b>第{1}行</b> <font color=red>{2}()</font><br />", FileName, LineNo, MethodName);
body.AppendFormat("<b>执行方式：</b> {0}<br />", CmdType);
body.AppendFormat("<b>Sql语句：</b> {0}<br />", Sql);
body.AppendFormat("<b>Sql参数：</b><br />");
SqlParamList.ForEach(o => body.AppendFormat("{0} = {1}<br />", o.Name, o.Value));
body.AppendFormat("<b>错误消息：</b><font color=red>{0}</font><br />", Message);
smtp.Send(mail.EmailAddress, string.Format("{0}：警告！数据库异常：{1}", DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss"), Message), body.ToString());
}
public DataTable LocalTbl_V3(SqlParamList Params)
{
SqlConnection sqlConnection;
DataTable retDt = new DataTable(Params.TableName);
SqlDataAdapter sqlDataAdapter;
using (sqlConnection = new SqlConnection(WebConfigurationManager.ConnectionStrings["useyourwebconfigconnection"].ConnectionString))
{
sqlConnection.Open();
using (Params.SqlCmd.Connection = sqlConnection)
{
using (sqlDataAdapter = new SqlDataAdapter(Params.SqlCmd.CommandText, sqlConnection))
{
if (sqlDataAdapter.SelectCommand.Parameters.Count > 0 == false)
{
sqlDataAdapter.SelectCommand = Params.SqlCmd;
sqlDataAdapter.Fill(Usrs);
}
}
}
}
return(retDt);
}
