frm-ipfind.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
//地点：阳谷祥光铜业
//功能:IP地址查询
//*************************************************

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

        DataSet myds = new DataSet();

        public frm_IPFind()
        {
            InitializeComponent();
        }

        //页面载入
        private void frm_IPFind_Load(object sender, EventArgs e)
        {
            MyCls.GetDataToComboBox("select DISTINCT network from t_switch where network <>''", comNetwork, "t_switch", "network", "network");
            comNetwork.Text = "192.168.8";
            MyCls.SetDGVColor(DGViewResult);
        }

        //退出
        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //查询
        private void btnFind_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where network ='");
            strSql.Append(comNetwork.Text);
            if (txtIP.Text.Trim() == "")
            {
                strSql.Append("'");
            }
            else
            {
                strSql.Append("' and ip='");
                strSql.Append(txtIP.Text.Trim());
                strSql.Append("'");
            }
            bool bl_Flag = 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 = 80;


            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);
                btnPageSetup.Enabled = false;
                btnPreview.Enabled = false;

            }
            else
            {
                btnPageSetup.Enabled = true;
                btnPreview.Enabled = true;
            }
        }


        //页面设置
        private void btnPageSetup_Click(object sender, EventArgs e)
        {
            MyCls.PrintData(DGViewResult, "计算机信息");
        }

        //打印预览
        private void btnPreview_Click(object sender, EventArgs e)
        {
            MyCls.DataPreview(DGViewResult, "计算机信息");
        }


        //所用未绑定IP
        private void btnNoBind_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where isbind ='N'");
            
            
            bool bl_Flag = 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["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);
                btnPageSetup.Enabled = false;
                btnPreview.Enabled = false;

            }
            else
            {
                btnPageSetup.Enabled = true;
                btnPreview.Enabled = true;
            }

        }
    }
}