//查询语句写在这
try
{
while (reader.Read())
{
if (reader.HasRows)
{
JSONstring += "{";
JSONstring += "\"" + "wx_id" + "\":\"" + reader.GetString("wx_id") + "\",";
beNeck = reader.GetString("beNeck");
if (beNeck != "0")
{
JSONstring += "\"" + "beNeck" + "\":\"" + reader.GetString("beNeck") + "\",";
JSONstring += "\"" + "neckN" + "\":\"" + reader.GetString("neckN") + "\",";
JSONstring += "\"" + "neckCR" + "\":\"" + reader.GetString("neckCR") + "\",";
JSONstring += "\"" + "neckRAN" + "\":\"" + reader.GetString("neckRAN") + "\",";
JSONstring += "\"" + "neckRSN" + "\":\"" + reader.GetString("neckRSN") + "\",";
JSONstring += "\"" + "neckChN" + "\":\"" + reader.GetString("neckChN") + "\",";
}
beShoulderW = reader.GetString("beShoulderW");
if (beShoulderW != "0")
{
JSONstring += "\"" + "beShoulderW"+ "\":\"" + reader.GetString("beShoulderW") + "\",";
JSONstring += "\"" + "shoulderWN" + "\":\"" + reader.GetString("shoulderWN") + "\",";
JSONstring += "\"" + "shoulderWCR" + "\":\"" + reader.GetString("shoulderWCR") + "\",";
JSONstring += "\"" + "shoulderWRAN" + "\":\"" + reader.GetString("shoulderWRAN") + "\",";
JSONstring += "\"" + "shoulderWRSN" + "\":\"" + reader.GetString("shoulderWRSN") + "\",";
JSONstring += "\"" + "shoulderWChN" + "\":\"" + reader.GetString("shoulderWChN") + "\",";
}
JSONstring = JSONstring.TrimEnd(specialChars);
JSONstring += "},";
JSONstring = JSONstring.TrimEnd(specialChars);
JSONstring += "]";
}
}
}
catch
{
reader.Close();
}
finally
{
reader.Close();
}
Response.Write(MysqlHelper.Encrypt(JSONstring));
C#拼接长字符串,根据是否查询到值来动态赋值。
最新推荐文章于 2022-10-24 19:16:58 发布