/// <summary> /// 根据默认值 ,验证输入的SQL语句正确性 /// </summary> /// <returns></returns> private bool ValidateSQL(string sql, List <entity.Fields> fields, ref string validSqlMsg) { SqlRun sqlHelper = new SqlRun(SqlRun.sqlstr); foreach (var f in fields) { if (f.type == "date" && string.IsNullOrWhiteSpace(f.defaultValue)) { f.defaultValue = DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss"); } if (f.type == "int" && string.IsNullOrWhiteSpace(f.defaultValue)) { f.defaultValue = "1"; } sql = sql.Replace(f.field, f.defaultValue); } return(sqlHelper.ValidateSQL(sql, ref validSqlMsg)); }