private void ConfigToSuccessForm() { tablePanel1.Rows[0].Height = tablePanel1.Rows[1].Height; ExpressionMethod.EditGridView(grvDSTieuDe); ExpressionMethod.EditGridView(grvDSGanDia); bindingDSTilte.DataSource = null; ExpressionMethod.LoadGridControl(grcDSTieuDe, grvDSTieuDe, bindingDSTilte); ExpressionMethod.LoadGridControl(grc_DSGanDia, grvDSGanDia, bindingDSDatTruoc); }
private void LoadView() { try { binding.DataSource = db.GetTitles(); ExpressionMethod.LoadGridControl(grd_TieuDe, grv_TieuDe, binding); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadDuDoanGridView(int idCustomer) { var dbAllRented = dbRented.GetListRenteds(); var lstDuDoan = dbAllRented.Where(x => x.IdCustomer == idCustomer && x.StatusOnBill == null && x.ExpectedReturnDate < DateTime.Today).Select(x => new { IdDisk = x.IdDisk, ExpectedReturnDate = x.ExpectedReturnDate }) .Join(dbDisk.GetDisks(), dd => dd.IdDisk, d => d.IdDisk, (dd, d) => new { dd, d }) .Join(dbTitle.GetTitles(), ddd => ddd.d.IdTitle, t => t.IdTitle, (ddd, t) => new{ IdDisk = ddd.dd.IdDisk, ExpectedReturnDate = ddd.dd.ExpectedReturnDate, Title = t.NameTitle }); var bindingDuDoan = new BindingSource(); bindingDuDoan.DataSource = lstDuDoan; ExpressionMethod.LoadGridControl(grcDuDoan, grvDuDoan, bindingDuDoan); var lstTreHan = dbAllRented.Where(x => x.IdCustomer == idCustomer && x.StatusOnBill != null && x.StatusOnBill.Equals(STATUS_UNPAID)).Select(x => new{ IdDisk = x.IdDisk, ExpectedReturnDate = x.ExpectedReturnDate, ActualReturnDate = x.ActualReturnDate, LateFee = x.LateFee }); var bindingTreHan = new BindingSource(); bindingTreHan.DataSource = lstTreHan; ExpressionMethod.LoadGridControl(grcTreHan, grvTreHan, bindingTreHan); double?phitrehan = 0; foreach (var item in lstTreHan) { phitrehan += item.LateFee; } txtTongPhiNo.Text = phitrehan.ToString(); }
private void ReportTitle() { var dbBSThueCuaTitle = (from d in dbDisk.GetDisks() group d by d.IdTitle into titleGroup select new { Title = titleGroup.Key, SoLuongThue = titleGroup.Where(x => x.DiskRentalStatus.Equals(STATUS_RENTED)).Count(), SoLuongBSDatTruoc = titleGroup.Where(x => x.DiskRentalStatus.Equals(STATUS_ONHOLD)).Count(), }) .Join(dbTitle.GetTitles(), bs => bs.Title, t => t.IdTitle, (bs, t) => new { idTitle = t.IdTitle, TitleName = t.NameTitle, SoLuongTrenKe = t.TotalDiskOnShelf, SoLuongThue = bs.SoLuongThue, SoLuongBSDatTruoc = bs.SoLuongBSDatTruoc }); var dbDSDatTruoc = from pre in dbListPre.GetListTitlePreOrders().Where(x => x.StatusProcess.Equals(STATUS_INCOMPLETE)) group pre by pre.IdTitle into preListGroup select new { idTitle = preListGroup.Key, TongDatTruoc = preListGroup.Sum(x => x.NumberOfDisk) }; var db = dbBSThueCuaTitle .GroupJoin(dbDSDatTruoc, bss => bss.idTitle, dt => dt.idTitle, (bss, dt) => new { bss, dt }) .SelectMany(temp => temp.dt.DefaultIfEmpty(), (bs, temp) => new { bs = bs, dt = temp }); List <ReportTitle> lst = new List <ReportTitle>(); foreach (var item in db) { int?tongsodattruoc = 0; if (item.dt != null) { tongsodattruoc = item.dt.TongDatTruoc; } lst.Add(new ReportTitle { TitleName = item.bs.bss.TitleName, TongSoBanSao = item.bs.bss.SoLuongThue + item.bs.bss.SoLuongTrenKe + item.bs.bss.SoLuongBSDatTruoc, TongSoBanSaoDuocDatTruoc = tongsodattruoc, TongSoBanSaoDuocThue = item.bs.bss.SoLuongThue, TongSoBanSaoTrongKho = item.bs.bss.SoLuongTrenKe, TongSoDatTruocDangXuLi = item.bs.bss.SoLuongBSDatTruoc }); } bindingTitle.DataSource = lst; ExpressionMethod.LoadGridControl(grcTieuDe, grvTieuDe, bindingTitle); }
private void LoadView() { binding.DataSource = db.GetCustomers(); ExpressionMethod.LoadGridControl(grd_KhachHang, grv_KhachHang, binding); }
private void LoadView() { binding.DataSource = new List <DiskInfoRent>(); ExpressionMethod.LoadGridControl(grdc_DSThueDia, grv_ThueDia, binding); }
private void LoadView() { ReportTitle(); ExpressionMethod.LoadGridControl(grcKH, grvKH, bindingCustomer); }
private void LoadView() { binding.DataSource = db.GetDisks(); ExpressionMethod.LoadGridControl(grdc_CD, grv_CD, binding); }
private void ConfigToSuccessView() { ExpressionMethod.EditGridView(grvDSDatTruoc); ExpressionMethod.LoadGridControl(grdc_DanhSach, grvDSDatTruoc, bindingDSDatTruoc); }
private void LoadView() { binding.DataSource = db.GetDiskTypes(); ExpressionMethod.LoadGridControl(grd_LoaiDia, grv_LoaiDia, binding); }
private void LoadView() { binding.DataSource = new List <DiskInfoReturn>(); ExpressionMethod.LoadGridControl(grc_TraDia, grv_TraDia, binding); }