frm-switchfind.cs

这是我个人写的一个实例用于登记公司的电脑信息

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

//*************************************************
//程序设计：殷庆飞
//时间：2007-7-23
//地点：阳谷祥光铜业
//功能:交换机查询
//*************************************************

namespace 计算机及IP管理
{
    public partial class frm_switchFind : Form
    {
        UserCls MyCls = new UserCls();

        DataSet myds = new DataSet();

        string strTitle;
  
        public frm_switchFind()
        {
            InitializeComponent();
        }

        //查询
        private void btnFind_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where ");
            
            //判断是否输入了查询条件
            if (txtPort.Text.Trim() != "" || txtScope.Text.Trim() !="")
            {
                if (txtPort.Text.Trim() != "" && txtScope.Text.Trim() != "")
                {
                    strSql.Append("port ='");
                    strSql.Append(txtPort.Text.Trim());
                    strSql.Append("' and ");
                    strSql.Append("scope = '");
                    strSql.Append(txtScope.Text.Trim());
                    strSql.Append("'");
                    strTitle = txtScope.Text.Trim() + "端口:" + txtPort.Text.Trim() + "的交换机信息表";
                }
                else if (txtPort.Text.Trim() != "" && txtScope.Text.Trim() == "")
                {
                    strSql.Append("port ='");
                    strSql.Append(txtPort.Text.Trim());
                    strSql.Append("'");
                    strTitle = "端口:" + txtPort.Text.Trim() + "的交换机信息表";
                }
                else if (txtPort.Text.Trim() == "" && txtScope.Text.Trim() != "")
                {
                    strSql.Append("scope = '");
                    strSql.Append(txtScope.Text.Trim());
                    strSql.Append("'");
                    strTitle = txtScope.Text.Trim() + "交换机信息表";
                }
            }
            else
            {
                MessageBox.Show("请输入查询条件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                txtPort.Focus();
                return;
            }

            MyCls.GetDataToGridView(DGViewResult, strSql.ToString(), "t_computer_ip", out myds);
          
            //设置DataGridView的列及列标题,isbind,remarks
            DGViewResult.Columns["ID"].Visible = false;
            DGViewResult.Columns["computermodel"].HeaderText = "计算机型号";
            DGViewResult.Columns["computermodel"].Width = 100;

            DGViewResult.Columns["department"].HeaderText = "部门";
            DGViewResult.Columns["department"].Width = 100;

            DGViewResult.Columns["charge"].HeaderText = "负责人";
            DGViewResult.Columns["charge"].Width = 80;

            DGViewResult.Columns["scope"].HeaderText = "区域";
            DGViewResult.Columns["scope"].Width = 120;


            DGViewResult.Columns["port"].HeaderText = "端口";
            DGViewResult.Columns["port"].Width = 60;

            DGViewResult.Columns["network"].HeaderText = "网段";
            DGViewResult.Columns["network"].Width = 80;

            DGViewResult.Columns["ip"].HeaderText = "IP";
            DGViewResult.Columns["ip"].Width = 50;

            DGViewResult.Columns["mac"].HeaderText = "MAC";
            DGViewResult.Columns["mac"].Width = 100;

            DGViewResult.Columns["isbind"].HeaderText = "是否绑定";
            DGViewResult.Columns["isbind"].Width = 80;

            DGViewResult.Columns["remarks"].HeaderText = "备注";
            DGViewResult.Columns["remarks"].Width = 160;

            if (myds.Tables[0].Rows.Count <= 0)
            {
                MessageBox.Show("查无数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                btnPrint.Enabled = false;
                btnPageSetup.Enabled = false;
            }
            else
            {
                btnPrint.Enabled = true;
                btnPageSetup.Enabled = true;
            }
       }

        //页面载入
        private void frm_switchFind_Load(object sender, EventArgs e)
        {
            //隔行变色
            MyCls.SetDGVColor(DGViewResult);
            //
            txttype.Items.Add("按部门汇总");
            txttype.Items.Add("按型号汇总");
            txttype.Items.Add("所有");
            txttype.SelectedItem = "按型号汇总";

            //设置区域
            MyCls.GetDataToComboBox("select distinct scope from t_switch where scope<>''", txtScope, "t_switch", "scope", "scope");
        }

        //汇总方式发生改变时触发
        private void txttype_SelectedValueChanged(object sender, EventArgs e)
        {
            if (txttype.Text.Trim() == "按部门汇总")
            {
                MyCls.GetDataToComboBox("select name from t_department", txtParam, "t_department", "name", "name");
            }
            else
            {
                txtParam.Text = "";
            }
        }

        //汇总
        private void btnHui_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder("select ");
            if (txttype.Text.Trim() == "按部门汇总")
            {
                strSql.Append("department,model,count(*) as intcount from t_switch where department = '");
                strSql.Append(txtParam.Text.Trim());
                strSql.Append("' group by department,model");

                strTitle = txtParam.Text.Trim() + "的交换机信息汇总表";

                MyCls.GetDataToGridView(DGViewResult, strSql.ToString(), "t_switch", out myds);

                //设置DataGridView的列及列标题,isbind,remarks
                DGViewResult.Columns["intcount"].HeaderText = "数量";
                DGViewResult.Columns["intcount"].Width = 100;

                DGViewResult.Columns["department"].HeaderText = "部门";
                DGViewResult.Columns["department"].Width = 100;

                DGViewResult.Columns["model"].HeaderText = "型号";
                DGViewResult.Columns["model"].Width = 100;


                if (myds.Tables[0].Rows.Count <= 0)
                {
                    MessageBox.Show("查无数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    btnPageSetup.Enabled = false;
                    btnPrint.Enabled = false;
                }
                else
                {
                    btnPageSetup.Enabled = true;
                    btnPrint.Enabled = true;
                }

            }
            else if (txttype.Text.Trim() == "按型号汇总")
            {
                strSql.Append("model,count(*) as intcount from t_switch");
                strSql.Append(" group by model");

                strTitle = txtParam.Text.Trim() + "的交换机信息汇总表";

                MyCls.GetDataToGridView(DGViewResult, strSql.ToString(), "t_switch", out myds);

                //设置DataGridView的列及列标题,isbind,remarks
                DGViewResult.Columns["intcount"].HeaderText = "数量";
                DGViewResult.Columns["intcount"].Width = 100;

                DGViewResult.Columns["model"].HeaderText = "型号";
                DGViewResult.Columns["model"].Width = 100;

                if (myds.Tables[0].Rows.Count <= 0)
                {
                    MessageBox.Show("查无数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    btnPageSetup.Enabled = false;
                    btnPrint.Enabled = false;
                }
                else
                {
                    btnPageSetup.Enabled = true;
                    btnPrint.Enabled = true;
                }

            }
            else if (txttype.Text.Trim() == "所有")
            {
                strSql.Append("department,model,count(*) as intcount from t_switch ");
          
                strSql.Append(" group by department,model");

                strTitle = "交换机信息汇总表";

                MyCls.GetDataToGridView(DGViewResult, strSql.ToString(), "t_switch", out myds);

                //设置DataGridView的列及列标题,isbind,remarks
                DGViewResult.Columns["intcount"].HeaderText = "数量";
                DGViewResult.Columns["intcount"].Width = 100;

                DGViewResult.Columns["department"].HeaderText = "部门";
                DGViewResult.Columns["department"].Width = 100;

                DGViewResult.Columns["model"].HeaderText = "型号";
                DGViewResult.Columns["model"].Width = 100;


                if (myds.Tables[0].Rows.Count <= 0)
                {
                    MessageBox.Show("查无数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    btnPageSetup.Enabled = false;
                    btnPrint.Enabled = false;
                }
                else
                {
                    btnPageSetup.Enabled = true;
                    btnPrint.Enabled = true;
                }

            }
            else
            {
                MessageBox.Show("请选择正确的汇总方式！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txttype.Focus();
                return;
            }
        }


        //页面设置
        private void btnPageSetup_Click(object sender, EventArgs e)
        {
            MyCls.PrintData(DGViewResult,strTitle);
        }


        //打印预览
        private void btnPrint_Click(object sender, EventArgs e)
        {
            MyCls.DataPreview(DGViewResult, strTitle);
        }

 
    }
}