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));
}
