/// <summary> /// 根据工作流实例ID得到请示单信息 /// </summary> /// <param name="WFLInstanceId"></param> /// <returns></returns> public TList <InstructionOfPkurg> GetInstructionOfPkurgByWFLInstanceId(string WFLInstanceId) { InstructionOfPkurgService rs = new InstructionOfPkurgService(); InstructionOfPkurgQuery query = new InstructionOfPkurgQuery(); query.Clear(); query.AppendEquals(string.Empty, InstructionOfPkurgColumn.WflInstanceId, WFLInstanceId); SqlSortBuilder <InstructionOfPkurgColumn> sort = new SqlSortBuilder <InstructionOfPkurgColumn>(); sort.AppendASC(InstructionOfPkurgColumn.CreateAtTime); return(rs.Find(query.GetParameters(), sort.GetSortColumns())); }
public TList <Attachment> GetAttachmentByFormID(string FormID) { AttachmentService rs = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); query.AppendEquals(string.Empty, AttachmentColumn.FormId, FormID); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(rs.Find(query.GetParameters(), sort.GetSortColumns())); }
public TList <Attachment> GetAttachmentByFormID(string FormID, Pkurg.PWorld.Entities.Employee currentEmployee) { AttachmentService rs = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); query.AppendEquals(string.Empty, AttachmentColumn.FormId, FormID); query.AppendEquals("and", AttachmentColumn.CreateByUserCode, currentEmployee.EmployeeCode); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(rs.Find(query.GetParameters(), sort.GetSortColumns())); }
/// <summary> /// 得到审批步骤列表 /// </summary> /// <returns></returns> public TList <WorkFlowInstance> GetWorkFlowInstanceList() { WorkFlowInstanceService service = new WorkFlowInstanceService(); WorkFlowInstanceQuery query = new WorkFlowInstanceQuery(); query.Clear(); SqlSortBuilder <WorkFlowInstanceColumn> sort = new SqlSortBuilder <WorkFlowInstanceColumn>(); sort.AppendASC(WorkFlowInstanceColumn.CreateAtTime); return(service.Find(query.GetParameters(), sort.GetSortColumns())); }
/// <summary> /// 得到请示单列表 /// </summary> /// <returns></returns> public TList <InstructionOfPkurg> GetInstructionOfPkurgList() { InstructionOfPkurgService service = new InstructionOfPkurgService(); InstructionOfPkurgQuery query = new InstructionOfPkurgQuery(); query.Clear(); SqlSortBuilder <InstructionOfPkurgColumn> sort = new SqlSortBuilder <InstructionOfPkurgColumn>(); sort.AppendASC(InstructionOfPkurgColumn.Date); return(service.Find(query.GetParameters(), sort.GetSortColumns())); }
/// <summary> /// 得到附件信息列表 /// </summary> /// <returns></returns> public TList <Attachment> GetAttachmentList() { AttachmentService service = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(service.Find(query.GetParameters(), sort.GetSortColumns())); }
/// <summary> /// 根据根据工作流实例ID与步骤名得到审批步骤 /// </summary> /// <param name="WflInstanceId"></param> /// <param name="CheckByUserRole"></param> /// <returns></returns> public WorkFlowInstance GetWorkFlowInstanceByWFInstanceId(string WfInstanceId) { WorkFlowInstance workFlowInstance = null; WorkFlowInstanceService rs = new WorkFlowInstanceService(); WorkFlowInstanceQuery query = new WorkFlowInstanceQuery(); query.Clear(); query.AppendEquals(string.Empty, WorkFlowInstanceColumn.WfInstanceId, WfInstanceId); SqlSortBuilder <WorkFlowInstanceColumn> sort = new SqlSortBuilder <WorkFlowInstanceColumn>(); sort.AppendASC(WorkFlowInstanceColumn.CreateAtTime); TList <WorkFlowInstance> WorkFlowInstanceList = rs.Find(query.GetParameters(), sort.GetSortColumns()); if (WorkFlowInstanceList.Count > 0) { workFlowInstance = WorkFlowInstanceList[0]; } return(workFlowInstance); }