public List <TaskClass> Get(int eventTabID) { List <TaskClass> tasks = new List <TaskClass>(); SqlCommand cmd = new SqlCommand("select * from Task where eventTabID=@eventTabID ORDER BY taskTableAddDate ASC", connection); cmd.Parameters.AddWithValue("@eventTabID", eventTabID); connection.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { TaskClass task = new TaskClass(); task.ID = (int)sdr["taskID"]; task.EventTabID = (int)sdr["eventTabID"]; task.Title = (string)sdr["taskTitle"]; task.Date = (DateTime)sdr["taskDate"]; task.GuessTime = (int)sdr["taskGuessTime"]; task.RealTime = (int)sdr["taskRealTime"]; task.TechnicalPersonID = (int)sdr["taskTechnicalPerson"]; task.WorkComment = (string)sdr["taskWorkComment"]; task.Note = (string)sdr["taskNotes"]; task.TaskButton.Text = task.Title; task.taskFinish = (Boolean)sdr["taskFinish"]; WorkFollow workFollow = new WorkFollow(); task.workFollows = workFollow.Get(task.ID); tasks.Add(task); } connection.Close(); return(tasks); }
public List <EventTab> GetList() { List <EventTab> eventTabs = new List <EventTab>(); TaskClass task = new TaskClass(); SqlCommand cmd = new SqlCommand("select * from eventTab where projectID=@projectID ORDER BY evenTabTableAddDate ASC", connection); cmd.Parameters.AddWithValue("@projectID", projectID); connection.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { EventTab eventTab = new EventTab(this.projectID); eventTab.ID = (int)sdr["eventTabID"]; eventTab.tasks = task.Get(eventTab.ID); foreach (TaskClass item in eventTab.tasks) { eventTab.Controls.Add(item.TaskButton); eventTab.Controls.SetChildIndex(eventTab.BtnEventAdd, eventTab.Controls.Count); eventTab.Height += item.TaskButton.Height + 6; } eventTab.TopPanel.TbTitle.Text = sdr["eventTabTitle"].ToString(); eventTabs.Add(eventTab); } connection.Close(); return(eventTabs); }
public TaskButton(TaskClass task) { Task = task; this.Name = "addEventButton"; this.Size = new System.Drawing.Size(240, 40); this.Dock = System.Windows.Forms.DockStyle.Top; this.BackColor = Color.Teal; this.ForeColor = Color.White; this.MouseDown += TaskButton_MouseDown; this.MouseMove += TaskButton_MouseMove; this.MouseUp += TaskButton_MouseUp; this.Click += TaskButton_Click; this.ParentChanged += TaskButton_ParentChanged; }
private void TaskAddButton_Click(object sender, EventArgs e) { EventTab eventTab = (EventTab)this.Parent; TaskClass task = new TaskClass(); task.EventTabID = eventTab.ID; task.Add(); eventTab.tasks.Add(task); eventTab.Controls.Add(task.TaskButton); eventTab.Controls.SetChildIndex(this, eventTab.tasks.Count + 1); if ((eventTab.Height + task.TaskButton.Height + 6 + this.Height) < eventTab.Parent.Height) { eventTab.Size = new Size(eventTab.Width, eventTab.Height + task.TaskButton.Height + 6); } }