public DataTable GetSinhVien(int KQHT_ToChucID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <KQHT_DiemThiInfo>(client.cDKQHT_DiemThi_GetSinhVien(GlobalVar.MaXacThuc, KQHT_ToChucID)));
}
}
public DataTable Get(GG_CongViecGiaoVienInfo pGG_CongViecGiaoVienInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_CongViecGiaoVien_GetResult>(client.cDGG_CongViecGiaoVien_Get_2(GlobalVar.MaXacThuc, pGG_CongViecGiaoVienInfo)));
}
}
public DataTable GetByIDDM_LoaiCongViec(int IDDM_LoaiCongViec, int IDNS_DonVi, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_CongViecGiaoVien_GetByIDDM_LoaiCongViecResult>(client.cDGG_CongViecGiaoVien_GetByIDDM_LoaiCongViec(GlobalVar.MaXacThuc, IDDM_LoaiCongViec, IDNS_DonVi, IDDM_NamHoc, HocKy)));
}
}
public DataTable KiemTraDiem(int IDSV_SinhVien, int IDDM_Lop, int IDDM_MonHoc, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThanhPhan_KiemTraDiemResult>(client.cDKQHT_DiemThanhPhan_KiemTraDiem(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_Lop, IDDM_MonHoc, IDDM_NamHoc, HocKy)));
}
}
public DataTable Get(KQHT_CTDT_ChiTietInfo pKQHT_CTDT_ChiTietInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_CTDT_ChiTiet_GetResult>(client.cDKQHT_CTDT_ChiTiet_Get(GlobalVar.MaXacThuc, pKQHT_CTDT_ChiTietInfo)));
}
}
public DataTable Get(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_TrinhDo_GetResult>(client.cDDM_TrinhDo_Get(GlobalVar.MaXacThuc, pDM_TrinhDoInfo)));
}
}
public DataTable GetDanhSach(int IDDM_Lop, int IDDM_MonHoc, int XL_MonHocTrongKyID, int IDDM_NamHoc, int HocKy, int LanThi, int KQHT_ChoNhapLaiDiemID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThanhPhan_GetDanhSachResult>(client.cDKQHT_DiemThanhPhan_GetDanhSach(GlobalVar.MaXacThuc, IDDM_Lop, IDDM_MonHoc, XL_MonHocTrongKyID, IDDM_NamHoc, HocKy, LanThi, KQHT_ChoNhapLaiDiemID)));
}
}
public DataTable GetChiTiet(int TC_BienLaiThuTienID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_TC_BienLaiThuTien_GetChiTietResult>(client.cDTC_BienLaiThuTien_GetChiTiet(GlobalVar.MaXacThuc, TC_BienLaiThuTienID)));
}
}
//public DataRow GetInfoByID(int TC_BienLaiThuTienID)
//{
// using (var client = new UnimOsServiceClient())
// {
// return client.cDTC_BienLaiThuTien_GetInfoByID(GlobalVar.MaXacThuc, TC_BienLaiThuTienID);
// }
//}
public DataTable GetBySinhVien(int IDSV_SinhVien, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_TC_BienLaiThuTien_GetBySinhVienResult>(client.cDTC_BienLaiThuTien_GetBySinhVien(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_NamHoc, HocKy)));
}
}
public DataTable GetByIDDM_MonHoc(int IDDM_MonHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_PhongHoc_MonHoc_GetByIDMonHocResult>(client.cDXL_PhongHoc_MonHoc_GetByIDDM_MonHoc(GlobalVar.MaXacThuc, IDDM_MonHoc)));
}
}
//public DataTable Get(TC_BienLaiThuTienInfo pTC_BienLaiThuTienInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_Get(GlobalVar.MaXacThuc, pTC_BienLaiThuTienInfo));
// }
//}
public DataTable GetNamHoc(int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_GetNamHoc(GlobalVar.MaXacThuc, IDDM_NamHoc, HocKy)));
}
}
public DataTable Get(XL_PhongHoc_MonHocInfo pXL_PhongHoc_MonHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_PhongHoc_MonHoc_GetResult>(client.cDXL_PhongHoc_MonHoc_Get(GlobalVar.MaXacThuc, pXL_PhongHoc_MonHocInfo)));
}
}
public DataTable GetByMonLop(int IDDM_Lop, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_GiaoVien_MonHoc_GetByMonLopResult>(client.cDXL_GiaoVien_MonHoc_GetByMonLop(GlobalVar.MaXacThuc, IDDM_Lop, IDDM_NamHoc, HocKy)));
}
}
public DataTable GetByIDDM_MonHocs(string IDDM_MonHocs)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <XL_GiaoVien_MonHocInfo>(client.cDXL_GiaoVien_MonHoc_GetByIDDM_MonHocs(GlobalVar.MaXacThuc, IDDM_MonHocs)));
}
}
public DataTable GetCombo(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_KeHoachKhac_GetComboResult>(client.cDXL_KeHoachKhac_GetCombo(GlobalVar.MaXacThuc, pXL_KeHoachKhacInfo)));
}
}
public DataTable GetTongHop(DM_LopInfo pDM_LopInfo, int IDDM_NamHoc, int IDTC_LoaiThuChi, int HocKy, int IDTC_QuyenHoaDon, bool TongHopTuDau)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_GetTongHop(GlobalVar.MaXacThuc, pDM_LopInfo, IDDM_NamHoc, IDTC_LoaiThuChi, HocKy, IDTC_QuyenHoaDon, TongHopTuDau)));
}
}
public DataTable GetByIDTrinhDo(int IDDM_TrinhDo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_ThanhPhanDiem_GetByIDTrinhDoResult>(client.cDKQHT_ThanhPhanDiem_GetByIDTrinhDo(GlobalVar.MaXacThuc, IDDM_TrinhDo)));
}
}
public DataTable GetThuChi(int IDTC_LoaiThuChi, string TuNgay, string DenNgay, int IDDM_NamHoc, int HocKy, string IDDM_Lops)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_GetThuChi(GlobalVar.MaXacThuc, IDTC_LoaiThuChi, TuNgay, DenNgay, IDDM_NamHoc, HocKy, IDDM_Lops)));
}
}
//public int Add(DM_TrinhDoInfo pDM_TrinhDoInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDDM_TrinhDo_Add(GlobalVar.MaXacThuc, pDM_TrinhDoInfo);
// client.Close();
// mErrorMessage = oDDM_TrinhDo.ErrorMessages;
// mErrorNumber = oDDM_TrinhDo.ErrorNumber;
// return ID;
//}
//public void Update(DM_TrinhDoInfo pDM_TrinhDoInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDDM_TrinhDo_Update(GlobalVar.MaXacThuc, pDM_TrinhDoInfo);
// client.Close();
// mErrorMessage = oDDM_TrinhDo.ErrorMessages;
// mErrorNumber = oDDM_TrinhDo.ErrorNumber;
//}
//public void Delete(DM_TrinhDoInfo pDM_TrinhDoInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDDM_TrinhDo_Delete(GlobalVar.MaXacThuc, pDM_TrinhDoInfo);
// client.Close();
// mErrorMessage = oDDM_TrinhDo.ErrorMessages;
// mErrorNumber = oDDM_TrinhDo.ErrorNumber;
//}
//public List<DM_TrinhDoInfo> GetList(DM_TrinhDoInfo pDM_TrinhDoInfo)
//{
// List<DM_TrinhDoInfo> oDM_TrinhDoInfoList = new List<DM_TrinhDoInfo>();
// DataTable dtb = Get(pDM_TrinhDoInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oDM_TrinhDoInfo = new DM_TrinhDoInfo();
// oDM_TrinhDoInfo.DM_TrinhDoID = int.Parse(dtb.Rows[i]["DM_TrinhDoID"].ToString());
// oDM_TrinhDoInfo.IDDM_He = int.Parse(dtb.Rows[i]["IDDM_He"].ToString());
// oDM_TrinhDoInfo.IDKQHT_QuyChe = int.Parse(dtb.Rows[i]["IDKQHT_QuyChe"].ToString());
// oDM_TrinhDoInfo.MaTrinhDo = dtb.Rows[i]["MaTrinhDo"].ToString();
// oDM_TrinhDoInfo.TenTrinhDo = dtb.Rows[i]["TenTrinhDo"].ToString();
// oDM_TrinhDoInfo.TenTrinhDo_E = dtb.Rows[i]["TenTrinhDo_E"].ToString();
// oDM_TrinhDoInfoList.Add(oDM_TrinhDoInfo);
// }
// }
// return oDM_TrinhDoInfoList;
//}
public DataTable GetByIDHe(int IDDM_He)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_TrinhDo_GetByIDHeResult>(client.cDDM_TrinhDo_GetByIDHe(GlobalVar.MaXacThuc, IDDM_He)));
}
}
public DataTable TimKiem(string SoPhieu, int PhieuThu, int PhieuHuy, string MaSinhVien, int IDDM_Lop, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <TC_BienLaiThuTienInfo>(client.cDTC_BienLaiThuTien_TimKiem(GlobalVar.MaXacThuc, SoPhieu, PhieuThu, PhieuHuy, MaSinhVien, IDDM_Lop, IDDM_NamHoc, HocKy)));
}
}
public DataTable ChoNhapLaiDiem_GetDanhSach(int IDKQHT_ChoNhapLaiDiem)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThanhPhan_ChoNhapLaiDiem_GetDanhSachResult>(client.cDKQHT_DiemThanhPhan_ChoNhapLaiDiem_GetDanhSach(GlobalVar.MaXacThuc, IDKQHT_ChoNhapLaiDiem)));
}
}
public DataTable GetSoPhieu(int HocKy, int IDDM_NamHoc, int SV_SinhVienID, int IDDM_DiaDiem)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_TC_BienLaiThuTien_GetSoPhieuResult>(client.cDTC_BienLaiThuTien_GetSoPhieu(GlobalVar.MaXacThuc, HocKy, IDDM_NamHoc, SV_SinhVienID, IDDM_DiaDiem)));
}
}
public DataTable GetLichSuSuaDiem(int IDXL_MonHocTrongKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DaChuyenDiem_GetLichSuSuaDiemResult>(client.cDKQHT_DaChuyenDiem_GetLichSuSuaDiem(GlobalVar.MaXacThuc, IDXL_MonHocTrongKy)));
}
}
public DataTable Get(NS_DonViInfo pNS_DonViInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_DonVi_GetResult>(client.cDNS_DonVi_Get(GlobalVar.MaXacThuc, pNS_DonViInfo)));
}
}
//public DataTable Get(DM_ChuyenNganhInfo pDM_ChuyenNganhInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<DM_ChuyenNganhInfo>(client.cDDM_ChuyenNganh_Get(GlobalVar.MaXacThuc, pDM_ChuyenNganhInfo));
// }
//}
public DataTable GetByIDNganh(int IDDM_Nganh)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_ChuyenNganh_GetByIDNganhResult>(client.cDDM_ChuyenNganh_GetByIDNganh(GlobalVar.MaXacThuc, IDDM_Nganh)));
}
}
public DataTable GetByID(int IDNS_DonVi)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_DonVi_GetByIDResult>(client.cDNS_DonVi_GetByID(GlobalVar.MaXacThuc, IDNS_DonVi)));
}
}
public DataTable Get(int IDGiaoVien, int IDNamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_CongViecGiaoVien_GetResult>(client.cDGG_CongViecGiaoVien_Get(GlobalVar.MaXacThuc, IDGiaoVien, IDNamHoc)));
}
}
public DataTable GetNotIn_SinhVien(int IDDM_Lop, int IDDM_MonHoc, int IDDM_NamHoc, int HocKy, int LanThi)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DanhSachKhongThi_GetNotIn_SinhVienResult>(client.cDKQHT_DanhSachKhongThi_GetNotIn_SinhVien(GlobalVar.MaXacThuc, IDDM_Lop, IDDM_MonHoc, IDDM_NamHoc, HocKy, LanThi)));
}
}
//private int[] GetPhongChuyenMon(int IDDM_MonHoc)
//{
// cBwsXL_PhongHoc_MonHoc oBXL_PhongHoc_MonHoc = new cBwsXL_PhongHoc_MonHoc();
// DataTable dt = oBXL_PhongHoc_MonHoc.GetByIDDM_MonHoc(IDDM_MonHoc);
// if (dt.Rows.Count > 0)
// {
// int[] arr = new int[dt.Rows.Count];
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// arr[i] = int.Parse(dt.Rows[i]["IDDM_PhongHoc"].ToString());
// }
// return arr;
// }
// else
// return null;
//}
public DataTable GetMonThiTotNghiep(int IDDM_NamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetMonThiTotNghiepResult>(client.cDDM_MonHoc_GetMonThiTotNghiep(GlobalVar.MaXacThuc, IDDM_NamHoc)));
}
}
public DataTable GetByLop(int IDDM_Lop, int IDDM_MonHoc, int IDXL_MonHocTrongKy, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThi_GetByLopResult>(client.cDKQHT_DiemThi_GetByLop(GlobalVar.MaXacThuc, IDDM_Lop, IDDM_MonHoc, IDXL_MonHocTrongKy, IDDM_NamHoc, HocKy)));
}
}