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