winform dataGridView1增删改查

winform dataGridView1增删改查

添加

   private void button1_Click(object sender, EventArgs e)
    {
        MovieLinedAddorEditFrm add = new MovieLinedAddorEditFrm(null);
        if (add.ShowDialog() == DialogResult.OK)
        {
            dgvMovieUser.DataSource = GetScource();
        }
    }

添加窗体

    public partial class MovieLinedAddorEditFrm : Form
    {
        private int? _Id = null;
        public MovieLinedAddorEditFrm(MovieLined movie)
        {
            InitializeComponent();
            if (movie != null)
            {
                comboBox2.Text = movie.MovieId.ToString();
                dateTimePicker1.Text = movie.MovieTime.ToString();
                textBox2.Text = movie.MovieLength.ToString();
                comboBox1.Text = movie.MovieRoomId.ToString();
                    //movie.UserType.HasValue ? admin.UserType.Value : 1;
                textBox1.Text = movie.Description;
                //admin.Id = admin.UserType; 
                if (movie.Id != 0)
                {
                    _Id = movie.Id;
                }
            }
            }
        

        private void button2_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(textBox2.Text))
            {
                textBox2.Text = "99";
                return;
            }
            if (String.IsNullOrEmpty(textBox1.Text))
            {
                textBox1.Text = "描述不能为空";
                return;
            }
            if (String.IsNullOrEmpty(comboBox2.Text)|| String.IsNullOrEmpty(comboBox1.Text))
            {
                MessageBox.Show("片名和影厅不能为空");
                return;
            }
            
            MovieLined admin = new MovieLined();
            admin.MovieId = Convert.ToInt32(comboBox2.SelectedValue);
            admin.MovieTime = Convert.ToDateTime( dateTimePicker1.Text);
            admin.MovieLength = Convert.ToInt32(textBox2.Text);
            admin.MovieRoomId = Convert.ToInt32(comboBox1.SelectedValue);
            admin.Description = textBox1.Text;

            // Edit   admin.Id = 0; 
            //string sql2 = "select * from MovieLined where MovieID = " + admin.MovieId;
            //if (DBHelper.ExecuteNonQuery(sql2))
            //{
                string sql = null;
                if (!_Id.HasValue)
                {//添加
                    sql = SQLHelper.InsertSQL(admin);
                }
                else
                {//更新
                    admin.Id = _Id.Value;
                    sql = SQLHelper.UpdateSQL(admin);
                }

                //var param = SQLHelper.SQLParam(admin);
                //int result = DBHelper.GetNonQuery(sql, param);
                if (DBHelper.ExecuteNonQuery(sql))
                {
                    MessageBox.Show("数据提交成功", "tip", MessageBoxButtons.OKCancel);
                    DialogResult = DialogResult.OK;
                    this.Close();
                }
            //} 
            //else
            //{
            //    MessageBox.Show("没有该影名ID"); 
            //}

        }

        private void MovieLinedAddorEditFrm_Load(object sender, EventArgs e)
        {
            comboBox1.DataSource = DBHelper.GetDataTable("select * from ScreeningRoom");
            comboBox1.DisplayMember = "ScreeningRoomName";
            comboBox1.ValueMember = "Id";
            //通过搜索添加的影厅在添加放映排挡时自动绑定
            comboBox2.DataSource = DBHelper.GetDataTable("select * from MovieInfo");
            comboBox2.DisplayMember = "MovieName";
            comboBox2.ValueMember = "Id";
            //通过搜索添加的影片名在添加放映排挡时自动绑定 
        }
    }

删除

  private void button3_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("是否删除？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                if (dgvMovieUser.CurrentRow != null)
                {

                    var table = (DataTable)dgvMovieUser.DataSource;
                    var row = table.Rows[dgvMovieUser.CurrentRow.Index];
                    MovieLined admin = new MovieLined();
                    //admin.Id = Convert.ToInt32(row.Cells["Id"].Value);
                    admin.Id = (int)row.ItemArray[0];
                    string sql = SQLHelper.DeleteSQL(admin);
                    //var param = SQLHelper.SQLParam(admin);
                    //int result = DBHelper.GetNonQuery(sql, param);
                    if (DBHelper.ExecuteNonQuery(sql))
                    {
                        MessageBox.Show("删除成功");
                        dgvMovieUser.DataSource = GetScource();
                    }
                    else
                    {
                        MessageBox.Show("删除失败！");
                    }
                }
                else
                {
                    MessageBox.Show("请选择删除行！");
                }
            }
        }

修改

   private void button2_Click(object sender, EventArgs e)
        {
            if (dgvMovieUser.CurrentRow != null)
            {
                var table = (DataTable)dgvMovieUser.DataSource;
                var row = table.Rows[dgvMovieUser.CurrentRow.Index];
                //var row = dgvMovieUser.SelectedRows[0];
                MovieType admin = new MovieType();
                if (row.ItemArray[1].ToString() != "")
                {
                    admin.Id = (int)row.ItemArray[0];
                    admin.TypeName = row.ItemArray[1].ToString();
                    admin.Description = row.ItemArray[2].ToString(); 
                    var add = new MovieTypeAddOrEditFrm(admin);
                    if (add.ShowDialog() == DialogResult.OK)
                        dgvMovieUser.DataSource = GetScource();
                }
                else
                {
                    MessageBox.Show("类型查询不到");

                }
            }
            else
            {
                MessageBox.Show("请选择修改行！");
            }
        }