mainframe.cs

航运管理系统

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

namespace ShipManageSystem
{
    public partial class mainFrame : Form
    {

        SqlConnection conn;
        SqlDataAdapter adap;
        DataSet ds = new DataSet();
        SqlParameter sp = new SqlParameter();
        DialogResult dr;
        DBConnection db = new DBConnection();
        String sql;
        SqlCommand comm;

        //public mainFrame()
        //{
        //    InitializeComponent();
        //}

        public mainFrame(string type)
        {
            if(type.Equals("admin"))
            {
                InitializeComponent();
            }
            else if (type.Equals("normal"))
            {
                InitializeComponent();
                this.dataGridView1.Visible = false;
                this.dataGridView2.Visible = false;
                this.dataGridView3.Visible = false;
                this.dataGridView5.Visible = false;
                this.button1.Enabled = false;
                this.button2.Enabled = false;
                this.button5.Enabled = false;
                this.button7.Visible = false;
                this.button8.Visible = false;
                this.button4.Enabled = false;
                this.button9.Visible = false;
                this.button10.Visible = false;
                this.button6.Enabled = false;
                this.button11.Visible = false;
                this.button12.Visible = false;
                this.button16.Visible = false;
                this.button17.Visible = false;
                this.button18.Enabled = false;
            }
        }

        private void label2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void mainFrame_Load(object sender, EventArgs e)
        {
            conn = db.getConnection();
            ds = db.fill();
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
            dataGridView3.DataSource = ds.Tables[1].DefaultView;
            dataGridView2.DataSource = ds.Tables[2].DefaultView;
            dataGridView5.DataSource = ds.Tables[3].DefaultView;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string right=null;
            if(radiobutton1.Checked)
                right=radiobutton1.Text;
            if(radiobutton2.Checked)
                right=radiobutton2.Text;
            string insUser = "insert into 用户 values('"+textBox1.Text+"','"+textBox2.Text+"','"+right+"')";
            conn.Open();
            comm = new SqlCommand(insUser, conn);
            int result = comm.ExecuteNonQuery();
            if (result == 1)
            {
                textBox1.Text = null;
                textBox2.Text = null;
                MessageBox.Show("添加用户成功！");
            }
            conn.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            String delUser = "delete from 用户 where 用户名='" + textBox3.Text + "'";
            conn.Open();
            comm = new SqlCommand(delUser, conn);
            int result = comm.ExecuteNonQuery();
            if (result == 1)
            {
                textBox3.Text = null;
                MessageBox.Show("删除用户成功！");
            }
            conn.Close();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            String updUser = "update 用户 set 密码='"+textBox5.Text+"' where 用户名='" + textBox6.Text + "' and 密码='"+textBox4.Text+"'";
            conn.Open();
            comm = new SqlCommand(updUser, conn);
            int result = comm.ExecuteNonQuery();
            if (result == 1)
            {
                textBox5.Text = null;
                textBox4.Text = null;
                textBox6.Text = null;
                MessageBox.Show("用户更新密码成功！");
            }
            else
            {
                MessageBox.Show("用户更新密码失败！\n也许用户名或密码错误！");
                textBox5.Text = null;
                textBox4.Text = null;
                textBox6.Text = null;
            }
            conn.Close();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            conn.Open();
            String insCustomer = "insert into 货主 values('"+textBox18.Text+"','"+textBox20.Text+"','"+textBox17.Text+"','"+textBox22.Text+"','"+textBox16.Text+"','"+textBox19.Text+"')";
            comm = new SqlCommand(insCustomer, conn);
            int result = comm.ExecuteNonQuery();
            if (result == 1)
            {
                MessageBox.Show("添加纪录成功！");
                sql = "select * from 货主 where 序号='"+textBox18.Text+"'";
                ds = db.search(sql,"customer");
                dataGridView1.Update();
            }
            else
            {
                MessageBox.Show("添加纪录失败！");
            }          
            conn.Close();         
        }

        private void button7_Click(object sender, EventArgs e)
        {
           // dataGridView1.Columns[0].ReadOnly = false;
           string updCustomer = "update 货主 set 公司名称=@name,联系人=@people,电话=@tele,传真=@fax,email=@email where 序号=@number";
           adap = db.getAdapter("customer");
           adap.UpdateCommand = new SqlCommand(updCustomer, conn);

           sp = adap.UpdateCommand.Parameters.Add("@number", SqlDbType.Char);
           sp.SourceColumn = "序号";
           sp.SourceVersion = DataRowVersion.Current;

           sp = adap.UpdateCommand.Parameters.Add("@name", SqlDbType.VarChar);
           sp.SourceColumn = "公司名称";
           sp.SourceVersion = DataRowVersion.Current;

           sp = adap.UpdateCommand.Parameters.Add("@people", SqlDbType.VarChar);
           sp.SourceColumn = "联系人";
           sp.SourceVersion = DataRowVersion.Current;

           sp = adap.UpdateCommand.Parameters.Add("@tele", SqlDbType.VarChar);
           sp.SourceColumn = "电话";
           sp.SourceVersion = DataRowVersion.Current;

           sp = adap.UpdateCommand.Parameters.Add("@fax", SqlDbType.VarChar);
           sp.SourceColumn = "传真";
           sp.SourceVersion = DataRowVersion.Current;

           sp = adap.UpdateCommand.Parameters.Add("@email", SqlDbType.VarChar);
           sp.SourceColumn = "email";
           sp.SourceVersion = DataRowVersion.Current;
           try
           {
               if (ds.HasChanges())
               {
                   dr = MessageBox.Show("您想要保存这些修改么？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                   if (dr == DialogResult.No)
                       return;
                   else
                   {
                       adap.Update(ds, "货主管理");
                       MessageBox.Show("数据库已更新！");
                   }
               }
               else
               {
                   MessageBox.Show("数据库未做任何修改！");
               }
           }
           catch (Exception)
           {
               MessageBox.Show("不可直接在显示窗体中添加信息，只允许修改及删除！");
           }
        }

        private void button8_Click(object sender, EventArgs e)
        {
            string delCustomer = "delete from 货主 where 序号=@number";
            adap = db.getAdapter("customer");
            adap.DeleteCommand = new SqlCommand(delCustomer, conn);

            sp = adap.DeleteCommand.Parameters.Add("@number", SqlDbType.Char);
            sp.SourceColumn = "序号";
            sp.SourceVersion = DataRowVersion.Original;

            dr = MessageBox.Show("您确定要删除当前纪录么？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (dr == DialogResult.Yes)
            {
                ds.Tables[0].Rows[dataGridView1.CurrentRow.Index].Delete();
                adap.Update(ds, "货主管理");
                MessageBox.Show("已删除纪录！");
            }
            else
            {
                MessageBox.Show("删除失败！");
                return;
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            conn.Open();
            String insBill = "insert into 清单 values('" + textBox12.Text + "','" + textBox11.Text + "','" + textBox13.Text + "','" + textBox14.Text + "','" + textBox9.Text + "','" + textBox7.Text + "','"+textBox8.Text+"')";
            comm = new SqlCommand(insBill, conn);
            try
            {
                int result = comm.ExecuteNonQuery();
                if (result == 1)
                {
                    MessageBox.Show("添加纪录成功！");
                    sql = "select * from 清单 where 提单号='" + textBox12.Text + "'";
                    ds = db.search(sql,"bill");
                    dataGridView2.Update();
                }
                else
                {
                    MessageBox.Show("添加纪录失败！");
                }
            }
            catch (SqlException)
            {
                MessageBox.Show("请检验该船号在船舶清单中是否存在!\n以及数据格式是否正确!");
            }
            
            conn.Close();
        }

        private void button9_Click(object sender, EventArgs e)
        {
            string updBill = "update 清单 set 船号=@number,起始港=@start,目的港=@end,总件数=@count,总重量=@weight,货物性质=@quantity where 提单号=@bill";
            adap = db.getAdapter("bill");
            adap.UpdateCommand = new SqlCommand(updBill, conn);

            sp = adap.UpdateCommand.Parameters.Add("@number", SqlDbType.Char);
            sp.SourceColumn = "船号";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@start", SqlDbType.VarChar);
            sp.SourceColumn = "起始港";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@end", SqlDbType.VarChar);
            sp.SourceColumn = "目的港";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@count", SqlDbType.VarChar);
            sp.SourceColumn = "总件数";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@weight", SqlDbType.VarChar);
            sp.SourceColumn = "总重量";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@quantity", SqlDbType.VarChar);
            sp.SourceColumn = "货物性质";
            sp.SourceVersion = DataRowVersion.Current;

            sp = adap.UpdateCommand.Parameters.Add("@bill", SqlDbType.VarChar);
            sp.SourceColumn = "提单号";
            sp.SourceVersion = DataRowVersion.Current;

            try
            {
                if (ds.HasChanges())
                {
                    dr = MessageBox.Show("您想要保存这些修改么？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dr == DialogResult.No)
                        return;
                    else
                    {
                        adap.Update(ds, "清单管理");
                        MessageBox.Show("数据库已更新！");
                    }
                }
                else
                {
                    MessageBox.Show("数据库未做任何修改！");
                }
            }
            catch (Exception)
            {