.net对各表的操作详细到字段的更改记录的日志

  /// <summary>
        /// 添加操作日志
        /// </summary>
        /// <param name="strsql">执行的sql语句</param>
        /// <param name="username">执行人</param>
        /// <param name="dentity">执行人身份</param>
        /// <param name="cmdparms">参数</param>
        public static void AddLog(StringBuilder strsql,string username,string dentity,params SqlParameter[] cmdparms)
        {
            Graduate.Model.OperateLog model = new Graduate.Model.OperateLog();
            model.dentity = dentity;
            model.operatUser = username;
            model.operatTime = DateTime.Now.ToString();
            string content = strsql.ToString().Substring(0, strsql.ToString().IndexOf("values"));
            StringBuilder sblog = new StringBuilder();
            sblog.Append(content + " values ");
            sblog.Append(" ( ");
            foreach (SqlParameter sp in cmdparms)
            {
                sblog.Append("‘" + sp.Value + "‘,");
            }
            sblog.ToString().TrimEnd(‘,‘);
            sblog.Insert(sblog.Length - 1, ‘)‘);
            model.operatContent = sblog.ToString().TrimEnd(‘,‘);
            model.PrevValue = "";
            model.NewValue = "";
            Graduate.DAL.OperateLog dal = new OperateLog();
            dal.Add(model);
        }

        /// <summary>
        /// 删除操作日志
        /// </summary>
        /// <param name="strsql">sql语句</param>
        /// <param name="username">执行人</param>
        /// <param name="dentity">执行人身份</param>
        /// <param name="id">关键字段</param>
        /// <param name="hash">参数(Hasttable)</param>
        public static void DeleteLog(StringBuilder strsql, string username, string dentity, string id,Hashtable hash)
        {
            Graduate.Model.OperateLog logmodel = new Graduate.Model.OperateLog();
            logmodel.dentity = dentity;
            logmodel.operatUser = username;
            StringBuilder sblog = new StringBuilder();
            string conten = strsql.ToString().Substring(0, strsql.ToString().IndexOf(‘=‘));
            sblog.Append(conten + " = ");
            sblog.Append(id.ToString());
            logmodel.operatContent = sblog.ToString();
            logmodel.operatTime = DateTime.Now.ToString();
            string prevval = "";
            foreach (DictionaryEntry de in hash)
            {
                prevval += de.Key + "=" + de.Value + ",";
            }
            prevval = prevval.TrimEnd(‘,‘);
            logmodel.PrevValue = prevval;
            logmodel.NewValue = "";
            Graduate.DAL.OperateLog logdal = new OperateLog();
            logdal.Add(logmodel);
        }

        /// <summary>
        /// 更新操作日志
        /// </summary>
        /// <param name="obj1">原对象</param>
        /// <param name="parmhash">更新字段集(Hashtable)</param>
        /// <param name="username">执行人</param>
        /// <param name="dentity">执行人身份</param>
        /// <param name="tableName">表名</param>
        /// <param name="keytable">存储条件和值(Hashtable)</param>
        public static void UpdateLog(object obj1,Hashtable parmhash,string username,string dentity,string tableName,Hashtable keytable)
        {
            PropertyInfo[] properties = obj1.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance);
           
            StringBuilder consb = new StringBuilder();
            Hashtable prevhash = new Hashtable();
            Hashtable newhash = new Hashtable();
            consb.Append(" update " + tableName + " set ");
            foreach (PropertyInfo pi in properties)
            {
                string piname = pi.Name;
                string pivalue = Convert.ToString(pi.GetValue(obj1, null));
                foreach (DictionaryEntry de in parmhash)
                {
                    if (piname == de.Key.ToString())
                    {
                        if (pivalue != de.Value.ToString())
                        {
                            if (!keytable.Contains(de.Key))
                            {
                                consb.Append(de.Key + "=‘" + de.Value + "‘" + ",");
                            }
                            prevhash.Add(piname, pivalue);
                            newhash.Add(piname, de.Value);
                        }
                    }
                }
            }
            consb.Remove(consb.Length - 1, 1);
            consb.Append(" where ");
            foreach (DictionaryEntry de in keytable)
            {
                consb.Append(de.Key + "=‘" + de.Value + "‘" + " and ");
            }
            consb.Remove(consb.Length - 4, 3); //去掉"and "
            string prevval = "";
            foreach (DictionaryEntry de in prevhash)
            {
                prevval += de.Key + "=" + de.Value + ",";
            }
            prevval = prevval.TrimEnd(‘,‘);
            string newval = "";
            foreach (DictionaryEntry de in newhash)
            {
                newval += de.Key + "=" + de.Value + ",";
            }
            newval = newval.TrimEnd(‘,‘);
            Graduate.Model.OperateLog logmodel = new Graduate.Model.OperateLog();
            logmodel.dentity = dentity;
            logmodel.NewValue = newval;
            logmodel.operatContent = consb.ToString();
            logmodel.operatTime = DateTime.Now.ToString();
            logmodel.operatUser = username;
            logmodel.PrevValue = prevval;
            Graduate.DAL.OperateLog logdal = new OperateLog();
            logdal.Add(logmodel);
        }