深圳全飞鸿

标题: scada的安卓版获得线别的工位配置的逻辑 [打印本页]

---

作者: zhgc    时间: 2019-11-10 18:41
标题: scada的安卓版获得线别的工位配置的逻辑

1.         if($SQL=="000001"){$SQL="SELECT distinct LINE_NAME from SFC.C_LINE_DESC_T order by line_name";}

复制代码

        /*if($SQL=="000002"){$SQL="SELECT distinct Section_Name , Group_Name, Station_Name
          FROM SFC.C_STATION_CONFIG_T
          WHERE LINE_NAME  in ( '3A') AND HOSTID = -1
         ORDER BY Group_Name";} */

1.         if($SQL=="000002"){$SQL="SELECT distinct a.Section_Name , a.Group_Name, a.Station_Name
   
2.                         FROM SFC.C_STATION_CONFIG_T a
   
3.                         inner join SFC.C_SMO_TYPE_T b ON a.group_name=b.group_name
   
4.                         WHERE a.HOSTID = -1
   
5.                         ORDER BY Group_Name";}       

复制代码

---

欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/)

Powered by Discuz! X3.2