示例#1
0
        protected static IEnumerable <T> Get <T>(string sql)
        {
            var list       = new List <T>();
            var properties = typeof(T).GetProperties();

            using (var conn = MicrosoftSQL.GetConnection())
            {
                using (var comm = new MySqlCommand(GetCommandText(sql), conn))
                {
                    conn.Open();
                    using (var reader = comm.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var element = Activator.CreateInstance <T>();

                            foreach (var f in properties)
                            {
                                var o = reader[f.Name];
                                if (o.GetType() != typeof(DBNull))
                                {
                                    f.SetValue(element, o, null);
                                }
                                o = null;
                            }
                            list.Add(element);
                        }
                    }
                    conn.Close();
                }
            }
            return(list);
        }
示例#2
0
 protected static int Delete(string sql, Dictionary <string, dynamic> fields)
 {
     using (MySqlConnection connection = MicrosoftSQL.GetConnection())
     {
         connection.Open();
         string cmdText = GetCommandText(sql);
         using (MySqlCommand command = new MySqlCommand(cmdText, connection))
         {
             command.CommandType = System.Data.CommandType.Text;
             foreach (var item in fields)
             {
                 command.Parameters.AddWithValue(item.Key, item.Value);
             }
             return(command.ExecuteNonQuery());
         }
     }
 }