|
[ASPX.CS]
//..
public class GanttData
{
//..
public string TaskName { get; set; }
public string StartDate { get; set; }
public string EndDate { get; set; }
public int Progress { get; set; }
}
public class Resources
{
public String ResourceId { get; set; }
public String ResourceName { get; set; }
public int TeamId { get; set; }
}
public List<GanttData> GetTasks()
{
//..
while (reader.Read())
{
GanttData obj = new GanttData();
obj.StartDate = Convert.ToDateTime(reader.GetValue(2)).ToString("MM/dd/yyyy");
obj.EndDate = Convert.ToDateTime(reader.GetValue(3)).ToString("MM/dd/yyyy");
data.Add(obj);
}
reader.Close();
//..
}
public List<object> GetResourceInfo(string[] values)
{
//..
foreach (string value in values)
{
if (value != "")
Resources.Add(value);
}
return Resources;
}
public List<Resources> GetResources()
{
//..
while (reader.Read())
{
Resources obj = new Resources();
obj.ResourceId = (string)reader.GetValue(0);
//..
data.Add(obj);
}
reader.Close();
//..
} |
|
|