C# 综合示例 库存管理系统18 快递公司管理（FormExpress）

版权声明：本文为博主原创文章，转载请在显著位置标明本文出处以及作者网名，未经作者允许不得用于商业目的

图99A-33 快递公司管理窗口设计

全部代码如下：

        public static void ShowForm()

        {

            FormExpress frm = new FormExpress();

            frm.ShowDialog();

        }

        OleDbConnection connection;

        List<int> arrExpress;

        private void FormExpress_Load(object sender, EventArgs e)

        {

            connection = new OleDbConnection(classMod.databaseConnString);

            //打开数据连接

            connection.Open();

            arrExpress = new List<int>();

            fillControls();

        }

        private void btnAdd_Click(object sender, EventArgs e)

        {

            string errMsg = checkData();

            if (errMsg != "")

            {

                MessageBox.Show(errMsg);

                return;

            }

            //新建OleDbCommand对象实例

            OleDbCommand command = new OleDbCommand();

            //设置OleDbCommand的数据连接为OleDbConnection

            command.Connection = connection;

            //公司名称

            string expressName = txtName.Text.Trim();

            //电话号码

            string expressTel = txtTel.Text.Trim();

            string sqlString;

            sqlString = "insert into 快递公司(公司名称,电话,是否删除) " +

                "values('" + expressName + "','" + expressTel + "','否')";

            command.CommandText = sqlString;

            //不管是新增还是修改，都不用返回值，所以使用ExecuteNonQuery。

            command.ExecuteNonQuery();

            fillControls();

        }

        private void btnDel_Click(object sender, EventArgs e)

        {

            delExpress("是");

        }

        private void btnRecovery_Click(object sender, EventArgs e)

        {

            delExpress("否");

        }

        private void delExpress(string isDel )

        {

        if( lvExpress.SelectedItems.Count< 1 )

            {

                MessageBox.Show("未选择需要删除的数据");

                    return;

            }

            int ExpressID = arrExpress[lvExpress.SelectedItems[0].Index];

            //从数据库中删除

            //新建OleDbCommand对象实例

            OleDbCommand command = new OleDbCommand();

            //设置OleDbCommand的数据连接为OleDbConnection

            command.Connection = connection;

            command.CommandText = "update 快递公司 set 是否删除='" + isDel + "' where 运货商ID=" + ExpressID;

            command.ExecuteNonQuery();

            //从listview中删除

            lvExpress.SelectedItems[0].SubItems[2].Text = isDel;

        }

        private void btnClose_Click(object sender, EventArgs e)

        {

            Close();

        }

        private void FormExpress_FormClosing(object sender, FormClosingEventArgs e)

        {

            connection.Close();

        }

        //填充数据选项，主要是 lvExpress

        private void fillControls()

        {

            arrExpress.Clear();

            lvExpress.Items.Clear();

            //新建OleDbCommand对象实例

            OleDbCommand command = new OleDbCommand();

            //=========填充快递公司列表==================

            //要执行的SQL查询

            command.CommandText = "select 运货商ID,公司名称,电话,是否删除 from 快递公司";

            //设置OleDbCommand的数据连接为OleDbConnection

            command.Connection = connection;

            //声明OleDbDataReader对象

            OleDbDataReader odReader;

            //通过OleDbCommand的ExecuteReader方法获得OleDbDataReader对象实例。

            odReader = command.ExecuteReader();

            //如果OleDbDataReader中包含数据

            if (odReader.HasRows)

                //循环读取每一行数据，直到Read方法返回False

                while (odReader.Read())

                {

                    arrExpress.Add(int.Parse(odReader.GetValue(0).ToString()));

                    ListViewItem lvi = new ListViewItem(odReader.GetValue(1).ToString());

                    lvi.SubItems.Add(odReader.GetValue(2).ToString());

                    lvi.SubItems.Add(odReader.GetValue(3).ToString());

                    lvExpress.Items.Add(lvi);

                }

            odReader.Close();

            //关闭数据读取器

            odReader.Close();

        }

        //检查数据合法性

        private string checkData()

        {

            if (txtName.Text.Trim() == "")

                return "公司名称不能为空";

            if (txtTel.Text.Trim() == "")

                return "电话号码不能为空";

            return "";

        }

学习更多vb.net知识，请参看vb.net 教程 目录

学习更多C#知识，请参看C#教程 目录