<%@ WebHandler Language="C#" Class="Search_Book" %>

using System;
using System.Web;

public class Search_Book : IHttpHandler {

public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";

string txtTitle = context.Request["txtTitle"];
string txtAuthor = context.Request["txtAuthor"];
string txtPress = context.Request["txtPress"];

string sql = @"select * from Item where 1=1 ";
System.Data.DataTable dt;


if (!string.IsNullOrEmpty(txtTitle))
{
sql += @" and ItemName like ‘%" + @txtTitle + "%‘ ";

}

if (!string.IsNullOrEmpty(txtAuthor))
{
sql += @" and BookAuthor like ‘%" + @txtAuthor + "%‘ ";
}
if (!string.IsNullOrEmpty(txtPress))
{
sql += @" and publisher like ‘%" + @txtPress + "%‘ ";

}

if (!string.IsNullOrEmpty(txtTitle))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtTitle, txtTitle));

}
else if (!string.IsNullOrEmpty(txtAuthor))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtAuthor, txtAuthor));
}
else if (!string.IsNullOrEmpty(txtPress))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtPress, txtPress));
}
else if (!string.IsNullOrEmpty(txtTitle) && !string.IsNullOrEmpty(txtAuthor))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtTitle, txtTitle), new System.Data.SqlClient.SqlParameter(@txtAuthor, txtAuthor));
}
else if (!string.IsNullOrEmpty(txtTitle) && !string.IsNullOrEmpty(txtPress))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtTitle, txtTitle), new System.Data.SqlClient.SqlParameter(@txtPress, txtPress));

}
else if (!string.IsNullOrEmpty(txtAuthor) && !string.IsNullOrEmpty(txtPress))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtAuthor, txtAuthor), new System.Data.SqlClient.SqlParameter(@txtPress, txtPress));
}
else if (!string.IsNullOrEmpty(txtTitle) && !string.IsNullOrEmpty(txtAuthor) && !string.IsNullOrEmpty(txtPress))
{
dt = SqlHelper.ExecuteDataTable(sql, new System.Data.SqlClient.SqlParameter(@txtTitle, txtTitle), new System.Data.SqlClient.SqlParameter(@txtAuthor, txtAuthor), new System.Data.SqlClient.SqlParameter(@txtPress, txtPress));

}

dt = SqlHelper.ExecuteDataTable(sql);

if (dt.Rows.Count > 0)
{
// lblShow.Text = "";

//object[] datas = new object[dt.Rows.Count];
//for (int i = 0; i < datas.Length; i++)
//{
// System.Data.DataRow row = dt.Rows[i];
// DateTime addDT = (DateTime)row["AddTime"];
// datas[i] = new { BookId = row["BookId"], BookAuthor = row["BookAuthor"], Publisher = row["Publisher"], PublishDate = addDT.ToString(), BookPrice = row["BookPrice"], ItemName = row["ItemName"], ItemImage = row["ItemImage"] };
//}, ListPrice = row["ListPrice"]
//string json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(datas);

object[] comments = new object[dt.Rows.Count];
for (int i = 0; i < comments.Length; i++)
{
System.Data.DataRow row = dt.Rows[i];
DateTime creatDT = (DateTime)row["PublishDate"];
comments[i] = new { BookId = row["BookId"], BookAuthor = row["BookAuthor"], Publisher = row["Publisher"], PublishDate = creatDT.ToString("yyyy-MM-dd"), img = row["ItemImage"], ListPrice = row["ListPrice"], ItemName = row["ItemName"] };
}
string json = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(comments);

context.Response.Write(json);

}
else if (dt.Rows.Count <= 0)
{

context.Response.Write("error_1");
}

}

public bool IsReusable {
get {
return false;
}
}

}