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