frm-computefind.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-20
//地点：阳谷祥光铜业
//功能:计算机管理的查询功能
//*************************************************

namespace 计算机及IP管理
{
    public partial class frm_computeFind : Form
    {
        DataSet myds = new DataSet();

        UserCls MyCls = new UserCls();

        string strTitle;

        public frm_computeFind()
        {
            InitializeComponent();
        }

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


        //按部门查询
        private void bntFindDepartment_Click(object sender, EventArgs e)
        {

            if (txtdepartment.Text.Trim() == "")
            {
                MessageBox.Show("请输入查询条件", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtdepartment.Focus();
                return;
            }
            strTitle = txtdepartment.Text + "计算机信息清单";

            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where department ='");


            strSql.Append(txtdepartment.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);
                btnPrint.Enabled = false;
                btnPreview.Enabled = false;
            }
            else
            {
                btnPrint.Enabled = true;
                btnPreview.Enabled = true;

            }


        }

        //按MAC查询
        private void btnFindMac_Click(object sender, EventArgs e)
        {
            if (txtMac.Text.Trim() == "")
            {
                MessageBox.Show("请输入查询条件", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtMac.Focus();
                return;
            }

            strTitle ="MAC为：" + txtMac.Text + "的计算机信息清单";

            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where mac ='");


            strSql.Append(txtMac.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["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;
                btnPreview.Enabled = false;

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

            }


        }


        //汇总
        private void btnHui_Click(object sender, EventArgs e)
        {
            if (txtdep.Text.Trim() == "")
            {
                MessageBox.Show("请输入查询条件", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtdep.Focus();
                return;
            }
            strTitle = txtdep.Text + "计算机信息汇总";

            StringBuilder strSql = new StringBuilder("select computermodel,department,count(*) as intcount from t_computer_ip where department ='");


            strSql.Append(txtdep.Text.Trim());
            strSql.Append("'");
            strSql.Append(" group by department,computermodel");
            bool bl_Flag = MyCls.GetDataToGridView(DGViewResult, strSql.ToString(), "t_computer_ip", out myds);

            //设置DataGridView的列及列标题,isbind,remarks
            DGViewResult.Columns["computermodel"].HeaderText = "计算机型号";
            DGViewResult.Columns["computermodel"].Width = 100;

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

            DGViewResult.Columns["intcount"].HeaderText = "数量";
            DGViewResult.Columns["intcount"].Width = 80;

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

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

        //画面载入
        private void frm_computeFind_Load(object sender, EventArgs e)
        {
            //载入部门
            MyCls.GetDataToComboBox("select * from  t_department", txtdepartment, "t_department", "name", "name");
            MyCls.GetDataToComboBox("select * from  t_department", txtdep, "t_department", "name", "name");
            //设置DataGridView的隔行变色
            MyCls.SetDGVColor(DGViewResult);
        }


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

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