急 from 关键字附近有语法错误string sql = "select top " + Parameter[5].ToString() + " from " + TableName + " where ColumnsId=" + Parameter[1].ToString() + "and ZT=1";string sql2 = "";if (Parameter[2].ToString() == "0"){sql2 = "and IsTop=0";

来源：学生作业帮助网编辑：作业帮时间：2024/05/08 03:37:21

急 from 关键字附近有语法错误string sql = "select top " + Parameter[5].ToString() + " from " + TableName + " where ColumnsId=" + Parameter[1].ToString() + "and ZT=1";string sql2 = "";if (Parameter[2].ToString() == "0"){sql2 = "and IsTop=0";
急 from 关键字附近有语法错误
string sql = "select top " + Parameter[5].ToString() + " from " + TableName + " where ColumnsId=" + Parameter[1].ToString() + "and ZT=1";
string sql2 = "";
if (Parameter[2].ToString() == "0")
{
sql2 = "and IsTop=0";
}
else
{
sql2 = "and IsTop=1";
}
sql += sql2;
string sql3 = "";
if (Parameter[3].ToString() == "0")
{
sql3 = "and IsJd=0";
}
else
{
sql3 = "and IsJd=1";
}
sql += sql3;
string sql4 = "";
if (Parameter[4].ToString() == "0")
{
sql4 = "and IsTj=0";
}
else
{
sql4 = "and IsTj=1";
}
sql += sql4;
string sql5 = "order by id desc";
sql += sql5;
db.ExecuteSQL(sql);
db.CloseConn();