|
|
|
|
|
select role,realname from c_user where userid=1
|
|
|
|
select parentID,companyNameShort from t_companyParent where parentid>0 order by companyNameShort
|
|
|
|
select docStyleID,item,linkto,case when linkto IS NULL then item else ''+item+'' end as itemlink from t_docstyle where type=3 and parentCompanyID=45 order by orderID
|
|
|
|
select docStyleID,item,linkto,case when linkto IS NULL then item else ''+item+'' end as itemlink from t_docstyle where type=3 and parentCompanyID=7 order by orderID
|
|
|