public List<KeHoachVonShortModel> DanhSachGiaiDoanKHV(string mdv, string nsd, string pas, string maDonVi, long idDuAn, int nam) { try { var listKeHoachVon = new List<KeHoachVonShortModel>(); var giamSatDataTier = new GiamSatRepository(); var tableData = giamSatDataTier.DanhSachGiaiDoanKHV(mdv, nsd, pas, maDonVi, idDuAn, nam); if (tableData != null && tableData.Rows.Count > 0) { var listId = new List<int>(); foreach (DataRow dr in tableData.Rows) { var id = Convert.ToInt32(dr["dot"]); if (listId.Exists(element => element == id)) break; listId.Add(id); var soQuyetDinh = dr["so_qd"].ToString(); var trangThai = "dk"; if (soQuyetDinh != " ") trangThai = "pd"; // da tham dinh ke hoach von else if (dr["td_noi"].ToString() != "0" || dr["td_ngoai"].ToString() != "0") trangThai = "td"; var xoa = (TinhTrangXoa)Convert.ToInt32(dr["khv_xoa"]); var khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.DangKyKHV; khv.TinhTrangXoa = xoa; if (trangThai != "") khv.TrangThaiThucHien = "Hoàn thành"; else khv.TrangThaiThucHien = "Chưa thực hiện"; listKeHoachVon.Add(khv); khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.ThamDinhKHV; khv.TinhTrangXoa = xoa; if (trangThai == "td" || trangThai == "pd") khv.TrangThaiThucHien = "Hoàn thành"; else khv.TrangThaiThucHien = "Chưa thực hiện"; listKeHoachVon.Add(khv); khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.PheDuyetKHV; khv.TinhTrangXoa = xoa; if (trangThai == "pd") khv.TrangThaiThucHien = "Hoàn thành"; else khv.TrangThaiThucHien = "Chưa thực hiện"; listKeHoachVon.Add(khv); } foreach (var l in listKeHoachVon) { foreach (DataRow dr in tableData.Rows) { if (l.Dot == Convert.ToInt32(dr["dot"])) { if (!dr.IsNull("giamsat_id")) { if (l.GiaiDoanKHV == (GiaiDoanKHV)Convert.ToInt32(dr["ma_gd_khv"])) { l.IdGiamSat = Convert.ToInt64(dr["giamsat_id"]); l.KetQuaGiamSat = (KetQuaGiamSat)Convert.ToInt32(dr["ma_kq_gs"]); l.GhiChuGiamSat = dr["ghi_chu"].ToString(); break; } } } } } } return listKeHoachVon; } catch (Exception) { return null; } }
public List <KeHoachVonShortModel> DanhSachGiaiDoanKHV(string mdv, string nsd, string pas, string maDonVi, long idDuAn, int nam) { try { var listKeHoachVon = new List <KeHoachVonShortModel>(); var giamSatDataTier = new GiamSatRepository(); var tableData = giamSatDataTier.DanhSachGiaiDoanKHV(mdv, nsd, pas, maDonVi, idDuAn, nam); if (tableData != null && tableData.Rows.Count > 0) { var listId = new List <int>(); foreach (DataRow dr in tableData.Rows) { var id = Convert.ToInt32(dr["dot"]); if (listId.Exists(element => element == id)) { break; } listId.Add(id); var soQuyetDinh = dr["so_qd"].ToString(); var trangThai = "dk"; if (soQuyetDinh != " ") { trangThai = "pd"; } // da tham dinh ke hoach von else if (dr["td_noi"].ToString() != "0" || dr["td_ngoai"].ToString() != "0") { trangThai = "td"; } var xoa = (TinhTrangXoa)Convert.ToInt32(dr["khv_xoa"]); var khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.DangKyKHV; khv.TinhTrangXoa = xoa; if (trangThai != "") { khv.TrangThaiThucHien = "Hoàn thành"; } else { khv.TrangThaiThucHien = "Chưa thực hiện"; } listKeHoachVon.Add(khv); khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.ThamDinhKHV; khv.TinhTrangXoa = xoa; if (trangThai == "td" || trangThai == "pd") { khv.TrangThaiThucHien = "Hoàn thành"; } else { khv.TrangThaiThucHien = "Chưa thực hiện"; } listKeHoachVon.Add(khv); khv = new KeHoachVonShortModel(); khv.IdDuAn = idDuAn; khv.MaDonVi = maDonVi; khv.NamKHV = nam; khv.Dot = id; khv.SoQuyetDinh = soQuyetDinh; khv.GiaiDoanKHV = GiaiDoanKHV.PheDuyetKHV; khv.TinhTrangXoa = xoa; if (trangThai == "pd") { khv.TrangThaiThucHien = "Hoàn thành"; } else { khv.TrangThaiThucHien = "Chưa thực hiện"; } listKeHoachVon.Add(khv); } foreach (var l in listKeHoachVon) { foreach (DataRow dr in tableData.Rows) { if (l.Dot == Convert.ToInt32(dr["dot"])) { if (!dr.IsNull("giamsat_id")) { if (l.GiaiDoanKHV == (GiaiDoanKHV)Convert.ToInt32(dr["ma_gd_khv"])) { l.IdGiamSat = Convert.ToInt64(dr["giamsat_id"]); l.KetQuaGiamSat = (KetQuaGiamSat)Convert.ToInt32(dr["ma_kq_gs"]); l.GhiChuGiamSat = dr["ghi_chu"].ToString(); break; } } } } } } return(listKeHoachVon); } catch (Exception) { return(null); } }