public YellowstonePathology.Business.Task.Model.TaskOrder PullTaskOrder(string taskOrderId, object writer) { lock (locker) { TaskOrderDocumentBuilder taskOrderDocumentBuilder = new TaskOrderDocumentBuilder(taskOrderId); DocumentId documentId = new DocumentId(typeof(YellowstonePathology.Business.Task.Model.TaskOrder), writer, taskOrderId); Document document = this.m_Stack.Pull(documentId, taskOrderDocumentBuilder); return((YellowstonePathology.Business.Task.Model.TaskOrder)document.Value); } }
public void PullTaskOrder(YellowstonePathology.Business.Task.Model.TaskOrder taskOrder, object writer) { SqlCommand cmd = new SqlCommand(" select tsk.*, ( select tskd.* from tblTaskOrderDetail tskd where tskd.TaskOrderId = tsk.TaskOrderId " + "for xml Path('TaskOrderDetail'), type) [TaskOrderDetailCollection] " + "from tblTaskOrder tsk where tsk.TaskOrderId = @TaskOrderId for xml Path('TaskOrder')"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TaskOrderId", SqlDbType.VarChar).Value = taskOrder.TaskOrderId; TaskOrderDocumentBuilder taskOrderDocumentBuilder = new TaskOrderDocumentBuilder(cmd); DocumentId documentId = new DocumentId(taskOrder, writer); Document document = this.m_Stack.Pull(documentId, taskOrderDocumentBuilder); }
public YellowstonePathology.Business.Task.Model.TaskOrder PullTaskOrder(string taskOrderId, object writer) { lock (locker) { TaskOrderDocumentBuilder taskOrderDocumentBuilder = new TaskOrderDocumentBuilder(taskOrderId); DocumentId documentId = new DocumentId(typeof(YellowstonePathology.Business.Task.Model.TaskOrder), writer, taskOrderId); Document document = this.m_Stack.Pull(documentId, taskOrderDocumentBuilder); return (YellowstonePathology.Business.Task.Model.TaskOrder)document.Value; } }
public void PullTaskOrder(YellowstonePathology.Business.Task.Model.TaskOrder taskOrder, object writer) { SqlCommand cmd = new SqlCommand(" select tsk.*, ( select tskd.* from tblTaskOrderDetail tskd where tskd.TaskOrderId = tsk.TaskOrderId " + "for xml Path('TaskOrderDetail'), type) [TaskOrderDetailCollection] " + "from tblTaskOrder tsk where tsk.TaskOrderId = @TaskOrderId for xml Path('TaskOrder')"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TaskOrderId", SqlDbType.VarChar).Value = taskOrder.TaskOrderId; TaskOrderDocumentBuilder taskOrderDocumentBuilder = new TaskOrderDocumentBuilder(cmd); DocumentId documentId = new DocumentId(taskOrder, writer); Document document = this.m_Stack.Pull(documentId, taskOrderDocumentBuilder); }