DataCode/ErrLog.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;

    public class ErrLogMgr
    {
        #region 静态函数

        #region 静态函数InsertErrLog 插入一条错误日志
        /// <summary>
        /// 增加一条日志
        /// </summary>
        /// <param name="MsgType">错误消息类型</param>
        /// <param name="Msg">错误消息</param>
        /// <param name="SQL">产生错误的SQL语句</param>
        public static void InsertErrLog(string MsgType, string Msg, string SQLContent)
        {
            SqlCommand cmd = new SqlCommand("u_InsertErrLog", DataControl.OpenGetConnection);
            try
            {
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter[] Parms = new SqlParameter[3];

                Parms[0] = new SqlParameter("MsgType", SqlDbType.NVarChar, 50);
                Parms[0].Value = MsgType;

                Parms[1] = new SqlParameter("Msg", SqlDbType.NVarChar, 4000);
                Parms[1].Value = Msg;

                Parms[2] = new SqlParameter("SQLContent", SqlDbType.NText);
                Parms[2].Value = SQLContent;

                foreach (SqlParameter Parm in Parms)
                {
                    cmd.Parameters.Add(Parm);
                }

                cmd.ExecuteNonQuery();
            }
            catch { }
        }
        #endregion

        #region 静态函数Search 搜索客服状态
        /// <summary>
        /// 查询错误日志
        /// </summary>
        /// <param name="MinInputDate">开始日期</param>
        /// <param name="MaxInputDate">截止日期</param>
        /// <param name="MsgType">错误日期类别</param>
        /// <param name="Msg">错误日志说明</param>
        /// <param name="RowCount">总行数</param>
        /// <param name="MaxRecord">返回行数</param>