private void ShowErrorMessageForm_Load(object sender, EventArgs e)
{
this.tbErrorInfo.Text = this.ecInfo;
this.reportContent.Append("组织机构:" + ConfigHelper.GetNode("orgName") + " 编号:" + ConfigHelper.GetNode("orgCode") + "\r\n");
Ping ping = new Ping();
try
{
if ((PadForm.netStatus == "1") && (ping.Send("smtp.163.com").Status == IPStatus.Success))
{
this.btnReport.Enabled = true;
}
}
catch (Exception)
{
}
if (!this.btnReport.Enabled)
{
SystemErrorLogBLL report = new SystemErrorLogBLL();
report.CheckTable("SystemErrorLog");
SystemErrorLogModel model = new SystemErrorLogModel
{
CreateDate = new DateTime?(DateTime.Now),
IDCardNo = PadForm.idNo,
LogData = this.exp.ToString(),
Message = this.exp.Message,
SendEd = "0",
StackTrace = this.exp.StackTrace,
TargetSite = this.exp.TargetSite.ToString()
};
report.Add(model);
}
}
protected void Application_Error(object sender, EventArgs e)
{
Exception LastError = Server.GetLastError();
SystemErrorLogModel SELM = new SystemErrorLogModel();
SELM.ErrorType = LastError.GetType().FullName;
SELM.ErrorMessage = LastError.Message;
SELM.PathAndQuery = Request.Url.PathAndQuery;
SELM.ClientIP = Request.UserHostAddress;
SELM.ErrorTime = DateTime.Now;
SELM.StackTrace = LastError.StackTrace.Replace("\r\n", "<br/>");
new SystemErrorLogBLL().Add(SELM);
}
public int Add(SystemErrorLogModel model)
{
DbCommand cmd = db.GetStoredProcCommand("PROC_T_SYS_SystemErrorLogAdd");
db.AddInParameter(cmd, "@ErrorType", DbType.String, model.ErrorType);
db.AddInParameter(cmd, "@ErrorMessage", DbType.String, model.ErrorMessage);
db.AddInParameter(cmd, "@PathAndQuery", DbType.String, model.PathAndQuery);
db.AddInParameter(cmd, "@ClientIP", DbType.String, model.ClientIP);
db.AddInParameter(cmd, "@ErrorTime", DbType.DateTime, model.ErrorTime);
db.AddInParameter(cmd, "@StackTrace", DbType.String, model.StackTrace);
int i = db.ExecuteNonQuery(cmd);
return(i);
}
public SystemErrorLogModel DataRowToModel(DataRow row)
{
SystemErrorLogModel report = new SystemErrorLogModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
report.ID = int.Parse(row["ID"].ToString());
}
if ((row["LogData"] != null) && (row["LogData"] != DBNull.Value))
{
report.LogData = row["LogData"].ToString();
}
if ((row["Message"] != null) && (row["Message"] != DBNull.Value))
{
report.Message = row["Message"].ToString();
}
if ((row["StackTrace"] != null) && (row["StackTrace"] != DBNull.Value))
{
report.StackTrace = row["StackTrace"].ToString();
}
if ((row["TargetSite"] != null) && (row["TargetSite"] != DBNull.Value))
{
report.TargetSite = row["TargetSite"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
report.IDCardNo = row["IDCardNo"].ToString();
}
if (((row["CreateDate"] != null) && (row["CreateDate"] != DBNull.Value)) && (row["CreateDate"].ToString() != ""))
{
report.CreateDate = new DateTime?(DateTime.Parse(row["CreateDate"].ToString()));
}
if ((row["SendEd"] != null) && (row["SendEd"] != DBNull.Value))
{
report.SendEd = row["SendEd"].ToString();
}
if (((row["SendDate"] != null) && (row["SendDate"] != DBNull.Value)) && (row["SendDate"].ToString() != ""))
{
report.SendDate = new DateTime?(DateTime.Parse(row["SendDate"].ToString()));
}
}
return(report);
}
public List <SystemErrorLogModel> DataTableToList(DataTable dt)
{
List <SystemErrorLogModel> list = new List <SystemErrorLogModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
SystemErrorLogModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public string GetSystemErrorLog(HttpContext context)
{
string PageIndex = context.Request["page"] == null ? "" : context.Request["page"].ToString();
string PageSize = context.Request["rows"] == null ? "" : context.Request["rows"].ToString();
string LogJson = "";
SystemErrorLogModel model = new SystemErrorLogModel();
model.PageIndex = string.IsNullOrEmpty(PageIndex) ? 1 : Convert.ToInt32(PageIndex);
model.PageSize = string.IsNullOrEmpty(PageSize) ? 10 : Convert.ToInt32(PageSize);
List <SystemErrorLogModel> List = SELBLL.GetList(model);
LogJson = "{\"total\":" + model.OUTTotalCount + ",\"rows\":[";
foreach (SystemErrorLogModel item in List)
{
LogJson += "{\"ID\":\"" + item.ID + "\",\"ErrorType\":\"" + item.ErrorType + "\",\"ErrorMessage\":\"" + item.ErrorMessage + "\",\"PathAndQuery\":\"" + item.PathAndQuery + "\",\"ClientIP\":\"" + item.ClientIP + "\",\"ErrorTime\":\"" + item.ErrorTime + "\",\"StackTrace\":\"" + item.StackTrace + "\"},";
}
LogJson = LogJson.TrimEnd(',');
LogJson += "]}";
return(LogJson);
}
public List <SystemErrorLogModel> GetList(SystemErrorLogModel model)
{
List <SystemErrorLogModel> List = new List <SystemErrorLogModel>();
string[] strPara = new string[] { "@PageIndex", "@PageSize", "@OUTTotalCount" };
ParameterMapper mapper = new ParameterMapper(strPara);
var ObjectModel = db.CreateSprocAccessor <SystemErrorLogModel>("PROC_T_SYS_GetSystemErrorLogList", mapper, MapBuilder <SystemErrorLogModel> .MapNoProperties()
.Map(p => p.ID).ToColumn("ID")
.Map(p => p.ErrorType).ToColumn("ErrorType")
.Map(p => p.ErrorMessage).ToColumn("ErrorMessage")
.Map(p => p.PathAndQuery).ToColumn("PathAndQuery")
.Map(p => p.ClientIP).ToColumn("ClientIP")
.Map(p => p.ErrorTime).ToColumn("ErrorTime")
.Map(p => p.StackTrace).ToColumn("StackTrace")
.Build()
);
object[] param = { model.PageIndex, model.PageSize, model.OUTTotalCount };
List = ObjectModel.Execute(param).ToList <SystemErrorLogModel>();
model.OUTTotalCount = int.Parse(mapper.GetParameterValue("@OUTTotalCount").ToString());
return(List);
}
public bool Update(SystemErrorLogModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SYS_ERROR_LOG set ");
builder.Append("LogData=@LogData,");
builder.Append("Message=@Message,");
builder.Append("StackTrace=@StackTrace,");
builder.Append("TargetSite=@TargetSite,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("CreateDate=@CreateDate,");
builder.Append("SendEd=@SendEd,");
builder.Append("SendDate=@SendDate");
builder.Append(" where ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@LogData", MySqlDbType.String),
new MySqlParameter("@Message", MySqlDbType.String),
new MySqlParameter("@StackTrace", MySqlDbType.String),
new MySqlParameter("@TargetSite", MySqlDbType.String),
new MySqlParameter("@IDCardNo", MySqlDbType.String),
new MySqlParameter("@CreateDate", MySqlDbType.Date),
new MySqlParameter("@SendEd", MySqlDbType.String, 1),
new MySqlParameter("@SendDate", MySqlDbType.Date),
new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.LogData;
cmdParms[1].Value = model.Message;
cmdParms[2].Value = model.StackTrace;
cmdParms[3].Value = model.TargetSite;
cmdParms[4].Value = model.IDCardNo;
cmdParms[5].Value = model.CreateDate;
cmdParms[6].Value = model.SendEd;
cmdParms[7].Value = model.SendDate;
cmdParms[8].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(SystemErrorLogModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SYS_ERROR_LOG(");
builder.Append("LogData,Message,StackTrace,TargetSite,IDCardNo,CreateDate,SendEd,SendDate)");
builder.Append(" values (");
builder.Append("@LogData,@Message,@StackTrace,@TargetSite,@IDCardNo,@CreateDate,@SendEd,@SendDate)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@LogData", MySqlDbType.String),
new MySqlParameter("@Message", MySqlDbType.String),
new MySqlParameter("@StackTrace", MySqlDbType.String),
new MySqlParameter("@TargetSite", MySqlDbType.String),
new MySqlParameter("@IDCardNo", MySqlDbType.String),
new MySqlParameter("@CreateDate", MySqlDbType.Date),
new MySqlParameter("@SendEd", MySqlDbType.String, 1),
new MySqlParameter("@SendDate", MySqlDbType.Date)
};
cmdParms[0].Value = model.LogData;
cmdParms[1].Value = model.Message;
cmdParms[2].Value = model.StackTrace;
cmdParms[3].Value = model.TargetSite;
cmdParms[4].Value = model.IDCardNo;
cmdParms[5].Value = model.CreateDate;
cmdParms[6].Value = model.SendEd;
cmdParms[7].Value = model.SendDate;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public List <SystemErrorLogModel> GetList(SystemErrorLogModel model)
{
return(DAL.GetList(model));
}
public int Add(SystemErrorLogModel model)
{
return(DAL.Add(model));
}
public int Add(SystemErrorLogModel model)
{
return(this.dal.Add(model));
}
public bool Update(SystemErrorLogModel model)
{
return(this.dal.Update(model));
}
