| | |
| | | sbSql.Append(",cast(0 as bit) as chkInt"); |
| | | } |
| | | else |
| | | sbSql.Append(",cast( (select count(1) from SYS_USER_BIND b where b.userGuid='" + keyType+ "' and b.aboutGuid=a.guid) as bit) as chkInt "); |
| | | sbSql.Append(",cast( (select count(1) from SYS_USER_BIND b where b.userGuid='" + keyType+ "' and b.aboutGuid=a.guid and b.fType='PDA页面') as bit) as chkInt "); |
| | | sbSql.Append(" from MES_SYS_PAGEVIEW a "); |
| | | sbSql.Append(keyWhere); |
| | | sbSql.Append(") as T "); |
| | |
| | | new("@outMsg", SqlDbType.NVarChar, 300), |
| | | new("@edtUserGuid", _userGuid), |
| | | new("@userGuid", userGuid), |
| | | new("@fType", fType), |
| | | new("@fType", fType), |
| | | new("@bindGuids", bindGuidslist) |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |