public string getNameNongSan(string id) { string ten; NongSanDB db = new NongSanDB(); ten = db.getNameNongSan(id); return(ten); }
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; }
// huy so luong phan bon qua han public List <HangHoa> getListNongSan() { NongSanDB db = new NongSanDB(); return(db.getListNongSan()); }
public NongSan getNongSan(string id) { NongSanDB db = new NongSanDB(); return(db.getNongSan(id)); }
public void Search(BunifuCustomDataGrid dataGrid, string s) { NongSanDB db = new NongSanDB(); db.Search(dataGrid, s); }
public void View(BunifuCustomDataGrid dataGrid) { NongSanDB db = new NongSanDB(); db.View(dataGrid); }
public void Edit(NongSan o) { NongSanDB db = new NongSanDB(); db.Edit(o); }
public void Delete(string id) { NongSanDB db = new NongSanDB(); db.Delete(id); }
public void Add(NongSan o) { NongSanDB db = new NongSanDB(); db.Add(o); }