public string OutputColumnInfo(string pis_yzm) { string pos_json = ""; string ls_yzm = ConfigurationManager.AppSettings["Yanzm"].ToString(); TPortalClass.DAO db = new DAO(); StringBuilder sbFirst = new StringBuilder(); StringBuilder sbSecond = new StringBuilder(); if (pis_yzm == ls_yzm) { try { string ss = ""; JpColumns JpColumns = new JpColumns(); DataTable dt = JpColumns.GetFirstColumns("0", "0"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { pos_json = GetJson(dt.Rows[i]["cid"].ToString()); if (i == 0) { ss = pos_json; } else { ss += "," + pos_json; } } } pos_json = "{ \"code\": \"0\", \"list\": [" + ss + "]}"; } catch { //系统错误 pos_json = "{\"code\":\"1\"}"; } finally { } } else { //非法调用 pos_json = "{\"code\":\"2\"}"; } return pos_json; }
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; }