這個類適用簡單的表
1.有且只有id為主鍵，
2.并且實例類主鍵，也就是id應為字段，其他為屬性
3.實例類名跟表名一樣，字段屬性跟列名一樣
public class ProType{public int id;public string type{get;set;}public int array{get;set;}public string relyTpye{get;set;}public string etype{get;set;}}
下面就是該類的實現
?
/// <summary>/// 排序枚舉/// </summary>public enum OrderType { asc, desc }public class SqlDAL<T> where T : new(){private PropertyInfo[] propertys;private List<string> nameList;public SqlDAL(){T t = new T();nameList = new List<string>();propertys = t.GetType().GetProperties();//MessageBox.Show(propertys.Length.ToString());foreach (var item in propertys){nameList.Add(item.Name);}}/// <summary>/// 查詢/// </summary>/// <returns></returns>public DataTable Select(){T t = new T();string sql = "select * from " + t.GetType().Name;DataTable dt = new DataTable();dt = DBHelper.GetInfo(sql);return dt;}/// <summary>/// 查詢/// </summary>/// <param name="orderType">排序</param>/// <param name="str">排序字段</param>/// <returns></returns>public DataTable Select(OrderType orderType, params string[] str){string orderStr = "";if (str.Length > 0){orderStr += " order by " + str[0];for (int i = 1; i < str.Length; i++){orderStr += "," + str[i];}orderStr += " " + orderType.ToString();}T t = new T();string sql = "select * from " + t.GetType().Name + orderStr;DataTable dt = DBHelper.GetInfo(sql);return dt;}/// <summary>/// 增/// </summary>/// <param name="t"></param>/// <returns></returns>public bool Insert(T t){List<SqlParameter> parm = new List<SqlParameter>();foreach (var item in propertys){SqlParameter parmitem = new SqlParameter(item.Name, item.GetValue(t, null));parm.Add(parmitem);}string strName = "";string strValue = "";strName += nameList[0];strValue += "@" + nameList[0];for (int i = 1; i < nameList.Count; i++){strName += "," + nameList[i];strValue += ",@" + nameList[i];}string sql = "insert into " + t.GetType().Name.ToString() + " (" + strName + ") values (" + strValue + ")";int isAdd = DBHelper.Commed(sql, parm.ToArray());if (isAdd > 0){return true;}else{return false;}}/// <summary>/// 改/// </summary>/// <param name="t"></param>/// <returns></returns>public bool Update(T t){List<SqlParameter> parm = new List<SqlParameter>();foreach (var item in propertys){SqlParameter parmitem = new SqlParameter(item.Name, item.GetValue(t, null));parm.Add(parmitem);}string str = "";str = nameList[0] + "=@" + nameList[0];for (int i = 1; i < nameList.Count; i++){str += "," + nameList[i] + "=@" + nameList[i];}string sql = "update " + t.GetType().Name + " set " + str + " where id=@id";int isUpdate = DBHelper.Commed(sql, parm.ToArray());if (isUpdate > 0){return true;}else{return false;}}/// <summary>/// 刪/// </summary>/// <param name="id"></param>/// <returns></returns>public bool Delete(string id){T t = new T();string sql = "delete from " + t.GetType().Name + " where id=" + id;int isDelete = DBHelper.Commed(sql);if (isDelete > 0){return true;}else{return false;}}}
?
這里之所以有這個類，是因為操作這些表的代碼大同小異，甚至可以做出通用任意表，實例類可以用特征類來標識，做出字段與列名的相對應
但那種太過繁瑣，用來實現這些簡單表就有點大材小用，所有先弄出了這個類，如果后面有機會再實現以下任意表通用類
