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