Example #1
0
        public YellowstonePathology.Business.Client.Model.ClientSupplyOrder PullClientSupplyOrder(string clientSupplyOrderId, object writer)
        {
            lock (locker)
            {
                ClientSupplyOrderDocumentBuilder builder = new ClientSupplyOrderDocumentBuilder(clientSupplyOrderId);

                DocumentId documentId = new DocumentId(typeof(YellowstonePathology.Business.Client.Model.ClientSupplyOrder), writer, clientSupplyOrderId);
                Document   document   = this.m_Stack.Pull(documentId, builder);
                return((YellowstonePathology.Business.Client.Model.ClientSupplyOrder)document.Value);
            }
        }
Example #2
0
        public void PullClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder, object writer)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "SELECT cso.*, (SELECT * from tblClientSupplyOrderDetail where clientsupplyorderid = cso.ClientSupplyOrderId for xml path('ClientSupplyOrderDetail'), type) ClientSupplyOrderDetailCollection " +
                              "FROM tblClientSupplyOrder cso where cso.ClientSupplyOrderId = @ClientSupplyOrderId for xml Path('ClientSupplyOrder'), type";
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add("@ClientSupplyOrderId", SqlDbType.VarChar).Value = clientSupplyOrder.ClientSupplyOrderId;
            ClientSupplyOrderDocumentBuilder builder = new ClientSupplyOrderDocumentBuilder(cmd);

            DocumentId documentId = new DocumentId(clientSupplyOrder, writer);
            Document   document   = this.m_Stack.Pull(documentId, builder);
        }
Example #3
0
        public YellowstonePathology.Business.Client.Model.ClientSupplyOrder PullClientSupplyOrder(string clientSupplyOrderId, object writer)
        {
            lock (locker)
            {
                ClientSupplyOrderDocumentBuilder builder = new ClientSupplyOrderDocumentBuilder(clientSupplyOrderId);

                DocumentId documentId = new DocumentId(typeof(YellowstonePathology.Business.Client.Model.ClientSupplyOrder), writer, clientSupplyOrderId);
                Document document = this.m_Stack.Pull(documentId, builder);
                return (YellowstonePathology.Business.Client.Model.ClientSupplyOrder)document.Value;
            }
        }
Example #4
0
        public void PullClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder, object writer)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "SELECT cso.*, (SELECT * from tblClientSupplyOrderDetail where clientsupplyorderid = cso.ClientSupplyOrderId for xml path('ClientSupplyOrderDetail'), type) ClientSupplyOrderDetailCollection " +
                "FROM tblClientSupplyOrder cso where cso.ClientSupplyOrderId = @ClientSupplyOrderId for xml Path('ClientSupplyOrder'), type";
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add("@ClientSupplyOrderId", SqlDbType.VarChar).Value = clientSupplyOrder.ClientSupplyOrderId;
            ClientSupplyOrderDocumentBuilder builder = new ClientSupplyOrderDocumentBuilder(cmd);

            DocumentId documentId = new DocumentId(clientSupplyOrder, writer);
            Document document = this.m_Stack.Pull(documentId, builder);
        }