public void ToDataRow(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo, ref DataRow dr) { dr[pKQHT_XepLoaiMonHocInfo.strKQHT_XepLoaiMonHocID] = pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID; dr[pKQHT_XepLoaiMonHocInfo.strTenXepLoai] = pKQHT_XepLoaiMonHocInfo.TenXepLoai; dr[pKQHT_XepLoaiMonHocInfo.strTuDiem] = pKQHT_XepLoaiMonHocInfo.TuDiem; dr[pKQHT_XepLoaiMonHocInfo.strMaXepLoai] = pKQHT_XepLoaiMonHocInfo.MaXepLoai; }
public void ToInfo(ref KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo, DataRow dr) { pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID = int.Parse(dr[pKQHT_XepLoaiMonHocInfo.strKQHT_XepLoaiMonHocID].ToString()); pKQHT_XepLoaiMonHocInfo.TenXepLoai = dr[pKQHT_XepLoaiMonHocInfo.strTenXepLoai].ToString(); pKQHT_XepLoaiMonHocInfo.TuDiem = double.Parse(dr[pKQHT_XepLoaiMonHocInfo.strTuDiem].ToString()); pKQHT_XepLoaiMonHocInfo.MaXepLoai = dr[pKQHT_XepLoaiMonHocInfo.strMaXepLoai].ToString(); }
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_KQHT_XepLoaiMonHoc_GetResult>(client.cDKQHT_XepLoaiMonHoc_Get(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo))); } }
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID)); RunProcedure("sp_KQHT_XepLoaiMonHoc_Delete", colParam); }
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID)); return(RunProcedureGet("sp_KQHT_XepLoaiMonHoc_Get", colParam)); }
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { int ID = 0; ID = oDKQHT_XepLoaiMonHoc.Add(pKQHT_XepLoaiMonHocInfo); mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages; mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber; return(ID); }
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { var client = new UnimOsServiceClient(); client.cDKQHT_XepLoaiMonHoc_Delete(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo); client.Close(); mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages; mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber; }
public void Update(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.TenXepLoai)); colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiMonHocInfo.TuDiem)); colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.MaXepLoai)); colParam.Add(CreateParam("@KQHT_XepLoaiMonHocID", SqlDbType.Int, pKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID)); RunProcedure("sp_KQHT_XepLoaiMonHoc_Update", colParam); }
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.TenXepLoai)); colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiMonHocInfo.TuDiem)); colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiMonHocInfo.MaXepLoai)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_XepLoaiMonHoc_Add", colParam)); }
public int Add(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { int ID = 0; var client = new UnimOsServiceClient(); ID = client.cDKQHT_XepLoaiMonHoc_Add(GlobalVar.MaXacThuc, pKQHT_XepLoaiMonHocInfo); client.Close(); mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages; mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber; return(ID); }
public List <KQHT_XepLoaiMonHocInfo> GetList(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { List <KQHT_XepLoaiMonHocInfo> oKQHT_XepLoaiMonHocInfoList = new List <KQHT_XepLoaiMonHocInfo>(); DataTable dtb = Get(pKQHT_XepLoaiMonHocInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_XepLoaiMonHocInfo = new KQHT_XepLoaiMonHocInfo(); oKQHT_XepLoaiMonHocInfo.KQHT_XepLoaiMonHocID = int.Parse(dtb.Rows[i]["KQHT_XepLoaiMonHocID"].ToString()); oKQHT_XepLoaiMonHocInfo.TenXepLoai = dtb.Rows[i]["TenXepLoai"].ToString(); oKQHT_XepLoaiMonHocInfo.TuDiem = double.Parse(dtb.Rows[i]["TuDiem"].ToString()); oKQHT_XepLoaiMonHocInfo.MaXepLoai = dtb.Rows[i]["MaXepLoai"].ToString(); oKQHT_XepLoaiMonHocInfoList.Add(oKQHT_XepLoaiMonHocInfo); } } return(oKQHT_XepLoaiMonHocInfoList); }
private void btnInBangDiem_Click(object sender, EventArgs e) { if (grvLichSu.FocusedRowHandle < 0) { ThongBao("Bạn chưa chọn lần nhập lại điểm nào !"); return; } // Lấy danh sách sinh viên dtSinhVien = CreateTable(); AddBand(); XuLyTable((int)grvLichSu.GetDataRow(grvLichSu.FocusedRowHandle)["KQHT_ChoNhapLaiDiemID"]); if (dtSinhVien.Rows.Count <= 0) { ThongBao("Không có dữ liệu để in báo cáo !"); return; } DataTable dtMain = oBKQHT_DiemThanhPhan.CreateTableReportMain(); DataRow dr = dtMain.NewRow(); dr["TenMonHoc"] = drMonHoc["TenMonHoc"]; dr["TenLop"] = pDM_LopInfo.TenLop.Replace("Lớp: ", ""); dr["HocKy"] = Program.HocKy; dr["NamHoc"] = Program.NamHoc; dr["SoTiet"] = drMonHoc["SoTiet"]; #region Tổng hợp Xếp loại // Đưa dữ liệu phần tỷ lệ kết quả học tập DataTable dtXepLoai; cBKQHT_XepLoaiMonHoc oBKQHT_XepLoaiMonHoc = new cBKQHT_XepLoaiMonHoc(); KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo = new KQHT_XepLoaiMonHocInfo(); int SoSinhVien; dtXepLoai = oBKQHT_XepLoaiMonHoc.Get(pKQHT_XepLoaiMonHocInfo); //dr = dtMain.NewRow(); SoSinhVien = dtSinhVien.Rows.Count; // Tỷ lệ giỏi string Condition = ""; int SoLuong = 0; DataRow[] ArrDr = dtXepLoai.Select("MaXepLoai = 'G'"); if (ArrDr.Length > 0) { Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"]; //foreach (DataRow drXL in ArrDr) //{ // Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"]; //} SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString()); dr["LoaiGioi"] = TinhPhanTram(SoLuong, SoSinhVien); } // Tỷ lệ khá ArrDr = dtXepLoai.Select("MaXepLoai = 'K'"); if (ArrDr.Length > 0) { Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"]; //foreach (DataRow drXL in ArrDr) //{ // Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"]; //} SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString()); dr["LoaiKha"] = TinhPhanTram(SoLuong, SoSinhVien); } // Tỷ lệ trung bình ArrDr = dtXepLoai.Select("MaXepLoai = 'TB'"); if (ArrDr.Length > 0) { Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"]; //foreach (DataRow drXL in ArrDr) //{ // Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"]; //} SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString()); dr["LoaiTrungBinh"] = TinhPhanTram(SoLuong, SoSinhVien); } // Tỷ lệ yếu ArrDr = dtXepLoai.Select("MaXepLoai = 'Y'"); if (ArrDr.Length > 0) { Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"]; //foreach (DataRow drXL in ArrDr) //{ // Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"]; //} SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString()); dr["LoaiYeu"] = TinhPhanTram(SoLuong, SoSinhVien); } // Tỷ lệ kém ArrDr = dtXepLoai.Select("MaXepLoai = 'KM'"); if (ArrDr.Length > 0) { Condition = "IDKQHT_XepLoai_1 = " + ArrDr[0]["KQHT_XepLoaiMonHocID"]; //foreach (DataRow drXL in ArrDr) //{ // Condition += (Condition == "" ? "" : " OR ") + "IDKQHT_XepLoai_1 = " + drXL["KQHT_XepLoaiMonHocID"]; //} Condition += " OR IDKQHT_XepLoai_1 = 0"; SoLuong = int.Parse(dtSinhVien.Compute("Count(SV_SinhVienID)", Condition).ToString()); dr["LoaiKem"] = TinhPhanTram(SoLuong, SoSinhVien); } dtMain.Rows.Add(dr); #endregion DataTable dtSub = oBKQHT_DiemThanhPhan.CreateTableReportSub_CDCNKT(dtSinhVien, dtThanhPhan, ColStart, IDKQHT_ThanhPhanTBHS); frmReport frm = new frmReport(dtMain, dtSub, "rBangKetQuaHocTap", "rBangKetQuaHocTapSub", new string[] { "SubReport1" }); frm.Show(); }
public void Delete(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { oDKQHT_XepLoaiMonHoc.Delete(pKQHT_XepLoaiMonHocInfo); mErrorMessage = oDKQHT_XepLoaiMonHoc.ErrorMessages; mErrorNumber = oDKQHT_XepLoaiMonHoc.ErrorNumber; }
public DataTable Get(KQHT_XepLoaiMonHocInfo pKQHT_XepLoaiMonHocInfo) { return(oDKQHT_XepLoaiMonHoc.Get(pKQHT_XepLoaiMonHocInfo)); }