/// <summary> /// 根据条件获取一个实体对象 /// </summary> public MemcachedUpdateRuleEntity Select(string where) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "select * from MemcachedUpdateRule with(nolock) where " + where; cmd.CommandType = System.Data.CommandType.Text; DataSet ds = DB.ExecuteDataSet(cmd); if (ds.Tables[0].Rows.Count == 0) { return(null); } DataRow dr = ds.Tables[0].Rows[0]; return(MemcachedUpdateRuleEntity.CreateEntity(dr)); }
/// <summary> /// 根据主键获取一个实体对象 /// </summary> public MemcachedUpdateRuleEntity Select(int MemcachedUpdateRuleId) { DbCommand cmd = DB.DbProviderFactory.CreateCommand(); cmd.CommandText = "select * from MemcachedUpdateRule with(nolock) where MemcachedUpdateRuleId=@MemcachedUpdateRuleId"; cmd.CommandType = System.Data.CommandType.Text; DB.AddInParameter(cmd, "MemcachedUpdateRuleId", DbType.Int32, MemcachedUpdateRuleId); DataSet ds = DB.ExecuteDataSet(cmd); if (ds.Tables[0].Rows.Count == 0) { return(null); } DataRow dr = ds.Tables[0].Rows[0]; return(MemcachedUpdateRuleEntity.CreateEntity(dr)); }