private void bntLuu_Click(object sender, EventArgs e) { try { ReceivableDetailDAO.ListDemoReceivableDetail.RemoveAt(studentReceivableDAO.TherowFocust); ReceivableDetail a = new ReceivableDetail(); a.Name = txtTenKhoanThu.Text; a.Price = decimal.Parse(txtMucThu.Text); a.Status = true; a.TimeUnits = cbbDonViThoiGian.Text; a.Frequency = int.Parse(txtTanso.Text); a.TotalPriceDetail = decimal.Parse(txtTongthu.Text); a.GradeID = (int)cbbKhoihoc.SelectedValue; a.StartDay = (DateTime)dtNgayBatDau.EditValue; a.EndDay = (DateTime)dtNgayKetThuc.EditValue; a.Feedback = cbHoanLai.Checked == true ? true : false; if (cbDoituongchinhsach.Checked == true) { a.PreferredID = PreferredDAO.PreferredIDList; } else { a.PreferredID = ""; } ReceivableDetailDAO.ListDemoReceivableDetail.Add(a); this.Close(); } catch { } }
private void bntSua_Click(object sender, EventArgs e) { if (ReceivableDetailDAO.DemoReceibavleDetail is null) { } else { FRSuaKhoanThu a = new FRSuaKhoanThu(); a.ShowDialog(); } grCacsKhoanThu.RefreshData(); // đưa trỏ chuột về dòng đầu tiên try { ReceivableDetail a = new ReceivableDetail(); a.Name = grCacsKhoanThu.GetRowCellValue(0, "Name").ToString(); a.Price = decimal.Parse(grCacsKhoanThu.GetRowCellValue(0, "Price").ToString()); a.Status = true; a.TimeUnits = grCacsKhoanThu.GetRowCellValue(0, "TimeUnits").ToString(); a.Frequency = int.Parse(grCacsKhoanThu.GetRowCellValue(0, "Frequency").ToString()); a.TotalPriceDetail = decimal.Parse(grCacsKhoanThu.GetRowCellValue(0, "TotalPriceDetail").ToString()); a.GradeID = (int)grCacsKhoanThu.GetRowCellValue(0, "GradeID"); a.Feedback = (bool)grCacsKhoanThu.GetRowCellValue(0, "Feedback"); a.PreferredID = grCacsKhoanThu.GetRowCellValue(0, "PreferredID").ToString(); PreferredDAO.PreferredIDList = grCacsKhoanThu.GetRowCellValue(0, "PreferredID").ToString(); ReceivableDetailDAO.DemoReceibavleDetail = a; } catch { } }
public bool Remove(ReceivableDetail entity) { ReceivableDetail a = dt.ReceivableDetails.Where(t => t.ReceivableDetailID == entity.ReceivableDetailID).FirstOrDefault(); dt.ReceivableDetails.DeleteOnSubmit(a); dt.SubmitChanges(); return(true); }
public bool Edit(ReceivableDetail entity) { ReceivableDetail a = dt.ReceivableDetails.Where(t => t.ReceivableDetailID == entity.ReceivableDetailID).FirstOrDefault(); a.ReceivableID = entity.ReceivableID; a.Name = entity.Name; a.Price = entity.Price; a.GradeID = entity.GradeID; a.PreferredID = entity.PreferredID; a.Status = entity.Status; a.Frequency = entity.Frequency; a.TimeUnits = entity.TimeUnits; a.Feedback = entity.Feedback; a.TotalPriceDetail = entity.TotalPriceDetail; dt.SubmitChanges(); return(true); }
public int Insert(ReceivableDetail entity) { ReceivableDetail a = new ReceivableDetail(); a.ReceivableID = entity.ReceivableID; a.Name = entity.Name; a.Price = entity.Price; a.Status = entity.Status; a.PreferredID = entity.PreferredID; a.GradeID = entity.GradeID; a.TotalPriceDetail = entity.TotalPriceDetail; a.TimeUnits = entity.TimeUnits; a.Frequency = entity.Frequency; a.Feedback = entity.Feedback; dt.ReceivableDetails.InsertOnSubmit(a); dt.SubmitChanges(); return(a.ReceivableDetailID); }
public void LoadKhoanPhi() { ReceivableDetail_StudentDAO dt = new ReceivableDetail_StudentDAO(); ReceivableDetailDAO dc = new ReceivableDetailDAO(); List <ReceivableDetail_Student> a = new List <ReceivableDetail_Student>(); List <ReceivableDetail> b = new List <ReceivableDetail>(); a = dt.ListReceivableDetail_Student(ClassStudentDAO.StudentID); foreach (var i in a) { ReceivableDetail c = new ReceivableDetail(); c = dc.ReceivableDetaiByStudenID(i.ReceivableDetailID, ReceivableIDAO.ReceivableID); if (c != null) { b.Add(c); } } grDanhsachkhoanthu.DataSource = b; }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { try { ReceivableDetail a = new ReceivableDetail(); a.Name = gridView1.GetRowCellValue(e.FocusedRowHandle, "Name").ToString(); a.Price = decimal.Parse(gridView1.GetRowCellValue(e.FocusedRowHandle, "Price").ToString()); a.Status = true; a.TimeUnits = gridView1.GetRowCellValue(e.FocusedRowHandle, "TimeUnits").ToString(); a.Frequency = int.Parse(gridView1.GetRowCellValue(e.FocusedRowHandle, "Frequency").ToString()); a.TotalPriceDetail = decimal.Parse(gridView1.GetRowCellValue(e.FocusedRowHandle, "TotalPriceDetail").ToString()); a.GradeID = (int)gridView1.GetRowCellValue(e.FocusedRowHandle, "GradeID"); a.Feedback = (bool)gridView1.GetRowCellValue(e.FocusedRowHandle, "Feedback"); a.PreferredID = gridView1.GetRowCellValue(e.FocusedRowHandle, "PreferredID").ToString(); PreferredDAO.PreferredIDList = gridView1.GetRowCellValue(e.FocusedRowHandle, "PreferredID").ToString(); ReceivableDetailDAO.DemoReceibavleDetail = a; studentReceivableDAO.TherowFocust = gridView1.FocusedRowHandle; } catch { } }
private void bntKhoitao_Click(object sender, EventArgs e) { if (txtTendotthu.Text == "") { MessageBox.Show("Bạn cần nhập đủ thông tin đợt thu"); } else { if (cbbHocky.Text != "") { try { // thêm đợt thu ReceivableIDAO rb = new ReceivableIDAO(); ReceivableDetailDAO rbd = new ReceivableDetailDAO(); Receivable rbdt = new Receivable(); rbdt.Name = txtTendotthu.Text; rbdt.CourseID = (int)cbbNamhoc.SelectedValue; rbdt.SemesterID = (int)cbbHocky.SelectedValue; rbdt.StartDate = dtNgaybatdau.Value; rbdt.EndDate = dtNgayketthuc.Value; rbdt.CreatedDate = dtNgaykhoitao.Value; rbdt.Note = txtGhiChu.Text; rbdt.Status = false; int c = rb.Insert(rbdt); // thêm khoản thu if (c != 0) { ReceivableDetail detail = new ReceivableDetail(); for (int i = 0; i < gridView1.RowCount; i++) { detail.Name = gridView1.GetRowCellValue(i, gridView1.Columns["Name"]).ToString(); detail.ReceivableID = c; detail.Price = (decimal)gridView1.GetRowCellValue(i, gridView1.Columns["Price"]); detail.Status = false; detail.TimeUnits = gridView1.GetRowCellValue(i, gridView1.Columns["TimeUnits"]).ToString(); detail.Frequency = (int)gridView1.GetRowCellValue(i, gridView1.Columns["Frequency"]); detail.TotalPriceDetail = (decimal)gridView1.GetRowCellValue(i, gridView1.Columns["TotalPriceDetail"]); detail.GradeID = (int)gridView1.GetRowCellValue(i, gridView1.Columns["GradeID"]); detail.Feedback = (bool)gridView1.GetRowCellValue(i, gridView1.Columns["Feedback"]); detail.PreferredID = gridView1.GetRowCellValue(i, gridView1.Columns["PreferredID"]).ToString(); int d = rbd.Insert(detail); if (d != 0) { //thêm khoản thu học cho học sinh theo lớp hiện hành StudenGrade gr = new StudenGrade(); ReceivableDetail_StudentDAO st = new ReceivableDetail_StudentDAO(); List <Student_Class> listClassID = gr.lookStudenbyGradeID((int)detail.GradeID); foreach (var j in listClassID) { if (j.Status == true) { ReceivableDetail_Student dt = new ReceivableDetail_Student(); dt.ReceivableDetailID = d; dt.StudentID = j.StudentID; dt.Status = false; if (st.Insert(dt) == true) { } else { MessageBox.Show("ban gi bi loi"); } } } } else { MessageBox.Show("Ban ghi " + i + " bi loi"); } } MessageBox.Show("Khoi tao hoan tat"); this.Close(); } } catch { MessageBox.Show("Loi"); } } } }
public ReceivableDetail ReceivableDetaiByStudenID(int ReceivableDetailID, int ReceivableId) { ReceivableDetail a = dt.ReceivableDetails.Where(t => t.ReceivableDetailID == ReceivableDetailID && t.ReceivableID == ReceivableId).FirstOrDefault(); return(a); }
private void export() { try { #region ===========khởi tạo excel===== //khởi tạo excell Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); //khởi tạo workbook Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); //khởi tọa worksheet Microsoft.Office.Interop.Excel._Worksheet worksheet = null; worksheet = workbook.Sheets["Sheet1"]; worksheet = workbook.ActiveSheet; worksheet.Name = "Danh sách hoc sinh"; app.Visible = true;//cho hiển thị excel #endregion ===========khởi tạo excel========== #region ===========đổ dữ liệu vào sheet====== worksheet.Cells[1, 1] = "SỞ GIÁO DỤC VÀ ĐÀO TẠO HÀ NỘI"; worksheet.Cells[2, 1] = "TRƯỜNG MẦM NON HOA LINH"; worksheet.Cells[4, 1] = "DANH SÁCH HỌC SINH"; worksheet.Cells[5, 1] = "Năm học:" + cbbNamhoc.Text; worksheet.Cells[6, 1] = "Khối:" + cbbKhoihoc.Text; worksheet.Cells[7, 1] = "Lớp:" + cbbLophoc.Text; worksheet.Cells[9, 1] = "STT"; worksheet.Cells[9, 2] = "Mã học sinh"; worksheet.Cells[9, 3] = "Họ"; worksheet.Cells[9, 4] = "Tên"; worksheet.Cells[9, 5] = "Ngày sinh"; worksheet.Cells[9, 6] = "Giới tính"; worksheet.Cells[9, 7] = "Địa chỉ"; worksheet.Cells[9, 8] = "Tình trạng"; worksheet.Cells[9, 9] = "Tổng thu"; //duyệt dết các dòng trong trong gridcontrol for (int i = 0; i < gridView1.RowCount; i++) { #region ==== tinh tien hoc tung hoc sinh====== ReceivableDetail_StudentDAO dt = new ReceivableDetail_StudentDAO(); ReceivableDetailDAO dc = new ReceivableDetailDAO(); List <ReceivableDetail_Student> a = new List <ReceivableDetail_Student>(); List <ReceivableDetail> b = new List <ReceivableDetail>(); decimal tong = 0; a = dt.ListReceivableDetail_Student((int)gridView1.GetRowCellValue(i, gridView1.Columns["StudentID"])); foreach (var j in a) { ReceivableDetail c = new ReceivableDetail(); c = dc.ReceivableDetaiByStudenID(j.ReceivableDetailID, (int)cbbDotthu.SelectedValue); if (c != null) { tong += (decimal)c.TotalPriceDetail; b.Add(c); } } foreach (var j in b) { string mg = j.PreferredID; List <string> b1 = new List <string>(); int perferredID = (int)gridView1.GetRowCellValue(i, gridView1.Columns["PreferredID"]); for (int sj = 0; sj < (mg.Length - 1); sj += 2) { string c = mg.Substring(sj, 1); b1.Add(c); } if (b1.Count == 0) { worksheet.Cells[10 + i, 9] = tong; } else { foreach (var k in b1) { if (int.Parse(k) == perferredID) { PreferredDAO dv = new PreferredDAO(); float pr = dv.lookPreferredPercent(perferredID); tong = tong - (((decimal)j.TotalPriceDetail * (decimal)pr) / 100); worksheet.Cells[10 + i, 9] = tong; break; } worksheet.Cells[10 + i, 9] = tong; } } } // grDanhsachkhoanthu.DataSource = b; #endregion ==== tinh tien hoc tung hoc sinh==== #region ---- thong tin hoc sinh---- worksheet.Cells[10 + i, 1] = i + 1; worksheet.Cells[10 + i, 2] = gridView1.GetRowCellValue(i, gridView1.Columns["StudentCode"]); worksheet.Cells[10 + i, 3] = gridView1.GetRowCellValue(i, gridView1.Columns["FirstName"]); worksheet.Cells[10 + i, 4] = gridView1.GetRowCellValue(i, gridView1.Columns["LastName"]); worksheet.Cells[10 + i, 5] = gridView1.GetRowCellValue(i, gridView1.Columns["Birthday"]); if ((bool)gridView1.GetRowCellValue(i, gridView1.Columns["Gender"]) == true) { worksheet.Cells[10 + i, 6] = "Nam"; } else { worksheet.Cells[10 + i, 6] = "Nữ"; } //worksheet.Cells[10 + i, 6] = gridView1.GetRowCellValue(i, gridView1.Columns["Gender"]); worksheet.Cells[10 + i, 7] = gridView1.GetRowCellValue(i, gridView1.Columns["AdressDetail"]); worksheet.Cells[10 + i, 8] = gridView1.GetRowCellValue(i, gridView1.Columns["tinhtrang"]); #endregion ---thong tin hoc sinh------ } int dongData = gridView1.RowCount; worksheet.Cells[dongData + 13, 8] = "Hà Nội, ngày tháng năm . "; worksheet.Cells[dongData + 14, 8] = "HIỆU TRƯỞNG. "; #endregion ============đổ dữ liệu vào sheet======= #region =====căn chỉnh====== //định dạng trang worksheet.PageSetup.Orientation = Microsoft.Office.Interop.Excel.XlPageOrientation.xlPortrait; // Giấy dọc worksheet.PageSetup.PaperSize = Microsoft.Office.Interop.Excel.XlPaperSize.xlPaperA4; // Loại giấy A4 worksheet.PageSetup.LeftMargin = 0; //can le trai worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.BottomMargin = 0; worksheet.PageSetup.CenterHorizontally = true; //can giua theo chieu ngang //dinh dang cot worksheet.Range["A1"].ColumnWidth = 3; worksheet.Range["B1"].ColumnWidth = 13; worksheet.Range["C1"].ColumnWidth = 13; worksheet.Range["D1"].ColumnWidth = 8; worksheet.Range["E1"].ColumnWidth = 13; worksheet.Range["F1"].ColumnWidth = 10; worksheet.Range["G1"].ColumnWidth = 28; worksheet.Range["H1"].ColumnWidth = 14; worksheet.Range["I1"].ColumnWidth = 11; worksheet.Range["J1"].ColumnWidth = 14; worksheet.Range["K1"].ColumnWidth = 11; //dinh dang font chu worksheet.Range["A1", "K100"].Font.Name = "Times New Roman"; worksheet.Range["A1", "K100"].Font.Size = 10; // size cho font chữ worksheet.Range["A4", "K4"].Font.Size = 12; // Size tiêu đề lớn hơn chút worksheet.Range["A1", "K2"].Font.Size = 16; // Size tiêu đề lớn hơn chút worksheet.Range["A5", "K7"].Font.Size = 12; worksheet.Range["A1", "I1"].MergeCells = true; // Nhập dòng tiêu đề worksheet.Range["A2", "I2"].MergeCells = true; worksheet.Range["A4", "I4"].MergeCells = true; worksheet.Range["A5", "I5"].MergeCells = true; worksheet.Range["A6", "I6"].MergeCells = true; worksheet.Range["A7", "I7"].MergeCells = true; worksheet.Range["A1", "K7"].Font.Bold = true; //to dam tieu de worksheet.Range["A9", "K9"].Font.Bold = true; //to dam ten cot worksheet.Range["A9", "I" + (dongData + 9)].Borders.LineStyle = 1; //ke vien bang worksheet.Range["A3", "A9"].HorizontalAlignment = 3; // Căn giữa tiêu đề bảng worksheet.Range["A8", "K8"].HorizontalAlignment = 3; // Tiêu đề cột bảng căn giữa worksheet.Range["A4", "K4"].HorizontalAlignment = 3; worksheet.Range["A5", "K5"].HorizontalAlignment = 3; worksheet.Range["A6", "K6"].HorizontalAlignment = 3; #endregion ====căn chỉnh===== } catch { } }