frm-computemodify.cs

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;//添加命名空间
using System.Drawing;
using System.Text;
using System.Windows.Forms;
//*************************************************
//程序设计：殷庆飞
//时间：2007-7-20
//地点：阳谷祥光铜业
//功能:计算机管理的维护
//*************************************************
namespace 计算机及IP管理
{
    public partial class frm_computeModify : Form
    {
        //引用自定义类
        UserCls MyCls = new UserCls();

        DataSet myds = new DataSet();

        public frm_computeModify()
        {
            InitializeComponent();
        }


        //页面载入
        private void frm_computeModify_Load(object sender, EventArgs e)
        {
            //设置DGViewResult的隔行变色
            MyCls.SetDGVColor(DGViewResult);

            txtFindType.Items.Add("负责人");
            txtFindType.Items.Add("IP");
            txtFindType.Items.Add("交换机端口");
            txtFindType.Items.Add("计算机型号");
            txtFindType.Items.Add("负责人所在部门");
            txtFindType.Items.Add("MAC");
            txtFindType.Items.Add("IP绑定");
            txtFindType.SelectedItem = "负责人";
        }


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

        //查询
        private void btnFind_Click(object sender, EventArgs e)
        {
            if (txtFindType.Text.Trim() == "")
            {
                MessageBox.Show("请选择查询方式", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtFindType.Focus();
                return;
            }


            StringBuilder strSql = new StringBuilder("select * from t_computer_ip where ");
           
            switch (txtFindType.Text.Trim())
            {
                case "负责人":
                {
                    if (txtParam.Text.Trim() == "")
                    {
                        MessageBox.Show("请输入查询参数", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        txtParam.Focus();
                        return;
                    }

                    strSql.Append("department='");
                    strSql.Append(txtModel.Text.Trim());
                    strSql.Append("' and charge='");
                }
                break;
                case "IP":
                {
                    strSql.Append("network ='");
                    strSql.Append(txtModel.Text.Trim());
                    strSql.Append("' and ip='");
                }
                break;
                case "交换机端口":
                {
                    strSql.Append("scope ='");
                    strSql.Append(txtModel.Text.Trim());

                    strSql.Append("' and port='");
                }
                break;

                case "计算机型号":
                {
                    strSql.Append("computermodel='");
                }
                break;
                case "负责人所在部门":
                {
                    if (txtParam.Text.Trim() == "")
                    {
                        MessageBox.Show("请输入查询参数", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        txtParam.Focus();
                        return;
                    }

                    strSql.Append("department='");
                }
                break;
                case "MAC":
                {
                    strSql.Append("mac='");
                }
                break;
                case "IP绑定":
                {
                    strSql.Append("isbind='");
                }
                break;
                default:
                {
                    MessageBox.Show("查询方式有误！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    txtFindType.Focus();
                    return;
                }
                
            }
            strSql.Append(txtParam.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 = 100;


            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);
                btnModify.Enabled = false;
                btnDelete.Enabled = false;
            }
            else
            {
                btnModify.Enabled = true;
                btnDelete.Enabled = true;

            }
        }

        //对修改过的内容进行保存
        private void btnModify_Click(object sender, EventArgs e)
        {
            if (myds.GetChanges() != null)//对DataGridView进行了修改
            {
               
                bool blFlag = MyCls.DataSetUpdateByDataSet(myds, "t_computer_ip");

                if (blFlag)
                {
                    MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            else
            {
                MessageBox.Show("没对数据进行任何修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

        //修改DataGridView中值时触发此函数
        private void DGViewResult_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            //获得当前所在的行列
            int i = DGViewResult.CurrentCell.RowIndex;
            int j = DGViewResult.CurrentCell.ColumnIndex;

            switch (j)
            {
                case 1://网段
                    {
                        if (!MyCls.CheckString(DGViewResult.CurrentCell.Value.ToString(), 15))
                        {
                            DGViewResult.CurrentCell = DGViewResult.Rows[i].Cells[j];
                            btnModify.Enabled = false;
                            return;
                        }
                    }
                    break;

                case 2://IP
                    {
                        if (!MyCls.CheckString(DGViewResult.CurrentCell.Value.ToString(), 3))
                        {