adminhangye.aspx.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using BLL;

public partial class AdminHangYe : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack ){
            if (!(Session["UserName"] != null && Session["UserRole"] == "Admin"))
            {
                Response.Redirect("../Default.aspx");
            }
            BindZhuanYeData();
            BindHangYeData();
        }
        
    }
    protected void BindZhuanYeData() {
        drlZhuanYe.DataSource = ZhuanYe.GetAllZhuanYe();
        drlZhuanYe.DataValueField = "ZhuanYeId";
        drlZhuanYe.DataTextField = "MingCheng";
        drlZhuanYe.DataBind();
    }

    protected void BindHangYeData() {

        dgHangYe.DataSource = HangYe.GetHangYeByZhuanYe(drlZhuanYe .SelectedValue );
        dgHangYe.DataBind();
    }
    protected void dgHangYe_EditCommand(object source, DataGridCommandEventArgs e)
    {
        dgHangYe.EditItemIndex = e.Item.ItemIndex;
        BindHangYeData();
    }
    protected void dgHangYe_CancelCommand(object source, DataGridCommandEventArgs e)
    {
        dgHangYe.EditItemIndex = -1;
        BindHangYeData();
    }
    protected void dgHangYe_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
        {
            LinkButton btDelete = (LinkButton)e.Item.Cells[2].Controls[0];
            btDelete.Attributes.Add("onclick", "javascript:return confirm('你确定要删除吗？');");
            e.Item.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='E8F4FF'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");


        }

    }
    protected void dgHangYe_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        RequiredFieldValidator2.Enabled = false;
        HangYe HY = new HangYe();
        HY.HangYeId = Convert.ToInt32(dgHangYe.DataKeys[e.Item.ItemIndex]);
        HY.DeleteRelf();
        BindHangYeData();
        RequiredFieldValidator2.Enabled = true;
    }
    protected void dgHangYe_UpdateCommand(object source, DataGridCommandEventArgs e)
    {
        RequiredFieldValidator2.Enabled = false;
        HangYe HY = new HangYe();
        HY.HangYeId = Convert.ToInt32(dgHangYe.DataKeys[e.Item.ItemIndex]);
        TextBox tb;
        tb = (TextBox)e.Item.FindControl("tbMC"); ;
        HY.MingCheng = tb.Text.Trim();
        HY.UpdateRelf();
        dgHangYe.EditItemIndex = -1;
        BindHangYeData();
        RequiredFieldValidator2.Enabled = true;
    }
    protected void drlZhuanYe_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindHangYeData();
    }
    protected void btAdd_Click(object sender, EventArgs e)
    {
        if(!RequiredFieldValidator2 .IsValid )return;
        HangYe HY = new HangYe();
        HY.MingCheng = tbHangYeMC.Text.Trim();
        HY.ZhuanYeId = Convert.ToInt32 (drlZhuanYe.SelectedValue);
        string JS;
        if (HY.InsertRelf() > 0)
        {
            BindHangYeData();
            JS = "<script type='text/javascript'>window.alert('添加成功!')</script>";
            this.ClientScript.RegisterStartupScript(this.GetType(), "SC", JS);
        }
        else
        {
            JS = "<script type='text/javascript'>window.alert('添加失败!')</script>";
            this.ClientScript.RegisterStartupScript(this.GetType(), "FT", JS);
        }
    }
}