/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ZSystem.Model.t_ChannelState model)
{
StringBuilder strSql;
DbParameter[] cmdParms;
PrepareUpdateCommand(model, out strSql, out cmdParms);
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
internal static void PrepareModel(ZSystem.Model.t_ChannelState model, DbDataReader dr)
{
model.iChID = GetInt(dr["iChID"]);
model.sChState = GetString(dr["sChState"]);
model.iChType = GetInt(dr["iChType"]);
model.sCaller = GetString(dr["sCaller"]);
model.sDTMF = GetString(dr["sDTMF"]);
model.iTimeElapse = GetInt(dr["iTimeElapse"]);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ZSystem.Model.t_ChannelState model)
{
int count = dal.Update(model);
if (EnableCache && count > 0)
{
RemoveModelCache(model.iChID);
}
}
public override bool Equals(object obj)
{
ZSystem.Model.t_ChannelState model = obj as ZSystem.Model.t_ChannelState;
if (model != null && model.iChID == this.iChID)
{
return(true);
}
return(false);
}
/// <summary>
/// 为新增一条数据准备参数
/// </summary>
internal static void PrepareAddCommand(ZSystem.Model.t_ChannelState model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("INSERT INTO t_ChannelState(");
strSql.Append("iChID, sChState, iChType, sCaller, sDTMF, iTimeElapse)");
strSql.Append(" VALUES (");
strSql.Append("@in_iChID, @in_sChState, @in_iChType, @in_sCaller, @in_sDTMF, @in_iTimeElapse)");
cmdParms = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID),
dbHelper.CreateInDbParameter("@in_sChState", DbType.String, model.sChState),
dbHelper.CreateInDbParameter("@in_iChType", DbType.Int32, model.iChType),
dbHelper.CreateInDbParameter("@in_sCaller", DbType.String, model.sCaller),
dbHelper.CreateInDbParameter("@in_sDTMF", DbType.String, model.sDTMF),
dbHelper.CreateInDbParameter("@in_iTimeElapse", DbType.Int32, model.iTimeElapse)
};
}
/// <summary>
/// 为更新一条数据准备参数
/// </summary>
internal static void PrepareUpdateCommand(ZSystem.Model.t_ChannelState model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("UPDATE t_ChannelState SET ");
strSql.Append("sChState=@in_sChState,");
strSql.Append("iChType=@in_iChType,");
strSql.Append("sCaller=@in_sCaller,");
strSql.Append("sDTMF=@in_sDTMF,");
strSql.Append("iTimeElapse=@in_iTimeElapse");
strSql.Append(" WHERE iChID=@in_iChID");
cmdParms = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_sChState", DbType.String, model.sChState),
dbHelper.CreateInDbParameter("@in_iChType", DbType.Int32, model.iChType),
dbHelper.CreateInDbParameter("@in_sCaller", DbType.String, model.sCaller),
dbHelper.CreateInDbParameter("@in_sDTMF", DbType.String, model.sDTMF),
dbHelper.CreateInDbParameter("@in_iTimeElapse", DbType.Int32, model.iTimeElapse),
dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID)
};
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZSystem.Model.t_ChannelState GetModel(int?iChID)
{
ZSystem.Model.t_ChannelState model = null;
if (!EnableCache)
{
model = dal.GetModel(iChID);
}
else
{
string key = iChID.ToString();
if (GetModelCache(key) != null)
{
model = (ZSystem.Model.t_ChannelState)GetModelCache(key);
}
else
{
model = dal.GetModel(iChID);
TryAddModelCache(key, model, null, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null);
}
}
return(model);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private ZSystem.Model.t_ChannelState GetModel(DbDataReader dr)
{
ZSystem.Model.t_ChannelState model = new ZSystem.Model.t_ChannelState();
PrepareModel(model, dr);
return model;
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private ZSystem.Model.t_ChannelState GetModel(DbDataReader dr)
{
ZSystem.Model.t_ChannelState model = new ZSystem.Model.t_ChannelState();
PrepareModel(model, dr);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ZSystem.Model.t_ChannelState model)
{
dal.Add(model);
}