读书人

一个关于查询的有关问题

发布时间: 2012-06-07 15:05:14 作者: rapoo

一个关于查询的问题
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 ? "退回" : "已派") + "'"; 

读书人网 >C#

热点推荐