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