public DataSet LayDanhSachNhomTaiSan() { DataSet dsNhomTS = new DataSet(); //Kiem tra ket noi server, service Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanRequest()); TruyVanResponse response = new TruyVanResponse(); try { DataTable dtThamso = null; LDatatable.MakeParameterTable(ref dtThamso); request.dtThamSo = dtThamso; request.objectName = "INQ.TS.DS_NHOM_TS"; request.inquiryName = "DS_NHOM_BCAO"; //make a call service client response = ClientTruyVan.TruyVanMessage(request); if (response != null && response.ResponseStatus == ApplicationConstant.ResponseStatus.THANH_CONG) { dsNhomTS = response.dsResult; } return(dsNhomTS); } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); return(null); } }
public DataSet GetTreeViewNhomTaiSan() { //Kiem tra ket noi server, service truoc khi request Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanRequest()); TruyVanResponse response = new TruyVanResponse(); DataSet dsNhomTaisan = null; try { DataTable dtThamSo = null; LDatatable.MakeParameterTable(ref dtThamSo); LDatatable.AddParameter(ref dtThamSo, "", "", ""); request.dtThamSo = dtThamSo; request.objectName = "INQ.TS_PLOAI_TS"; request.inquiryName = "TREE_PLOAI_TS"; //make a call to service client response = ClientTruyVan.TruyVanMessage(request); //kiem tra ket qua tra ve Common.Utilities.ValidResponse(request, response); if (response != null && response.ResponseStatus == ApplicationConstant.ResponseStatus.THANH_CONG) { dsNhomTaisan = response.dsResult; } return(dsNhomTaisan); } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); return(null); } }
public DataSet GetTaiKhoanHachToan(string maDoiTuong, string maDonVi) { TruyVanServiceClient client = null; TruyVanRequest request = null; TruyVanResponse response = null; try { // Kiểm tra kết nối, server, service trước khi request Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService); request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest()); response = new TruyVanServiceRef.TruyVanResponse(); DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@MA_PHAN_HE", "STRING", DatabaseConstant.Module.TDTT.getValue()); LDatatable.AddParameter(ref dt, "@MA_DTUONG", "STRING", maDoiTuong); LDatatable.AddParameter(ref dt, "@MA_DON_VI", "STRING", maDonVi); request.dtThamSo = dt; request.objectName = "INQ.CT.TD_SAN_PHAM"; request.inquiryName = "TAI_KHOAN_HACH_TOAN"; // make a call to service client here response = client.TruyVanMessage(request); //Kiểm tra kết quả trả về Common.Utilities.ValidResponse(request, response); DataSet ds = response.dsResult; return(ds); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { if (client.State == CommunicationState.Faulted) { client.Abort(); } else { client.Close(); } client = null; request = null; response = null; } }
public DataSet GetHanMucChiTiet(string maLoaiDTuong, string maDTuong, string module, string tinhNang) { TruyVanServiceClient client = null; TruyVanRequest request = null; TruyVanResponse response = null; try { // Kiểm tra kết nối, server, service trước khi request Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService); request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest()); response = new TruyVanServiceRef.TruyVanResponse(); //Khởi tạo request DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@MA_DTUONG_LOAI", "STRING", maLoaiDTuong); LDatatable.AddParameter(ref dt, "@MA_DTUONG", "STRING", maDTuong); LDatatable.AddParameter(ref dt, "@MODULE", "STRING", module); LDatatable.AddParameter(ref dt, "@TINH_NANG", "STRING", tinhNang); request.dtThamSo = dt; request.objectName = "INQ.DS.HAN_MUC"; request.inquiryName = "CHI_TIET"; // make a call to service client here response = client.TruyVanMessage(request); //Kiểm tra kết quả trả về Common.Utilities.ValidResponse(request, response); DataSet ds = response.dsResult; return(ds); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { if (client.State == CommunicationState.Faulted) { client.Abort(); } else { client.Close(); } client = null; request = null; response = null; } }
public DataSet GetDanhSachHanMucKhachHangChiTiet(DataTable dt) { TruyVanServiceClient client = null; TruyVanRequest request = null; TruyVanResponse response = null; try { // Kiểm tra kết nối, server, service trước khi request Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService); request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest()); response = new TruyVanServiceRef.TruyVanResponse(); //Khởi tạo request //DataTable dt = null; //LDatatable.MakeParameterTable(ref dt); //LDatatable.AddParameter(ref dt, "@TRANG_THAI_NVU", "STRING", trangThaiNVu); //LDatatable.AddParameter(ref dt, "@MA_DVI", "STRING", maDonVi); request.dtThamSo = dt; request.objectName = "INQ.DS.HMUC_KHACH_HANG_CTIET"; request.inquiryName = "DANH_SACH"; // make a call to service client here response = client.TruyVanMessage(request); //Kiểm tra kết quả trả về Common.Utilities.ValidResponse(request, response); DataSet ds = response.dsResult; return(ds); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { if (client.State == CommunicationState.Faulted) { client.Abort(); } else { client.Close(); } client = null; request = null; response = null; } }
public DataSet GetResultCT(DataTable dt) { TruyVanServiceClient client = null; TruyVanRequest request = null; TruyVanResponse response = null; try { // Kiểm tra kết nối, server, service trước khi request Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri()); client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService); request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest()); response = new TruyVanServiceRef.TruyVanResponse(); //Khởi tạo request request.dtThamSo = dt; request.objectName = "INQ.DS.COB"; request.inquiryName = "RESULT_CT"; // make a call to service client here response = client.TruyVanMessage(request); //Kiểm tra kết quả trả về Common.Utilities.ValidResponse(request, response); DataSet ds = response.dsResult; return(ds); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } finally { if (client.State == CommunicationState.Faulted) { client.Abort(); } else { client.Close(); } client = null; request = null; response = null; } }