public Diablog_BangTH(string id)
        {
            InitializeComponent();
            border();
            BangThuHoachDB db = new BangThuHoachDB();
            // load noi dung de sua thong tin
            Dictionary <int, string> d;

            using (QLNTEntities1 db1 = new QLNTEntities1())
            {
                d = (
                    from c in db1.Cay
                    select new { c.MaLoaiCay, c.TenCay }

                    ).ToDictionary(c => c.MaLoaiCay, c => c.TenCay);
            }
            comboBoxTenCay.DataSource = d.Values.ToList();
            using (QLNTEntities1 db1 = new QLNTEntities1())
            {
                d = (
                    from c in db1.NhanVien
                    select new { c.MaNV, c.TenNV }

                    ).ToDictionary(c => c.MaNV, c => c.TenNV);
            }
            comboBoxTenNV.DataSource = d.Values.ToList();
            #region gắn giá trị
            this.id = Convert.ToInt32(id);
            o       = db.GetBangThuHoach(id);
            //textSanLuongThuHoach.Text = o..ToString();
            // DatepickerNgayThuHoach.Value.ToString("dd/MM/yyyy");
            #endregion

            //Hien button luu
            button_luu.Visible = true;
            //button_luu.Enabled = false;
        }
        public void Search(BunifuCustomDataGrid dataGrid, int month, int year)
        {
            BangThuHoachDB db = new BangThuHoachDB();

            db.Search(dataGrid, month, year);
        }
        public void View(BunifuCustomDataGrid dataGrid)
        {
            BangThuHoachDB db = new BangThuHoachDB();

            db.View(dataGrid);
        }
        public void Edit(BangThuHoach o)
        {
            BangThuHoachDB db = new BangThuHoachDB();

            db.Edit(o);
        }
        public void Delete(string id)
        {
            BangThuHoachDB db = new BangThuHoachDB();

            db.Delete(id);
        }
        public void Add(BangThuHoach o)
        {
            BangThuHoachDB db = new BangThuHoachDB();

            db.Add(o);
        }