谁能看看这个是怎么实现的？？？

[liubright996]

谁能看看这个是怎么实现的？？？



http://ebooks.artron.net/Interface/CatalogueList.aspx?page=0&pagesize=5&organcode=JG0005





http://ebooks.artron.net/Interface/CatalogueList.aspx?page=0&pagesize=5&organcode=JG0005



为什么后边organcode 的值不同返回不同的json格式的数据呢？？？

附源码：


using System;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using Newtonsoft.Json;

public partial class Interface_CardList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
int userId = -1;
try
{
userId = int.Parse(Request["userid"]);
}
catch
{ }

if (userId <= 0) return;

List<Interface.CardInfo> res = new List<Interface.CardInfo>();

MySqlConnection con = new MySqlConnection(Config.ConStr);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
con.Open();

cmd.CommandText = string.Format("SELECT * FROM tb_VIPCard WHERE UserId={0}", userId);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Interface.CardInfo card = new Interface.CardInfo();
card.SerialNumber = (string)reader["SerialNumber"];
card.OrganCode = (string)reader["OrganCode"];
card.Deadline = reader["Deadline"].ToString();
card.Value = (int)reader["Value"];
res.Add(card);
}
reader.Close();

foreach (Interface.CardInfo card in res)
{
cmd.CommandText = string.Format("SELECT * FROM tb_PictureBook WHERE OrganCode='{0}' LIMIT 1", card.OrganCode);
reader = cmd.ExecuteReader();
if (reader.Read())
{
card.OrganName = (string)reader["OrganName"];
card.OrganSimpleName = (string)reader["OrganSimpleName"];
}
reader.Close();
}

con.Close();

Response.Write(JsonConvert.SerializeObject(res));
}
}



谁能解释下具体原理呢？？？？？

[人生难得一只鸡]

根据organcode=JG0005这个值来获取不同的信息呗

就像根据用户ID得到不同用户的信息，然后按json格式返回.

[极地_雪狼]

organcode 是一个输入参数，和url中的pagesize和page一样，value不同，处理过程不同