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