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


    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() > 0)
            {
                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() > 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>";
            }
        }
    }
    C#
    <%@ 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() > 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");
    
        }
    }
    c#删除
  • 相关阅读:
    NoSQL数据库 continue posting...
    CAP 理论
    Clojure Web 开发 (一)
    HttpClient 4.0.x Tips
    zZ Java中String和Byte[]之间的那些事
    使用nhibernate出现Could not find the dialect in the configuration
    eclipse导入项目出现Project has no default.properties file! Edit the project properties to set one.
    今天开通此博~
    美国白蛾入侵北京 GIS兵法破解危局
    HTML5 存取Json
  • 原文地址:https://www.cnblogs.com/981971554nb/p/4738919.html
Copyright © 2020-2023  润新知