c# MVC框架对mysql数据库的查询-白红宇

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;using demo2.Models;using MySql.Data.MySqlClient;using Newtonsoft.Json;namespace demo2.Controllers{    public class GetFilesController : Controller    {        // GET: GetFiles        [HttpGet]        public void GetFiles(GetFiles Parameter)        {            string sn = Parameter.Sn_code;            string t = DateTime.Now.ToString("yyyyMMdd");            string name = Parameter.File_name;            MySqlConnection sqlCnn = new MySqlConnection();            string connetStr = "Server = 127.0.0.1; Port = 3306; Database = Database; Uid = root; Pwd = root;SslMode = none;";            MySqlConnection conn = new MySqlConnection(connetStr);            //string sql1 = string.Format("select * from device_files where sn_code='{0}' order by file_time,fid DESC limit 0,1", sn);            //string sql1 = string.Format("select * from device_files where sn_code='{0}' and file_time='{1}'", sn, t); //查询当前日期包含的数据            string sql1 = string.Format("select * from device_files where sn_code='{0}' and file_name like '%{1}%'", sn, name); //模糊查询文件名            MySqlCommand cmd = new MySqlCommand(sql1, conn);            try            {                conn.Open();                //执行查询，并将结果返回给读取器                MySqlDataReader reader = cmd.ExecuteReader();                List
     
       proList = new List
      
       ();                while (reader.Read())                {                    proList.Add(new GetFiles                    {                        Fid = reader.GetString(reader.GetOrdinal("fid")),                        Sn_code = reader.GetString(reader.GetOrdinal("sn_code")),                        File_src = reader.GetString(reader.GetOrdinal("file_src")),                        File_time = reader.GetString(reader.GetOrdinal("file_time")),                        File_name = reader.GetString(reader.GetOrdinal("file_name"))                    });                }                var obj = new                {                    Sn_code = reader.GetString(reader.GetOrdinal("sn_code")),                    data = proList,                    message = true,                    state = 200                };                Formatting microsoftDataFormatSettings = default(Formatting);                string result = JsonConvert.SerializeObject(obj, microsoftDataFormatSettings);                Response.Write(result);            }            catch (MySqlException ex)            {                Response.Write(ex);            }            finally            {                conn.Close();                Console.WriteLine("关闭数据库");            }        }    }}
查询结果生成json格式返回到微信小程序里