departform.aspx.cs

商机管理系统

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;


public partial class depart_users_departform : System.Web.UI.Page
{
    DataSet ds1 = new DataSet();
    string sqlstr = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            HiddenField1.Value = "0";
            if (Request.QueryString["did"] != null)
            {
                HiddenField1.Value = Request.QueryString["did"];
            }

            if (GridView1.Rows.Count == 0)
            {
                norecord.Visible = true;
            }
            else
            {
                norecord.Visible = false;
            }

            string columdelete = MyCommon.getAuthorization();
            if (columdelete[0] == '1')
            {
                GridView1.Columns[4].Visible = true;
                GridView1.Columns[5].Visible = true;
                btn.Visible = true;
            }
            else
            {
                GridView1.Columns[4].Visible = false;
                GridView1.Columns[5].Visible = false;
                btn.Visible = false;
            }

        }
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string com;
        string did = GridView1.Rows[GridView1.SelectedIndex].Cells[1].Text;
        CreateDataSet();
        sqlstr = "";
        getTree(did);
        sqlstr = sqlstr + "departid=" + did;
        com = "delete from depart where " + sqlstr;
        SqlConnection sqlcon = new SqlConnection(MyCommon.getConnectstr());
        SqlCommand sqlcom = new SqlCommand(com, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.DataBind();
    }

    private void CreateDataSet()
    {
        ds1.Clear();
        ds1.Dispose();
        string connectstr = MyCommon.getConnectstr();
        SqlConnection myConn = new SqlConnection(connectstr);
        SqlCommand myCmd = new SqlCommand("select departid,parentid,name from depart");
        SqlDataAdapter myDataAdpter = new SqlDataAdapter();
        myCmd.Connection = myConn;
        myDataAdpter.SelectCommand = myCmd;
        myConn.Open();
        myDataAdpter.Fill(ds1, "depart1");
        myConn.Close();
    }

    private void getTree(string parentid)
    {
        DataView dv = new DataView();
        dv.Table = ds1.Tables["depart1"];
        dv.RowFilter = "parentid=" + parentid + "";
        string strId;
        foreach (DataRowView drv in dv)
        {
            strId = drv["departid"].ToString();
            sqlstr = sqlstr + "departid =" + strId + " or ";
            getTree(strId);
        }
    }

}