服务器超时问题。在线等
if (!this.IsPostBack)
  {
   
  //字段排序操作

  int sumPage;
  int pageNo = 1;
  int pageSize = 10;
  if (Request.QueryString["CurrentPage"] == null)
  {
  pageNo = 1;
  }
  else
  {
  pageNo = Int32.Parse(Request.QueryString["CurrentPage"]);
  }
  string tablist = "a.id,a.jobname,a.jobcode,a.recruiter,a.manager,typeid,a.region,convert(varchar(20),a.intime,23) as intime,a.edittime,a.xmsession,a.department,(select count(b.xmid) as num1 from cvsession b,cvresume c where b.xmid = a.id and b.cvsession = '已申请' and c.id = b.cvid) as num1,(select count(b.xmid) as num1 from cvsession b,cvresume c where b.xmid = a.id and b.cvsession != '已申请' and c.id = b.cvid) as num2,(select count(b.xmid) as num1 from cvsession b,cvresume c where b.xmid = a.id and c.id = b.cvid) as num3,(select count(id) as num from colog where xmid=a.id) as lognum";
  string tabname = "xm a";
  string wh = "company = '" + Session["company"].ToString() + "'";
  string keywords = Server.UrlDecode(function.Filter(function.Vall("keywords")));
  if (keywords != null && keywords != "" && keywords != "请输入职位筛选关键字")
  {
  string[] key = keywords.Split(' ');
  for (int i = 0; i < key.Length; i++)
  {
  wh = wh + " and (CONTAINS(*, '" + key[i] + "' ) or jobcode like '%" + key[i] + "%')";
  }
  }
  string recruiters = Server.UrlDecode(function.Vall("recruiters"));
  if (recruiters != "")
  {
  wh = wh + " and a.recruiter like '%," + recruiters + ",%'";
  }
  string departments = Server.UrlDecode(function.Vall("departments"));
  if (departments != "")
  {
  wh = wh + " and a.department = '" + departments + "'";
  }
  string xmsessions = Server.UrlDecode(function.Vall("xmsessions"));
  if (xmsessions != "")
  {
  wh = wh + " and a.xmsession = '" + xmsessions + "'";
  }
  if (limit == "0")
  {
  string us = "";
  string mySql1 = "select username from colist where id = '" + Session["coid"].ToString() + "'";
  SqlCommand myCmd1 = new SqlCommand(mySql1, myConn);
  myCmd1.Connection.Open();
  SqlDataReader dr1 = myCmd1.ExecuteReader();
  if (dr1.Read())
  {
  us = "," + dr1["username"].ToString().Trim() + ",";
  }
  dr1.Close();
  myCmd1.Connection.Close();

  wh = wh + " and recruiter like '%" + us + "%'";
  }
  SqlDataAdapter da = new SqlDataAdapter();
  da.SelectCommand = new SqlCommand();
&nbs