Web 1三级联动下拉框 2添加修改删除弹框

2022-09-15 18:47:45

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();

    }

}

三级联动下拉C#

<%@ 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>

三级联动下拉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() > )

        {

            Info data = query.First();

            //2.告诉上下文

            _Context.Work.DeleteAllOnSubmit(data.Work);

            _Context.Family.DeleteAllOnSubmit(data.Family);

            _Context.Info.DeleteOnSubmit(data);

            //3.提交

            _Context.SubmitChanges();

        }

        Show();

    }

}

添加修改删除主界面 C#

<%@ 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>

添加界面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");

    }

}

添加界面C#

<%@ 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>

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() > )

        {

            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() > )

        {

            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>

删除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() > )

        {

            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");

    }

}

c#删除

码农公寓

相关文章