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