public List <KQHT_DiemThanhPhanInfo> GetList(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
List <KQHT_DiemThanhPhanInfo> oKQHT_DiemThanhPhanInfoList = new List <KQHT_DiemThanhPhanInfo>();
DataTable dtb = Get(pKQHT_DiemThanhPhanInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
oKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID = long.Parse(dtb.Rows[i]["KQHT_DiemThanhPhanID"].ToString());
oKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DiemThanhPhanInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_DiemThanhPhanInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DiemThanhPhanInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem = int.Parse(dtb.Rows[i]["IDKQHT_ThanhPhanDiem"].ToString());
oKQHT_DiemThanhPhanInfo.Diem = double.Parse(dtb.Rows[i]["Diem"].ToString());
oKQHT_DiemThanhPhanInfo.LyDo = dtb.Rows[i]["LyDo"].ToString();
oKQHT_DiemThanhPhanInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString());
oKQHT_DiemThanhPhanInfo.NgayTao = DateTime.Parse(dtb.Rows[i]["NgayTao"].ToString());
oKQHT_DiemThanhPhanInfoList.Add(oKQHT_DiemThanhPhanInfo);
}
}
return(oKQHT_DiemThanhPhanInfoList);
}
public DataTable Get(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThanhPhan_GetResult>(client.cDKQHT_DiemThanhPhan_Get(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo)));
}
}
public DataTable Get(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemThanhPhanID", SqlDbType.BigInt, pKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID));
return(RunProcedureGet("sp_KQHT_DiemThanhPhan_Get", colParam));
}
public void Delete(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemThanhPhanID", SqlDbType.BigInt, pKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID));
RunProcedure("sp_KQHT_DiemThanhPhan_Delete", colParam);
}
public int AddByImport(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo, int LanThi, string MaSinhVien)
{
int ID = 0;
ID = oDKQHT_DiemThanhPhan.AddByImport(pKQHT_DiemThanhPhanInfo, LanThi, MaSinhVien);
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
return(ID);
}
public int Add(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
int ID = 0;
ID = oDKQHT_DiemThanhPhan.Add(pKQHT_DiemThanhPhanInfo);
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
return(ID);
}
public void Delete(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DiemThanhPhan_Delete(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo);
client.Close();
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
}
public int AddByImport(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo, int LanThi, string MaSinhVien)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_DiemThanhPhan_AddByImport(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo, LanThi, MaSinhVien);
client.Close();
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
return(ID);
}
public int Add(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_DiemThanhPhan_Add(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo);
client.Close();
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
return(ID);
}
public void ToInfo(ref KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo, DataRow dr)
{
pKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID = long.Parse(dr[pKQHT_DiemThanhPhanInfo.strKQHT_DiemThanhPhanID].ToString());
pKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strIDSV_SinhVien].ToString());
pKQHT_DiemThanhPhanInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strIDDM_MonHoc].ToString());
pKQHT_DiemThanhPhanInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strIDDM_NamHoc].ToString());
pKQHT_DiemThanhPhanInfo.HocKy = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strHocKy].ToString());
pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strIDKQHT_ThanhPhanDiem].ToString());
pKQHT_DiemThanhPhanInfo.Diem = double.Parse(dr[pKQHT_DiemThanhPhanInfo.strDiem].ToString());
pKQHT_DiemThanhPhanInfo.LyDo = dr[pKQHT_DiemThanhPhanInfo.strLyDo].ToString();
pKQHT_DiemThanhPhanInfo.IDHT_User = int.Parse(dr[pKQHT_DiemThanhPhanInfo.strIDHT_User].ToString());
pKQHT_DiemThanhPhanInfo.NgayTao = DateTime.Parse(dr[pKQHT_DiemThanhPhanInfo.strNgayTao].ToString());
}
public frmNhapDiemThanhPhan()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DiemThanhPhan = new cBKQHT_DiemThanhPhan();
pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
rdgTuDanhSach.Enabled = false;
}
public void ToDataRow(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo, ref DataRow dr)
{
dr[pKQHT_DiemThanhPhanInfo.strKQHT_DiemThanhPhanID] = pKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID;
dr[pKQHT_DiemThanhPhanInfo.strIDSV_SinhVien] = pKQHT_DiemThanhPhanInfo.IDSV_SinhVien;
dr[pKQHT_DiemThanhPhanInfo.strIDDM_MonHoc] = pKQHT_DiemThanhPhanInfo.IDDM_MonHoc;
dr[pKQHT_DiemThanhPhanInfo.strIDDM_NamHoc] = pKQHT_DiemThanhPhanInfo.IDDM_NamHoc;
dr[pKQHT_DiemThanhPhanInfo.strHocKy] = pKQHT_DiemThanhPhanInfo.HocKy;
dr[pKQHT_DiemThanhPhanInfo.strIDKQHT_ThanhPhanDiem] = pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem;
dr[pKQHT_DiemThanhPhanInfo.strDiem] = pKQHT_DiemThanhPhanInfo.Diem;
dr[pKQHT_DiemThanhPhanInfo.strLyDo] = pKQHT_DiemThanhPhanInfo.LyDo;
dr[pKQHT_DiemThanhPhanInfo.strIDHT_User] = pKQHT_DiemThanhPhanInfo.IDHT_User;
dr[pKQHT_DiemThanhPhanInfo.strNgayTao] = pKQHT_DiemThanhPhanInfo.NgayTao;
}
public void DeleteByInfo(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.HocKy));
colParam.Add(CreateParam("@IDKQHT_ThanhPhanDiem", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem));
colParam.Add(CreateParam("@DiemThu", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.DiemThu));
colParam.Add(CreateParam("@DiemLan", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.DiemLan));
RunProcedure("sp_KQHT_DiemThanhPhan_DeleteByInfo", colParam);
}
public frmNhapDiemTheoLopHocLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBKQHT_DiemThanhPhan = new cBKQHT_DiemThanhPhan();
pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_LopHocLai = new cBKQHT_LopHocLai();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public int AddByImport(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo, int LanThi, string MaSinhVien)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, MaSinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.HocKy));
colParam.Add(CreateParam("@IDKQHT_ThanhPhanDiem", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemThanhPhanInfo.Diem));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDHT_User));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DiemThanhPhan_AddByImport", colParam));
}
public void Update(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.HocKy));
colParam.Add(CreateParam("@IDKQHT_ThanhPhanDiem", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem));
colParam.Add(CreateParam("@DiemThu", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.DiemThu));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemThanhPhanInfo.Diem));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DiemThanhPhanInfo.LyDo));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDHT_User));
colParam.Add(CreateParam("@KQHT_DiemThanhPhanID", SqlDbType.BigInt, pKQHT_DiemThanhPhanInfo.KQHT_DiemThanhPhanID));
RunProcedure("sp_KQHT_DiemThanhPhan_Update", colParam);
}
public int Add(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.HocKy));
colParam.Add(CreateParam("@IDKQHT_ThanhPhanDiem", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem));
colParam.Add(CreateParam("@DiemThu", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.DiemThu));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemThanhPhanInfo.Diem));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DiemThanhPhanInfo.LyDo));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDHT_User));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@DiemLan", SqlDbType.Int, pKQHT_DiemThanhPhanInfo.DiemLan));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DiemThanhPhan_Add", colParam));
}
public void TinhDiemTBHS(DataTable dtSV, DataRow drMonHoc, int IDDM_Lop, int IDDM_TrinhDo, int IDDM_NamHoc, int HocKy, int IDKQHT_ThanhPhanDiem, int LanThi, string CongThucDiem, int NS_GiaoVienID)
{
DataTable dtDiem = GetTongHopTBHS(int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString()), int.Parse(drMonHoc["DM_MonHocID"].ToString()), IDDM_Lop, IDDM_TrinhDo, IDDM_NamHoc, HocKy, LanThi);
DataTable dtTPBatBuoc = (new cDKQHT_ThanhPhanDiemBatBuoc()).GetByTrinhDo(IDDM_TrinhDo);
string TinhCaTietNghiCoPhep = (new cBHT_ThamSoHeThong()).GetGiaTriByMaThamSo("TinhCaTietNghiCoPhep");
string LyDo;
int SoTietNghi;
double DiemThapNhat = double.Parse((new cBHT_ThamSoHeThong()).GetGiaTriByMaThamSo("DieuKienDiemDuThi"));
DataRow[] arrDr, arrDrTPBatBuoc;
KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_DiemThanhPhanInfo.IDDM_MonHoc = int.Parse(drMonHoc["DM_MonHocID"].ToString());
pKQHT_DiemThanhPhanInfo.IDXL_MonHocTrongKy = int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString());
pKQHT_DiemThanhPhanInfo.IDDM_NamHoc = IDDM_NamHoc;
pKQHT_DiemThanhPhanInfo.HocKy = HocKy;
pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem = IDKQHT_ThanhPhanDiem;
pKQHT_DiemThanhPhanInfo.IDHT_User = NS_GiaoVienID;
pKQHT_DiemThanhPhanInfo.DiemThu = LanThi;
pKQHT_DiemThanhPhanInfo.DiemLan = LanThi;
cDKQHT_DanhSachKhongThi oDKQHT_DanhSachKhongThi = new cDKQHT_DanhSachKhongThi();
KQHT_DanhSachKhongThiInfo pKQHT_DanhSachKhongThiInfo = new KQHT_DanhSachKhongThiInfo();
pKQHT_DanhSachKhongThiInfo.IDDM_MonHoc = pKQHT_DiemThanhPhanInfo.IDDM_MonHoc;
pKQHT_DanhSachKhongThiInfo.IDDM_NamHoc = IDDM_NamHoc;
pKQHT_DanhSachKhongThiInfo.HocKy = HocKy;
pKQHT_DanhSachKhongThiInfo.LanThi = LanThi;
foreach (DataRow dr in dtSV.Rows)
{
LyDo = "";
// Kiểm tra số tiết nghỉ
SoTietNghi = int.Parse("0" + dr["KhongLyDo"]);
if (TinhCaTietNghiCoPhep != "0")
{
SoTietNghi += int.Parse("0" + dr["CoLyDo"]);
}
if (SoTietNghi > SoTietNghiChoPhep * int.Parse("0" + drMonHoc["SoTiet"]))
{
LyDo = "Nghỉ quá số tiết quy định;";
}
// Kiểm tra số thành phần điểm
arrDr = dtDiem.Select("IDSV_SinhVien = " + dr["SV_SinhVienID"]);
if (arrDr.Length > 0)
{
foreach (DataRow dr1 in arrDr)
{
arrDrTPBatBuoc = dtTPBatBuoc.Select("SoHocTrinh = " + drMonHoc["SoHocTrinh"] + " And IDKQHT_ThanhPhanDiem = " + dr1["IDKQHT_ThanhPhanDiem"]);
if (arrDrTPBatBuoc.Length > 0)
{
if (int.Parse("0" + dr1["SoDiem"]) < int.Parse("0" + arrDrTPBatBuoc[0]["SoDiemBatBuoc"]))
{
dr1["SoDiem"] = arrDrTPBatBuoc[0]["SoDiemBatBuoc"];
LyDo += "Số thành phần của " + dr1["KyHieu"] + " ít hơn quy định;";
}
}
}
// Được phép tổng hợp điểm hệ số
pKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DiemThanhPhanInfo.Diem = TestCongThuc(arrDr, CongThucDiem);
if (!(double.IsInfinity(pKQHT_DiemThanhPhanInfo.Diem) ||
double.IsNaN(pKQHT_DiemThanhPhanInfo.Diem) || double.IsNegativeInfinity(pKQHT_DiemThanhPhanInfo.Diem)))
{
dr[IDKQHT_ThanhPhanDiem.ToString() + "_" + LanThi.ToString()] = pKQHT_DiemThanhPhanInfo.Diem;
oDKQHT_DiemThanhPhan.Add(pKQHT_DiemThanhPhanInfo);
pKQHT_DiemThanhPhanInfo.Diem = 0;
}
if (pKQHT_DiemThanhPhanInfo.Diem < DiemThapNhat)
{
LyDo += "Điểm TBHS < " + DiemThapNhat.ToString() + ";";
}
}
else
{
LyDo = "Chưa có điểm thành phần";
pKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
oDKQHT_DiemThanhPhan.DeleteByInfo(pKQHT_DiemThanhPhanInfo);
}
if (LyDo != "")
{
// Đưa SV vào danh sách không được thi
pKQHT_DanhSachKhongThiInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DanhSachKhongThiInfo.LyDo = LyDo;
pKQHT_DanhSachKhongThiInfo.LanThi = LanThi;
oDKQHT_DanhSachKhongThi.AddTuDong(pKQHT_DanhSachKhongThiInfo);
dr["LyDo"] = LyDo;
}
else if ("" + dr["LyDo"] != "")
{
pKQHT_DanhSachKhongThiInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DanhSachKhongThiInfo.LanThi = LanThi;
oDKQHT_DanhSachKhongThi.DeleteTuDong(pKQHT_DanhSachKhongThiInfo);
dr["LyDo"] = "";
}
}
oDKQHT_DanhSachKhongThi.DeleteDanhSachDuThi(pKQHT_DanhSachKhongThiInfo, pKQHT_DiemThanhPhanInfo.IDXL_MonHocTrongKy);
}
public void TinhDiemTBHS_QCNghe(DataTable dtSV, DataRow drMonHoc, int IDDM_Lop, int IDDM_TrinhDo, int IDDM_NamHoc, int HocKy, int IDKQHT_ThanhPhanDiem, int LanThi, string CongThucDiem, int NS_GiaoVienID)
{
DataTable dtDiem = GetTongHopTBHS(int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString()), int.Parse(drMonHoc["DM_MonHocID"].ToString()), IDDM_Lop, IDDM_TrinhDo, IDDM_NamHoc, HocKy, LanThi);
DataTable dtTPBatBuoc = (new cDKQHT_ThanhPhanDiemBatBuoc()).GetByTrinhDo(IDDM_TrinhDo);
string TinhCaTietNghiCoPhep = (new cBwsHT_ThamSoHeThong()).GetGiaTriByMaThamSo("TinhCaTietNghiCoPhep");
string LyDo;
//int SoTietNghi;
double DiemThapNhat = double.Parse((new cBwsHT_ThamSoHeThong()).GetGiaTriByMaThamSo("DieuKienDiemDuThi"));
DataRow[] arrDr, arrDrTPBatBuoc;
KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_DiemThanhPhanInfo.IDDM_MonHoc = int.Parse(drMonHoc["DM_MonHocID"].ToString());
pKQHT_DiemThanhPhanInfo.IDXL_MonHocTrongKy = int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString());
pKQHT_DiemThanhPhanInfo.IDDM_NamHoc = IDDM_NamHoc;
pKQHT_DiemThanhPhanInfo.HocKy = HocKy;
pKQHT_DiemThanhPhanInfo.IDKQHT_ThanhPhanDiem = IDKQHT_ThanhPhanDiem;
pKQHT_DiemThanhPhanInfo.IDHT_User = NS_GiaoVienID;
pKQHT_DiemThanhPhanInfo.DiemThu = LanThi;
pKQHT_DiemThanhPhanInfo.DiemLan = LanThi;
cDKQHT_DanhSachKhongThi oDKQHT_DanhSachKhongThi = new cDKQHT_DanhSachKhongThi();
KQHT_DanhSachKhongThiInfo pKQHT_DanhSachKhongThiInfo = new KQHT_DanhSachKhongThiInfo();
pKQHT_DanhSachKhongThiInfo.IDDM_MonHoc = pKQHT_DiemThanhPhanInfo.IDDM_MonHoc;
pKQHT_DanhSachKhongThiInfo.IDDM_NamHoc = IDDM_NamHoc;
pKQHT_DanhSachKhongThiInfo.HocKy = HocKy;
foreach (DataRow dr in dtSV.Rows)
{
LyDo = "";
// Kiểm tra số tiết nghỉ
//SoTietNghi = int.Parse("0" + dr["KhongLyDo"]);
//if (TinhCaTietNghiCoPhep != "0")
// SoTietNghi += int.Parse("0" + dr["CoLyDo"]);
//if (SoTietNghi > SoTietNghiChoPhep * int.Parse("0" + drMonHoc["SoTiet"]))
//{
// LyDo = "Nghỉ quá số tiết quy định;";
//}
// Kiểm tra số tiết học lại
if ("" + dr["SoTietHocLai"] != "")
{
LyDo = "Học lại " + dr["SoTietHocLai"] + " tiết";
}
// Kiểm tra số thành phần điểm
arrDr = dtDiem.Select("IDSV_SinhVien = " + dr["SV_SinhVienID"]);
if (arrDr.Length > 0)
{
foreach (DataRow dr1 in arrDr)
{
arrDrTPBatBuoc = dtTPBatBuoc.Select("SoHocTrinh = " + drMonHoc["SoHocTrinh"] + " And IDKQHT_ThanhPhanDiem = " + dr1["IDKQHT_ThanhPhanDiem"]);
if (arrDrTPBatBuoc.Length > 0)
{
if (int.Parse("0" + dr1["SoDiem"]) < int.Parse("0" + arrDrTPBatBuoc[0]["SoDiemBatBuoc"]))
{
dr1["SoDiem"] = arrDrTPBatBuoc[0]["SoDiemBatBuoc"];
LyDo += "Số thành phần của " + dr1["KyHieu"] + " ít hơn quy định;";
}
}
}
// Được phép tổng hợp điểm hệ số
pKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DiemThanhPhanInfo.Diem = TestCongThuc(arrDr, CongThucDiem);
dr[IDKQHT_ThanhPhanDiem.ToString() + "_" + LanThi.ToString()] = pKQHT_DiemThanhPhanInfo.Diem;
var client = new UnimOsServiceClient();
client.cDKQHT_DiemThanhPhan_Add(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo);
client.Close();
if (pKQHT_DiemThanhPhanInfo.Diem < DiemThapNhat)
{
LyDo += "Điểm TBHS < " + DiemThapNhat.ToString() + ";";
}
}
else
{
LyDo = "Chưa có điểm thành phần";
pKQHT_DiemThanhPhanInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
var client = new UnimOsServiceClient();
client.cDKQHT_DiemThanhPhan_DeleteByInfo(GlobalVar.MaXacThuc, pKQHT_DiemThanhPhanInfo);
client.Close();
}
if (LyDo != "" || "" + dr["SoTietHocLai"] != "")
{
// Đưa SV vào danh sách không được thi
pKQHT_DanhSachKhongThiInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DanhSachKhongThiInfo.LyDo = LyDo;
pKQHT_DanhSachKhongThiInfo.LanThi = LanThi;
if ("" + dr["SoTietHocLai"] != "")
{
pKQHT_DanhSachKhongThiInfo.SoTietHocLai = int.Parse("" + dr["SoTietHocLai"]);
}
else
{
pKQHT_DanhSachKhongThiInfo.SoTietHocLai = null;
}
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachKhongThi_AddTuDong(GlobalVar.MaXacThuc, pKQHT_DanhSachKhongThiInfo);
client.Close();
dr["LyDo"] = LyDo;
}
else if ("" + dr["LyDo"] != "" && "" + dr["SoTietHocLai"] == "")
{
pKQHT_DanhSachKhongThiInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
pKQHT_DanhSachKhongThiInfo.LanThi = LanThi;
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachKhongThi_DeleteTuDong(GlobalVar.MaXacThuc, pKQHT_DanhSachKhongThiInfo);
client.Close();
dr["LyDo"] = "";
}
}
}
public void Update(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
oDKQHT_DiemThanhPhan.Update(pKQHT_DiemThanhPhanInfo);
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
}
public void DeleteByInfo(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
oDKQHT_DiemThanhPhan.DeleteByInfo(pKQHT_DiemThanhPhanInfo);
mErrorMessage = oDKQHT_DiemThanhPhan.ErrorMessages;
mErrorNumber = oDKQHT_DiemThanhPhan.ErrorNumber;
}
public DataTable Get(KQHT_DiemThanhPhanInfo pKQHT_DiemThanhPhanInfo)
{
return(oDKQHT_DiemThanhPhan.Get(pKQHT_DiemThanhPhanInfo));
}
