LgBofResSql01.cs 1007 B

123456789101112131415161718192021222324252627282930313233
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. namespace Core.LgMes.Client.lgServiceMgt.LgSqlCollection.LgRes.LgBofSql
  6. {
  7. public class LgBofResSql01
  8. {
  9. /// <summary>
  10. /// 返回表stl_bof_optinfo sql
  11. /// </summary>
  12. /// <param name="sqlCondition"></param>
  13. /// <returns></returns>
  14. public static string GetSqlForStlBofOptinfo(string sqlCondition)
  15. {
  16. string sqlStr = "select * from stl_bof_optinfo a where 1 = 1 {0} ";
  17. return string.Format(sqlStr, sqlCondition);
  18. }
  19. /// <summary>
  20. /// 返回表stl_bof_optinfo sql
  21. /// </summary>
  22. /// <param name="sqlCondition"></param>
  23. /// <returns></returns>
  24. public static string GetSqlForHisStlBofOptinfo(string sqlCondition)
  25. {
  26. string sqlStr = "select * from j#stl_bof_optinfo a where 1 = 1 {0} ";
  27. return string.Format(sqlStr, sqlCondition);
  28. }
  29. }
  30. }