showusers.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 users_users : System.Web.UI.Page
{
    DataSet ds = new DataSet();
    static string sqlstr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string did = "0";
            if (Request.QueryString["did"] != null)
            {
                did = Request.QueryString["did"];
            }
            //Hid_Did.Value = did;
            CreateDataSet();
            sqlstr = "";
            getTree(did);
            sqlstr += "u_departid =" + did;
            //sqlstr = sqlstr.TrimEnd(tmpstr.ToCharArray());
            GridView1.DataSource = getDataSource(sqlstr);
            GridView1.DataBind();
        }
    }

    private void CreateDataSet()
    {
        ds.Clear();
        ds.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(ds, "depart");
        myConn.Close();
    }

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

    private SqlDataSource getDataSource(string str)
    {
        SqlDataSource sds = new SqlDataSource();
        sds.ConnectionString = MyCommon.getConnectstr();
        sds.SelectCommand = "SELECT userid, username, logname, password, roleid, unit, grid, nodeid, u_departid, id, departid, parentid, name FROM" +
        " user_depart WHERE " + str;
        //sds.SelectCommand = "select * from user_depart";
        return sds;
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.ID = e.Row.Cells[0].Text;
            e.Row.Attributes.Add("onclick",
            "GridView_selectRow(this,'" + e.Row.Cells[1].Text + "')");
            e.Row.Attributes.Add("onmouseover", "GridView_mouseHover(this)");
        }

    }
    protected void Btn_Confirm_Click(object sender, EventArgs e)
    {

    }
}