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;
}