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 Delete : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(Session["uid"]!="")
{

if(!IsPostBack)
{ InfoDataContext context = new InfoDataContext();

//取主键值
string code=Request["code"].ToString();

//查出该条数据
Info data = context.Info.Where(p=>p.Code==code).First();
//删除
//先删除外键值
var queryw = context.Work.Where(p=>p.InfoCode==code);
context.Work.DeleteAllOnSubmit(queryw);
var queryf = context.Family.Where(p=>p.InfoCode==code);
context.Family.DeleteAllOnSubmit(queryf);

//再删除本身值
context.Info.DeleteOnSubmit(data);
//提交改动
context.SubmitChanges();

//返回
Response.Redirect("Main.aspx");
}
}
else
{
Response.Redirect("denglu.aspx");
}


}
}

posted @ 2015-12-22 10:10  小热包1  阅读(131)  评论(0编辑  收藏  举报