C# vista.VistaQuery類代碼示例

 internal MdoQuery buildGetConsultNoteRequest(string consultIen)
 {
     VistaUtils.CheckRpcParams(consultIen);
     VistaQuery vq = new VistaQuery("ORQQCN DETAIL");
     vq.addParameter(vq.LITERAL, consultIen);
     return vq;
 }

 internal MdoQuery buildGetSitesForStationRequest()
 {
     // This first RPC is from the AO project and the M code
     // behind it doesn't have a bug fix that the same function
     // in the SS project does have.  The second RPC is the one
     // with the bug fix.
     //VistaQuery vq = new VistaQuery("AMOJVL CPGPI GETSITES");
     VistaQuery vq = new VistaQuery("AMOJ VL APPTFL GET SITES");
     return vq;
 }

 public MdoQuery buildCancelAppointmentRequest(Appointment appointment, string cancellationReason, string remarks)
 {
     VistaQuery request = new VistaQuery("SD APPOINTMENT CANCEL");
     request.addParameter(request.LITERAL, cxn.Pid);
     request.addParameter(request.LITERAL, appointment.Clinic.Id);
     request.addParameter(request.LITERAL, appointment.Timestamp);
     request.addParameter(request.LITERAL, appointment.AppointmentType.ID);
     request.addParameter(request.LITERAL, cancellationReason);
     request.addParameter(request.LITERAL, remarks);
     return request;
 }

 public MdoQuery buildGetSurgeryReportTextRequest(string dfn, string ien)
 {
     VistaQuery vq = new VistaQuery("ORWRP REPORT TEXT");
     vq.addParameter(vq.LITERAL, dfn);
     vq.addParameter(vq.LITERAL, "28:SURGERY (LOCAL ONLY)~");
     vq.addParameter(vq.LITERAL, "");
     vq.addParameter(vq.LITERAL, "");
     vq.addParameter(vq.LITERAL, ien);
     vq.addParameter(vq.LITERAL, "0");
     vq.addParameter(vq.LITERAL, "0");
     return vq;
 }

 internal MdoQuery buildRequest()
 {
     if (Operation == null || Operation == "")
     {
         throw new ArgumentNullException("Must have an operation");
     }
     VistaQuery vq = new VistaQuery("DDR FILER");
     vq.addParameter(vq.LITERAL, Operation);
     DictionaryHashList lst = new DictionaryHashList();
     for (int i = 0; i < Args.Length; i++)
     {
         lst.Add(Convert.ToString(i+1), Args[i]);
     }
     vq.addParameter(vq.LIST, lst);
     return vq;
 }

        public MdoQuery buildRpcRequest(string rpcName, string[] paramValues, int[] paramTypes, bool[] paramEncrypted)
        {
            if (String.IsNullOrEmpty(rpcName))
            {
                throw new MdoException(MdoExceptionCode.ARGUMENT_INVALID, "rpcName must be specified");

            }
            if (paramValues.Length != paramTypes.Length || paramValues.Length != paramEncrypted.Length)
            {
                throw new MdoException(MdoExceptionCode.ARGUMENT_INVALID, "paramValues, paramTypes and paramEncrpted must be the same size");
            }

            VistaQuery vq = new VistaQuery(rpcName);
            for (int n = 0; n < paramValues.Length; n++)
            {
                if (paramEncrypted[n])
                    vq.addEncryptedParameter(paramTypes[n], paramValues[n]);
                else
                    vq.addParameter(paramTypes[n], paramValues[n]);
            }
            return vq;
        }

 internal string[] getOrderChecks(string dfn, string dlgType)
 {
     VistaQuery vq = new VistaQuery("ORWDXC DISPLAY");
     vq.addParameter(vq.LITERAL, dfn);
     vq.addParameter(vq.LITERAL, dlgType);
     string rtn = (string)cxn.query(vq);
     if (StringUtils.isEmpty(rtn))
     {
         return new string[0];
     }
     return StringUtils.split(rtn, StringUtils.CRLF);
 }

        internal string[] getDialogList(string loc)
        {
            VistaUtils.CheckRpcParams(loc);
            VistaQuery vq = new VistaQuery("ORWDX WRLST");
            vq.addParameter(vq.LITERAL, loc);

            string response = (string)cxn.query(vq);
            return StringUtils.split(response, StringUtils.CRLF);
        }

 internal string checkReleaseOrder(Order order)
 {
     VistaQuery vq = new VistaQuery("ORWDXC SESSION");
     vq.addParameter(vq.LITERAL, cxn.Pid);
     DictionaryHashList lst = new DictionaryHashList();
     lst.Add("1", order.Id + "^^1");
     vq.addParameter(vq.LIST, lst);
     return (string)cxn.query(vq);
 }

 internal MdoQuery buildSendOrderByPolicyRequest(string dfn, string locIen, string esig, Order order)
 {
     VistaQuery vq = new VistaQuery("ORWDX SEND");
     vq.addParameter(vq.LITERAL, dfn);
     vq.addParameter(vq.LITERAL, "0");
     vq.addParameter(vq.LITERAL, locIen);
     vq.addEncryptedParameter(vq.LITERAL, ' ' + esig);	//' ' apparently needed to avoid a bug in Vista?  See CPRS.
     DictionaryHashList lst = new DictionaryHashList();
     String value = order.Id + '^' +
         VistaConstants.SS_ESIGNED + '^' +
         VistaConstants.RS_RELEASE + '^' +
         VistaConstants.NO_POLICY;
     lst.Add("1", value);
     vq.addParameter(vq.LIST, lst);
     return vq;
 }

 internal MdoQuery buildIsUnitDoseQuickOrderRequest(string orderIen)
 {
     VistaQuery vq = new VistaQuery("ORWDXM3 ISUDQO");
     vq.addParameter(vq.LITERAL, orderIen);
     return vq;
 }

 internal MdoQuery buildIsIvQuickOrderRequest(string orderIen)
 {
     VistaQuery vq = new VistaQuery("ORIMO ISIVQO");
     vq.addParameter(vq.LITERAL, orderIen);
     return vq;
 }

 internal MdoQuery buildGetOrderDetailRequest(string orderIen, string dfn)
 {
     VistaUtils.CheckRpcParams(dfn);
     VistaQuery vq = new VistaQuery("ORQOR DETAIL");
     vq.addParameter(vq.LITERAL, orderIen);
     vq.addParameter(vq.LITERAL, dfn);
     return vq;
 }

 internal MdoQuery buildGetOrderableItemsByNameRequest(string name)
 {
     VistaQuery vq = new VistaQuery("AMOJVL CPGPI OILOOK");
     vq.addParameter(vq.LITERAL, name);
     return vq;
 }

 internal MdoQuery buildGetNewDlgIenRequest(string type, string locationIen)
 {
     VistaQuery vq = new VistaQuery("ORWDCN32 NEWDLG");
     vq.addParameter(vq.LITERAL, type);
     vq.addParameter(vq.LITERAL, locationIen);
     return vq;
 }