private void Load() { tb = new DataTable(); dsDaiLy = BUS_DaiLy.DsDaiLy(); txtDiaChi.Modified = false; txtNguoiThu.Modified = false; txtSdt.Modified = false; txtTienNo.Modified = false; dsIdDL = new int[dsDaiLy.Count]; int i = 0; tb = new DataTable(); tb.Columns.Add("idDL", typeof(int)); tb.Columns.Add("diachi", typeof(string)); tb.Columns.Add("sdt", typeof(string)); tb.Columns.Add("tienno", typeof(float)); foreach (DTO_DaiLy dl in dsDaiLy) { dsIdDL[i] = dl.IdDL; string tendaily = BUS_DaiLy.GetTenById(dl.IdDL); cbDaiLy.Items.Add(tendaily); tb.Rows.Add(dl.IdDL, dl.DiaChi, dl.Sdt, dl.TienNo); i++; } cbDaiLy.SelectedIndex = 0; }
private void cbCN_SelectedIndexChanged(object sender, EventArgs e) { tb.Clear(); if (cbCN.SelectedIndex != -1) { int thang = int.Parse(cbCN.SelectedItem.ToString()); congNo = BUS_BaoCaoCongNo.GetCongNo(thang); foreach (DTO_CongNo dso in congNo) { string tendl = BUS_DaiLy.GetTenById(dso.IdDaiLy); tb.Rows.Add(dso.IdDaiLy, tendl, dso.NoDau, dso.NoCuoi); } gvCN.DataSource = tb; } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { tb.Clear(); if (cbThang.SelectedIndex != -1) { int thang = int.Parse(cbThang.SelectedItem.ToString()); doanhSo = BUS_BaoCaoDoanhSo.GetDoanhSo(thang); foreach (DTO_DoanhSo dso in doanhSo) { string tendl = BUS_DaiLy.GetTenById(dso.IdDaiLy); tb.Rows.Add(dso.IdDaiLy, tendl, dso.SoPhieuXuat, dso.TongDoanhSo, dso.TiLe + "%"); } gvDoanhSo.DataSource = tb; } }
private void UpdateGvDaiLy() { ResetTable(); int t = 0; foreach (DTO_DaiLy dl in dsDaiLy) { arrIdDL[t] = dl.IdDL; t++; string tenDL = BUS_DaiLy.GetTenById(dl.IdDL); string tenQuan = BUS_Quan.GetTen(dl.IdQuan); string tenLoaiDL = BUS_LoaiDL.GetTenById(dl.IdLoaiDL); string tenNV = BUS_NhanVien.GetTenNV(dl.Cmnd); string ngay = dl.NgayNhan.ToString("dd/MM/yyyy"); tb.Rows.Add(dl.IdDL, dl.IdLoaiDL, dl.IdQuan, tenDL, tenLoaiDL, dl.Sdt, tenQuan, ngay, tenNV, dl.TienNo, dl.DiaChi); } }