/// <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"]);
}
