private void gridTietHoc_SelectionChanged(object sender, SelectionChangedEventArgs e)//binding { try { tietHocSelected = ((TietHoc)gridTietHoc.Items[gridTietHoc.SelectedIndex]); ngayHocTxt.SelectedDate = tietHocSelected.NgayHoc; cbxTrangThai.SelectedIndex = tietHocSelected.TrangThai + 1; txtTenPhong.Text = tietHocSelected.TenPhong; txtTietBatDau.Text = tietHocSelected.TietBatDau + ""; txtGhiChu.Text = tietHocSelected.GhiChu; if (!(tietHocSelected is TietHocBu)) { txtTietBatDau.IsEnabled = false; ngayHocTxt.IsEnabled = false; } else { txtTietBatDau.IsEnabled = true; ngayHocTxt.IsEnabled = true; } } catch { } }
private List <TietHoc> sortBuoiHoc(List <TietHoc> th) { for (int i = 0; i < th.Count - 1; i++) { for (int j = i + 1; j < th.Count; j++) { if (TietHoc.Compare(th[i], th[j]) > 0) { TietHoc temp = th[i]; th[i] = th[j]; th[j] = temp; } } } return(th); }
private void btnSua_Click(object sender, RoutedEventArgs e) { TietHoc th; if (tietHocSelected is TietHocBu) { th = new TietHocBu(this.lopHoc, tietHocSelected.Id, txtTenPhong.Text, ngayHocTxt.SelectedDate.Value, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text, int.Parse(txtTietBatDau.Text)); } else { th = new TietHoc(tietHocSelected.LopHoc, tietHocSelected.Id, txtTenPhong.Text.ToUpper(), tietHocSelected.NgayHoc, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text); } TietHocDAO.Instance.SuaTietHoc(th); gridTietHoc.ItemsSource = sortBuoiHoc(TietHocDAO.Instance.DSTietHocTheoLopHoc(this.lopHoc.MaLopHoc + "")); }
private void ExportDataGridViewTo_Excel() { try { Excel.Application oExcel = null; //Excel_12 Application Excel.Workbook oBook = null; // Excel_12 Workbook Excel.Sheets oSheetsColl = null; // Excel_12 Worksheets collection Excel.Worksheet oSheet = null; // Excel_12 Worksheet Excel.Range oRange = null; // Cell or Range in worksheet Object oMissing = System.Reflection.Missing.Value; // Create an instance of Excel_12. oExcel = new Excel.Application(); // Make Excel_12 visible to the user. oExcel.Visible = true; // Set the UserControl property so Excel_12 won't shut down. oExcel.UserControl = true; // System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US"); //object file = File_Name; //object missing = System.Reflection.Missing.Value; // Add a workbook. oBook = oExcel.Workbooks.Add(oMissing); // Get worksheets collection oSheetsColl = oExcel.Worksheets; // Get Worksheet "Sheet1" oSheet = (Excel.Worksheet)oSheetsColl.get_Item("Sheet1"); oSheet.Name = "BuoiHoc"; oSheet.Range[oSheet.Cells[1, 1], oSheet.Cells[1, 8]].Merge(); oRange = (Excel.Range)oSheet.Cells[1, 1]; oRange.Value2 = lopHoc.GiangVien.HoTenGV; oRange.EntireRow.Font.Bold = true; oRange.EntireRow.Font.Size = 16; oSheet.Range[oSheet.Cells[2, 1], oSheet.Cells[2, 8]].Merge(); oRange = (Excel.Range)oSheet.Cells[2, 1]; oRange.Value2 = lopHoc.NoiDung; oRange.EntireRow.Font.Size = 12; oSheet.Range[oSheet.Cells[3, 1], oSheet.Cells[3, 8]].Merge(); oRange = (Excel.Range)oSheet.Cells[3, 1]; oRange.Value2 = lopHoc.NoiDungLop; oRange.EntireRow.Font.Size = 12; // Export titles for (int j = 0; j < gridTietHoc.Columns.Count; j++) { oRange = (Excel.Range)oSheet.Cells[5, j + 1]; //oRange.DisplayFormat.Font.Background = Colors.Black; //oRange.DisplayFormat.Font.Color = Colors.White; oRange.Value2 = gridTietHoc.Columns[j].Header; oRange.Interior.ColorIndex = 5; oRange.EntireRow.Font.Bold = true; oRange.EntireRow.Font.Size = 14; oRange.EntireRow.Font.ColorIndex = 2; oRange.Columns.ColumnWidth = 20; oRange.Columns.Borders.ColorIndex = 2; oRange.Columns.Borders.Weight = 2; oRange.Columns.VerticalAlignment = AlignmentY.Center; } // Export data for (int i = 0; i < gridTietHoc.Items.Count; i++) { TietHoc th = ((TietHoc)gridTietHoc.Items[i]); oRange = (Excel.Range)oSheet.Cells[i + 6, 1]; oRange.Value2 = th.NgayHoc.ToShortDateString() + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 2]; oRange.Value2 = th.Tuan + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 3]; oRange.Value2 = th.TuanHocBu + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 4]; oRange.Value2 = th.Thu + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 5]; oRange.Value2 = th.TenPhong + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 6]; oRange.Value2 = th.SoTiet + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 7]; oRange.Value2 = th.TextTrangThai + ""; oRange = (Excel.Range)oSheet.Cells[i + 6, 8]; oRange.Value2 = th.GhiChu + ""; } oBook = null; oExcel.Quit(); oExcel = null; GC.Collect(); } catch (Exception) { } }