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