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