Пример #1
0
        //public static List<T> GetListOf<T>(Expression<Func<T, bool>> expression) where T : class
        //{
        //    using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
        //    {
        //        return db.Set<T>().Where(expression).ToList();
        //    }
        //}

        //public static List<T> GetListOf<T>(Expression<Func<T, bool>> expression) where T : class
        //{
        //    ProductsEntities _context = new ProductsEntities();
        //    return _context.CreateObjectSet<T>().Where(expression).ToList();
        //}

        /// <summary>
        /// 这个方法用户记录数据库所有产生变化的字段,方便迅捷,但是缺点就是像ID这样的字段,只能记录ID不能记录名称,不方面前端知直接查看:
        /// 比如:[ColourID] : old value = 307 , new Value = 304,另外对于强类型新增的对象的ID,记录为0....
        /// 2014年3月10日
        /// </summary>
        /// <param name="table"></param>
        /// <param name="logDetail"></param>
        public static void DbRecorder(DbEntityEntry table, LogOfUserOperatingDetails logDetail)
        {
            var logDesc = string.Empty;
            var entry   = table;
            var currentPropertyNames = entry.CurrentValues.PropertyNames;//OriginalValues
            var modifiedProperties   = from name in currentPropertyNames
                                       where entry.Property(name).IsModified
                                       select name;

            foreach (var propertyName in modifiedProperties)
            {
                logDesc += " <b> [" + propertyName + "] </b> : old value =  <span style='color:red'>  " + HttpUtility.HtmlEncode(entry.OriginalValues[propertyName]) + " </span> , new Value = <span style='color:red'>  " + HttpUtility.HtmlEncode(entry.CurrentValues[propertyName]) + "  </span>";
                logDesc += "<br>";
            }
            logDetail.Descriptions = logDesc;
            DbRecorder(logDetail);
        }
Пример #2
0
        /// <summary>
        /// 这个方法不解释...
        /// </summary>
        /// <param name="logDetail"></param>
        public static void DbRecorder(LogOfUserOperatingDetails logDetail)
        {
            IDictionary <string, string> ls = new Dictionary <string, string>();

            ls.Add("ModelName", logDetail.ModelName);
            ls.Add("ActionName", logDetail.ActionName);
            ls.Add("ActionType", logDetail.ActionType.ToString(CultureInfo.InvariantCulture));

            ls.Add("SKU", logDetail.SKU);
            ls.Add("SKUID", logDetail.SKUID.ToString());
            ls.Add("ChannelID", logDetail.ChannelID.ToString());
            ls.Add("ChannelName", logDetail.ChannelName);
            ls.Add("ProductID", logDetail.ProductID.ToString());
            ls.Add("HMNUM", logDetail.HMNUM.ToString(CultureInfo.InvariantCulture));

            ls.Add("Descriptions", logDetail.Descriptions);
            ls.Add("CreateOn", logDetail.CreateOn.ToString("yyyy-MM-dd HH:mm:ss"));
            ls.Add("CreateBy", logDetail.CreateBy);
            NBCMSLoggerManager.NBCMSLogger("OperatingDetail", "", ls);
        }