public string GetJson(string cid) { string pos_json = ""; TPortalClass.DAO db = new DAO(); StringBuilder sbFirst = new StringBuilder(); StringBuilder sbSecond = new StringBuilder(); TPortalClass.JpColumns JpColumns = new JpColumns(); DataTable dtFirstColumn = JpColumns.GetFirstColumns(cid, "1"); if (dtFirstColumn.Rows.Count > 0) { sbSecond.Append(" ["); #region for (int i = 0; i < dtFirstColumn.Rows.Count; i++) { DataTable dtSecondColumn = JpColumns.GetSecondColumns(dtFirstColumn.Rows[i]["cid"].ToString()); for (int j = 0; j < dtSecondColumn.Rows.Count; j++) { if (dtSecondColumn.Rows.Count > 0) { if (i == 0) { if (j == 0) { sbSecond.Append("{\"SecondColumnName\":\"" + dtSecondColumn.Rows[j]["cname"].ToString() + "\",\"PictureUrl\":\"" + dtSecondColumn.Rows[j]["newpic"].ToString() + "\"}"); } else { sbSecond.Append(",{\"SecondColumnName\":\"" + dtSecondColumn.Rows[j]["cname"].ToString() + "\",\"PictureUrl\":\"" + dtSecondColumn.Rows[j]["newpic"].ToString() + "\"}"); } } else { sbSecond.Append(",{\"SecondColumnName\":\"" + dtSecondColumn.Rows[j]["cname"].ToString() + "\",\"PictureUrl\":\"" + dtSecondColumn.Rows[j]["newpic"].ToString() + "\"}"); } } } sbSecond.Append("]"); if (i == 0) { sbFirst.Append("{\"FirstColumnName\":\"" + dtFirstColumn.Rows[i]["cname"].ToString() + "\",\"SecondColumnList\":" + sbSecond.ToString() + "}"); } else { sbFirst.Append(",{\"FirstColumnName\":\"" + dtFirstColumn.Rows[i]["cname"].ToString() + "\",\"SecondColumnList\":" + sbSecond.ToString() + "}"); } } #endregion pos_json = sbFirst.ToString(); } return pos_json; }