物业客户管理信息系统（七）之员工主窗体~2

第二部分的员工主窗体代码，这次的主窗体代码可是足量的啊，老师看到了都吓坏啦，当时，还问这个只是主窗体的代码吗？我说是的。呵呵，其实重复代码很多这里面，而且有些是注释了的代码，但是因为当时可能会用到所以就一直没有删除，知道最后就干脆不删除了，就那么办。这个物业客户关系管理信息系统是我的第一个较为完整的程序吧，虽然花了很多的精力，但是最终还是评优了，而且我的界面做得也不错。当时在网上找的一张图片然后自己用PS处理的。而且根据不同的界面进行了设置，不过大体是一样的。

//选中——————TreeView
private void treeview_left_AfterSelect(object sender, EventArgs e)      //点击treeview所触发的函数
{
    isonce = true;
    listview_columns();
    if (treeview_left.SelectedNode == null)      //判断是否选中了树节点
    {
        switch (splitcon1.Tag.ToString())
        {
            case “sy”:
                tempint = 0;
                tempsql = “select * from zhufang”;
                iswhere = false;
                UpdateListview(tempsql);
                break;
            case “yz”:
                tempint = 0;
                tempsql = “select * from yezhu”;
                iswhere = false;
                UpdateListview(tempsql);
                break;
            case “yg”:
                tempint = 0;
                tempsql = “select * from yuangong”;
                iswhere = false;
                UpdateListview(tempsql);
                break;
            case “yw”:
                break;
        }
        //return;
    }
    else
    {
        SelectNode = treeview_left.SelectedNode;        //把当前选中的节点赋值给SelectNode
        treeview_left.MouseDown += new MouseEventHandler(treeview_left_MouseDown);
        switch (splitcon1.Tag.ToString())
        {
            case “sy”:
                //当鼠标位于控件treeView上并按下鼠标键时，加载treeview_MouseDown的函数
                DataSet DSet = SQLClass.getDataSet(“select id from kaifashang where id = ‘” + treeview_left.SelectedNode.Name + “‘ and gongsi = ‘” + treeview_left.SelectedNode.Text + “‘”, “开发商信息表”);
                DataTable dt = DSet.Tables[“开发商信息表”];
                if (dt.Rows.Count > 0)
                {
                    //treeview_left.Nodes[treeview_left.SelectedNode.Name].Nodes.Clear();
                    DataSet parentDSet = SQLClass.getDataSet(“select id from fangchan where kaifashangid = ‘” + treeview_left.SelectedNode.Name + “‘”, “楼盘信息表”);
                    DataTable parentdt = parentDSet.Tables[“楼盘信息表”];
                    if (parentdt.Rows.Count > 0)
                    {
                        tempint = 0;
                        for (int i = 0; i < parentdt.Rows.Count; i++)
                        {
                            if (tempint == 0)
                            {
                                tempsql = “select * from zhufang where fangchanid = ‘” + parentdt.Rows[i][0].ToString() + “‘”;
                            }
                            else
                            {
                                tempsql = tempsql + ” or fangchanid = ‘” + parentdt.Rows[i][0].ToString() + “‘”;
                            }
                            iswhere = true;
                            UpdateListview(“select * from zhufang where fangchanid = ‘” + parentdt.Rows[i][0].ToString() + “‘”);
                        }
                    }
                }
                else
                {
                    DataSet newDSet = SQLClass.getDataSet(“select id from fangchan where jianzu = ‘” + treeview_left.SelectedNode.Text + “‘”, “房产信息表”);
                    DataTable newdt = newDSet.Tables[“房产信息表”];
                    if (newdt.Rows.Count > 0)
                    {
                        tempint = 0;
                        for (int i = 0; i < newdt.Rows.Count; i++)
                        {
                            if (tempint == 0)
                            {
                                tempsql = “select * from zhufang where fangchanid = ‘” + newdt.Rows[i][0].ToString() + “‘”;
                            }
                            else
                            {
                                tempsql = tempsql + ” or fangchanid = ‘” + newdt.Rows[i][0].ToString() + “‘”;
                            }
                            iswhere = true;
                            UpdateListview(“select * from zhufang where fangchanid = ‘” + newdt.Rows[i][0].ToString() + “‘”);
                        }
                    }
                }
                break;
            case “yz”:
                tempint = 0;
                tempsql = “select * from yezhu where quanxian = ‘” + treeview_left.SelectedNode.Name + “‘”;
                iswhere = true;
                UpdateListview(tempsql);
                break;
            case “yg”:
                listview_right.Items.Clear();
                DataSet gwDSet = SQLClass.getDataSet(“select id from gangwei where gangwei = ‘” + treeview_left.SelectedNode.Text + “‘”, “岗位信息表”);
                DataTable gwdt = gwDSet.Tables[“岗位信息表”];
                if (gwdt.Rows.Count > 0)
                {
                    tempint = 0;
                    tempsql = “select * from yuangong where gangweiid = ‘” + treeview_left.SelectedNode.Name + “‘”;
                    iswhere = true;
                    UpdateListview(tempsql);
                }
                else
                {
                    DataSet ygDSet = SQLClass.getDataSet(“select id from gangwei where bumen = ‘” + treeview_left.SelectedNode.Text + “‘”, “部门信息表”);
                    DataTable ygdt = ygDSet.Tables[“部门信息表”];
                    if (ygdt.Rows.Count > 0)
                    {
                        tempint = 0;
                        for (int i = 0; i < ygdt.Rows.Count; i++)
                        {
                            tempsql = “select * from yuangong where gangweiid = ‘” + ygdt.Rows[i][0] + “‘”;
                            iswhere = true;
                            UpdateListview(tempsql);
                        }
                    }
                }
                break;
            case “yw”:
                switch (treeview_left.SelectedNode.Name)
                {
                    case “1”:
                        UpdateComboBox();
                        tempint = 0;
                        tempsql = “select * from richang”;
                        iswhere = false;
                        UpdateListview(tempsql);
                        break;
                    case “2”:
                        UpdateComboBox();
                        tempint = 0;
                        tempsql = “select * from fuwu”;
                        iswhere = false;
                        UpdateListview(tempsql);
                        break;
                    case “3”:
                        UpdateComboBox();
                        tempint = 0;
                        tempsql = “select * from shoufei”;
                        iswhere = false;
                        UpdateListview(tempsql);
                        break;
                }
                break;
        }
    }
}
//private void toolStripMenuItem_Click(object sender, EventArgs e)
//{
//    MessageBox.Show(“数据库连接失败！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
//鼠标按钮动作—————————–
private void treeview_left_MouseDown(object sender, MouseEventArgs e)
{
    this.treeview_left.ContextMenuStrip = conMenuStr_tree_1;
    conMenuStr_tree_1.Items.Clear();
    //创建一个矩形Rect，对初始化Rect的位置和大小
    switch(splitcon1.Tag.ToString())
    {
        case “sy”:
            ToolStripMenuItem addkaifashang = new ToolStripMenuItem(“添加开发商”);
            addkaifashang.Click += new EventHandler(添加开发商toolStripMenuItem_Click);
            conMenuStr_tree_1.Items.Add(addkaifashang);
            break;
        case “yg”:
            ToolStripMenuItem addgangwei = new ToolStripMenuItem(“添加岗位”);
            addgangwei.Click += new EventHandler(添加岗位toolStripMenuItem_Click);
            conMenuStr_tree_1.Items.Add(addgangwei);
            ToolStripMenuItem revisebumen = new ToolStripMenuItem(“修改部门”);
            ToolStripMenuItem deletebumen = new ToolStripMenuItem(“删除部门”);
            revisebumen.Click += new EventHandler(修改部门toolStripMenuItem_Click);
            deletebumen.Click += new EventHandler(删除部门toolStripMenuItem_Click);
            conMenuStr_tree_1.Items.Add(revisebumen);
            conMenuStr_tree_1.Items.Add(deletebumen);
            break;
    }
    Rectangle Rect = new Rectangle(SelectNode.Bounds.X, SelectNode.Bounds.Y, SelectNode.Bounds.Width, SelectNode.Bounds.Height);
    if (Rect.Contains(e.X, e.Y))     //如果鼠标停留在矩形内
    {
        //把treeview的右键菜单设置为contextMenuStrip
        switch (splitcon1.Tag.ToString())
        {
            case “sy”:
                //ToolStripMenuItem addkaifashang = new ToolStripMenuItem(“添加开发商”);
                //addkaifashang.Click += new EventHandler(添加开发商toolStripMenuItem_Click);
                //conMenuStr_tree_1.Items.Add(addkaifashang);
                DataSet DSet = SQLClass.getDataSet(“select id from kaifashang where id = ‘” + treeview_left.SelectedNode.Name + “‘ and gongsi = ‘” + treeview_left.SelectedNode.Text + “‘”, “开发商信息表”);
                DataTable dt = DSet.Tables[“开发商信息表”];
                if (dt.Rows.Count > 0)
                {
                    ToolStripMenuItem revisekaifashang = new ToolStripMenuItem(“修改开发商”);
                    ToolStripMenuItem lookkaifashang = new ToolStripMenuItem(“查看开发商”);
                    ToolStripMenuItem deletekaifashang = new ToolStripMenuItem(“删除开发商”);
                    revisekaifashang.Click += new EventHandler(修改开发商toolStripMenuItem_Click);
                    lookkaifashang.Click += new EventHandler(查看开发商toolStripMenuItem_Click);
                    deletekaifashang.Click += new EventHandler(删除开发商toolStripMenuItem_Click);
                    conMenuStr_tree_1.Items.Add(revisekaifashang);
                    conMenuStr_tree_1.Items.Add(lookkaifashang);
                    conMenuStr_tree_1.Items.Add(deletekaifashang);
                    ToolStripMenuItem addloupan = new ToolStripMenuItem(“添加楼盘”);
                    addloupan.Click += new EventHandler(添加楼盘toolStripMenuItem_Click);
                    conMenuStr_tree_1.Items.Add(addloupan);
                }
                else
                {
                    ToolStripMenuItem addloupan = new ToolStripMenuItem(“添加楼盘”);
                    ToolStripMenuItem reviseloupan = new ToolStripMenuItem(“修改楼盘”);
                    ToolStripMenuItem lookloupan = new ToolStripMenuItem(“查看楼盘”);
                    ToolStripMenuItem deleteloupan = new ToolStripMenuItem(“删除楼盘”);
                    addloupan.Click += new EventHandler(添加楼盘toolStripMenuItem_Click);
                    reviseloupan.Click += new EventHandler(修改楼盘toolStripMenuItem_Click);
                    lookloupan.Click += new EventHandler(查看楼盘toolStripMenuItem_Click);
                    deleteloupan.Click += new EventHandler(删除楼盘toolStripMenuItem_Click);
                    conMenuStr_tree_1.Items.Add(addloupan);
                    conMenuStr_tree_1.Items.Add(reviseloupan);
                    conMenuStr_tree_1.Items.Add(lookloupan);
                    conMenuStr_tree_1.Items.Add(deleteloupan);
                }
                break;
            case “yz”:
                //this.treeview_left.ContextMenuStrip = conMenuStr_yz_1;
                break;
            case “yg”:
                //this.treeview_left.ContextMenuStrip = conMenuStr_yg_1;
                DataSet bmDSet = SQLClass.getDataSet(“select bumen from gangwei where bumen = ‘” + treeview_left.SelectedNode.Text + “‘”, “部门信息表”);
                DataTable bmdt = bmDSet.Tables[“部门信息表”];
                if (bmdt.Rows.Count > 0)
                {
                }
                else
                {
                    ToolStripMenuItem revisegangwei = new ToolStripMenuItem(“修改岗位”);
                    ToolStripMenuItem deletegangwei = new ToolStripMenuItem(“删除岗位”);
                    ToolStripMenuItem revisebumen = new ToolStripMenuItem(“修改部门”);
                    ToolStripMenuItem deletebumen = new ToolStripMenuItem(“删除部门”);
                    revisegangwei.Click += new EventHandler(修改岗位toolStripMenuItem_Click);
                    deletegangwei.Click += new EventHandler(删除岗位toolStripMenuItem_Click);
                    revisebumen.Click += new EventHandler(修改部门toolStripMenuItem_Click);
                    deletebumen.Click += new EventHandler(删除部门toolStripMenuItem_Click);
                    conMenuStr_tree_1.Items.Add(revisegangwei);
                    conMenuStr_tree_1.Items.Add(deletegangwei);
                    conMenuStr_tree_1.Items.Add(revisebumen);
                    conMenuStr_tree_1.Items.Add(deletebumen);
                }
                break;
            case “yw”:
                //this.treeview_left.ContextMenuStrip = conMenuStr_yw_1;
                break;
        }
    }
    //else
    //{
    //    this.treeview_left.ContextMenuStrip = null;     //treeview的右键菜单为空
    //}
    ToolStripMenuItem refresh = new ToolStripMenuItem(“刷新”);
    refresh.Click += new EventHandler(刷新树toolStripMenuItem_Click);
    conMenuStr_tree_1.Items.Add(refresh);
}
//treeview节点右键菜单动作
private void 添加开发商toolStripMenuItem_Click(object sender, EventArgs e)
{
    Kfs_Form kfs = new Kfs_Form();
    kfs.Form_Type = 0;
    kfs.Text = “添加开发商”;
    kfs.ShowDialog();
    if (kfs.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“添加开发商成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 修改开发商toolStripMenuItem_Click(object sender, EventArgs e)
{
    Kfs_Form kfs = new Kfs_Form();
    kfs.kfsid = treeview_left.SelectedNode.Name;
    kfs.Form_Type = 1;
    kfs.Text = “修改开发商”;
    kfs.ShowDialog();
    if (kfs.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“修改添加开发商成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 查看开发商toolStripMenuItem_Click(object sender, EventArgs e)
{
    Kfs_Form kfs = new Kfs_Form();
    kfs.kfsid = treeview_left.SelectedNode.Name;
    kfs.Form_Type = 2;
    kfs.Text = “查看开发商”;
    kfs.ShowDialog();
}
private void 删除开发商toolStripMenuItem_Click(object sender, EventArgs e)
{
    SqlDataReader dr = SQLClass.getcom(“select id from fangchan where kaifashangid = ‘” + treeview_left.SelectedNode.Name + “‘”);
    bool ifcom = dr.Read();
    if (ifcom)
    {
        MessageBox.Show(“该开发商下有房产，无法删除！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    else
    {
        if (DialogResult.OK == MessageBox.Show(“确定删除（” + treeview_left.SelectedNode.Text + “）的所有信息吗？”, “询问”, MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
        {
            //确认删除数据
            SQLClass.getsqlcom(“delete from kaifashang where id = ‘” + treeview_left.SelectedNode.Name + “‘ and gongsi = ‘” + treeview_left.SelectedNode.Text + “‘”);
            UpdateTreeview();
            SQLClass.con_close();       //关闭数据库连接，释放资源
            MessageBox.Show(“删除开发商成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    }
}
private void 添加楼盘toolStripMenuItem_Click(object sender, EventArgs e)
{
    Fangchan_Form fc = new Fangchan_Form();
    fc.Form_Type = 0;
    fc.kfsname = treeview_left.SelectedNode.Text;
    fc.Text = “添加楼盘”;
    fc.ShowDialog();
    if (fc.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“添加楼房成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 修改楼盘toolStripMenuItem_Click(object sender, EventArgs e)
{
    Fangchan_Form fc = new Fangchan_Form();
    fc.fcid = treeview_left.SelectedNode.Name;
    fc.Form_Type = 1;
    fc.Text = “修改楼盘”;
    fc.ShowDialog();
    if (fc.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“修改楼房成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 查看楼盘toolStripMenuItem_Click(object sender, EventArgs e)
{
    Fangchan_Form fc = new Fangchan_Form();
    fc.fcid = treeview_left.SelectedNode.Name;
    fc.Form_Type = 2;
    fc.Text = “查看楼盘”;
    fc.ShowDialog();
}
private void 删除楼盘toolStripMenuItem_Click(object sender, EventArgs e)
{
    SqlDataReader dr = SQLClass.getcom(“select id from zhufang where fangchanid = ‘” + treeview_left.SelectedNode.Name + “‘”);
    bool ifcom = dr.Read();
    if (ifcom)
    {
        MessageBox.Show(“该栋建筑还存在住房，请先清空住房后再试！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    else
    {
        if (DialogResult.OK == MessageBox.Show(“确定删除（” + treeview_left.SelectedNode.Text + “）的所有信息吗？”, “询问”, MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
        {
            //确认删除数据
            SQLClass.getsqlcom(“delete from fangchan where id = ‘” + treeview_left.SelectedNode.Name + “‘ and jianzu = ‘” + treeview_left.SelectedNode.Text + “‘”);
            UpdateTreeview();
            SQLClass.con_close();       //关闭数据库连接，释放资源
            MessageBox.Show(“删除楼房成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    }
}
private void 添加岗位toolStripMenuItem_Click(object sender, EventArgs e)
{
    Gangwei_Form gw = new Gangwei_Form();
    gw.Form_Type = 0;
    gw.Text = “添加岗位”;
    gw.ShowDialog();
    if (gw.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“添加岗位成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 修改岗位toolStripMenuItem_Click(object sender, EventArgs e)
{
    Gangwei_Form gw = new Gangwei_Form();
    gw.gwid = treeview_left.SelectedNode.Name;
    gw.bmname = treeview_left.SelectedNode.Parent.Text;
    gw.Form_Type = 1;
    gw.Text = “添加岗位”;
    gw.ShowDialog();
    if (gw.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“修改岗位成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
private void 修改部门toolStripMenuItem_Click(object sender, EventArgs e)
{
    Bumen_Form bm = new Bumen_Form();
    bm.bmname = treeview_left.SelectedNode.Text;
    //bm.Form_Type = 1;
    bm.Text = “修改部门”;
    bm.ShowDialog();
    if (bm.Form_OK == 1)
    {
        UpdateTreeview();       //更新树节点
        MessageBox.Show(“修改部门成功！”, “信息提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}