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