private List<KHTHReturn> GetKeHoachThucHien(FilterCondition filter)
{
List<KHTHReturn> listKHTH = new List<KHTHReturn>();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
listKHTH = dc.GetKeHoachThucHien(filter.SystemId,
filter.SelectedCapDo,
filter.SelectedGiaTriCapDo,
filter.SelectedCongDoan,
filter.sDateFrom,
filter.sDateTo).ToList<KHTHReturn>();
}
return listKHTH;
}
public ArrayList GetKeHoachThucHien(FilterCondition filter)
{
ArrayList listKhTh = new ArrayList();
using (TKTDSXEntities dc = new TKTDSXEntities())
{
string dtFrom = string.Format("{0}-{1}-{2}", filter.DateFrom.Year, filter.DateFrom.Month, filter.DateFrom.Day);
string dtTo = string.Format("{0}-{1}-{2}", filter.DateFrom.Year, filter.DateFrom.Month, filter.DateFrom.Day);
try
{
var listRaw = dc.GetKeHoachThucHien(filter.SystemId, filter.SelectedCapDo, filter.SelectedGiaTriCapDo,
filter.SelectedCongDoan, dtFrom, dtTo).ToList <KHTHReturn>();
//Header
ArrayList lineHeader = new ArrayList();
lineHeader.Add("Data");
for (int i = 0; i < listRaw.Count; i++)
{
lineHeader.Add(listRaw[i].CONGDOAN.ToString());
}
listKhTh.Add(lineHeader);
//KeHoach
ArrayList lineKeHoach = new ArrayList();
lineKeHoach.Add("KeHoach");
for (int y = 0; y < listRaw.Count; y++)
{
lineKeHoach.Add(listRaw[y].KEHOACH.ToString());
}
listKhTh.Add(lineKeHoach);
//ThucHien
ArrayList lineThucHien = new ArrayList();
lineThucHien.Add("ThucHien");
for (int y = 0; y < listRaw.Count; y++)
{
lineThucHien.Add(listRaw[y].THUCHIEN.ToString());
}
listKhTh.Add(lineThucHien);
}
catch
{
//do nothing
}
}
return(listKhTh);
}
