<%@ WebHandler Language="C#" Class="CheckPriKey" Debug="true" %>
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.IO;
using eMIS.Data;
using System.Data.Common;
using System.Text;
using System.Web.SessionState;
using eMIS;
using System.Text.RegularExpressions;
public class CheckPriKey : IHttpHandler, IRequiresSessionState
{
public void ProcessRequest (HttpContext context)
{
string searchWord = context.Request.QueryString["sw"].ToString();
//string condition = context.Request.QueryString["c"].ToString();
int pageIndex = int.Parse(context.Request.QueryString["pi"].ToString());
bool b = false;
if (searchWord != "")
{
string f = searchWord.Substring(0, 1);
System.Text.RegularExpressions.Regex reg1 = new System.Text.RegularExpressions.Regex(@"^[A-Za-z]+$");
b = reg1.IsMatch(f);
}
DataManager dm = new DataManager();
StringBuilder sb = new StringBuilder();
sb.Append("");
//string defaultCondition = control.GetDataFieldConditionSql; //inst.DefaultCondition;
//if (defaultCondition == "")
string defaultCondition = "1=1";
//if (pageType == "0")
// defaultCondition = "1=1";
string sql = "1=1";
if (searchWord != "")
{
if (b)
{
sql = "sp like '%" + searchWord + "%'";
}
else
{
sql = "xingming like '%" + searchWord + "%'";
}
}
DataTable dt= dm.Operator.ExecuteProcedureTable("pagers2", pageIndex, 10,"id", "id,xingming" ,"com_yhb", sql , "order by xingming");
//DbDataReader reader = inst.BusinessDbOperator.ExecuteReader(sql);
//i = 1;
int l = dt.Rows.Count;
int i;
int total = l/10 + ((l % 10==0)?0:1);
for(i=0;i< l;i++)
{
sb.Append("| " + dt.Rows[i][1].ToString() + " |
");
}
if(l==0)
sb.Append("| 无 |
");
else
sb.Append(" |
");
sb.Append("");
context.Response.Write(sb.ToString());
}
public bool IsReusable
{
get
{
return false;
}
}
}