Example #1
0
        public string getNameNongSan(string id)
        {
            string    ten;
            NongSanDB db = new NongSanDB();

            ten = db.getNameNongSan(id);
            return(ten);
        }
Example #2
0
        public void setHuySL(List <HangHoa> list)
        {
            NongSanDB db = new NongSanDB();

            foreach (var i in list)
            {
                if (i.loai.Equals("Nông sản"))
                {
                    db.setHuySL(i.ma);
                }
            }
        }
        public Diablog_NS(string id)
        {
            InitializeComponent();
            border();
            NongSanDB db = new NongSanDB();

            ds = busCay.getAllNameTree();
            // MessageBox.Show(ds.Count.ToString());
            comboBoxLoaiCay.DataSource = ds.Values.ToList();
            // load noi dung de sua thong tin
            #region gắn giá trị
            this.id = Convert.ToInt32(id);
            o       = db.getNongSan(id);
            textThoiGianBaoQuan.Text = o.ThoiGianBaoQuan.ToString();
            textSanLuongTonKho.Text  = o.SanLuongTonKho.ToString();
            textDonGia.Text          = o.DonGia.ToString();
            Dictionary <int, string> d;
            using (QLNTEntities1 db1 = new QLNTEntities1())
            {
                d = (
                    from z in db1.Cay
                    select new { z.MaLoaiCay, z.TenCay }

                    ).ToDictionary(z => z.MaLoaiCay, z => z.TenCay);
            }
            var kq = d.Values.ToString();
            foreach (var k in d)
            {
                if (k.Key.ToString() == o.MaLoaiCay.ToString())
                {
                    kq = k.Value.ToString();
                    break;
                }
            }
            comboBoxLoaiCay.Text = kq;
            #endregion
            // An button add
            button_add.Enabled = false;
            button_add.Visible = false;
            //Hien button luu
            button_luu.Visible = true;
            //button_luu.Enabled = false;
        }
Example #4
0
        // huy so luong phan bon qua han
        public List <HangHoa> getListNongSan()
        {
            NongSanDB db = new NongSanDB();

            return(db.getListNongSan());
        }
Example #5
0
        public NongSan getNongSan(string id)
        {
            NongSanDB db = new NongSanDB();

            return(db.getNongSan(id));
        }
Example #6
0
        public void Search(BunifuCustomDataGrid dataGrid, string s)
        {
            NongSanDB db = new NongSanDB();

            db.Search(dataGrid, s);
        }
Example #7
0
        public void View(BunifuCustomDataGrid dataGrid)
        {
            NongSanDB db = new NongSanDB();

            db.View(dataGrid);
        }
Example #8
0
        public void Edit(NongSan o)
        {
            NongSanDB db = new NongSanDB();

            db.Edit(o);
        }
Example #9
0
        public void Delete(string id)
        {
            NongSanDB db = new NongSanDB();

            db.Delete(id);
        }
Example #10
0
        public void Add(NongSan o)
        {
            NongSanDB db = new NongSanDB();

            db.Add(o);
        }