sbsql.toString() 结果是这个 SELECT a.ID,a.[IPAddresss],a.[UID],(SELECT b.UserName FROM ICI_d_AdminInfo b WHERE b.ID=a.UID) AS UserName FROM [ICI_e_OperationLog] a ORDER BY a.ID DESC
为何不直接public string username 然后查出来 绑定到实体呢
StringBuilder sbsql = new StringBuilder(); sbsql.Append("SELECT a.ID "); sbsql.Append(",a.[IPAddresss] "); sbsql.Append(",a.[UID] "); sbsql.Append(",b.[UserName] "); sbsql.Append(" FROM ICI_e_OperationLog a INNER JOIN ICI_d_AdminInfo b ON b.[ID]=a.[UID] "); sbsql.Append(" ORDER BY a.ID DESC ");
SELECT a.ID,a.[IPAddresss],a.[UID],(SELECT b.UserName FROM ICI_d_AdminInfo b WHERE b.ID=a.UID) AS UserName FROM [ICI_e_OperationLog] a ORDER BY a.ID DESC
sbsql.Append("SELECT a.ID ");
sbsql.Append(",a.[IPAddresss] ");
sbsql.Append(",a.[UID] ");
sbsql.Append(",b.[UserName] ");
sbsql.Append(" FROM ICI_e_OperationLog a INNER JOIN ICI_d_AdminInfo b ON b.[ID]=a.[UID] ");
sbsql.Append(" ORDER BY a.ID DESC ");