using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using DAL; using System.Text; namespace iosjson { public partial class getpronumber : System.Web.UI.Page { public int count; public int pagecount; ProductsDAL prodal = new ProductsDAL(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["page"]!=null) { int currentpage = int.Parse(Request.QueryString["page"].ToString()); DataTable dt = prodal.CutPage(currentpage, out pagecount, out count).Tables[0]; if (currentpage > count) { Response.Write("{\"result\":1}"); } else { StringBuilder jsonBuilder = new StringBuilder(); jsonBuilder.Append("{\""); jsonBuilder.Append("result\":\"0\",\"data"); jsonBuilder.Append("\":["); for (int i = 0; i < dt.Rows.Count; i++) { jsonBuilder.Append("{"); jsonBuilder.Append("\"productnumber\":\""); jsonBuilder.Append(dt.Rows[i]["ProductNumber"].ToString()); jsonBuilder.Append("\","); jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("},"); } jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("]"); jsonBuilder.Append("}"); Response.Write(jsonBuilder.ToString()); Response.End(); } } } } } }