| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435 |
- //
- // System.Web.UI.WebControls.ObjectDataSource
- //
- // Authors:
- // Lluis Sanchez Gual ([email protected])
- //
- // (C) 2005 Novell, Inc. (http://www.novell.com)
- //
- //
- // Permission is hereby granted, free of charge, to any person obtaining
- // a copy of this software and associated documentation files (the
- // "Software"), to deal in the Software without restriction, including
- // without limitation the rights to use, copy, modify, merge, publish,
- // distribute, sublicense, and/or sell copies of the Software, and to
- // permit persons to whom the Software is furnished to do so, subject to
- // the following conditions:
- //
- // The above copyright notice and this permission notice shall be
- // included in all copies or substantial portions of the Software.
- //
- // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
- // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
- // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
- // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
- // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
- // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
- // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
- //
- #if NET_2_0
- using System.Collections;
- using System.Collections.Specialized;
- using System.ComponentModel;
- using System.IO;
- using System.Security.Permissions;
- using System.Drawing;
- namespace System.Web.UI.WebControls
- {
-
- [DefaultEventAttribute ("Selecting")]
- [DefaultPropertyAttribute ("TypeName")]
- [DesignerAttribute ("System.Web.UI.Design.WebControls.ObjectDataSourceDesigner, " + Consts.AssemblySystem_Design, "System.ComponentModel.Design.IDesigner")]
- [ParseChildrenAttribute (true)]
- [PersistChildrenAttribute (false)]
- [AspNetHostingPermissionAttribute (SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
- [AspNetHostingPermissionAttribute (SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
- [ToolboxBitmap ("bitmap file goes here")]
- public class ObjectDataSource : DataSourceControl
- {
- static readonly string [] emptyNames = new string [] { "DefaultView" };
- ObjectDataSourceView defaultView;
-
- int cacheDuration = 0;
- bool enableCaching = false;
- string cacheKeyDependency = null;
- string sqlCacheDependency = null;
- DataSourceCacheManager cache = null;
- DataSourceCacheExpiry cacheExpirationPolicy = DataSourceCacheExpiry.Absolute;
- public ObjectDataSource ()
- {
- }
-
- public ObjectDataSource (string typeName, string selectMethod)
- {
- SelectMethod = selectMethod;
- TypeName = typeName;
- }
-
- ObjectDataSourceView DefaultView {
- get {
- if (defaultView == null) {
- defaultView = new ObjectDataSourceView (this, emptyNames [0], Context);
- if (IsTrackingViewState)
- ((IStateManager) defaultView).TrackViewState ();
- }
- return defaultView;
- }
- }
-
- public event ObjectDataSourceStatusEventHandler Deleted {
- add { DefaultView.Deleted += value; }
- remove { DefaultView.Deleted -= value; }
- }
-
- public event ObjectDataSourceMethodEventHandler Deleting {
- add { DefaultView.Deleting += value; }
- remove { DefaultView.Deleting -= value; }
- }
-
- public event ObjectDataSourceFilteringEventHandler Filtering {
- add { DefaultView.Filtering += value; }
- remove { DefaultView.Filtering -= value; }
- }
-
- public event ObjectDataSourceStatusEventHandler Inserted {
- add { DefaultView.Inserted += value; }
- remove { DefaultView.Inserted -= value; }
- }
-
- public event ObjectDataSourceMethodEventHandler Inserting {
- add { DefaultView.Inserting += value; }
- remove { DefaultView.Inserting -= value; }
- }
-
- public event ObjectDataSourceObjectEventHandler ObjectCreated {
- add { DefaultView.ObjectCreated += value; }
- remove { DefaultView.ObjectCreated -= value; }
- }
-
- public event ObjectDataSourceObjectEventHandler ObjectCreating {
- add { DefaultView.ObjectCreating += value; }
- remove { DefaultView.ObjectCreating -= value; }
- }
-
- public event ObjectDataSourceDisposingEventHandler ObjectDisposing {
- add { DefaultView.ObjectDisposing += value; }
- remove { DefaultView.ObjectDisposing -= value; }
- }
-
- /* public event ObjectDataSourceResolvingMethodEventHandler ResolvingMethod {
- add { DefaultView.ResolvingMethod += value; }
- remove { DefaultView.ResolvingMethod -= value; }
- }
- */
- public event ObjectDataSourceStatusEventHandler Selected {
- add { DefaultView.Selected += value; }
- remove { DefaultView.Selected -= value; }
- }
-
- public event ObjectDataSourceSelectingEventHandler Selecting {
- add { DefaultView.Selecting += value; }
- remove { DefaultView.Selecting -= value; }
- }
-
- public event ObjectDataSourceStatusEventHandler Updated {
- add { DefaultView.Updated += value; }
- remove { DefaultView.Updated -= value; }
- }
-
- public event ObjectDataSourceMethodEventHandler Updating {
- add { DefaultView.Updating += value; }
- remove { DefaultView.Updating -= value; }
- }
- [DefaultValue (0)]
- [TypeConverter ("System.Web.UI.DataSourceCacheDurationConverter, " + Consts.AssemblySystem_Web)]
- public virtual int CacheDuration
- {
- get {
- return cacheDuration;
- }
- set {
- if (value < 0)
- throw new ArgumentOutOfRangeException ("value", "The duration must be non-negative");
- cacheDuration = value;
- }
- }
- [DefaultValue (DataSourceCacheExpiry.Absolute)]
- public virtual DataSourceCacheExpiry CacheExpirationPolicy
- {
- get {
- return cacheExpirationPolicy;
- }
- set {
- cacheExpirationPolicy = value;
- }
- }
- [DefaultValue ("")]
- public virtual string CacheKeyDependency
- {
- get {
- return cacheKeyDependency != null ? cacheKeyDependency : string.Empty;
- }
- set {
- cacheKeyDependency = value;
- }
- }
-
- [WebCategoryAttribute ("Data")]
- [DefaultValueAttribute (ConflictOptions.OverwriteChanges)]
- public ConflictOptions ConflictDetection {
- get { return DefaultView.ConflictDetection; }
- set { DefaultView.ConflictDetection = value; }
- }
- [DefaultValue (false)]
- public bool ConvertNullToDBNull
- {
- get {
- return DefaultView.ConvertNullToDBNull;
- }
- set {
- DefaultView.ConvertNullToDBNull = value;
- }
- }
-
- [WebCategoryAttribute ("Data")]
- [DefaultValueAttribute ("")]
- public string DataObjectTypeName {
- get { return DefaultView.DataObjectTypeName; }
- set { DefaultView.DataObjectTypeName = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [DefaultValueAttribute ("")]
- public string DeleteMethod {
- get { return DefaultView.DeleteMethod; }
- set { DefaultView.DeleteMethod = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [MergablePropertyAttribute (false)]
- [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
- [DefaultValueAttribute (null)]
- [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
- public ParameterCollection DeleteParameters {
- get { return DefaultView.DeleteParameters; }
- }
- [DefaultValue (false)]
- public virtual bool EnableCaching {
- get { return enableCaching; }
- set { enableCaching = value; }
- }
-
- [WebCategoryAttribute ("Paging")]
- [DefaultValueAttribute (false)]
- public bool EnablePaging {
- get { return DefaultView.EnablePaging; }
- set { DefaultView.EnablePaging = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [DefaultValueAttribute ("")]
- public string FilterExpression {
- get { return DefaultView.FilterExpression; }
- set { DefaultView.FilterExpression = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [MergablePropertyAttribute (false)]
- [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
- [DefaultValueAttribute (null)]
- [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
- public ParameterCollection FilterParameters {
- get { return DefaultView.FilterParameters; }
- }
-
- [DefaultValueAttribute ("")]
- [WebCategoryAttribute ("Data")]
- public string InsertMethod {
- get { return DefaultView.InsertMethod; }
- set { DefaultView.InsertMethod = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [MergablePropertyAttribute (false)]
- [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
- [DefaultValueAttribute (null)]
- [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
- public ParameterCollection InsertParameters {
- get { return DefaultView.InsertParameters; }
- }
-
- [WebCategoryAttribute ("Paging")]
- [DefaultValueAttribute ("maximumRows")]
- public string MaximumRowsParameterName {
- get { return DefaultView.MaximumRowsParameterName; }
- set { DefaultView.MaximumRowsParameterName = value; }
- }
- [WebCategoryAttribute ("Data")]
- [DefaultValueAttribute ("{0}")]
- public string OldValuesParameterFormatString {
- get { return DefaultView.OldValuesParameterFormatString; }
- set { DefaultView.OldValuesParameterFormatString = value; }
- }
-
- [WebCategoryAttribute ("Paging")]
- [DefaultValueAttribute ("")]
- public string SelectCountMethod {
- get { return DefaultView.SelectCountMethod; }
- set { DefaultView.SelectCountMethod = value; }
- }
-
- [DefaultValueAttribute ("")]
- [WebCategoryAttribute ("Data")]
- public string SelectMethod {
- get { return DefaultView.SelectMethod; }
- set { DefaultView.SelectMethod = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [MergablePropertyAttribute (false)]
- [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
- [DefaultValueAttribute (null)]
- [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
- public ParameterCollection SelectParameters {
- get { return DefaultView.SelectParameters; }
- }
- [DefaultValueAttribute ("")]
- [WebCategoryAttribute ("Data")]
- public string SortParameterName {
- get { return DefaultView.SortParameterName; }
- set { DefaultView.SortParameterName = value; }
- }
- [MonoTODO ("SQLServer specific")]
- [DefaultValue ("")]
- public virtual string SqlCacheDependency {
- get { return sqlCacheDependency != null ? sqlCacheDependency : string.Empty; }
- set { sqlCacheDependency = value; }
- }
-
- [WebCategoryAttribute ("Paging")]
- [DefaultValueAttribute ("startRowIndex")]
- public string StartRowIndexParameterName {
- get { return DefaultView.StartRowIndexParameterName; }
- set { DefaultView.StartRowIndexParameterName = value; }
- }
-
- [DefaultValueAttribute ("")]
- [WebCategoryAttribute ("Data")]
- public string TypeName {
- get { return DefaultView.TypeName; }
- set { DefaultView.TypeName = value; }
- }
-
- [DefaultValueAttribute ("")]
- [WebCategoryAttribute ("Data")]
- public string UpdateMethod {
- get { return DefaultView.UpdateMethod; }
- set { DefaultView.UpdateMethod = value; }
- }
-
- [WebCategoryAttribute ("Data")]
- [MergablePropertyAttribute (false)]
- [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
- [DefaultValueAttribute (null)]
- [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
- public ParameterCollection UpdateParameters {
- get { return DefaultView.UpdateParameters; }
- }
- internal DataSourceCacheManager Cache {
- get {
- if (cache == null)
- cache = new DataSourceCacheManager (CacheDuration, CacheKeyDependency, CacheExpirationPolicy, this, Context);
- return cache;
- }
- }
- protected override DataSourceView GetView (string viewName)
- {
- if (viewName == null)
- throw new ArgumentException ("viewName");
- return DefaultView;
- }
-
- protected override ICollection GetViewNames ()
- {
- return emptyNames;
- }
-
- public IEnumerable Select ()
- {
- return DefaultView.Select (DataSourceSelectArguments.Empty);
- }
-
- public int Update ()
- {
- Hashtable empty = new Hashtable ();
- return DefaultView.Update (empty, empty, null);
- }
- public int Delete ()
- {
- Hashtable empty = new Hashtable ();
- return DefaultView.Delete (empty, null);
- }
-
- public int Insert ()
- {
- Hashtable empty = new Hashtable ();
- return DefaultView.Insert (empty);
- }
-
- protected internal override void OnInit (EventArgs e)
- {
- Page.LoadComplete += OnPageLoadComplete;
- }
-
- void OnPageLoadComplete (object sender, EventArgs e)
- {
- FilterParameters.UpdateValues (Context, this);
- SelectParameters.UpdateValues (Context, this);
- }
-
- protected override void LoadViewState (object savedState)
- {
- if (savedState == null) {
- base.LoadViewState (null);
- ((IStateManager)DefaultView).LoadViewState (null);
- } else {
- Pair p = (Pair) savedState;
- base.LoadViewState (p.First);
- ((IStateManager)DefaultView).LoadViewState (p.Second);
- }
- }
- protected override object SaveViewState()
- {
- object baseState = base.SaveViewState ();
- object viewState = ((IStateManager)DefaultView).SaveViewState ();
- if (baseState != null || viewState != null) return new Pair (baseState, viewState);
- else return null;
- }
- protected override void TrackViewState()
- {
- ((IStateManager)DefaultView).TrackViewState ();
- }
- }
- }
- #endif
|