public string Select(string sql) { string a = ";lt"; string b = ";gt"; sql = sql.Replace(a, "<").Replace(b, ">"); DataTable dt = MySqlHelpers.ExecuteDataTable(MySqlHelpers.connectionString, CommandType.Text, sql); IsoDateTimeConverter timeFormat = new IsoDateTimeConverter(); timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; return(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.None, timeFormat).ToLower()); }
public string GetData(string configKey, string sqlCode) { string result = ""; #region old code string xmlName = XmlHelper.GetBaseConfigValue(configKey); List <string> sqlArray = new List <string>(); if (xmlName.Equals("") == false) { var list = XmlHelper.ReadXml(xmlName, sqlCode); if (list != null && list.Count > 0) { foreach (var sql in list) { sqlArray.Add(sql.Value); } } if (sqlArray.Count > 0) { DataTable dt = MySqlHelpers.ExecuteDataTable(MySqlHelpers.connectionString, CommandType.Text, sqlArray[0]); result = JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.None, new JsonSerializerSettings { ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver() } ); } } else { result = "error:"; } #endregion return(result); }
public string SelectOriginal(string sql) { string a = ";lt"; string b = ";gt"; sql = sql.Replace(a, "<").Replace(b, ">"); DataTable dt = MySqlHelpers.ExecuteDataTable(MySqlHelpers.connectionString, CommandType.Text, sql); //名称和日期都进行格式 Newtonsoft.Json.JsonSerializerSettings setting = new Newtonsoft.Json.JsonSerializerSettings { ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver() }; JsonConvert.DefaultSettings = new Func <JsonSerializerSettings>(() => { //日期类型默认格式化处理 setting.DateFormatHandling = Newtonsoft.Json.DateFormatHandling.MicrosoftDateFormat; setting.DateFormatString = "yyyy-MM-dd HH:mm:ss"; //空值处理 setting.NullValueHandling = NullValueHandling.Ignore; return(setting); }); return(JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.None, setting)); }