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#删除

 

posted @ 2015-08-18 13:08  奔跑的小黄鸡  阅读(462)  评论(1)  编辑  收藏  举报