1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5using System.Data.Common;
  6
  7using IFNuke;
  8
  9namespace IFNuke.Data
 10...{
 11    public abstract class DataProvider
 12    ...{
 13        // Provider constants - eliminates need for reflection later.
 14        private const string ProviderType = "data"; // Maps to <sectionGroup> in web.config.
 15        private const string ProviderNamespace = "IFNuke.Data"; // Project name space.
 16        private const string ProviderAssemblyName = "";  // Project assembly name.
 17
 18        // Singleton reference to the instantiated object.        
 19        private static DataProvider _provider = null;
 20        private static bool _isCreated = false;
 21        protected DataProvider()...{} 
 22                
 23        public static DataProvider Instance()
 24        ...{
 25            if (!_isCreated)
 26            ...{
 27                _provider = (DataProvider)IFNuke.Reflection.CreateObject(ProviderType);
 28                _isCreated = true;
 29            }
 30            return _provider;
 31        }
 32                
 33        protected static string GetTableName<T>()
 34        ...{
 35            T bo = Activator.CreateInstance<T>();
 36            string tableName = bo.GetType().GetField("TableName").GetValue(bo).ToString();
 37            bo = default(T);  // suppose to dispose the memory
 38            return tableName;
 39        }
 40
 41        protected static string GetIdName<T>()
 42        ...{
 43            T bo = Activator.CreateInstance<T>();
 44            string idName = bo.GetType().GetField("IdName").GetValue(bo).ToString();
 45            bo = default(T);  // suppose to dispose the memory
 46            return idName;
 47        }
 48       
 49        ExecuteNonQuery#region ExecuteNonQuery
 50
 51        public int ExecuteNonQuery(string sql)
 52        ...{
 53            return ExecuteNonQuery(CommandType.Text, sql, (CriteriaCollection)null);
 54        }
 55
 56        public int ExecuteNonQuery(string spName, CriteriaCollection parameters)
 57        ...{
 58            return ExecuteNonQuery(CommandType.StoredProcedure, spName, parameters);
 59        }        
 60
 61        public int ExecuteNonQuery(CommandType commandType, string commandText)
 62        ...{
 63            return ExecuteNonQuery(commandType, commandText, (CriteriaCollection)null);
 64        }
 65
 66        public abstract int ExecuteNonQuery(CommandType commandType, string commandText, CriteriaCollection parameters);
 67
 68        #endregion
 69
 70        ExecuteDataset#region ExecuteDataset
 71
 72        public  DataSet ExecuteDataSet(string sql)
 73        ...{
 74            return ExecuteDataSet( CommandType.Text, sql, (CriteriaCollection)null);
 75        }
 76
 77        public  DataSet ExecuteDataSet(string spName, CriteriaCollection parameters)
 78        ...{
 79            return ExecuteDataSet( CommandType.StoredProcedure, spName, parameters);
 80        }        
 81               
 82
 83        public  DataSet ExecuteDataSet(CommandType commandType, string commandText)
 84        ...{
 85            return ExecuteDataSet( commandType, commandText, (CriteriaCollection)null);
 86        }
 87
 88        public abstract DataSet ExecuteDataSet(CommandType commandType, string commandText, CriteriaCollection parameters);
 89           
 90
 91        public abstract DataSet ExecuteDataSet(CommandType commandType, string commandText, CriteriaCollection parameters, int pageSize, int pageNumber, out int totalRecord);
 92      
 93
 94        #endregion
 95
 96        ExecuteScalar#region ExecuteScalar
 97
 98        public  object ExecuteScalar(string sql)
 99        ...{
100            return ExecuteScalar( CommandType.Text, sql, (CriteriaCollection)null);
101        }
102
103        public  object ExecuteScalar(string spName, CriteriaCollection parameters)
104        ...{
105            return ExecuteScalar( CommandType.StoredProcedure, spName, parameters);
106        }
107               
108        public  object ExecuteScalar(CommandType commandType, string commandText)
109        ...{
110            return ExecuteScalar( commandType, commandText, (CriteriaCollection)null);
111        }
112
113        public abstract object ExecuteScalar(CommandType commandType, string commandText, CriteriaCollection parameters);
114
115        #endregion
116
117        ExecuteReader#region ExecuteReader
118
119        public IDataReader ExecuteReader(string sql)
120        ...{
121            return ExecuteReader(CommandType.Text, sql, (CriteriaCollection)null);
122        }
123
124        public IDataReader ExecuteReader(string spName, CriteriaCollection parameters)
125        ...{
126            return ExecuteReader(CommandType.StoredProcedure, spName, parameters);
127        }
128
129        public IDataReader ExecuteReader(CommandType commandType, string commandText)
130        ...{
131            return ExecuteReader(commandType, commandText, (CriteriaCollection)null);
132        }
133
134        public abstract IDataReader ExecuteReader(CommandType commandType, string commandText, CriteriaCollection parameters);
135
136        #endregion
137
138         public abstract T Select<T>(int id);
139
140         public abstract DataSet Select<T>(string spName, CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord);
141
142         public abstract List<T> SelectList<T>(string spName, CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord);
143
144        public int Save<T>(T t)
145        ...{
146            return Save<T>(t, "");
147        }
148
149        public abstract int Save<T>(T t, string spName);  
150
151        public abstract bool Delete<T>(int id);
152               
153        public Dictionary<string, string> GetNameValueList<T>(string idName, string textName)
154        ...{
155            string tableName = GetTableName<T>();
156            string sql = string.Format("select {0}, {1} from {2} order by {3}", idName, textName, tableName, textName);
157            DataTable dt = DataProvider.Instance().ExecuteDataSet(sql).Tables[0];
158            return DataProvider.ConvertTableToDictionary(dt);
159        }
160
161        public static Dictionary<string, string> ConvertTableToDictionary(DataTable dt)
162        ...{
163            Dictionary<string, string> dict = new Dictionary<string, string>();
164            foreach (DataRow dr in dt.Rows)
165                dict.Add(dr[1].ToString(), dr[0].ToString());
166            return dict;
167        }
168    }
169}
170