ObjectDataSource.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435
  1. //
  2. // System.Web.UI.WebControls.ObjectDataSource
  3. //
  4. // Authors:
  5. // Lluis Sanchez Gual ([email protected])
  6. //
  7. // (C) 2005 Novell, Inc. (http://www.novell.com)
  8. //
  9. //
  10. // Permission is hereby granted, free of charge, to any person obtaining
  11. // a copy of this software and associated documentation files (the
  12. // "Software"), to deal in the Software without restriction, including
  13. // without limitation the rights to use, copy, modify, merge, publish,
  14. // distribute, sublicense, and/or sell copies of the Software, and to
  15. // permit persons to whom the Software is furnished to do so, subject to
  16. // the following conditions:
  17. //
  18. // The above copyright notice and this permission notice shall be
  19. // included in all copies or substantial portions of the Software.
  20. //
  21. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  22. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  23. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  24. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  25. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  26. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  27. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  28. //
  29. #if NET_2_0
  30. using System.Collections;
  31. using System.Collections.Specialized;
  32. using System.ComponentModel;
  33. using System.IO;
  34. using System.Security.Permissions;
  35. using System.Drawing;
  36. namespace System.Web.UI.WebControls
  37. {
  38. [DefaultEventAttribute ("Selecting")]
  39. [DefaultPropertyAttribute ("TypeName")]
  40. [DesignerAttribute ("System.Web.UI.Design.WebControls.ObjectDataSourceDesigner, " + Consts.AssemblySystem_Design, "System.ComponentModel.Design.IDesigner")]
  41. [ParseChildrenAttribute (true)]
  42. [PersistChildrenAttribute (false)]
  43. [AspNetHostingPermissionAttribute (SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
  44. [AspNetHostingPermissionAttribute (SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
  45. [ToolboxBitmap ("bitmap file goes here")]
  46. public class ObjectDataSource : DataSourceControl
  47. {
  48. static readonly string [] emptyNames = new string [] { "DefaultView" };
  49. ObjectDataSourceView defaultView;
  50. int cacheDuration = 0;
  51. bool enableCaching = false;
  52. string cacheKeyDependency = null;
  53. string sqlCacheDependency = null;
  54. DataSourceCacheManager cache = null;
  55. DataSourceCacheExpiry cacheExpirationPolicy = DataSourceCacheExpiry.Absolute;
  56. public ObjectDataSource ()
  57. {
  58. }
  59. public ObjectDataSource (string typeName, string selectMethod)
  60. {
  61. SelectMethod = selectMethod;
  62. TypeName = typeName;
  63. }
  64. ObjectDataSourceView DefaultView {
  65. get {
  66. if (defaultView == null) {
  67. defaultView = new ObjectDataSourceView (this, emptyNames [0], Context);
  68. if (IsTrackingViewState)
  69. ((IStateManager) defaultView).TrackViewState ();
  70. }
  71. return defaultView;
  72. }
  73. }
  74. public event ObjectDataSourceStatusEventHandler Deleted {
  75. add { DefaultView.Deleted += value; }
  76. remove { DefaultView.Deleted -= value; }
  77. }
  78. public event ObjectDataSourceMethodEventHandler Deleting {
  79. add { DefaultView.Deleting += value; }
  80. remove { DefaultView.Deleting -= value; }
  81. }
  82. public event ObjectDataSourceFilteringEventHandler Filtering {
  83. add { DefaultView.Filtering += value; }
  84. remove { DefaultView.Filtering -= value; }
  85. }
  86. public event ObjectDataSourceStatusEventHandler Inserted {
  87. add { DefaultView.Inserted += value; }
  88. remove { DefaultView.Inserted -= value; }
  89. }
  90. public event ObjectDataSourceMethodEventHandler Inserting {
  91. add { DefaultView.Inserting += value; }
  92. remove { DefaultView.Inserting -= value; }
  93. }
  94. public event ObjectDataSourceObjectEventHandler ObjectCreated {
  95. add { DefaultView.ObjectCreated += value; }
  96. remove { DefaultView.ObjectCreated -= value; }
  97. }
  98. public event ObjectDataSourceObjectEventHandler ObjectCreating {
  99. add { DefaultView.ObjectCreating += value; }
  100. remove { DefaultView.ObjectCreating -= value; }
  101. }
  102. public event ObjectDataSourceDisposingEventHandler ObjectDisposing {
  103. add { DefaultView.ObjectDisposing += value; }
  104. remove { DefaultView.ObjectDisposing -= value; }
  105. }
  106. /* public event ObjectDataSourceResolvingMethodEventHandler ResolvingMethod {
  107. add { DefaultView.ResolvingMethod += value; }
  108. remove { DefaultView.ResolvingMethod -= value; }
  109. }
  110. */
  111. public event ObjectDataSourceStatusEventHandler Selected {
  112. add { DefaultView.Selected += value; }
  113. remove { DefaultView.Selected -= value; }
  114. }
  115. public event ObjectDataSourceSelectingEventHandler Selecting {
  116. add { DefaultView.Selecting += value; }
  117. remove { DefaultView.Selecting -= value; }
  118. }
  119. public event ObjectDataSourceStatusEventHandler Updated {
  120. add { DefaultView.Updated += value; }
  121. remove { DefaultView.Updated -= value; }
  122. }
  123. public event ObjectDataSourceMethodEventHandler Updating {
  124. add { DefaultView.Updating += value; }
  125. remove { DefaultView.Updating -= value; }
  126. }
  127. [DefaultValue (0)]
  128. [TypeConverter ("System.Web.UI.DataSourceCacheDurationConverter, " + Consts.AssemblySystem_Web)]
  129. public virtual int CacheDuration
  130. {
  131. get {
  132. return cacheDuration;
  133. }
  134. set {
  135. if (value < 0)
  136. throw new ArgumentOutOfRangeException ("value", "The duration must be non-negative");
  137. cacheDuration = value;
  138. }
  139. }
  140. [DefaultValue (DataSourceCacheExpiry.Absolute)]
  141. public virtual DataSourceCacheExpiry CacheExpirationPolicy
  142. {
  143. get {
  144. return cacheExpirationPolicy;
  145. }
  146. set {
  147. cacheExpirationPolicy = value;
  148. }
  149. }
  150. [DefaultValue ("")]
  151. public virtual string CacheKeyDependency
  152. {
  153. get {
  154. return cacheKeyDependency != null ? cacheKeyDependency : string.Empty;
  155. }
  156. set {
  157. cacheKeyDependency = value;
  158. }
  159. }
  160. [WebCategoryAttribute ("Data")]
  161. [DefaultValueAttribute (ConflictOptions.OverwriteChanges)]
  162. public ConflictOptions ConflictDetection {
  163. get { return DefaultView.ConflictDetection; }
  164. set { DefaultView.ConflictDetection = value; }
  165. }
  166. [DefaultValue (false)]
  167. public bool ConvertNullToDBNull
  168. {
  169. get {
  170. return DefaultView.ConvertNullToDBNull;
  171. }
  172. set {
  173. DefaultView.ConvertNullToDBNull = value;
  174. }
  175. }
  176. [WebCategoryAttribute ("Data")]
  177. [DefaultValueAttribute ("")]
  178. public string DataObjectTypeName {
  179. get { return DefaultView.DataObjectTypeName; }
  180. set { DefaultView.DataObjectTypeName = value; }
  181. }
  182. [WebCategoryAttribute ("Data")]
  183. [DefaultValueAttribute ("")]
  184. public string DeleteMethod {
  185. get { return DefaultView.DeleteMethod; }
  186. set { DefaultView.DeleteMethod = value; }
  187. }
  188. [WebCategoryAttribute ("Data")]
  189. [MergablePropertyAttribute (false)]
  190. [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
  191. [DefaultValueAttribute (null)]
  192. [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
  193. public ParameterCollection DeleteParameters {
  194. get { return DefaultView.DeleteParameters; }
  195. }
  196. [DefaultValue (false)]
  197. public virtual bool EnableCaching {
  198. get { return enableCaching; }
  199. set { enableCaching = value; }
  200. }
  201. [WebCategoryAttribute ("Paging")]
  202. [DefaultValueAttribute (false)]
  203. public bool EnablePaging {
  204. get { return DefaultView.EnablePaging; }
  205. set { DefaultView.EnablePaging = value; }
  206. }
  207. [WebCategoryAttribute ("Data")]
  208. [DefaultValueAttribute ("")]
  209. public string FilterExpression {
  210. get { return DefaultView.FilterExpression; }
  211. set { DefaultView.FilterExpression = value; }
  212. }
  213. [WebCategoryAttribute ("Data")]
  214. [MergablePropertyAttribute (false)]
  215. [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
  216. [DefaultValueAttribute (null)]
  217. [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
  218. public ParameterCollection FilterParameters {
  219. get { return DefaultView.FilterParameters; }
  220. }
  221. [DefaultValueAttribute ("")]
  222. [WebCategoryAttribute ("Data")]
  223. public string InsertMethod {
  224. get { return DefaultView.InsertMethod; }
  225. set { DefaultView.InsertMethod = value; }
  226. }
  227. [WebCategoryAttribute ("Data")]
  228. [MergablePropertyAttribute (false)]
  229. [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
  230. [DefaultValueAttribute (null)]
  231. [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
  232. public ParameterCollection InsertParameters {
  233. get { return DefaultView.InsertParameters; }
  234. }
  235. [WebCategoryAttribute ("Paging")]
  236. [DefaultValueAttribute ("maximumRows")]
  237. public string MaximumRowsParameterName {
  238. get { return DefaultView.MaximumRowsParameterName; }
  239. set { DefaultView.MaximumRowsParameterName = value; }
  240. }
  241. [WebCategoryAttribute ("Data")]
  242. [DefaultValueAttribute ("{0}")]
  243. public string OldValuesParameterFormatString {
  244. get { return DefaultView.OldValuesParameterFormatString; }
  245. set { DefaultView.OldValuesParameterFormatString = value; }
  246. }
  247. [WebCategoryAttribute ("Paging")]
  248. [DefaultValueAttribute ("")]
  249. public string SelectCountMethod {
  250. get { return DefaultView.SelectCountMethod; }
  251. set { DefaultView.SelectCountMethod = value; }
  252. }
  253. [DefaultValueAttribute ("")]
  254. [WebCategoryAttribute ("Data")]
  255. public string SelectMethod {
  256. get { return DefaultView.SelectMethod; }
  257. set { DefaultView.SelectMethod = value; }
  258. }
  259. [WebCategoryAttribute ("Data")]
  260. [MergablePropertyAttribute (false)]
  261. [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
  262. [DefaultValueAttribute (null)]
  263. [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
  264. public ParameterCollection SelectParameters {
  265. get { return DefaultView.SelectParameters; }
  266. }
  267. [DefaultValueAttribute ("")]
  268. [WebCategoryAttribute ("Data")]
  269. public string SortParameterName {
  270. get { return DefaultView.SortParameterName; }
  271. set { DefaultView.SortParameterName = value; }
  272. }
  273. [MonoTODO ("SQLServer specific")]
  274. [DefaultValue ("")]
  275. public virtual string SqlCacheDependency {
  276. get { return sqlCacheDependency != null ? sqlCacheDependency : string.Empty; }
  277. set { sqlCacheDependency = value; }
  278. }
  279. [WebCategoryAttribute ("Paging")]
  280. [DefaultValueAttribute ("startRowIndex")]
  281. public string StartRowIndexParameterName {
  282. get { return DefaultView.StartRowIndexParameterName; }
  283. set { DefaultView.StartRowIndexParameterName = value; }
  284. }
  285. [DefaultValueAttribute ("")]
  286. [WebCategoryAttribute ("Data")]
  287. public string TypeName {
  288. get { return DefaultView.TypeName; }
  289. set { DefaultView.TypeName = value; }
  290. }
  291. [DefaultValueAttribute ("")]
  292. [WebCategoryAttribute ("Data")]
  293. public string UpdateMethod {
  294. get { return DefaultView.UpdateMethod; }
  295. set { DefaultView.UpdateMethod = value; }
  296. }
  297. [WebCategoryAttribute ("Data")]
  298. [MergablePropertyAttribute (false)]
  299. [EditorAttribute ("System.Web.UI.Design.WebControls.ParameterCollectionEditor, " + Consts.AssemblySystem_Design, "System.Drawing.Design.UITypeEditor, " + Consts.AssemblySystem_Drawing)]
  300. [DefaultValueAttribute (null)]
  301. [PersistenceModeAttribute (PersistenceMode.InnerProperty)]
  302. public ParameterCollection UpdateParameters {
  303. get { return DefaultView.UpdateParameters; }
  304. }
  305. internal DataSourceCacheManager Cache {
  306. get {
  307. if (cache == null)
  308. cache = new DataSourceCacheManager (CacheDuration, CacheKeyDependency, CacheExpirationPolicy, this, Context);
  309. return cache;
  310. }
  311. }
  312. protected override DataSourceView GetView (string viewName)
  313. {
  314. if (viewName == null)
  315. throw new ArgumentException ("viewName");
  316. return DefaultView;
  317. }
  318. protected override ICollection GetViewNames ()
  319. {
  320. return emptyNames;
  321. }
  322. public IEnumerable Select ()
  323. {
  324. return DefaultView.Select (DataSourceSelectArguments.Empty);
  325. }
  326. public int Update ()
  327. {
  328. Hashtable empty = new Hashtable ();
  329. return DefaultView.Update (empty, empty, null);
  330. }
  331. public int Delete ()
  332. {
  333. Hashtable empty = new Hashtable ();
  334. return DefaultView.Delete (empty, null);
  335. }
  336. public int Insert ()
  337. {
  338. Hashtable empty = new Hashtable ();
  339. return DefaultView.Insert (empty);
  340. }
  341. protected internal override void OnInit (EventArgs e)
  342. {
  343. Page.LoadComplete += OnPageLoadComplete;
  344. }
  345. void OnPageLoadComplete (object sender, EventArgs e)
  346. {
  347. FilterParameters.UpdateValues (Context, this);
  348. SelectParameters.UpdateValues (Context, this);
  349. }
  350. protected override void LoadViewState (object savedState)
  351. {
  352. if (savedState == null) {
  353. base.LoadViewState (null);
  354. ((IStateManager)DefaultView).LoadViewState (null);
  355. } else {
  356. Pair p = (Pair) savedState;
  357. base.LoadViewState (p.First);
  358. ((IStateManager)DefaultView).LoadViewState (p.Second);
  359. }
  360. }
  361. protected override object SaveViewState()
  362. {
  363. object baseState = base.SaveViewState ();
  364. object viewState = ((IStateManager)DefaultView).SaveViewState ();
  365. if (baseState != null || viewState != null) return new Pair (baseState, viewState);
  366. else return null;
  367. }
  368. protected override void TrackViewState()
  369. {
  370. ((IStateManager)DefaultView).TrackViewState ();
  371. }
  372. }
  373. }
  374. #endif