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