12.22 repeater 主页

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Main : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

if (Session["uid"] != null)//如果数据库有数据跳转到主界面
{
if (!IsPostBack)//判断是否刷新
{

InfoDataContext context = new InfoDataContext();

//指定数据源
Repeater1.DataSource = context.Info;
Repeater1.DataBind();

}
}
else//如果没有数据发回到等录界面
{
Response.Redirect("denglu.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//按照代号和姓名查询
//取所有数据
InfoDataContext context = new InfoDataContext();
List<Info> list= context.Info.ToList();

//取第一个查询条件
string code=txtCode.Text;
if( code!="")
{
list=list.Where(p=>p.Code==code).ToList();
}
//取第二个查询条件
string name=txtName.Text;
if( name!="")
{
list = list.Where(p => p.Name.Contains(name)).ToList();
}

//给repeater做数据源
Repeater1.DataSource = list;
Repeater1.DataBind();

}
//造显示性别函数
public string ShowSex()
{
return Convert.ToBoolean(Eval("Sex"))?"男":"女";

}
//造显示民族的函数
public string ShowNation()
{

InfoDataContext context = new InfoDataContext();

string code= Eval("Nation").ToString();

return context.Nation.Where(p=>p.Code==code).First().Name;

}
//造显示生日的函数
public string ShowBirthday()
{
return Convert.ToDateTime(Eval("Birthday")).ToString("yyyy年MM月dd日");

}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("Insert.aspx");
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{

}
}