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