adminxiangmuinfoadd.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 System.Data.SqlClient;
using BLL;

public partial class AdminXiangMuInfoAdd : System.Web.UI.Page
{
    SQLHelper sqlHelper = new SQLHelper();
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["YGId"] != null)
        {
            ViewState["YGId"] = Request.QueryString["YGId"];
        }
        if(!IsPostBack ){
            if (!(Session["UserName"] != null && Session["UserRole"] == "Admin"))
            {
                Response.Redirect("../Default.aspx");
            }
            
            BindZhuanYeData();
            BindHangYeData(drlZhuanYe .SelectedValue );
            BindGeRenXMData(Request .QueryString ["YGId"].ToString ());
            ViewState["YGId"] = Request.QueryString["YGId"];
        }
    }

    protected void BindZhuanYeData() {
        drlZhuanYe.DataSource = ZhuanYe.GetAllZhuanYe();
        drlZhuanYe.DataTextField = "MingCheng";
        drlZhuanYe.DataValueField = "ZhuanYeId";
        drlZhuanYe.DataBind();
    }

    protected void BindHangYeData(string ZhuanYeId) {
        if(rblHangYe .Items .Count >0){
            rblHangYe.Items.Clear();
        }
        rblHangYe.DataSource = HangYe.GetHangYeByZhuanYe(ZhuanYeId);
        rblHangYe.DataTextField = "MingCheng";
        rblHangYe.DataBind();
    }

    protected void drlZhuanYe_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindHangYeData(drlZhuanYe.SelectedValue);
    }
    protected void btFaBu_Click(object sender, EventArgs e)
    {
        XiangMu XM = new XiangMu();
        XM.MingCheng = tbMingCheng.Text.Trim();
        XM.ShiJian = drlShiJianYue.SelectedItem.Value + "/1/" + tbShiJianNian.Text.Trim();
        XM.DiDian = tbDiDian.Text.Trim();
        XM.ZhuanYe = drlZhuanYe.SelectedItem.Text ;
        XM.HangYe = rblHangYe.SelectedItem.Value;
        XM.JianJie = ftbContent.Text.Trim();
        XM.FuZeRenId = Convert.ToInt32(ViewState ["YGId"]);
        string JS = "";
        if (XM.InsertData() > 0)
        {
            BindGeRenXMData(ViewState["YGId"].ToString());
            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);
        }
    }

    protected void dgGeRenXM_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            LinkButton btDelete = (LinkButton)e.Item.Cells[3].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   BindGeRenXMData(string YGId){
        string sql = "select XMId,MingCheng,XMZhuanYe from GeRenXMV where YGId="+YGId ;
        sqlHelper.RunSQL(sql,out dr);
        dgGeRenXM.DataSource = dr;
        dgGeRenXM.DataBind();
        dr.Close();
    }
    protected void dgGeRenXM_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        string sql = "delete from XiangMuInfo where XMId="+dgGeRenXM .DataKeys [e.Item .ItemIndex ].ToString ();
        sqlHelper.RunSQL(sql);
        BindGeRenXMData(ViewState ["YGId"].ToString ());
    }
}