日期:2014-05-18  浏览次数:20704 次

一个关于查询的问题
select * from " + GasFieldInfo.QueryDataView + " where " + (mark == 0 ? "" : "FSuohao='" + LoginInfo.m_sDepartNum + "' and FAccept='"+ mark == 0 ? "退回" : "已派"+"'")
哪里有错啊,实在找不到了。

------解决方案--------------------
C# code
string str = "select * from " + GasFieldInfo.QueryDataView + " where " + (mark == 0 ? "" : "FSuohao='" + LoginInfo.m_sDepartNum + "' and ") + "FAccept='" + (mark == 0 ? "退回" : "已派") + "'";