public long AddByImport(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, string MaSinhVien)
{
pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = oDKQHT_DiemTongKetMon.AddByImport(pKQHT_DiemTongKetMonInfo, MaSinhVien);
mErrorMessage = oDKQHT_DiemTongKetMon.ErrorMessages;
mErrorNumber = oDKQHT_DiemTongKetMon.ErrorNumber;
return(pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID);
}
public DataTable Get(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemTongKetMon_GetResult>(client.cDKQHT_DiemTongKetMon_Get(GlobalVar.MaXacThuc, pKQHT_DiemTongKetMonInfo)));
}
}
public List <KQHT_DiemTongKetMonInfo> GetList(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
List <KQHT_DiemTongKetMonInfo> oKQHT_DiemTongKetMonInfoList = new List <KQHT_DiemTongKetMonInfo>();
DataTable dtb = Get(pKQHT_DiemTongKetMonInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = long.Parse(dtb.Rows[i]["KQHT_DiemTongKetMonID"].ToString());
oKQHT_DiemTongKetMonInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DiemTongKetMonInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_DiemTongKetMonInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DiemTongKetMonInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_DiemTongKetMonInfo.LanThi = int.Parse(dtb.Rows[i]["LanThi"].ToString());
oKQHT_DiemTongKetMonInfo.Diem = double.Parse(dtb.Rows[i]["Diem"].ToString());
oKQHT_DiemTongKetMonInfo.LyDo = dtb.Rows[i]["LyDo"].ToString();
oKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai = int.Parse(dtb.Rows[i]["IDKQHT_XepLoai"].ToString());
oKQHT_DiemTongKetMonInfoList.Add(oKQHT_DiemTongKetMonInfo);
}
}
return(oKQHT_DiemTongKetMonInfoList);
}
public DataTable Get(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemTongKetMonID", SqlDbType.BigInt, pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID));
return(RunProcedureGet("sp_KQHT_DiemTongKetMon_Get", colParam));
}
public void Delete(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemTongKetMonID", SqlDbType.BigInt, pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID));
RunProcedure("sp_KQHT_DiemTongKetMon_Delete", colParam);
}
public void Add(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DiemTongKetMon_Add(GlobalVar.MaXacThuc, pKQHT_DiemTongKetMonInfo);
client.Close();
mErrorMessage = oDKQHT_DiemTongKetMon.ErrorMessages;
mErrorNumber = oDKQHT_DiemTongKetMon.ErrorNumber;
}
//public void ToInfo(ref KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, DataRow dr)
//{
// pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = long.Parse(dr[pKQHT_DiemTongKetMonInfo.strKQHT_DiemTongKetMonID].ToString());
// pKQHT_DiemTongKetMonInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDSV_SinhVien].ToString());
// pKQHT_DiemTongKetMonInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDDM_MonHoc].ToString());
// pKQHT_DiemTongKetMonInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDDM_NamHoc].ToString());
// pKQHT_DiemTongKetMonInfo.HocKy = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strHocKy].ToString());
// pKQHT_DiemTongKetMonInfo.LanThi = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strLanThi].ToString());
// pKQHT_DiemTongKetMonInfo.Diem = double.Parse(dr[pKQHT_DiemTongKetMonInfo.strDiem].ToString());
// pKQHT_DiemTongKetMonInfo.LyDo = dr[pKQHT_DiemTongKetMonInfo.strLyDo].ToString();
// pKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDKQHT_XepLoai].ToString());
//}
public void TinhDiemTBM(DataTable dtSV, DataTable dtXLMonHoc, DataRow drMonHoc, int IDDM_Lop, int IDDM_TrinhDo, string IDThanhPhanThi,
int IDKQHT_ThanhPhanTBHS, int LanThi, string CongThucDiem, int IDDM_NamHoc, int HocKy, int IDNS_GiaoVien)
{
DataTable dtDiem = (new cBwsKQHT_DiemThanhPhan()).GetTongHopTBHS(int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString()),
int.Parse(drMonHoc["DM_MonHocID"].ToString()), IDDM_Lop, IDDM_TrinhDo, IDDM_NamHoc, HocKy, LanThi);
oKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oKQHT_DiemTongKetMonInfo.IDDM_MonHoc = int.Parse(drMonHoc["DM_MonHocID"].ToString());
oKQHT_DiemTongKetMonInfo.IDXL_MonHocTrongKy = int.Parse(drMonHoc["XL_MonHocTrongKyID"].ToString());
oKQHT_DiemTongKetMonInfo.IDDM_NamHoc = IDDM_NamHoc;
oKQHT_DiemTongKetMonInfo.HocKy = HocKy;
oKQHT_DiemTongKetMonInfo.LanThi = LanThi;
bool CoDiemThi, CoDiemTBHS;
DataRow[] arrDr;
foreach (DataRow dr in dtSV.Rows)
{
if ("" + dr[IDKQHT_ThanhPhanTBHS.ToString() + "_" + LanThi.ToString()] != "")
{
CoDiemTBHS = true;
}
else
{
CoDiemTBHS = false;
}
if ("" + dr[IDThanhPhanThi + "_" + LanThi.ToString()] != "")
{
CoDiemThi = true;
}
else
{
CoDiemThi = false;
}
if (CoDiemTBHS || CoDiemThi)
{
arrDr = dtDiem.Select("IDSV_SinhVien = " + dr["SV_SinhVienID"]);
oKQHT_DiemTongKetMonInfo.IDSV_SinhVien = int.Parse(dr["SV_SinhVienID"].ToString());
oKQHT_DiemTongKetMonInfo.Diem = TestCongThuc(dr, arrDr, CongThucDiem, IDThanhPhanThi, IDKQHT_ThanhPhanTBHS, LanThi);
oKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai = XepLoaiMonHoc(dtXLMonHoc, oKQHT_DiemTongKetMonInfo.Diem);
var client = new UnimOsServiceClient();
client.cDKQHT_DiemTongKetMon_Add(GlobalVar.MaXacThuc, oKQHT_DiemTongKetMonInfo);
client.Close();
dr["TK_" + LanThi.ToString()] = oKQHT_DiemTongKetMonInfo.Diem;
dr["IDKQHT_XepLoai_" + LanThi.ToString()] = oKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai;
}
else
{
var client = new UnimOsServiceClient();
client.cDKQHT_DiemTongKetMon_DeleteByIDMonHocTrongKy(GlobalVar.MaXacThuc, int.Parse(dr["SV_SinhVienID"].ToString()), oKQHT_DiemTongKetMonInfo.IDXL_MonHocTrongKy, LanThi);
client.Close();
}
}
}
public frmNhapDiemHoiDongMonHoc()
{
InitializeComponent();
oBKQHT_HoiDongMon = new cBKQHT_HoiDongMon();
pKQHT_HoiDongMonInfo = new KQHT_HoiDongMonInfo();
pKQHT_HoiDongMon_DiemInfo = new KQHT_HoiDongMon_DiemInfo();
oBKQHT_HoiDongMon_Diem = new cBKQHT_HoiDongMon_Diem();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public long AddByImport(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, string MaSinhVien)
{
var client = new UnimOsServiceClient();
pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = client.cDKQHT_DiemTongKetMon_AddByImport(GlobalVar.MaXacThuc, pKQHT_DiemTongKetMonInfo, MaSinhVien);
client.Close();
mErrorMessage = oDKQHT_DiemTongKetMon.ErrorMessages;
mErrorNumber = oDKQHT_DiemTongKetMon.ErrorNumber;
return(pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID);
}
public frmNhapDiemTongKet()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
oBKQHT_DaChuyenDiem = new cBKQHT_DaChuyenDiem();
}
public frmNhapDiemTheoSoBDVaPhach()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
cls = new clsDataTableHelper();
}
//public List<KQHT_DiemTongKetMonInfo> GetList(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
//{
// List<KQHT_DiemTongKetMonInfo> oKQHT_DiemTongKetMonInfoList = new List<KQHT_DiemTongKetMonInfo>();
// DataTable dtb = Get(pKQHT_DiemTongKetMonInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
// oKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = long.Parse(dtb.Rows[i]["KQHT_DiemTongKetMonID"].ToString());
// oKQHT_DiemTongKetMonInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
// oKQHT_DiemTongKetMonInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
// oKQHT_DiemTongKetMonInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
// oKQHT_DiemTongKetMonInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
// oKQHT_DiemTongKetMonInfo.LanThi = int.Parse(dtb.Rows[i]["LanThi"].ToString());
// oKQHT_DiemTongKetMonInfo.Diem = double.Parse(dtb.Rows[i]["Diem"].ToString());
// oKQHT_DiemTongKetMonInfo.LyDo = dtb.Rows[i]["LyDo"].ToString();
// oKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai = int.Parse(dtb.Rows[i]["IDKQHT_XepLoai"].ToString());
// oKQHT_DiemTongKetMonInfoList.Add(oKQHT_DiemTongKetMonInfo);
// }
// }
// return oKQHT_DiemTongKetMonInfoList;
//}
public void ToDataRow(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, ref DataRow dr)
{
dr[pKQHT_DiemTongKetMonInfo.strKQHT_DiemTongKetMonID] = pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID;
dr[pKQHT_DiemTongKetMonInfo.strIDSV_SinhVien] = pKQHT_DiemTongKetMonInfo.IDSV_SinhVien;
dr[pKQHT_DiemTongKetMonInfo.strIDDM_MonHoc] = pKQHT_DiemTongKetMonInfo.IDDM_MonHoc;
dr[pKQHT_DiemTongKetMonInfo.strIDDM_NamHoc] = pKQHT_DiemTongKetMonInfo.IDDM_NamHoc;
dr[pKQHT_DiemTongKetMonInfo.strHocKy] = pKQHT_DiemTongKetMonInfo.HocKy;
dr[pKQHT_DiemTongKetMonInfo.strLanThi] = pKQHT_DiemTongKetMonInfo.LanThi;
dr[pKQHT_DiemTongKetMonInfo.strDiem] = pKQHT_DiemTongKetMonInfo.Diem;
dr[pKQHT_DiemTongKetMonInfo.strLyDo] = pKQHT_DiemTongKetMonInfo.LyDo;
dr[pKQHT_DiemTongKetMonInfo.strIDKQHT_XepLoai] = pKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai;
}
public void ToInfo(ref KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, DataRow dr)
{
pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID = long.Parse(dr[pKQHT_DiemTongKetMonInfo.strKQHT_DiemTongKetMonID].ToString());
pKQHT_DiemTongKetMonInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDSV_SinhVien].ToString());
pKQHT_DiemTongKetMonInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDDM_MonHoc].ToString());
pKQHT_DiemTongKetMonInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDDM_NamHoc].ToString());
pKQHT_DiemTongKetMonInfo.HocKy = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strHocKy].ToString());
pKQHT_DiemTongKetMonInfo.LanThi = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strLanThi].ToString());
pKQHT_DiemTongKetMonInfo.Diem = double.Parse(dr[pKQHT_DiemTongKetMonInfo.strDiem].ToString());
pKQHT_DiemTongKetMonInfo.LyDo = dr[pKQHT_DiemTongKetMonInfo.strLyDo].ToString();
pKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai = int.Parse(dr[pKQHT_DiemTongKetMonInfo.strIDKQHT_XepLoai].ToString());
}
public frmTongKetDiemMonHoc()
{
InitializeComponent();
// Check quyền để cho phép hay không cho phép thực hiện thao tạc lưu dữ liệu
SetQuyen(this, "" + this.Tag);
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
}
public int AddByImport(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo, string MaSinhVien)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, MaSinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemTongKetMonInfo.Diem));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DiemTongKetMon_AddByImport", 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 void Update(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemTongKetMonInfo.Diem));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DiemTongKetMonInfo.LyDo));
colParam.Add(CreateParam("@IDKQHT_XepLoai", SqlDbType.Int, pKQHT_DiemTongKetMonInfo.IDKQHT_XepLoai));
colParam.Add(CreateParam("@KQHT_DiemTongKetMonID", SqlDbType.BigInt, pKQHT_DiemTongKetMonInfo.KQHT_DiemTongKetMonID));
RunProcedure("sp_KQHT_DiemTongKetMon_Update", colParam);
}
public frmNhapDiemTongKet()
{
InitializeComponent();
// Check quyền để cho phép hay không cho phép thực hiện thao tạc lưu dữ liệu
SetQuyen(this, "" + this.Tag);
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
oBKQHT_DiemMonThiTotNghiep = new cBKQHT_DiemMonThiTotNghiep();
dtXLMonHoc = (new cBKQHT_XepLoaiMonHoc()).Get(new KQHT_XepLoaiMonHocInfo());
}
public DataTable Get(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
return(oDKQHT_DiemTongKetMon.Get(pKQHT_DiemTongKetMonInfo));
}
public void Add(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
oDKQHT_DiemTongKetMon.Add(pKQHT_DiemTongKetMonInfo);
mErrorMessage = oDKQHT_DiemTongKetMon.ErrorMessages;
mErrorNumber = oDKQHT_DiemTongKetMon.ErrorNumber;
}
public void Delete(KQHT_DiemTongKetMonInfo pKQHT_DiemTongKetMonInfo)
{
oDKQHT_DiemTongKetMon.Delete(pKQHT_DiemTongKetMonInfo);
mErrorMessage = oDKQHT_DiemTongKetMon.ErrorMessages;
mErrorNumber = oDKQHT_DiemTongKetMon.ErrorNumber;
}
