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