private void button1_Click(object sender, EventArgs e) { if (treeList1.FocusedNode != null) { if (treeList1.FocusedNode.Level == 0) { DSWorkFlow.tblWorkFlowDataTable dt1 = new DSWorkFlow.tblWorkFlowDataTable(); nParentNodeID = (int)treeList1.FocusedNode.GetValue("ID"); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); treeList1.FocusedNode = treeList1.AppendNode(dt1.AddtblWorkFlowRow(nKey,nParentNodeID, 0, "", nDepartment, nEmployee, ""), treeList1.FocusedNode.Id); //treeList1.FocusedNode = treeList1.AppendNode(new object[] {nParentNodeID,0,"",4,3798}, treeList1.FocusedNode.Id); //tblWorkFlowTableAdapter.Insert(nParentNodeID, 1, "", ""); tblWorkFlowTableAdapter2.Update(dt1); //tblWorkFlowTableAdapter.Fill(this.dSWorkFlow.tblWorkFlow); } else { DSWorkFlow.tblWorkFlowDataTable dt = new DSWorkFlow.tblWorkFlowDataTable(); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); nParentNodeID = (int)treeList1.FocusedNode.GetValue("ID"); treeList1.FocusedNode = treeList1.AppendNode(dt.AddtblWorkFlowRow(nKey,nParentNodeID, 0, "", nDepartment, nEmployee, ""), treeList1.FocusedNode.Id); //tblWorkFlowTableAdapter.Insert(nParentNodeID, 1, "", ""); tblWorkFlowTableAdapter2.Update(dt); } } }
private void button1_Click(object sender, EventArgs e) { if (treeList1.FocusedNode != null) { if (treeList1.FocusedNode.Level == 0) { DSWorkFlow.tblWorkFlowDataTable dt1 = new DSWorkFlow.tblWorkFlowDataTable(); nParentNodeID = (int)treeList1.FocusedNode.GetValue("ID"); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); treeList1.FocusedNode = treeList1.AppendNode(dt1.AddtblWorkFlowRow(nKey, nParentNodeID, 0, "", nDepartment, nEmployee, ""), treeList1.FocusedNode.Id); //treeList1.FocusedNode = treeList1.AppendNode(new object[] {nParentNodeID,0,"",4,3798}, treeList1.FocusedNode.Id); //tblWorkFlowTableAdapter.Insert(nParentNodeID, 1, "", ""); tblWorkFlowTableAdapter2.Update(dt1); //tblWorkFlowTableAdapter.Fill(this.dSWorkFlow.tblWorkFlow); } else { DSWorkFlow.tblWorkFlowDataTable dt = new DSWorkFlow.tblWorkFlowDataTable(); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); nParentNodeID = (int)treeList1.FocusedNode.GetValue("ID"); treeList1.FocusedNode = treeList1.AppendNode(dt.AddtblWorkFlowRow(nKey, nParentNodeID, 0, "", nDepartment, nEmployee, ""), treeList1.FocusedNode.Id); //tblWorkFlowTableAdapter.Insert(nParentNodeID, 1, "", ""); tblWorkFlowTableAdapter2.Update(dt); } } }
private void button2_Click(object sender, EventArgs e) { DSWorkFlow.tblWorkFlowDataTable dt = new DSWorkFlow.tblWorkFlowDataTable(); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); treeList1.FocusedNode = treeList1.AppendNode(dt.AddtblWorkFlowRow(nKey,0, 0, "", nDepartment, nEmployee, ""), null); tblWorkFlowTableAdapter2.Insert(0, 1, "", nDepartment, nEmployee,""); //tblWorkFlowTableAdapter.Update(dSWorkFlow); //tblWorkFlowTableAdapter.Fill(this.dSWorkFlow.tblWorkFlow, nDepartment); tblWorkFlowTableAdapter2.Fill(this.dSWorkFlow.tblWorkFlow); }
private void button2_Click(object sender, EventArgs e) { DSWorkFlow.tblWorkFlowDataTable dt = new DSWorkFlow.tblWorkFlowDataTable(); nKey = System.Convert.ToInt32(tblWorkFlowTableAdapter2.GetKey()); treeList1.FocusedNode = treeList1.AppendNode(dt.AddtblWorkFlowRow(nKey, 0, 0, "", nDepartment, nEmployee, ""), null); tblWorkFlowTableAdapter2.Insert(0, 1, "", nDepartment, nEmployee, ""); //tblWorkFlowTableAdapter.Update(dSWorkFlow); //tblWorkFlowTableAdapter.Fill(this.dSWorkFlow.tblWorkFlow, nDepartment); tblWorkFlowTableAdapter2.Fill(this.dSWorkFlow.tblWorkFlow); }
public virtual DSWorkFlow.tblWorkFlowDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; DSWorkFlow.tblWorkFlowDataTable dataTable = new DSWorkFlow.tblWorkFlowDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual DSWorkFlow.tblWorkFlowDataTable GetChildValue(global::System.Nullable<int> ParentID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((ParentID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[0].Value = ((int)(ParentID.Value)); } else { this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value; } DSWorkFlow.tblWorkFlowDataTable dataTable = new DSWorkFlow.tblWorkFlowDataTable(); this.Adapter.Fill(dataTable); return dataTable; }