1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5
  6using IFNuke;
  7
  8namespace IFNuke.Data
  9...{
 10    [Serializable()]
 11    public class BusinessBase<T>
 12      where T : BusinessBase<T>
 13    ...{
 14        private static readonly string TableName_Select = "TableName_Select";
 15
 16        Select#region Select
 17
 18        public static T Select(int id)
 19        ...{
 20            return DataProvider.Instance().Select<T>(id);
 21        }
 22
 23        // ---------- select dataset ---------------//
 24        public static DataSet Select()
 25        ...{
 26            int totalRecord = 0;
 27            return Select(TableName_Select, (CriteriaCollection)null, 0, 0, out totalRecord);
 28        }
 29
 30        public static DataSet Select(CriteriaCollection parameters)
 31        ...{
 32            int totalRecord = 0;
 33            return Select(TableName_Select, parameters, 0, 0, out totalRecord);
 34        }
 35
 36        public static DataSet Select(string spName, CriteriaCollection parameters)
 37        ...{
 38            int totalRecord = 0;
 39            return Select(spName, parameters, 0, 0, out totalRecord);
 40        }
 41
 42        public static DataSet Select(CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord)
 43        ...{
 44            return Select(TableName_Select, parameters, pageIndex, pageSize, out totalRecord);
 45        }
 46
 47        public static DataSet Select(string spName, CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord)
 48        ...{
 49            return DataProvider.Instance().Select<T>(spName, parameters, pageIndex, pageSize, out totalRecord);
 50        }
 51
 52        // ----------- select BOCollection --------------- //
 53        public static List<T> SelectList()
 54        ...{
 55            int totalRecord = 0;
 56            return DataProvider.Instance().SelectList<T>(TableName_Select, (CriteriaCollection)null, 0, 0, out totalRecord);
 57        }
 58
 59        public static List<T> SelectList(CriteriaCollection parameters)
 60        ...{
 61            int totalRecord = 0;
 62            return DataProvider.Instance().SelectList<T>(TableName_Select, parameters, 0, 0, out totalRecord);
 63        }
 64
 65        public static List<T> SelectList(string spName, CriteriaCollection parameters)
 66        ...{
 67            int totalRecord = 0;
 68            return DataProvider.Instance().SelectList<T>(spName, parameters, 0, 0, out totalRecord);
 69        }
 70
 71        public static List<T> SelectList(CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord)
 72        ...{
 73            return DataProvider.Instance().SelectList<T>(TableName_Select, parameters, pageIndex, pageSize, out totalRecord);
 74        }
 75
 76        public static List<T> SelectList(string spName, CriteriaCollection parameters, int pageIndex, int pageSize, out int totalRecord)
 77        ...{
 78            return DataProvider.Instance().SelectList<T>(spName, parameters, pageIndex, pageSize, out totalRecord);
 79        }
 80        #endregion
 81
 82        public static bool Delete(int id)
 83        ...{
 84            return DataProvider.Instance().Delete<T>(id);
 85        }
 86
 87        // save include Insert and Update
 88        public int Save()
 89        ...{
 90            return DataProvider.Instance().Save<T>((T)this, "");
 91        }
 92
 93        public int Save(string spName)
 94        ...{
 95            return DataProvider.Instance().Save<T>((T)this, spName);
 96        }
 97
 98        public static bool IsExist(int id)
 99        ...{
100            return Select(id) != null;
101        }
102
103        public static bool IsExist(CriteriaCollection parameters)
104        ...{
105            List<T> list = SelectList(parameters);
106            return list != null && list.Count > 0;
107        }
108
109        public static Dictionary<string, string> GetNameValueList()
110        ...{
111           return  DataProvider.Instance().GetNameValueList<T>("Id", "Name");
112        }        
113        public static Dictionary<string, string> GetNameValueList(string textName)
114        ...{
115            return DataProvider.Instance().GetNameValueList<T>("Id", textName);
116        }
117        public static Dictionary<string, string> GetNameValueList(string idName,string textName)
118        ...{
119            return DataProvider.Instance().GetNameValueList<T>(idName, textName);
120        }
121
122               
123    }
124}
125