| | |
| | | ], |
| | | datetime: [ |
| | | {value: '', text: _dict['model.empty']}, |
| | | {value: '0', text: '今天'}, |
| | | {value: '0', text: '当前'}, |
| | | {value: 1, text: '昨天'}, |
| | | {value: 3, text: '前三天'}, |
| | | {value: 7, text: '前七天'}, |
| | |
| | | ] |
| | | } |
| | | |
| | | export const queryTableSql = 'select TbName,Remark from (select TbName,Remark from sDataDictb where appkey= @appkey@ and Deleted=0 union select a.TbName,Remark from (select TbName,Remark from sDataDictb where appkey= \'\' and Deleted=0 ) a left join (select TbName from sDataDictb where appkey= @appkey@ and Deleted=0 ) b on a.TbName=b.TbName where b.TbName is null ) t' |
| | | export const queryTableSql = 'select top 999999 TbName,Remark from (select TbName,Remark from sDataDictb where appkey= @appkey@ and Deleted=0 union select a.TbName,Remark from (select TbName,Remark from sDataDictb where appkey= \'\' and Deleted=0 ) a left join (select TbName from sDataDictb where appkey= @appkey@ and Deleted=0 ) b on a.TbName=b.TbName where b.TbName is null ) t order by TbName' |