Web 三级联动 下拉框
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { private MyDBDataContext _Context = new MyDBDataContext(); private void FillProd() { List<Productor> list = _Context.Productor.ToList(); ddlProd.DataSource = list; ddlProd.DataTextField = "Prod_Name"; ddlProd.DataValueField = "Prod_Code"; ddlProd.DataBind(); } private void FillBrand() { string prodCode = ddlProd.SelectedValue; List<Brand> list = _Context.Brand.Where(p=>p.Prod_Code == prodCode).ToList(); ddlBrand.DataSource = list; ddlBrand.DataTextField = "Brand_Name"; ddlBrand.DataValueField = "Brand_Code"; ddlBrand.DataBind(); } private void FillCar() { string brandCode = ddlBrand.SelectedValue; List<Car> list = _Context.Car.Where(p=>p.Brand == brandCode).ToList(); ddlCar.DataSource = list; ddlCar.DataTextField = "Name"; ddlCar.DataValueField = "Code"; ddlCar.DataBind(); } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillProd(); FillBrand(); FillCar(); } } protected void ddlProd_SelectedIndexChanged(object sender, EventArgs e) { FillBrand(); FillCar(); } protected void ddlBrand_SelectedIndexChanged(object sender, EventArgs e) { FillCar(); } }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="ddlProd" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlProd_SelectedIndexChanged"> </asp:DropDownList> <asp:DropDownList ID="ddlBrand" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlBrand_SelectedIndexChanged"> </asp:DropDownList> <asp:DropDownList ID="ddlCar" runat="server"> </asp:DropDownList> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; /// <summary> /// Info 的摘要说明 /// </summary> public partial class Info { public string SexName { get { if (this.Sex.Value == true) return "男"; else return "女"; } } public string NationName { get { return this.Nation1 .Name; } } }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> <style type="text/css"> .trover { background-color:green; } </style> <script language="javascript"> function doOver(tr) { //tr.style.backgroundColor = "yellow"; tr.className = "trover"; } function doOut(tr) { //tr.style.backgroundColor = ""; tr.className = ""; } </script> </head> <body> <form id="form1" runat="server"> <ul id="uu"></ul> <div> <asp:Repeater ID="Repeater1" runat="server" > <HeaderTemplate> <table width="100%" border="1"> </HeaderTemplate> <FooterTemplate> </table> </FooterTemplate> <ItemTemplate> <tr onmouseover="doOver(this)" onmouseout="doOut(this)"> <td><%# Eval("Code") %></td> <td><%# Eval("Name") %></td> <td><%# Eval("SexName") %></td> <td><%# Eval("NationName") %></td> <td><%# Eval("Birthday","{0:yyyy年MM月dd日}") %></td> <td> <%--<a href="Edit.aspx?id=<%# Eval("Code") %>">修改</a>--%> <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="#" onclick="<%# ShowClickScript() %>">修改</asp:HyperLink> <a href="Delete.aspx?id=<%# Eval("Code") %>" onclick="return confirm('确认要删除吗?')" >删除</a> <asp:Button ID="Button1" OnClick="Button1_Click" CommandArgument="<%# SetKey() %>" runat="server" Text="删除" /> </td> </tr> </ItemTemplate> </asp:Repeater> </div> <asp:HyperLink ID="HyperLink2" runat="server" onclick="window.open('Add.aspx','_blank','width=300 height=300');return false;" NavigateUrl="#">添加</asp:HyperLink> </form> </body> </html> <script language="javascript"> var li = document.createElement("li"); li.innerHTML = "苹果" document.getElementById("uu").appendChild(li); alert( "asdfasdf" ); document.getElementById("uu").removeChild(li); </script>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Default2 : System.Web.UI.Page { private MyDBDataContext _Context = new MyDBDataContext(); public string SetKey() { return Eval("Code").ToString(); } public string ShowClickScript() { string url = "Edit.aspx?id=" + Eval("Code"); string s = "window.open('"+url+"','_blank','width=300 height=300');return false;"; return s; } public string ShowHref() { return "Edit.aspx?id=" + Eval("Code"); } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Show(); } } private void Show() { //查数据 List<Info> list = _Context.Info.ToList(); //填进去 Repeater1.DataSource = list; Repeater1.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { //删除的代码。 //找到被点击的删除按钮 Button btn = (Button)sender; //找到按钮上的主键值 string code = btn.CommandArgument.ToString(); //删除 //1.找到要删除的对象 var query = _Context.Info.Where(p => p.Code == code); if (query.Count() > 0) { Info data = query.First(); //2.告诉上下文 _Context.Work.DeleteAllOnSubmit(data.Work); _Context.Family.DeleteAllOnSubmit(data.Family); _Context.Info.DeleteOnSubmit(data); //3.提交 _Context.SubmitChanges(); } Show(); } }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Add.aspx.cs" Inherits="Add" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <h1>添加</h1> <form id="form1" runat="server"> <div> 代号:<asp:TextBox ID="txtCode" runat="server" Text=""></asp:TextBox> <br /> 姓名:<asp:TextBox ID="txtName" runat="server"></asp:TextBox> <br /> 性别:<asp:RadioButtonList ID="txtSex" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow"> <asp:ListItem Value="True">男</asp:ListItem> <asp:ListItem Value="False">女</asp:ListItem> </asp:RadioButtonList> <br /> 民族:<asp:DropDownList ID="txtNation" runat="server"> </asp:DropDownList> <br /> 生日:<asp:TextBox ID="txtBirthday" runat="server"></asp:TextBox> <br /> <br /> <asp:Button ID="btnOK" runat="server" Text="添加" OnClick="btnOK_Click" /> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="返回" /> </div> <div> <asp:Literal ID="Literal1" runat="server"></asp:Literal> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Add : System.Web.UI.Page { private MyDBDataContext _Context = new MyDBDataContext(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillNation(); } } private void FillNation() { List<Nation> list = _Context.Nation.ToList(); txtNation.DataSource = list; txtNation.DataTextField = "Name"; txtNation.DataValueField = "Code"; txtNation.DataBind(); } protected void btnOK_Click(object sender, EventArgs e) { //把界面上的值取出来 string code = txtCode.Text; string name = txtName.Text; bool sex = Convert.ToBoolean(txtSex.SelectedValue); string nation = txtNation.SelectedValue; DateTime birthday = Convert.ToDateTime(txtBirthday.Text); //送到数据库中去 //1.造个对象 Info data = new Info(); data.Code = code; data.Name = name; data.Sex = sex; data.Nation = nation; data.Birthday = birthday; //2.告诉上下文 _Context.Info.InsertOnSubmit(data); //3.提交 _Context.SubmitChanges(); //跳转 //Response.Redirect("Default2.aspx"); Literal1.Text = "<script language=javascript>window.opener.location.reload();window.close();</script>"; } protected void Button1_Click(object sender, EventArgs e) { Response.Redirect("Default2.aspx"); } }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Edit.aspx.cs" Inherits="Edit" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <form id="form1" runat="server"> <div> <h1>修改</h1> <div> 代号:<asp:Label ID="txtCode" runat="server" Text="Label"></asp:Label> <br /> 姓名:<asp:TextBox ID="txtName" runat="server"></asp:TextBox> <br /> 性别:<asp:RadioButtonList ID="txtSex" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow"> <asp:ListItem Value="True">男</asp:ListItem> <asp:ListItem Value="False">女</asp:ListItem> </asp:RadioButtonList> <br /> 民族:<asp:DropDownList ID="txtNation" runat="server"> </asp:DropDownList> <br /> 生日:<asp:TextBox ID="txtBirthday" runat="server"></asp:TextBox> <br /> <br /> <asp:Button ID="btnOK" runat="server" Text="更新" OnClick="btnOK_Click" /> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="返回" /> <asp:Literal ID="Literal1" runat="server"></asp:Literal> </div> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Edit : System.Web.UI.Page { private MyDBDataContext _Context = new MyDBDataContext(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillNation(); //填充民族 LoadInfo(); //加载人员信息 } } private void LoadInfo() { //获取要修改的人员值 string code = Request["id"]; //查出来 var query = _Context.Info.Where(p => p.Code == code); if (query.Count() > 0) { Info data = query.First(); //填进去 txtCode.Text = data.Code; txtName.Text = data.Name; txtSex.SelectedValue = data.Sex.ToString(); txtNation.SelectedValue = data.Nation; txtBirthday.Text = data.Birthday.Value.ToString("yyyy-MM-dd"); } } private void FillNation() { List<Nation> list = _Context.Nation.ToList(); txtNation.DataSource = list; txtNation.DataTextField = "Name"; txtNation.DataValueField = "Code"; txtNation.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { Response.Redirect("Default2.aspx"); } protected void btnOK_Click(object sender, EventArgs e) { //把界面上的值取出来, string code = txtCode.Text; string name = txtName.Text; bool sex = Convert.ToBoolean(txtSex.SelectedValue); string nation = txtNation.SelectedValue; DateTime birthday = Convert.ToDateTime(txtBirthday.Text); //送加数据库 //1.查询要修改的对象 var query = _Context.Info.Where(p=>p.Code == code); if (query.Count() > 0) { Info data = query.First(); //2.把值修改一下。 data.Name = name; data.Sex = sex; data.Nation = nation; data.Birthday = birthday; //3.提交送回数据 _Context.SubmitChange() _Context.SubmitChanges(); //跳转 //Response.Redirect("Default2.aspx"); Literal1.Text = "<script language=javascript>window.opener.location.reload();window.close();</script>"; } } }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Delete.aspx.cs" Inherits="Delete" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <form id="form1" runat="server"> <div> </div> </form> </body> </html>
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 { private MyDBDataContext _Context = new MyDBDataContext(); protected void Page_Load(object sender, EventArgs e) { //找出主键值 string code = Request["id"]; //删除 //1.找到要删除的对象 var query = _Context.Info.Where(p=>p.Code == code); if (query.Count() > 0) { Info data = query.First(); //2.告诉上下文 _Context.Work.DeleteAllOnSubmit(data.Work); _Context.Family.DeleteAllOnSubmit(data.Family); _Context.Info.DeleteOnSubmit(data); //3.提交 _Context.SubmitChanges(); } //跳转 Response.Redirect("Default2.aspx"); } }