ISqlBuilder.cs 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. namespace Ant.SQLite
  7. {
  8. interface ISqlBuilder
  9. {
  10. string ToSql();
  11. ISqlBuilder Append(object obj);
  12. ISqlBuilder Append(object obj1, object obj2);
  13. ISqlBuilder Append(object obj1, object obj2, object obj3);
  14. ISqlBuilder Append(object obj1, object obj2, object obj3, object obj4);
  15. ISqlBuilder Append(object obj1, object obj2, object obj3, object obj4, object obj5);
  16. ISqlBuilder Append(params object[] objs);
  17. }
  18. class SqlBuilder : ISqlBuilder
  19. {
  20. StringBuilder _sb = new StringBuilder();
  21. public string ToSql()
  22. {
  23. return this._sb.ToString();
  24. }
  25. public ISqlBuilder Append(object obj)
  26. {
  27. this._sb.Append(obj);
  28. return this;
  29. }
  30. public ISqlBuilder Append(object obj1, object obj2)
  31. {
  32. return this.Append(obj1).Append(obj2);
  33. }
  34. public ISqlBuilder Append(object obj1, object obj2, object obj3)
  35. {
  36. return this.Append(obj1).Append(obj2).Append(obj3);
  37. }
  38. public ISqlBuilder Append(object obj1, object obj2, object obj3, object obj4)
  39. {
  40. return this.Append(obj1).Append(obj2).Append(obj3).Append(obj4);
  41. }
  42. public ISqlBuilder Append(object obj1, object obj2, object obj3, object obj4, object obj5)
  43. {
  44. return this.Append(obj1).Append(obj2).Append(obj3).Append(obj4).Append(obj5);
  45. }
  46. public ISqlBuilder Append(params object[] objs)
  47. {
  48. if (objs == null)
  49. return this;
  50. for (int i = 0; i < objs.Length; i++)
  51. {
  52. var obj = objs[i];
  53. this.Append(obj);
  54. }
  55. return this;
  56. }
  57. }
  58. }