/// <summary>
/// 为更新一条数据准备参数
/// </summary>
internal static void PrepareUpdateCommand(ZSystem.Model.t_IVRControl model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("UPDATE t_IVRControl SET ");
strSql.Append("sFileName=@in_sFileName,");
strSql.Append("iKeyNum=@in_iKeyNum,");
strSql.Append("SubID=@in_SubID,");
strSql.Append("sIVRName=@in_sIVRName,");
strSql.Append("IsEnable=@in_IsEnable,");
strSql.Append("BeginDate=@in_BeginDate,");
strSql.Append("EndDate=@in_EndDate,");
strSql.Append("LastUpdate=@in_LastUpdate");
strSql.Append(" WHERE KeyID=@in_KeyID");
cmdParms = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_sFileName", DbType.String, model.sFileName),
dbHelper.CreateInDbParameter("@in_iKeyNum", DbType.Int32, model.iKeyNum),
dbHelper.CreateInDbParameter("@in_SubID", DbType.String, model.SubID),
dbHelper.CreateInDbParameter("@in_sIVRName", DbType.String, model.sIVRName),
dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable),
dbHelper.CreateInDbParameter("@in_BeginDate", DbType.DateTime, model.BeginDate),
dbHelper.CreateInDbParameter("@in_EndDate", DbType.DateTime, model.EndDate),
dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate),
dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID)
};
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ZSystem.Model.t_IVRControl model)
{
StringBuilder strSql;
DbParameter[] cmdParms;
PrepareUpdateCommand(model, out strSql, out cmdParms);
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ZSystem.Model.t_IVRControl model)
{
int count = dal.Update(model);
if (EnableCache && count > 0)
{
RemoveModelCache(model.KeyID);
}
}
public override bool Equals(object obj)
{
ZSystem.Model.t_IVRControl model = obj as ZSystem.Model.t_IVRControl;
if (model != null && model.KeyID == this.KeyID)
{
return(true);
}
return(false);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
internal static void PrepareModel(ZSystem.Model.t_IVRControl model, DbDataReader dr)
{
model.KeyID = GetString(dr["KeyID"]);
model.sFileName = GetString(dr["sFileName"]);
model.iKeyNum = GetInt(dr["iKeyNum"]);
model.SubID = GetString(dr["SubID"]);
model.sIVRName = GetString(dr["sIVRName"]);
model.IsEnable = GetBool(dr["IsEnable"]);
model.BeginDate = GetDateTime(dr["BeginDate"]);
model.EndDate = GetDateTime(dr["EndDate"]);
model.LastUpdate = GetDateTime(dr["LastUpdate"]);
}
/// <summary>
/// 为新增一条数据准备参数
/// </summary>
internal static void PrepareAddCommand(ZSystem.Model.t_IVRControl model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("INSERT INTO t_IVRControl(");
strSql.Append("KeyID, sFileName, iKeyNum, SubID, sIVRName, IsEnable, BeginDate, EndDate, LastUpdate)");
strSql.Append(" VALUES (");
strSql.Append("@in_KeyID, @in_sFileName, @in_iKeyNum, @in_SubID, @in_sIVRName, @in_IsEnable, @in_BeginDate, @in_EndDate, @in_LastUpdate)");
cmdParms = new DbParameter[] {
dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID),
dbHelper.CreateInDbParameter("@in_sFileName", DbType.String, model.sFileName),
dbHelper.CreateInDbParameter("@in_iKeyNum", DbType.Int32, model.iKeyNum),
dbHelper.CreateInDbParameter("@in_SubID", DbType.String, model.SubID),
dbHelper.CreateInDbParameter("@in_sIVRName", DbType.String, model.sIVRName),
dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable),
dbHelper.CreateInDbParameter("@in_BeginDate", DbType.DateTime, model.BeginDate),
dbHelper.CreateInDbParameter("@in_EndDate", DbType.DateTime, model.EndDate),
dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate)
};
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZSystem.Model.t_IVRControl GetModel(string KeyID)
{
ZSystem.Model.t_IVRControl model = null;
if (!EnableCache)
{
model = dal.GetModel(KeyID);
}
else
{
string key = KeyID.ToString();
if (GetModelCache(key) != null)
{
model = (ZSystem.Model.t_IVRControl)GetModelCache(key);
}
else
{
model = dal.GetModel(KeyID);
TryAddModelCache(key, model, null, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null);
}
}
return(model);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private ZSystem.Model.t_IVRControl GetModel(DbDataReader dr)
{
ZSystem.Model.t_IVRControl model = new ZSystem.Model.t_IVRControl();
PrepareModel(model, dr);
return model;
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private ZSystem.Model.t_IVRControl GetModel(DbDataReader dr)
{
ZSystem.Model.t_IVRControl model = new ZSystem.Model.t_IVRControl();
PrepareModel(model, dr);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ZSystem.Model.t_IVRControl model)
{
dal.Add(model);
}
