谁能看看这个是怎么实现的???
谁能看看这个是怎么实现的???
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不同,处理过程不同
补充:.NET技术 , C#