/* * res : callback goi lai truyen tu main * code : phan loai chuc nang ( them/sua+xoa) . Xem phan constant * */ public DialogBangDiem(Response <Int32> res, int code, bangdiem l) { this.response = res; InitializeComponent(); setViewControl(code); mCode = code; mItem = l; }
internal static int DeleteProfile(bangdiem b) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ma", b.mabd), }; return(DataProvider.ExecuteNonQuery("xoabangdiem", para)); }
private void gridDiem_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (user.Quyen == Constants.CODE_QUYEN_SV) { return; } bangdiem item = (bangdiem)gridDiem.CurrentRow.DataBoundItem; new DialogBangDiem(this, DialogController.CODE_UPDATE, item).Show(); }
private void btnAdd_Click(object sender, EventArgs e) { bangdiem item = getDataFromView(); bool result = new BangdiemSerivices().add(item); if (result) { this.Hide(); //refresh list response.onResponse(Constants.CODE_DIEM); } else { MessageBox.Show("Khong the them vao danh sach"); } }
private bangdiem getDataFromView() { String masv = mListSinhVien[cboMaSv.SelectedIndex].masv; String mamonhoc = mListMonHoc[cboMaMonHoc.SelectedIndex].mamonhoc; String soTietNghi = txtSoTietNghi.Text; String diemtp = txtDiemTp.Text; String diemlan1 = txtDiemLan1.Text; String diemlan2 = txtDiemLan2.Text; bangdiem item = new bangdiem(); item.masv = masv; item.mamonhoc = mamonhoc; item.sotietnghi = soTietNghi; item.diemthilan1 = diemlan1; item.diemthilan2 = diemlan2; item.diemtp = diemtp; return(item); }
public static int UpdateProfile(bangdiem b) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ma", b.mabd), new SqlParameter("@mahs", b.mahs), new SqlParameter("@tb", b.diemtb), new SqlParameter("@toan", b.diemtoan), new SqlParameter("@van", b.diemvan), new SqlParameter("@anh", b.diemanh), new SqlParameter("@hoa", b.diemhoa), new SqlParameter("@ly", b.diemly), new SqlParameter("@sinh", b.diemsinh), new SqlParameter("@su", b.diemsu), new SqlParameter("@dia", b.diemdia), new SqlParameter("@gv", b.giaovienquanly) }; return(DataProvider.ExecuteNonQuery("suabangdiem", para)); }
private List <bangdiem> getListDiemFromExcel(String path) { List <bangdiem> listKhoa = new List <bangdiem>(); xlApp = new Microsoft.Office.Interop.Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(path, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); if (xlWorkSheet != null) { range = xlWorkSheet.UsedRange; int row = range.Rows.Count; int col = range.Columns.Count; for (int r = 2; r <= row; r++) { bangdiem item = new bangdiem(); bool badRow = false; for (int c = 1; c <= col; c++) { String content = "" + (range[r, c] as Range).Value2; if (content.Equals("")) { badRow = true; break; } if (c == 1) { item.masv = content; } else { // item. = content; } } if (!badRow) { listKhoa.Add(item); } } } return(listKhoa); }
private void butluu_Click(object sender, EventArgs e) { if (txtma.Text == "") { MessageBox.Show("Chưa nhập đủ thông tin!"); return; } bangdiem b = new bangdiem(); b.mabd = txtma.Text; b.mahs = cbxmahs.Text; b.diemtb = txttb.Text; b.diemtoan = txttoan.Text; b.diemvan = txtvan.Text; b.diemanh = txtanh.Text; b.diemhoa = txthoa.Text; b.diemly = txtly.Text; b.diemsinh = txtsinh.Text; b.diemsu = txtsu.Text; b.diemdia = txtdia.Text; b.giaovienquanly = cbxgv.Text; if (MessageBox.Show(string.Format("Bạn có muốn lưu Bang diem của học sinh này không?"), "", MessageBoxButtons.OKCancel) == DialogResult.OK) { if (Bus.InsertProfile(b) > 0) { MessageBox.Show("lưu thành công!"); Bangdiem_Load(sender, e); } else { MessageBox.Show("bị Lỗi"); } } }
public static int DeleteProfile(bangdiem b) { return(Dao.DeleteProfile(b)); }
public static int UpdateProfile(bangdiem b) { return(Dao.UpdateProfile(b)); }
public static int InsertProfile(bangdiem b) { return(Dao.InsertProfile(b)); }
public bool update(bangdiem lop) { return(bangdiemController.update(lop)); }
public bool delete(bangdiem lop) { return(bangdiemController.delete(lop)); }
public bool add(bangdiem lop) { return(bangdiemController.insert(lop)); }