public void UpdateTachGop(int XL_MonHocTrongKyID, bool HocOLopTachGop)
{
var client = new UnimOsServiceClient();
client.cDXL_MonHocTrongKy_UpdateTachGop(GlobalVar.MaXacThuc, XL_MonHocTrongKyID, HocOLopTachGop);
client.Close();
mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
mErrorNumber = oDXL_MonHocTrongKy.ErrorNumber;
}
public void UpdateDaChuyenDiem(bool IsDaChuyen, double IDXL_MonHocTrongKy, int LanThi)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachDuThi_UpdateDaChuyenDiem(GlobalVar.MaXacThuc, IsDaChuyen, IDXL_MonHocTrongKy, LanThi);
client.Close();
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
public void UpdateDaChuyenDiemByToChucThi(bool IsDaChuyen, int IDKQHT_ToChucThi, int LanThi)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachDuThi_UpdateDaChuyenDiemByToChucThi(GlobalVar.MaXacThuc, IsDaChuyen, IDKQHT_ToChucThi, LanThi);
client.Close();
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
//public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDKQHT_DanhSachDuThi_Add(GlobalVar.MaXacThuc, pKQHT_DanhSachDuThiInfo);
// client.Close();
// mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
// mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
// return ID;
//}
//public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDKQHT_DanhSachDuThi_Update(GlobalVar.MaXacThuc, pKQHT_DanhSachDuThiInfo);
// client.Close();
// mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
// mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
//}
public void UpdateSoPhach(string SoPhach, int TuiThiSo, double KQHT_DanhSachDuThiID)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachDuThi_UpdateSoPhach(GlobalVar.MaXacThuc, SoPhach, TuiThiSo, KQHT_DanhSachDuThiID);
client.Close();
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
public DataTable GetTreeTheoKhoa(string NamHoc)
{
var client = new UnimOsServiceClient();
DataTable dt = ConvertList.ToDataTable <sp_DM_Lop_GetTreeResult>(client.cDDM_Lop_GetTree(GlobalVar.MaXacThuc, NamHoc));
//DataTable dt = client.cDDM_Lop_GetTree(GlobalVar.MaXacThuc, NamHoc);
client.Close();
return(CreateTree(dt));
}
public void Update(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
{
var client = new UnimOsServiceClient();
client.cDXL_MonHocTrongKy_Update(GlobalVar.MaXacThuc, pXL_MonHocTrongKyInfo);
client.Close();
mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
mErrorNumber = oDXL_MonHocTrongKy.ErrorNumber;
}
//public int Add(HT_UserInfo pHT_UserInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDHT_User_Add(GlobalVar.MaXacThuc, pHT_UserInfo);
// client.Close();
// mErrorMessage = oDHT_User.ErrorMessages;
// mErrorNumber = oDHT_User.ErrorNumber;
// return ID;
//}
//public void Update(HT_UserInfo pHT_UserInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDHT_User_Update(GlobalVar.MaXacThuc, pHT_UserInfo);
// client.Close();
// mErrorMessage = oDHT_User.ErrorMessages;
// mErrorNumber = oDHT_User.ErrorNumber;
//}
public void UpdateChucNang(int HT_UserID, int IDHT_UserGroup)
{
var client = new UnimOsServiceClient();
client.cDHT_User_UpdateChucNang(GlobalVar.MaXacThuc, HT_UserID, IDHT_UserGroup);
client.Close();
mErrorMessage = oDHT_User.ErrorMessages;
mErrorNumber = oDHT_User.ErrorNumber;
}
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 UpdateTrangThai(bool DaDongBo, long HT_DongBoID)
{
var client = new UnimOsServiceClient();
client.cDHT_DongBo_UpdateTrangThai(GlobalVar.MaXacThuc, DaDongBo, HT_DongBoID);
client.Close();
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
}
public void Delete(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
var client = new UnimOsServiceClient();
client.cDHT_ThongTinTruong_Delete(GlobalVar.MaXacThuc, pHT_ThongTinTruongInfo);
client.Close();
mErrorMessage = oDHT_ThongTinTruong.ErrorMessages;
mErrorNumber = oDHT_ThongTinTruong.ErrorNumber;
}
public void Update(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_MonHoc_CT_KhoiKienThuc_Update(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo);
client.Close();
mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber;
}
public void Update(HT_DongBoInfo pHT_DongBoInfo)
{
var client = new UnimOsServiceClient();
client.cDHT_DongBo_Update(GlobalVar.MaXacThuc, pHT_DongBoInfo);
client.Close();
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
}
public void Delete(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
var client = new UnimOsServiceClient();
client.cDGG_HeSoLopDongTheoKhoa_Delete(GlobalVar.MaXacThuc, pGG_HeSoLopDongTheoKhoaInfo);
client.Close();
mErrorMessage = oDGG_HeSoLopDongTheoKhoa.ErrorMessages;
mErrorNumber = oDGG_HeSoLopDongTheoKhoa.ErrorNumber;
}
//public void Delete(GG_GiangDayGiaoVienInfo pGG_GiangDayGiaoVienInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDGG_GiangDayGiaoVien_Delete(GlobalVar.MaXacThuc, pGG_GiangDayGiaoVienInfo);
// client.Close();
// mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages;
// mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber;
//}
public void DeleteNotIn(int IDNS_GiaoVien, int IDDM_NamHoc, int HocKy, string IDGGNotIn)
{
var client = new UnimOsServiceClient();
client.cDGG_GiangDayGiaoVien_DeleteNotIn(GlobalVar.MaXacThuc, IDNS_GiaoVien, IDDM_NamHoc, HocKy, IDGGNotIn);
client.Close();
mErrorMessage = oDGG_GiangDayGiaoVien.ErrorMessages;
mErrorNumber = oDGG_GiangDayGiaoVien.ErrorNumber;
}
public void UpdateDiem(double Diem, double KQHT_DanhSachDuThiID)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachDuThi_UpdateDiem(GlobalVar.MaXacThuc, Diem, KQHT_DanhSachDuThiID);
client.Close();
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
public void ApDungCacLopKhac(int DM_LopID, int DM_LopIDNew, int IDDM_NamHoc, int HocKy)
{
var client = new UnimOsServiceClient();
client.cDXL_MonHocTrongKy_ApDungCacLopKhac(GlobalVar.MaXacThuc, DM_LopID, DM_LopIDNew, IDDM_NamHoc, HocKy);
client.Close();
mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
mErrorNumber = oDXL_MonHocTrongKy.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 void HuyPhachMonLop(long IDXL_MonHocTrongKy, int LanThi)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DanhSachDuThi_HuyPhachMonLop(GlobalVar.MaXacThuc, IDXL_MonHocTrongKy, LanThi);
client.Close();
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
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 int Add(KQHT_DiemDanhInfo pKQHT_DiemDanhInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_DiemDanh_Add(GlobalVar.MaXacThuc, pKQHT_DiemDanhInfo);
client.Close();
mErrorMessage = oDKQHT_DiemDanh.ErrorMessages;
mErrorNumber = oDKQHT_DiemDanh.ErrorNumber;
return(ID);
}
public int Add(XL_PhanCongGiaoVienInfo pXL_PhanCongGiaoVienInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDXL_PhanCongGiaoVien_Add(GlobalVar.MaXacThuc, pXL_PhanCongGiaoVienInfo);
client.Close();
mErrorMessage = oDXL_PhanCongGiaoVien.ErrorMessages;
mErrorNumber = oDXL_PhanCongGiaoVien.ErrorNumber;
return(ID);
}
public int Add(DM_HinhThucThiInfo pDM_HinhThucThiInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_HinhThucThi_Add(GlobalVar.MaXacThuc, pDM_HinhThucThiInfo);
client.Close();
mErrorMessage = oDDM_HinhThucThi.ErrorMessages;
mErrorNumber = oDDM_HinhThucThi.ErrorNumber;
return(ID);
}
public int Add(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDGG_DinhMucGioDay_Add(GlobalVar.MaXacThuc, pGG_DinhMucGioDayInfo);
client.Close();
mErrorMessage = oDGG_DinhMucGioDay.ErrorMessages;
mErrorNumber = oDGG_DinhMucGioDay.ErrorNumber;
return(ID);
}
//public int Add(KQHT_DanhSachKhongThiInfo pKQHT_DanhSachKhongThiInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDKQHT_DanhSachKhongThi_Add(GlobalVar.MaXacThuc, pKQHT_DanhSachKhongThiInfo);
// client.Close();
// mErrorMessage = oDKQHT_DanhSachKhongThi.ErrorMessages;
// mErrorNumber = oDKQHT_DanhSachKhongThi.ErrorNumber;
// return ID;
//}
public int AddTuDong(KQHT_DanhSachKhongThiInfo pKQHT_DanhSachKhongThiInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_DanhSachKhongThi_AddTuDong(GlobalVar.MaXacThuc, pKQHT_DanhSachKhongThiInfo);
client.Close();
mErrorMessage = oDKQHT_DanhSachKhongThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachKhongThi.ErrorNumber;
return(ID);
}
//public int Add(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDDM_TinhHuyenXa_Add(GlobalVar.MaXacThuc, pDM_TinhHuyenXaInfo);
// client.Close();
// mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
// mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
// return ID;
//}
public int AddByImport(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo, string MaCha)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_TinhHuyenXa_AddByImport(GlobalVar.MaXacThuc, pDM_TinhHuyenXaInfo, MaCha);
client.Close();
mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
return(ID);
}
public int Add(HT_LogInfo pHT_LogInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDHT_Log_Add(GlobalVar.MaXacThuc, pHT_LogInfo);
client.Close();
mErrorMessage = oDHT_Log.ErrorMessages;
mErrorNumber = oDHT_Log.ErrorNumber;
return(ID);
}
public int Add(KQHT_ChuongTrinhDaoTaoInfo pKQHT_ChuongTrinhDaoTaoInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_ChuongTrinhDaoTao_Add(GlobalVar.MaXacThuc, pKQHT_ChuongTrinhDaoTaoInfo);
client.Close();
mErrorMessage = oDKQHT_ChuongTrinhDaoTao.ErrorMessages;
mErrorNumber = oDKQHT_ChuongTrinhDaoTao.ErrorNumber;
return(ID);
}
public int AddByImport(DM_MonHocInfo pDM_MonHocInfo, ref string Error)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_MonHoc_AddByImport(GlobalVar.MaXacThuc, pDM_MonHocInfo, ref Error);
client.Close();
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
return(ID);
}
//public long Add(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo)
//{
// long ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDGG_CongViecGiaoVien_Add(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo);
// client.Close();
// mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages;
// mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber;
// return ID;
//}
//public void Update(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDGG_CongViecGiaoVien_Update(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo);
// client.Close();
// mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages;
// mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber;
//}
public long UpdateAdd(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo)
{
long ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDGG_CongViecGiaoVien_UpdateAdd(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo);
client.Close();
mErrorMessage = oDGG_CongViecGiaoVien.ErrorMessages;
mErrorNumber = oDGG_CongViecGiaoVien.ErrorNumber;
return(ID);
}
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);
}