Project

General

Profile

Feature #552 » sqlstmt.h

yufeng wu, 05/11/2020 10:17 PM

 
1

    
2
#ifndef __SQLSTMT_H__
3
#define __SQLSTMT_H__
4

    
5
#define SQL_GROUP		"select F1001_GROUPCODE, F1001_GROUPDESC from SEMODEL.TB1001_GROUP order by F1001_GROUPNO"
6
#define SQL_AOJ			"select F1000_AOJ, F1000_AOJDESC from SEMODEL.TB1000_AOJ"
7
#define SQL_APPSYS		"select F1010_APPSYSID, F1010_APPSYSDESC from SEMODEL.TB1010_APPSYS"// order by F1010_APPSYSID"
8
#define SQL_DEVTYPE		"select F1005_DEVTYPEID, F1005_DEVTYPEDESC from SEMODEL.TB1005_DEVTYPE"
9

    
10
#define SQL_PRIOR		"select F4200_PRIORITY, F4200_PRIORITYDESC, F4200_COLOR from SEMODEL.TB4200_ALMPRIORITY order by F4200_PRIORITY"
11
#define SQL_ALMCLASS	"select F4201_CLASSNAME, F4201_CLASSDESC, F4201_ICON from SEMODEL.TB4201_ALMCLASS"
12

    
13
#endif
(4-4/5)