frmdepartmentmodify.cs

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

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

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

        public frmDepartmentModify()
        {
            InitializeComponent();
        }


        //关闭
        private void buttonItem1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //页面载入
        private void frmDepartmentModify_Load(object sender, EventArgs e)
        {
            //给Datagridview填值
            MyCls.GetDataToGridView(DGViewResult, "select distinct * from t_department" ,"t_department", out myds);
            //隔行变色
            MyCls.SetDGVColor(DGViewResult);
            //设置列标题
            DGViewResult.Columns["name"].Width = 240;
            DGViewResult.Columns["name"].HeaderText = "名称";
        }


        //新增
        private void btnAdd_Click(object sender, EventArgs e)
        {
            myds = MyCls.GetDataSet("select name from t_department where name='" + txtName.Text.Trim()+"'", "t_department");
            if(myds.Tables["t_department"].Rows.Count>0)
            {
                MessageBox.Show("数据重复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtName.Focus();
                return;
            }
            //长度验证
            if (MyCls.CheckString(txtName.Text.Trim(), 30))
            {
                if (MyCls.ExecSqlString("insert into t_department (name) values( '" + txtName.Text.Trim()+"')"))
                {
                    MessageBox.Show("新增成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    txtName.Text = "";
                    MyCls.GetDataToGridView(DGViewResult, "select distinct * from t_department", "t_department", out myds);
                }
                else
                {
                    MessageBox.Show("新增失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                txtName.Focus();
            }

        }


        //维护的单击
        private void ribbonTabItem2_Click(object sender, EventArgs e)
        {
            //给Datagridview填值
            MyCls.GetDataToGridView(DGViewResult2, "select distinct * from t_department", "t_department", out myds);
            //隔行变色
            MyCls.SetDGVColor(DGViewResult2);
            //设置列标题
            DGViewResult2.Columns["name"].Width = 240;
            DGViewResult2.Columns["name"].HeaderText = "名称";

            if (myds.Tables[0].Rows.Count > 0)
            {
                btnDelete.Enabled = true;
                btnModify.Enabled = true;
            }


        }

        //当修改页面中的单元格时触发
        private void DGViewResult2_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            //获得当前所在的行列
            int i = DGViewResult.CurrentCell.RowIndex;
            int j = DGViewResult.CurrentCell.ColumnIndex;

            switch (j)
            {
                case 1://ID
                    {
                        
                    }
                    break;

                case 2://名称
                    {
                        if (!MyCls.CheckString(DGViewResult.CurrentCell.Value.ToString(), 30))
                        {
                            DGViewResult.CurrentCell = DGViewResult.Rows[i].Cells[j];
                            btnModify.Enabled = false;
                            return;
                        }
                    }
                    break;

            }
            DataRow DR = myds.Tables["t_department"].Rows[i];

            int rowindex=0;
            for (; rowindex < myds.Tables["t_department"].Rows.Count; rowindex++)//判断修改后的名称是否有重复的
            {
                if (DGViewResult.CurrentCell.Value.ToString() == myds.Tables["t_department"].Rows[rowindex]["name"].ToString() && rowindex != i)
                {
                    MessageBox.Show("数据表中存在与之相同的名称，请修改为其它名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    DGViewResult.CurrentCell = DGViewResult.Rows[rowindex].Cells[j];
                    btnModify.Enabled = false;
                    return;
                }
            }


            DR.BeginEdit();
            DR[j] = DGViewResult.CurrentCell.Value.ToString();
            DR.EndEdit();

            btnModify.Enabled = true;
        }

        //修改
        private void btnModify_Click(object sender, EventArgs e)
        {
            if (myds.GetChanges() != null)//对DataGridView进行了修改
            {

                bool blFlag = MyCls.DataSetUpdateByDataSet(myds, "t_department");

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

        }

        //删除 
        private void btnDelete_Click(object sender, EventArgs e)
        {
            string strReturn = MessageBox.Show("确实要删除此记录吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information).ToString();
            if (strReturn == "OK")
            {
                int i = DGViewResult.CurrentRow.Index;
                DataRow DR = myds.Tables["t_department"].Rows[i];
                DR.BeginEdit();
                DR.Delete();
                DR.EndEdit();

                bool blFlag = MyCls.DataSetUpdateByDataSet(myds, "t_department");

                if (blFlag)
                {
                    MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    if (myds.Tables[0].Rows.Count <= 0)
                    {
                        btnDelete.Enabled = false;
                        btnModify.Enabled = false;
                    }
                }
                else
                {
                    MessageBox.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

            }

        }

        //点击新增时
        private void ribbonTabItem1_Click(object sender, EventArgs e)
        {
            //给Datagridview填值
            MyCls.GetDataToGridView(DGViewResult, "select distinct * from t_department", "t_department", out myds);

        }
    }
}