// Function Load database to grid wiew private void loadDataTable() { table_bill.DataSource = bill.GetAll(); table_bill.MainView.PopulateColumns(); ((GridView)table_bill.MainView).Columns[0].Caption = "Mã hóa đơn"; ((GridView)table_bill.MainView).Columns[1].Caption = "Mã Sim"; ((GridView)table_bill.MainView).Columns[2].Caption = "Ngày xuất phiếu"; ((GridView)table_bill.MainView).Columns[2].DisplayFormat.FormatType = FormatType.DateTime; ((GridView)table_bill.MainView).Columns[2].DisplayFormat.FormatString = "dd/MM/yyyy"; ((GridView)table_bill.MainView).Columns[3].Caption = "Ngày cắt"; ((GridView)table_bill.MainView).Columns[3].DisplayFormat.FormatType = FormatType.DateTime; ((GridView)table_bill.MainView).Columns[3].DisplayFormat.FormatString = "dd/MM/yyyy"; ((GridView)table_bill.MainView).Columns[4].Caption = "Cước thuê bao"; ((GridView)table_bill.MainView).Columns[5].Caption = "Cước phí hàng tháng"; ((GridView)table_bill.MainView).Columns[6].Caption = "Tình trạng"; ((GridView)table_bill.MainView).Columns[7].Visible = false; }
private void ShowAllBill() { lvBill.Items.Clear(); List <Bill> bills = billBUS.GetAll(); foreach (Bill bill in bills) { ListViewItem item = new ListViewItem(bill.ID.ToString()); item.SubItems.Add(bill.Name); item.SubItems.Add(bill.Datetime.ToString("dd/MM/yyyy hh:mm:ss")); item.SubItems.Add(bill.Total.ToString()); item.SubItems.Add(bill.Status.ToString()); item.Tag = bill; if (bill.Status == BillStatus.Unprocessed) { item.Group = lvBill.Groups["lvgUnprocessed"]; } else if (bill.Status == BillStatus.Processing) { item.Group = lvBill.Groups["lvgProcessing"]; } else if (bill.Status == BillStatus.Shipping) { item.Group = lvBill.Groups["lvgShipping"]; } else if (bill.Status == BillStatus.Done) { item.Group = lvBill.Groups["lvgDone"]; } else if (bill.Status == BillStatus.Cancel) { item.Group = lvBill.Groups["lvgCancel"]; } lvBill.Items.Add(item); } }