|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/30d84c9f/424ff89a/ |
?#pragma checksum "D:\wwwroot\nuoya\wwwroot\people.aspx.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "5913D8F7798470E59B20BE176B885D7F"
#line 1 "D:\wwwroot\nuoya\wwwroot\people.aspx.cs"
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;
public partial class people : System.Web.UI.Page
{
static string sql = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sql = "select top 1 * from jobs order by sort asc,id desc";
if (Request.QueryString["id"] != null)
{
sql = "select * from jobs where typeid=" + Request.QueryString["id"] + " order by sort asc,id desc";
}
DataTable dts1 = DBHelper.GetDataSet("select * from jobs where id=114 order by sort asc,id desc");
Repeater1.DataSource = dts1;
Repeater1.DataBind();
DataTable dts2 = DBHelper.GetDataSet("select top 4 * from jobs where typeid=141 order by sort asc,id desc");
Repeater2.DataSource = dts2;
Repeater2.DataBind();
DataTable dts3 = DBHelper.GetDataSet("select top 1 * from jobs where typeid=140 order by sort asc,id desc");
Repeater3.DataSource = dts3;
Repeater3.DataBind();
DataTable dts4 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 1 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater4.DataSource = dts4;
Repeater4.DataBind();
DataTable dts5 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 3 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater5.DataSource = dts5;
Repeater5.DataBind();
DataTable dts6 = DBHelper.GetDataSet("select top 1 * from jobs where typeid=140 and id not in(select top 5 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater6.DataSource = dts6;
Repeater6.DataBind();
DataTable dts7 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 6 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater7.DataSource = dts7;
Repeater7.DataBind();
DataTable dts8 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 8 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater8.DataSource = dts8;
Repeater8.DataBind();
DataTable dts9 = DBHelper.GetDataSet("select top 1 * from jobs where typeid=140 and id not in(select top 10 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater9.DataSource = dts9;
Repeater9.DataBind();
DataTable dts10 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 11 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater10.DataSource = dts10;
Repeater10.DataBind();
DataTable dts11 = DBHelper.GetDataSet("select top 2 * from jobs where typeid=140 and id not in(select top 13 id from jobs where typeid=140 order by sort asc,id desc) order by sort asc,id desc");
Repeater11.DataSource = dts11;
Repeater11.DataBind();
DataTable dts13 = DBHelper.GetDataSet("select * from xia where id=63 order by sort asc,id desc");
Repeater14.DataSource = dts13;
Repeater14.DataBind();
}
GetfdID();
info_bind(sql);
string tid = Request.QueryString["id"];
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
if (tid == null)
{
using (Managers ms = new Managers())
{
DataTable dt1 = DBHelper.GetDataSet("select * from t_configs");
Page.Title = "诺亚人——" + dt1.Rows[0]["name"].ToString();
// Label1.Text = "公司介绍";
// Label2.Text = "关于锦才";
}
}
else
{
using (Managers ms = new Managers())
{
DataTable dt2 = DBHelper.GetDataSet("select * from t_configs");
string a = dt2.Rows[0]["name"].ToString();
ds1 = ms.getlist("jobs", "*", 0, "id=" + tid, "");
string b = ds1.Tables[0].Rows[0]["title"].ToString();
Page.Title = b + "——" + a;
// Label1.Text = b;
// Label2.Text = b;
}
}
}
private void info_bind(string sql)
{
DataTable dt = DBHelper.GetDataSet(sql);
////设置分页
//AspNetPager1.RecordCount = dt.Rows.Count; //纪录总数
PagedDataSource pd = new PagedDataSource();
pd.DataSource = dt.DefaultView;
//pd.AllowPaging = true; //数据源允许分页
//pd.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; //显示当前页
//pd.PageSize = AspNetPager1.PageSize; //取控件的分页大幼
// Repeater2.DataSource = pd;
// Repeater2.DataBind();
}
/// <summary>
/// 为网站设置关键字的搜索
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string getwebInfo(string id)
{
OLEControl mc = new OLEControl();
DataTable dt1 = DBHelper.GetDataSet("select * from t_configs where id=" + id + "");
StringBuilder sb = new StringBuilder();
// DataTable dt = mc.ExecuteDataTable("select * from t_configs where id=" + id + "");
foreach (DataRow dr in dt1.Rows)
{
//sb.Append("<title>");
//sb.Append(dr["name"]);
//sb.Append("</title>");
sb.Append("<meta name=\"keywords\" content=\"");
sb.Append(dr["keyword"]);
sb.Append("\" />");
sb.Append("<meta name=\"description\" content=\"");
sb.Append(dr["content"]);
sb.Append("\" />");
}
return sb.ToString();
}
//给二级菜单点击后增长布景致
public string fdid = "";
public string GetfdID()
{
string tid1 = Request.QueryString["id"];
fdid = tid1;
return fdid;
}
}
#line default
#line hidden