private void button1_Click_1(object sender, EventArgs e)
 {
     DbHelper.ExportExcel(dataGridView1);
 }
        private void btluu_Click(object sender, EventArgs e)
        {
            if (validate())
            {
                if (state == "insert")
                {
                    //MessageBox.Show("INSERT INTO PhieuNhap(MaPhieuNhap, TenNCC, TenMH, SoLuongNhap,GiaNhap,TienDaThanhToan,NgayThanhToan) VALUES (" + Convert.ToInt32(txtMaPhieuNhap.Text) + ",N'" + txtTenNCC.Text + "',N'" + txtTenMH.Text + "'," + Convert.ToInt32(txtSoLuongNhap.Text) + "," + Convert.ToInt32(txtGiaNhap.Text) + "," + Convert.ToInt32(txtTienDaThanhToan.Text) + ",'"+txtNgayThanhToan.Value.ToShortDateString().ToString() +"')");
                    string sql = @"INSERT INTO [QLKhoHang].[dbo].[PhieuXuat]
           ([NgayXuat]
           ,[NguoiXuat]
           ,[MaKH]
           ,[SoLuongXuat]
           ,[MaHH])
     VALUES
           ('" + fieldNgayXuat.Value.ToString("yyyy/MM/dd") + @"'
           ,N'" + fieldNguoiXuat.Text + @"'
           ," + fieldMaKH.SelectedValue + @"
           ," + Convert.ToInt64(fieldSoLuongXuat.Text) + @"
           ," + fieldMaHH.SelectedValue + @"
)";

                    if (DbHelper.Query(sql) != -1)
                    {
                        MessageBox.Show("Thêm thành công !");
                    }
                    else
                    {
                        MessageBox.Show("Có lỗi trong quá trình thêm");
                    }
                }
                //end add
                else if (state == "update")
                {
                    string sql = @"UPDATE [QLKhoHang].[dbo].[PhieuXuat]
   SET [NgayXuat] ='" + fieldNgayXuat.Value.ToString("yyyy/MM/dd") + @"'
      ,[NguoiXuat] = N'" + fieldNguoiXuat.Text + @"'
      ,[MaKH] =" + fieldMaKH.SelectedValue + @"
      ,[SoLuongXuat] =" + Convert.ToInt64(fieldSoLuongXuat.Text) + @"
      ,[MaHH] = " + fieldMaHH.SelectedValue + @"
 WHERE MaPXK = " + Convert.ToInt64(fieldMaPXK.Text);



                    if (DbHelper.Query(sql) != -1)
                    {
                        MessageBox.Show("Sửa thành công !");
                    }
                    else
                    {
                        MessageBox.Show("Có lỗi trong quá trình Sửa");
                    }
                }

                hien();
                dongtxt();
                mobtn();
            }//end validate
            if (state == "delete" && validate())
            {
                string sql = @"DELETE [QLKhoHang].[dbo].[PhieuXuat]
 WHERE MaPXK = " + Convert.ToInt64(fieldMaPXK.Text);


                if (DbHelper.Query(sql) != -1)
                {
                    MessageBox.Show("Xóa thành công !");
                }
                else
                {
                    MessageBox.Show("Có lỗi trong quá trình Xóa");
                }

                hien();
                dongtxt();
                mobtn();
            }
        }