/// <summary> /// 增加一条数据 /// </summary> public int Add(ZSystem.Model.t_Authorization model) { StringBuilder strSql; DbParameter[] cmdParms; PrepareAddCommand(model, out strSql, out cmdParms); return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms)); }
public override bool Equals(object obj) { ZSystem.Model.t_Authorization model = obj as ZSystem.Model.t_Authorization; if (model != null && model.UserID == this.UserID && model.iUserLevel == this.iUserLevel) { return(true); } return(false); }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Authorization model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_Authorization("); strSql.Append("UserID, iUserLevel)"); strSql.Append(" VALUES ("); strSql.Append("@in_UserID, @in_iUserLevel)"); cmdParms = new DbParameter[] { dbHelper.CreateInDbParameter("@in_UserID", DbType.String, model.UserID), dbHelper.CreateInDbParameter("@in_iUserLevel", DbType.Int32, model.iUserLevel) }; }
/// <summary> /// 得到一个对象实体 /// </summary> public ZSystem.Model.t_Authorization GetModel(string UserID, int?iUserLevel) { ZSystem.Model.t_Authorization model = null; if (!EnableCache) { model = dal.GetModel(UserID, iUserLevel); } else { string key = UserID.ToString() + "_" + iUserLevel.ToString(); if (GetModelCache(key) != null) { model = (ZSystem.Model.t_Authorization)GetModelCache(key); } else { model = dal.GetModel(UserID, iUserLevel); TryAddModelCache(key, model, null, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null); } } return(model); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private ZSystem.Model.t_Authorization GetModel(DbDataReader dr) { ZSystem.Model.t_Authorization model = new ZSystem.Model.t_Authorization(); PrepareModel(model, dr); return(model); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private ZSystem.Model.t_Authorization GetModel(DbDataReader dr) { ZSystem.Model.t_Authorization model = new ZSystem.Model.t_Authorization(); PrepareModel(model, dr); return model; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ZSystem.Model.t_Authorization model) { dal.Add(model); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> internal static void PrepareModel(ZSystem.Model.t_Authorization model, DbDataReader dr) { model.UserID = GetString(dr["UserID"]); model.iUserLevel = GetInt(dr["iUserLevel"]); }