C#拼接长字符串，根据是否查询到值来动态赋值。

最新推荐文章于 2024-04-26 16:37:09 发布

slm311

最新推荐文章于 2024-04-26 16:37:09 发布

阅读量557

点赞数

分类专栏： c# 文章标签： c#

本文链接：https://blog.csdn.net/u010481239/article/details/78940658

版权

c# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

//查询语句写在这
                    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));