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))); } }