ISqlBuilder.cs 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Dynamic;
  5. using System.Linq;
  6. using System.Linq.Expressions;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. namespace SqlSugar
  10. {
  11. public partial interface ISqlBuilder
  12. {
  13. SqlSugarProvider Context { get; set; }
  14. CommandType CommandType { get; set; }
  15. String AppendWhereOrAnd(bool isWhere, string sqlString);
  16. string AppendHaving(string sqlString);
  17. SqlQueryBuilder SqlQueryBuilder { get; set; }
  18. QueryBuilder QueryBuilder { get; set; }
  19. InsertBuilder InsertBuilder { get; set; }
  20. DeleteBuilder DeleteBuilder { get; set; }
  21. UpdateBuilder UpdateBuilder { get; set; }
  22. string SqlParameterKeyWord { get; }
  23. string SqlFalse { get; }
  24. string SqlDateNow { get; }
  25. string FullSqlDateNow { get; }
  26. string SqlTranslationLeft { get; }
  27. string SqlTranslationRight { get; }
  28. string SqlSelectAll { get; }
  29. void ChangeJsonType(SugarParameter paramter);
  30. string GetTranslationTableName(string name);
  31. string GetTranslationColumnName(string entityName, string propertyName);
  32. string GetTranslationColumnName(string propertyName);
  33. string GetNoTranslationColumnName(string name);
  34. string GetPackTable(string sql,string shortName);
  35. string GetDefaultShortName();
  36. string GetWhere(string fieldName, string conditionalType, int? parameterIndex = null);
  37. string GetUnionAllSql(List<string> sqlList);
  38. string GetUnionSql(List<string> sqlList);
  39. void RepairReplicationParameters(ref string appendSql, SugarParameter[] parameters, int addIndex);
  40. KeyValuePair<string, SugarParameter[]> ConditionalModelToSql(List<IConditionalModel> models, int beginIndex = 0);
  41. string GetUnionFomatSql(string sql);
  42. Type GetNullType(string tableName,string columnName);
  43. string RemoveParentheses(string sql);
  44. string RemoveN(string sql);
  45. void FormatSaveQueueSql(StringBuilder sqlBuilder);
  46. }
  47. }