首页 > 代码库 > SQLHelper.cs
SQLHelper.cs
1 using System; 2 using System.Collections.Generic; 3 using System.Data; 4 using System.Data.SqlClient; 5 using System.Linq; 6 using System.Reflection; 7 using System.Text; 8 using System.Threading.Tasks; 9 10 namespace DataBaseUility11 {12 /// <summary>13 /// 数据库使用公共类14 /// </summary>15 public class SQLHelper16 {17 public static string Connection18 {19 get20 {21 return "Data Source=.;Database=ShortMessage;Integrated Security=true";22 }23 }24 25 /// <summary>26 /// 增删改数据27 /// </summary>28 /// <param name="strSql"></param>29 /// <returns></returns>30 public static bool Processing(string strSql)31 {32 using (SqlConnection sqlCon = new SqlConnection(DatabaseCommon.Connection))33 {34 sqlCon.Open();35 SqlCommand sqlCom = new SqlCommand(strSql, sqlCon);36 if (sqlCom.ExecuteNonQuery() > 0)37 {38 return true;39 }40 return false;41 }42 }43 44 /// <summary>45 /// 指定条件查询,返回实体集合46 /// </summary>47 /// <returns></returns>48 public static List<T> GetTabaleValue<T>(string strSql)49 where T : class,new()50 {51 using (SqlConnection sqlCon = new SqlConnection(DatabaseCommon.Connection))52 {53 sqlCon.Open();54 SqlDataAdapter sqlDA = new SqlDataAdapter(strSql, sqlCon);55 DataTable dt = new DataTable();56 sqlDA.Fill(dt);57 List<T> config = DTToModel<T>(dt);58 return config;59 }60 }61 62 /// <summary>63 /// 数据表转换为实体64 /// </summary>65 /// <typeparam name="T"></typeparam>66 /// <param name="dt"></param>67 /// <returns></returns>68 public static List<T> DTToModel<T>(DataTable dt) where T : class,new()69 {70 Type type = typeof(T);71 PropertyInfo[] files = type.GetProperties();72 List<T> list = new List<T>();73 foreach (DataRow dr in dt.Rows)74 {75 T model = new T();76 for (int i = 0; i < files.Count(); i++)77 {78 files[i].SetValue(model, dr[i]);79 }80 list.Add(model);81 }82 return list;83 }84 }85 86 }
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。