개정판 f6493ebf
issue #901: fix line no
Change-Id: I1fa8befde4f2c09de08dd68f3118ecbc22795b43
| DTI_PID/DTI_PID/AppDocData.py | ||
|---|---|---|
| 1698 | 1698 |
kyouho 2018.07.16 edit query order by code |
| 1699 | 1699 |
''' |
| 1700 | 1700 |
|
| 1701 |
def getNomialPipeSizeData(self, forCheckLineNumber=False, orderStr="CODE"):
|
|
| 1701 |
def getNomialPipeSizeData(self, forCheckLineNumber=False, orderStr="MetricStr"):
|
|
| 1702 | 1702 |
res = [] |
| 1703 | 1703 |
configs = self.getConfigs('Line No', 'Size Unit')
|
| 1704 | 1704 |
sizeUnit = configs[0].value if 1 == len(configs) else 'Metric' |
| ... | ... | |
| 1709 | 1709 |
# Get a cursor object |
| 1710 | 1710 |
cursor = conn.cursor() |
| 1711 | 1711 |
|
| 1712 |
sql = "select UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr from NominalDiameter ORDER BY {} ASC".format(
|
|
| 1712 |
sql = "select UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr from NominalDiameter ORDER BY {} DESC".format(
|
|
| 1713 | 1713 |
orderStr) |
| 1714 | 1714 |
cursor.execute(sql) |
| 1715 | 1715 |
rows = cursor.fetchall() |
내보내기 Unified diff
