/// <summary> /// 向数据表DawnAuthError中插入一条新记录 /// </summary> /// <param name="dawnAuthError">DawnAuthError实体对象</param> /// <returns></returns> public static int Insert(DawnAuthErrorMDL dawnAuthError) { if (dawnAuthError == null) { return(0); } return(DawnAuthErrorBLL._dal.Insert(dawnAuthError)); }
/// <summary> /// 得到DawnAuthError实体对象 /// </summary> /// <param name="dr">dr</param> /// <returns>DawnAuthError实体对象</returns> public DawnAuthErrorMDL Select(IDataReader dr) { DawnAuthErrorMDL obj = new DawnAuthErrorMDL(); try { obj.ErrId = (Guid)dr["err_id"]; } catch { } try { obj.ErrTime = ((dr["err_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["err_time"]); } catch { } try { obj.ErrAddress = dr["err_address"].ToString(); } catch { } try { obj.ErrMessage = dr["err_message"].ToString(); } catch { } try { obj.ErrTarget = dr["err_target"].ToString(); } catch { } try { obj.ErrTrace = dr["err_trace"].ToString(); } catch { } try { obj.ErrSource = dr["err_source"].ToString(); } catch { } try { obj.ErrIp = dr["err_ip"].ToString(); } catch { } try { obj.ErrUid = ((dr["err_uid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["err_uid"]); } catch { } try { obj.ErrUname = dr["err_uname"].ToString(); } catch { } return(obj); }
/// <summary> /// 根据ID,返回一个DawnAuthError实体对象 /// </summary> /// <param name="errId">系统编号</param> /// <returns>DawnAuthError实体对象</returns> public DawnAuthErrorMDL Select(Guid errId) { DawnAuthErrorMDL obj = null; SqlParameter[] param = { new SqlParameter("@ErrId", SqlDbType.UniqueIdentifier) }; param[0].Value = errId; string sqlCommand = "DawnAuthErrorSelect"; using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param)) { while (dr.Read()) { obj = this.Select(dr); } } return(obj); }
/// <summary> /// 记录错误信息 /// </summary> /// <param name="ex">错误数据对象</param> /// <returns></returns> public static int InsertByError(Exception ex) { try { if ((ex is System.Threading.ThreadAbortException)) { return(-1); } DawnAuthErrorMDL errInfo = new DawnAuthErrorMDL(); if (ex.InnerException != null) { errInfo.ErrTime = System.DateTime.Now; errInfo.ErrAddress = string.IsNullOrEmpty(RequestHelper.GetUrl()) == true ? "非法数据!(页面信息)" : RequestHelper.GetUrl(); errInfo.ErrMessage = string.IsNullOrEmpty(ex.InnerException.Message) == true ? "非法数据!(错误信息)" : ex.InnerException.Message; errInfo.ErrTarget = string.IsNullOrEmpty(ex.InnerException.TargetSite.ToString()) == true ? "非法数据!(异常方法)" : ex.InnerException.TargetSite.ToString(); errInfo.ErrTrace = string.IsNullOrEmpty(ex.InnerException.StackTrace) == true ? "非法数据!(表示形式)" : ex.InnerException.StackTrace; errInfo.ErrSource = string.IsNullOrEmpty(ex.InnerException.Source) == true ? "非法数据!(数据源)" : ex.InnerException.Source; errInfo.ErrIp = string.IsNullOrEmpty(RequestHelper.GetIPAddress()) == true ? "非法数据!(IP地址)" : RequestHelper.GetIPAddress(); errInfo.ErrUid = DawnauthHandler.UserId; errInfo.ErrUname = string.IsNullOrEmpty(DawnauthHandler.UserSurname) ? "未登录" : DawnauthHandler.UserSurname; } else { errInfo.ErrTime = System.DateTime.Now; errInfo.ErrAddress = string.IsNullOrEmpty(RequestHelper.GetUrl()) == true ? "非法数据!(页面信息)" : RequestHelper.GetUrl(); errInfo.ErrMessage = string.IsNullOrEmpty(ex.Message) == true ? "非法数据!(错误信息)" : ex.Message; errInfo.ErrTarget = string.IsNullOrEmpty(ex.TargetSite.ToString()) == true ? "非法数据!(异常方法)" : ex.TargetSite.ToString(); errInfo.ErrTrace = string.IsNullOrEmpty(ex.StackTrace) == true ? "非法数据!(表示形式)" : ex.StackTrace; errInfo.ErrSource = string.IsNullOrEmpty(ex.Source) == true ? "非法数据!(数据源)" : ex.Source; errInfo.ErrIp = string.IsNullOrEmpty(RequestHelper.GetIPAddress()) == true ? "非法数据!(IP地址)" : RequestHelper.GetIPAddress(); errInfo.ErrUid = DawnauthHandler.UserId; errInfo.ErrUname = string.IsNullOrEmpty(DawnauthHandler.UserSurname) ? "未登录" : DawnauthHandler.UserSurname; } int res = DawnAuthErrorBLL.Insert(errInfo); return(res); } catch { return(-1); } }
/// <summary> /// 向数据表DawnAuthError中插入一条新记录 /// </summary> /// <param name="dawnAuthError">DawnAuthError实体对象</param> /// <returns></returns> public int Insert(DawnAuthErrorMDL dawnAuthError) { try { string sqlCommand = "DawnAuthErrorInsert"; int res; SqlParameter[] param = { new SqlParameter("@ErrId", SqlDbType.UniqueIdentifier), new SqlParameter("@ErrTime", SqlDbType.DateTime), new SqlParameter("@ErrAddress", SqlDbType.VarChar, 2000), new SqlParameter("@ErrMessage", SqlDbType.VarChar, 4000), new SqlParameter("@ErrTarget", SqlDbType.VarChar, -1), new SqlParameter("@ErrTrace", SqlDbType.NVarChar, -1), new SqlParameter("@ErrSource", SqlDbType.NVarChar, -1), new SqlParameter("@ErrIp", SqlDbType.VarChar, 200), new SqlParameter("@ErrUid", SqlDbType.Int), new SqlParameter("@ErrUname", SqlDbType.NVarChar, 20) }; param[0].Direction = ParameterDirection.Output; param[1].Value = dawnAuthError.ErrTime; param[2].Value = dawnAuthError.ErrAddress; param[3].Value = dawnAuthError.ErrMessage; param[4].Value = dawnAuthError.ErrTarget; param[5].Value = dawnAuthError.ErrTrace; param[6].Value = dawnAuthError.ErrSource; param[7].Value = dawnAuthError.ErrIp; param[8].Value = dawnAuthError.ErrUid; param[9].Value = dawnAuthError.ErrUname; res = SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param); dawnAuthError.ErrId = (Guid)param[0].Value; return(res); } catch { return(-1); } }
/// <summary> /// 得到DawnAuthError实体对象 /// </summary> /// <param name="row">row</param> /// <returns>DawnAuthError实体对象</returns> public DawnAuthErrorMDL Select(DataRow row) { DawnAuthErrorMDL obj = new DawnAuthErrorMDL(); if (row != null) { try { obj.ErrId = (Guid)row["err_id"]; } catch { } try { obj.ErrTime = ((row["err_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["err_time"]); } catch { } try { obj.ErrAddress = row["err_address"].ToString(); } catch { } try { obj.ErrMessage = row["err_message"].ToString(); } catch { } try { obj.ErrTarget = row["err_target"].ToString(); } catch { } try { obj.ErrTrace = row["err_trace"].ToString(); } catch { } try { obj.ErrSource = row["err_source"].ToString(); } catch { } try { obj.ErrIp = row["err_ip"].ToString(); } catch { } try { obj.ErrUid = ((row["err_uid"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["err_uid"]); } catch { } try { obj.ErrUname = row["err_uname"].ToString(); } catch { } } else { return(null); } return(obj); }