/// <summary> /// 由一行数据得到一个实体 /// </summary> internal static void PrepareModel(ZSystem.Model.t_Log model, DbDataReader dr) { model.ID = GetString(dr["ID"]); model.sContent = GetString(dr["sContent"]); model.sType = GetString(dr["sType"]); model.LogTime = GetDateTime(dr["LogTime"]); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(ZSystem.Model.t_Log model) { StringBuilder sbSql4t_Log; DbParameter[] parms4t_Log; PrepareUpdateCommand(model, out sbSql4t_Log, out parms4t_Log); return(dbHelper.ExecuteNonQuery(CommandType.Text, sbSql4t_Log.ToString(), parms4t_Log)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ZSystem.Model.t_Log model) { int count = dal.Update(model); if (EnableCache && count > 0) { RemoveModelCache(model.ID); } }
public override bool Equals(object obj) { ZSystem.Model.t_Log model = obj as ZSystem.Model.t_Log; if (model != null && model.ID == this.ID) { return(true); } return(false); }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Log model, out StringBuilder sbSql4t_Log, out DbParameter[] parms4t_Log) { sbSql4t_Log = new StringBuilder(); sbSql4t_Log.Append("INSERT INTO t_Log("); sbSql4t_Log.Append("ID, sContent, sType, LogTime)"); sbSql4t_Log.Append(" VALUES ("); sbSql4t_Log.Append("@in_ID, @in_sContent, @in_sType, @in_LogTime)"); parms4t_Log = new DbParameter[] { dbHelper.CreateInDbParameter("@in_ID", DbType.String, model.ID), dbHelper.CreateInDbParameter("@in_sContent", DbType.String, model.sContent), dbHelper.CreateInDbParameter("@in_sType", DbType.String, model.sType), dbHelper.CreateInDbParameter("@in_LogTime", DbType.DateTime, model.LogTime) }; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_Log model, out StringBuilder sbSql4t_Log, out DbParameter[] parms4t_Log) { sbSql4t_Log = new StringBuilder(); sbSql4t_Log.Append("UPDATE t_Log SET "); sbSql4t_Log.Append("sContent=@in_sContent,"); sbSql4t_Log.Append("sType=@in_sType,"); sbSql4t_Log.Append("LogTime=@in_LogTime"); sbSql4t_Log.Append(" WHERE ID=@in_ID"); parms4t_Log = new DbParameter[] { dbHelper.CreateInDbParameter("@in_sContent", DbType.String, model.sContent), dbHelper.CreateInDbParameter("@in_sType", DbType.String, model.sType), dbHelper.CreateInDbParameter("@in_LogTime", DbType.DateTime, model.LogTime), dbHelper.CreateInDbParameter("@in_ID", DbType.String, model.ID) }; }
/// <summary> /// 得到一个对象实体 /// </summary> public ZSystem.Model.t_Log GetModel(string ID) { ZSystem.Model.t_Log model = null; if (!EnableCache) { model = dal.GetModel(ID); } else { string key = ID.ToString(); if (GetModelCache(key) != null) { model = (ZSystem.Model.t_Log)GetModelCache(key); } else { model = dal.GetModel(ID); TryAddModelCache(key, model, null, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null); } } return(model); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private ZSystem.Model.t_Log GetModel(DbDataReader dr) { ZSystem.Model.t_Log model = new ZSystem.Model.t_Log(); PrepareModel(model, dr); return model; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ZSystem.Model.t_Log model) { dal.Add(model); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private ZSystem.Model.t_Log GetModel(DbDataReader dr) { ZSystem.Model.t_Log model = new ZSystem.Model.t_Log(); PrepareModel(model, dr); return(model); }