infomanage.aspx.cs

asp.net 2.0的教务管理软件源码

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

public partial class Admin_InfoManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        myCodeTree.CodeSelected += new uctl_CodeTree.CodeSelectedEventHander(ShowDataView);
        if (!IsPostBack)
        {
            int parentCode = myCodeTree.Value;
            ShowDataView(parentCode);
        }
    }

    protected void ShowDataView(int pID)
    {
        int parentCode = pID;
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add("ac_ParentCode", parentCode.ToString());
        GridView1.DataBind();
        Label2.Text = myCodeTree.Path;
        myCodeTree.Value = pID;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
            int order = CommOp.ToInt(txtOrder.Text);
            int parentCode = myCodeTree.Value;
            String sql = "INSERT INTO J_AllCode(ac_Order,ac_Name,ac_ParentCode) VALUES ("+order+",'"+txtName.Text+"',"+parentCode+")";
            DBExec.ExecNonQuery(sql);
            Label1.Text = "新增成功！";
            txtOrder.Text = (order + 1).ToString();
            txtName.Text = "";
            ShowDataView(parentCode);
    }
    protected void btnMove_Click(object sender, EventArgs e)
    {
        string selectedCodes = CommOp.ToStr(Request["CheckBox1"]);
        int parentCode = tpAllCode.SelectedValue;
        if (selectedCodes!="")
        {
            String sql = "UPDATE J_AllCode SET ac_ParentCode="+parentCode+" WHERE ac_Code in (" + selectedCodes + ")";
 //           Response.Write(sql);
            DBExec.ExecNonQuery(sql);
            ShowDataView(parentCode);
        }
    }

    protected void btnDelete_Click(object sender, EventArgs e)
    {
        string selectedCodes = Request["CheckBox1"].Trim();
        if (selectedCodes != "")
        {
            String sql = "DELETE FROM J_AllCode WHERE ac_Code IN (" + selectedCodes + ")";
            DBExec.ExecNonQuery(sql);
            ShowDataView(myCodeTree.Value);
        }
    }
    protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        Label3.Text = "共" + e.AffectedRows + "条";
    }
    protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {
        if (e.Exception != null)
            CommOp.ShowError("Delete_KeyWord_Error");
    }
}