public ArrayList getAllThisLayerNeedSolvedCrowTaskInDecomposeResult(string workflow_id,string mainTaskId) { // int result = 0; SqlCommand com = null; ArrayList al = new ArrayList(); try { conn.Open(); string sql = string.Format("select * from decomposeResult where simples='{0}' and workflow_id='{1}' and mainTaskId='{2}'", "yes",workflow_id,mainTaskId); com = new SqlCommand(sql, conn); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { //输出数据 DecomposeResult decomposeResult = new DecomposeResult(); decomposeResult.taskName = dr["taskName"].ToString(); decomposeResult.taskDescription = dr["taskDescription"].ToString(); decomposeResult.taskOrder = dr["taskOrder"].ToString(); decomposeResult.workflow_id = dr["workflow_id"].ToString(); decomposeResult.parent_workflow_id = dr["parent_workflow_id"].ToString(); decomposeResult.vote = dr["vote"].ToString(); decomposeResult.simple = dr["simples"].ToString(); decomposeResult.mainTaskId = dr["mainTaskId"].ToString(); al.Add(decomposeResult); } } catch (Exception e) { throw e; } finally { if (com != null) { com.Dispose(); } if (conn != null) { conn.Close(); } } return al; }
public Dictionary<string, ArrayList> getAllNeedSolvedCrowTaskInDecomposeResult(string mainTaskId) { // int result = 0; SqlCommand com = null; Dictionary<string, ArrayList> dic = new Dictionary<string, ArrayList>(); try { conn.Open(); string sql = string.Format("select wrokflow_id from decomposeResult where simples='{0}' and mainTaskId='{1}' group by workflow_id", "yes",mainTaskId); com = new SqlCommand(sql, conn); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { ArrayList al = new ArrayList(); string sql2 = string.Format("select * from decomposeResult where simples='{0}' and workflow_id='{1}' and mainTaskId='{2}'", "yes",dr["workflow_id"].ToString(),mainTaskId); SqlConnection sqlconnection = DbHelper.getSqlConnection(); SqlCommand sc = new SqlCommand(sql2,sqlconnection); SqlDataReader dr1 = sc.ExecuteReader(); while (dr1.Read()) { DecomposeResult decomposeResult = new DecomposeResult(); decomposeResult.taskName = dr["taskName"].ToString(); decomposeResult.taskDescription = dr["taskDescription"].ToString(); decomposeResult.taskOrder = dr["taskOrder"].ToString(); decomposeResult.workflow_id = dr["workflow_id"].ToString(); decomposeResult.parent_workflow_id = dr["parent_workflow_id"].ToString(); decomposeResult.vote = dr["vote"].ToString(); decomposeResult.simple = dr["simples"].ToString(); decomposeResult.mainTaskId = dr["mainTaskId"].ToString(); al.Add(decomposeResult); } dic.Add(dr["workflow_id"].ToString(),al); } } catch (Exception e) { throw e; } finally { if (com != null) { com.Dispose(); } if (conn != null) { conn.Close(); } } return dic; }
public ArrayList findDecomposeResultByWorkflowId(string workflow_id,string mainTaskId) { ArrayList arrayList = new ArrayList(); SqlCommand com = null; try { conn.Open(); string sql = string.Format("select * from decomposeResult where workflow_id='{0}' and mainTaskId='{1}'", workflow_id,mainTaskId); com = new SqlCommand(sql, conn); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { DecomposeResult decomposeResult = new DecomposeResult(); decomposeResult.taskName = dr["taskName"].ToString(); decomposeResult.taskDescription = dr["taskDescription"].ToString(); decomposeResult.taskOrder = dr["taskOrder"].ToString(); decomposeResult.workflow_id = dr["workflow_id"].ToString(); decomposeResult.parent_workflow_id = dr["parent_workflow_id"].ToString(); decomposeResult.vote = dr["vote"].ToString(); decomposeResult.simple = dr["simples"].ToString(); decomposeResult.mainTaskId=dr["mainTaskId"].ToString(); arrayList.Add(decomposeResult); } com = new SqlCommand(sql, conn); } catch (Exception e) { throw e; } finally { if (com != null) { com.Dispose(); } if (conn != null) { conn.Close(); } } return arrayList; }
public Dictionary<string,ArrayList> findAllDecomposeResultByParentWorkflowId(string parent_workflow_id,string mainTaskId) { Dictionary<string, ArrayList> dic = new Dictionary<string, ArrayList>(); SqlCommand com = null; try { conn.Open(); string sql = string.Format("select * from decomposeResult where parent_workflow_id='{0}' and mainTaskId='{1}'", parent_workflow_id,mainTaskId); com = new SqlCommand(sql, conn); SqlDataReader dr = com.ExecuteReader(); ArrayList arrayList = new ArrayList(); while (dr.Read()) { DecomposeResult decomposeResult = new DecomposeResult(); decomposeResult.taskName = dr["taskName"].ToString(); decomposeResult.taskDescription = dr["taskDescription"].ToString(); decomposeResult.taskOrder = dr["taskOrder"].ToString(); decomposeResult.workflow_id = dr["workflow_id"].ToString(); decomposeResult.parent_workflow_id = dr["parent_workflow_id"].ToString(); decomposeResult.simple = dr["simples"].ToString(); decomposeResult.mainTaskId = dr["mainTaskId"].ToString(); arrayList.Add(decomposeResult); } ArrayList list = new ArrayList(); for (int i=0;i<arrayList.Count-1;i++) { DecomposeResult dr1 = arrayList[i] as DecomposeResult; DecomposeResult dr2 = arrayList[i+1] as DecomposeResult; if (dr1.workflow_id == dr2.workflow_id) { list.Add(dr1); list.Add(dr2); } } } catch (Exception e) { throw e; } finally { if (com != null) { com.Dispose(); } if (conn != null) { conn.Close(); } } return dic; }
protected void Button1_Click(object sender, EventArgs e) { ArrayList arrayList = new ArrayList(); string steps = tb_step.Text; int number = Convert.ToInt32(steps); CrowdTask[] crowdTasks = new CrowdTask[number]; DecomposeResult[] decomposeResults = new DecomposeResult[number]; for (int i = 0; i < number; i++) { CrowdTask ct = new CrowdTask(); crowdTasks[i] = ct; DecomposeResult dr = new DecomposeResult(); decomposeResults[i] = dr; } switch(steps){ case "2": /* crowdTasks[0].taskName = taskName_1.Text; crowdTasks[0].taskDescription = taskDescription_1.Text; crowdTasks[1].taskName = taskName_2.Text; crowdTasks[1].taskDescription = taskDescription_2.Text; */ decomposeResults[0].taskName = taskName_1.Text; decomposeResults[0].taskDescription = taskDescription_1.Text; decomposeResults[0].taskOrder = "第一步"; decomposeResults[0].workflow_id = taskWorkflowId; decomposeResults[0].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[0].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[1].taskName = taskName_2.Text; decomposeResults[1].taskDescription = taskDescription_2.Text; decomposeResults[1].taskOrder = "第二步"; decomposeResults[1].workflow_id = taskWorkflowId; decomposeResults[1].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[1].mainTaskId = currentCrowdTask.mainTaskId; for (int i = 0; i < number; i++) { arrayList.Add(decomposeResults[i]); } break; case "3": /* crowdTasks[0].taskName = taskName_1.Text; crowdTasks[0].taskDescription = taskDescription_1.Text; crowdTasks[1].taskName = taskName_2.Text; crowdTasks[1].taskDescription = taskDescription_2.Text; crowdTasks[2].taskName = taskName_3.Text; crowdTasks[2].taskDescription = taskDescription_3.Text; */ decomposeResults[0].taskName = taskName_1.Text; decomposeResults[0].taskDescription = taskDescription_1.Text; decomposeResults[0].taskOrder = "第一步"; decomposeResults[0].workflow_id = taskWorkflowId; decomposeResults[0].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[0].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[1].taskName = taskName_2.Text; decomposeResults[1].taskDescription = taskDescription_2.Text; decomposeResults[1].taskOrder = "第二步"; decomposeResults[1].workflow_id = taskWorkflowId; decomposeResults[1].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[1].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[2].taskName = taskName_3.Text; decomposeResults[2].taskDescription = taskDescription_3.Text; decomposeResults[2].taskOrder = "第三步"; decomposeResults[2].workflow_id = taskWorkflowId; decomposeResults[2].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[2].mainTaskId = currentCrowdTask.mainTaskId; for (int i = 0; i < number; i++) { arrayList.Add(decomposeResults[i]); } break; case "4": /* crowdTasks[0].taskName = taskName_1.Text; crowdTasks[0].taskDescription = taskDescription_1.Text; crowdTasks[1].taskName = taskName_2.Text; crowdTasks[1].taskDescription = taskDescription_2.Text; crowdTasks[2].taskName = taskName_3.Text; crowdTasks[2].taskDescription = taskDescription_3.Text; crowdTasks[3].taskName = taskName_4.Text; crowdTasks[3].taskDescription = taskDescription_4.Text; */ decomposeResults[0].taskName = taskName_1.Text; decomposeResults[0].taskDescription = taskDescription_1.Text; decomposeResults[0].taskOrder = "第一步"; decomposeResults[0].workflow_id = taskWorkflowId; decomposeResults[0].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[0].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[1].taskName = taskName_2.Text; decomposeResults[1].taskDescription = taskDescription_2.Text; decomposeResults[1].taskOrder = "第二步"; decomposeResults[1].workflow_id = taskWorkflowId; decomposeResults[1].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[1].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[2].taskName = taskName_3.Text; decomposeResults[2].taskDescription = taskDescription_3.Text; decomposeResults[2].taskOrder = "第三步"; decomposeResults[2].workflow_id = taskWorkflowId; decomposeResults[2].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[2].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[3].taskName = taskName_4.Text; decomposeResults[3].taskDescription = taskDescription_4.Text; decomposeResults[3].taskOrder = "第四步"; decomposeResults[3].workflow_id = taskWorkflowId; decomposeResults[3].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[3].mainTaskId = currentCrowdTask.mainTaskId; for (int i = 0; i < number; i++) { arrayList.Add(decomposeResults[i]); } break; case "5": /* crowdTasks[0].taskName = taskName_1.Text; crowdTasks[0].taskDescription = taskDescription_1.Text; crowdTasks[1].taskName = taskName_2.Text; crowdTasks[1].taskDescription = taskDescription_2.Text; crowdTasks[2].taskName = taskName_3.Text; crowdTasks[2].taskDescription = taskDescription_3.Text; crowdTasks[3].taskName = taskName_4.Text; crowdTasks[3].taskDescription = taskDescription_4.Text; crowdTasks[4].taskName = taskName_5.Text; crowdTasks[4].taskDescription = taskDescription_5.Text; */ decomposeResults[0].taskName = taskName_1.Text; decomposeResults[0].taskDescription = taskDescription_1.Text; decomposeResults[0].taskOrder = "第一步"; decomposeResults[0].workflow_id = taskWorkflowId; decomposeResults[0].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[0].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[1].taskName = taskName_2.Text; decomposeResults[1].taskDescription = taskDescription_2.Text; decomposeResults[1].taskOrder = "第二步"; decomposeResults[1].workflow_id = taskWorkflowId; decomposeResults[1].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[1].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[2].taskName = taskName_3.Text; decomposeResults[2].taskDescription = taskDescription_3.Text; decomposeResults[2].taskOrder = "第三步"; decomposeResults[2].workflow_id = taskWorkflowId; decomposeResults[2].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[2].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[3].taskName = taskName_4.Text; decomposeResults[3].taskDescription = taskDescription_4.Text; decomposeResults[3].taskOrder = "第四步"; decomposeResults[3].workflow_id = taskWorkflowId; decomposeResults[3].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[3].mainTaskId = currentCrowdTask.mainTaskId; decomposeResults[4].taskName = taskName_5.Text; decomposeResults[4].taskDescription = taskDescription_5.Text; decomposeResults[4].taskOrder = "第五步"; decomposeResults[4].workflow_id = taskWorkflowId; decomposeResults[4].parent_workflow_id = currentCrowdTask.taskParentWorkflowId; decomposeResults[4].mainTaskId = currentCrowdTask.mainTaskId; for (int i = 0; i < number; i++) { arrayList.Add(decomposeResults[i]); } break; } WorkflowApplication instance = MyWorkflowInstance.getDecomposeWorkflowApplication(taskWorkflowId); instance.ResumeBookmark(BookmarkName.Decomposing, arrayList); //跳转到分解完成页面 Server.Transfer("decomposeCompeleted.aspx"); }