LgCasResSql.cs 736 B

123456789101112131415161718192021222324252627
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. namespace Core.LgMes.Client.lgServiceMgt.LgSqlCollection.LgRes.LgCasSql
  6. {
  7. public class LgCasResSql
  8. {
  9. /// <summary>
  10. /// 返回氩站实绩SQL
  11. /// </summary>
  12. /// <param name="sqlWhere"></param>
  13. /// <returns></returns>
  14. public static string returnSqlOfStl_Cas_Optinfo(string sqlWhere)
  15. {
  16. string sqlStr = "";
  17. sqlStr = "select * from stl_cas_optinfo a where 1=1 {0}";
  18. sqlStr += "union all select * from j#stl_cas_optinfo a where 1=1 {0}";
  19. sqlStr = string.Format(sqlStr,sqlWhere);
  20. return sqlStr;
  21. }
  22. }
  23. }