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 GetMonChuaToChuc(int KQHT_ChuongTrinhDaoTaoID, int IDDM_Lop, int CTDT_HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_ChuongTrinhDaoTao_GetMonChuaToChucResult>(client.cDKQHT_ChuongTrinhDaoTao_GetMonChuaToChuc(GlobalVar.MaXacThuc, KQHT_ChuongTrinhDaoTaoID, IDDM_Lop, CTDT_HocKy)));
}
}
//public DataTable Get(HT_LogInfo pHT_LogInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<HT_LogInfo>(client.cDHT_Log_Get(GlobalVar.MaXacThuc, pHT_LogInfo));
// }
//}
public DataTable Search(int IDPhanHe, int IDChucNang, string SuKien, string NguoiDung, string NoiDung, DateTime dtTuNgay, DateTime dtDenNgay)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <HT_LogInfo>(client.cDHT_Log_Search(GlobalVar.MaXacThuc, IDPhanHe, IDChucNang, SuKien, NguoiDung, NoiDung, dtTuNgay, dtDenNgay)));
}
}
public DataTable GetNotInIDCTKhoiKienThuc(int IDKQHT_CT_KhoiKienThuc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetNotInIDCTKhoiKienThucResult>(client.cDDM_MonHoc_GetNotInIDCTKhoiKienThuc(GlobalVar.MaXacThuc, IDKQHT_CT_KhoiKienThuc)));
}
}
public DataTable GetMonKyByLop(int IDDM_Lop, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetMonKyByLopResult>(client.cDDM_MonHoc_GetMonKyByLop(GlobalVar.MaXacThuc, IDDM_Lop, IDDM_NamHoc, HocKy)));
}
}
//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 GetDanhSach(int IDDM_BoMon)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetDanhSachResult>(client.cDDM_MonHoc_GetDanhSach(GlobalVar.MaXacThuc, IDDM_BoMon)));
}
}
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 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 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)));
}
}
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 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(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 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 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 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 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 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 Get(DM_MonHocInfo pDM_MonHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetResult>(client.cDDM_MonHoc_Get(GlobalVar.MaXacThuc, pDM_MonHocInfo)));
}
}
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 GetPhongChuyenMon(string IDDM_PhongHocs)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetPhongChuyenMonResult>(client.cDDM_MonHoc_GetPhongChuyenMon(GlobalVar.MaXacThuc, IDDM_PhongHocs)));
}
}
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 GetNotInIDNSGiaoVien(int IDNS_GiaoVien)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetNotInIDGiaoVienResult>(client.cDDM_MonHoc_GetNotInIDNSGiaoVien(GlobalVar.MaXacThuc, IDNS_GiaoVien)));
}
}
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 GetChiTiet(int KQHT_ChuongTrinhDaoTaoID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_ChuongTrinhDaoTao_GetChiTietResult>(client.cDKQHT_ChuongTrinhDaoTao_GetChiTiet(GlobalVar.MaXacThuc, KQHT_ChuongTrinhDaoTaoID)));
}
}
//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 GetLop(int IDKQHT_ChuongTrinhDaoTao)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_ChuongTrinhDaoTao_GetLopResult>(client.cDKQHT_ChuongTrinhDaoTao_GetLop(GlobalVar.MaXacThuc, IDKQHT_ChuongTrinhDaoTao)));
}
}
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 Get(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<DM_TinhHuyenXaInfo>(client.cDDM_TinhHuyenXa_Get(GlobalVar.MaXacThuc, pDM_TinhHuyenXaInfo));
// }
//}
public DataTable GetByCap(int Level, int ParentID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_TinhHuyenXa_GetByCapResult>(client.cDDM_TinhHuyenXa_GetByCap(GlobalVar.MaXacThuc, Level, ParentID)));
}
}
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)));
}
}