public ListDuAnModelGridView TimKiemDuAn(string mdv, string nsd, string pas, SearchProjectSetting searchProjectSetting, int pageSize, int pageIndex = 1)
{
try
{
var listDuAn = new ListDuAnModelGridView();
var giamSatDataTier = new GiamSatRepository();
var objData = giamSatDataTier.TimKiemDuAn(mdv, nsd, pas, searchProjectSetting, pageSize, pageIndex);
if (objData != null)
{
var list = new List <DuAnShortModel>();
var pageSetting = new PaginationSetting
{
PageSize = pageSize,
TotalRecords = Convert.ToInt64(objData[1])
};
listDuAn.TotalPage = pageSetting.TotalPage;
listDuAn.TotalRecords = pageSetting.TotalRecords;
var table = objData[0] as DataTable;
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
var duan = new DuAnShortModel();
duan.IdDuAn = Convert.ToInt64(dr["so_id"]);
duan.LoaiNguonVon = (LoaiNguonVon)Convert.ToInt32(dr["loai_nguon_von"]);
duan.LoaiPhanCap = (LoaiPhanCap)Enum.Parse(typeof(LoaiPhanCap), dr["phancap"].ToString());
duan.MaDonVi = dr["ma_dvi"].ToString();
duan.MaDuAn = dr["ma"].ToString();
duan.NamBatDau = Convert.ToInt32(dr["nambd"]);
duan.NamKetThuc = Convert.ToInt32(dr["namkt"]);
duan.NhomDuAn = (NhomDuAn)Enum.Parse(typeof(NhomDuAn), dr["nhom_da"].ToString());
duan.TenDuAn = dr["ten"].ToString();
duan.TongVonDauTu = Convert.ToInt64(dr["tienqd"]);
duan.TenLoaiNguonVon = EnumHelper.GetDescription(duan.LoaiNguonVon);
duan.TenLoaiPhanCap = EnumHelper.GetDescription(duan.LoaiPhanCap);
duan.TenNhomDuAn = EnumHelper.GetDescription(duan.NhomDuAn);
list.Add(duan);
}
listDuAn.DuAnModelsGridView = list;
}
}
return(listDuAn);
}
catch (Exception)
{
return(null);
}
}
public DuAnShortModel ChiTietDuAn(string mdv, string nsd, string pas, string maDonVi, long idDuAn)
{
try
{
var giamSatDataTier = new GiamSatRepository();
var tableData = giamSatDataTier.ChiTietDuAn(mdv, nsd, pas, maDonVi, idDuAn);
if (tableData != null && tableData.Rows.Count > 0)
{
var duAn = new DuAnShortModel();
duAn.IdDuAn = idDuAn;
duAn.MaDonVi = maDonVi;
duAn.MaDuAn = tableData.Rows[0]["ma"].ToString();
duAn.TenDuAn = tableData.Rows[0]["ten"].ToString();
duAn.LoaiNguonVon = (LoaiNguonVon)Convert.ToInt32(tableData.Rows[0]["loai_nguon_von"]);
duAn.LoaiPhanCap = (LoaiPhanCap)Enum.Parse(typeof(LoaiPhanCap), tableData.Rows[0]["phan_cap"].ToString());
duAn.NhomDuAn = (NhomDuAn)Enum.Parse(typeof(NhomDuAn), tableData.Rows[0]["nhom_da"].ToString());
duAn.MaLoaiDuAn = tableData.Rows[0]["loai"].ToString();
duAn.TenLoaiDuAn = tableData.Rows[0]["ten_loai_duan"].ToString();
duAn.NamBatDau = Convert.ToInt32(tableData.Rows[0]["nam_bd"]);
duAn.NamKetThuc = Convert.ToInt32(tableData.Rows[0]["nam_kt"]);
duAn.TongVonDauTu = Convert.ToInt64(tableData.Rows[0]["tien_qd"]);
duAn.TenDonViThucHien = tableData.Rows[0]["ten_donvi_thuchien"].ToString();
duAn.TenDonViQuanLy = tableData.Rows[0]["ten_donvi_quanly"].ToString();
duAn.SoQuyetDinh = tableData.Rows[0]["so_qd"].ToString();
duAn.TenLoaiNguonVon = EnumHelper.GetDescription(duAn.LoaiNguonVon);
duAn.TenLoaiPhanCap = EnumHelper.GetDescription(duAn.LoaiPhanCap);
duAn.TenNhomDuAn = EnumHelper.GetDescription(duAn.NhomDuAn);
return duAn;
}
return null;
}
catch (Exception ex)
{
return null;
}
}
public DuAnShortModel ChiTietDuAn(string mdv, string nsd, string pas, string maDonVi, long idDuAn)
{
try
{
var giamSatDataTier = new GiamSatRepository();
var tableData = giamSatDataTier.ChiTietDuAn(mdv, nsd, pas, maDonVi, idDuAn);
if (tableData != null && tableData.Rows.Count > 0)
{
var duAn = new DuAnShortModel();
duAn.IdDuAn = idDuAn;
duAn.MaDonVi = maDonVi;
duAn.MaDuAn = tableData.Rows[0]["ma"].ToString();
duAn.TenDuAn = tableData.Rows[0]["ten"].ToString();
duAn.LoaiNguonVon = (LoaiNguonVon)Convert.ToInt32(tableData.Rows[0]["loai_nguon_von"]);
duAn.LoaiPhanCap = (LoaiPhanCap)Enum.Parse(typeof(LoaiPhanCap), tableData.Rows[0]["phan_cap"].ToString());
duAn.NhomDuAn = (NhomDuAn)Enum.Parse(typeof(NhomDuAn), tableData.Rows[0]["nhom_da"].ToString());
duAn.MaLoaiDuAn = tableData.Rows[0]["loai"].ToString();
duAn.TenLoaiDuAn = tableData.Rows[0]["ten_loai_duan"].ToString();
duAn.NamBatDau = Convert.ToInt32(tableData.Rows[0]["nam_bd"]);
duAn.NamKetThuc = Convert.ToInt32(tableData.Rows[0]["nam_kt"]);
duAn.TongVonDauTu = Convert.ToInt64(tableData.Rows[0]["tien_qd"]);
duAn.TenDonViThucHien = tableData.Rows[0]["ten_donvi_thuchien"].ToString();
duAn.TenDonViQuanLy = tableData.Rows[0]["ten_donvi_quanly"].ToString();
duAn.SoQuyetDinh = tableData.Rows[0]["so_qd"].ToString();
duAn.TenLoaiNguonVon = EnumHelper.GetDescription(duAn.LoaiNguonVon);
duAn.TenLoaiPhanCap = EnumHelper.GetDescription(duAn.LoaiPhanCap);
duAn.TenNhomDuAn = EnumHelper.GetDescription(duAn.NhomDuAn);
return(duAn);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
public ListDuAnModelGridView TimKiemDuAn(string mdv, string nsd, string pas, SearchProjectSetting searchProjectSetting, int pageSize, int pageIndex = 1)
{
try
{
var listDuAn = new ListDuAnModelGridView();
var giamSatDataTier = new GiamSatRepository();
var objData = giamSatDataTier.TimKiemDuAn(mdv, nsd, pas, searchProjectSetting, pageSize, pageIndex);
if (objData != null)
{
var list = new List<DuAnShortModel>();
var pageSetting = new PaginationSetting
{
PageSize = pageSize,
TotalRecords = Convert.ToInt64(objData[1])
};
listDuAn.TotalPage = pageSetting.TotalPage;
listDuAn.TotalRecords = pageSetting.TotalRecords;
var table = objData[0] as DataTable;
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
var duan = new DuAnShortModel();
duan.IdDuAn = Convert.ToInt64(dr["so_id"]);
duan.LoaiNguonVon = (LoaiNguonVon)Convert.ToInt32(dr["loai_nguon_von"]);
duan.LoaiPhanCap = (LoaiPhanCap)Enum.Parse(typeof(LoaiPhanCap), dr["phancap"].ToString());
duan.MaDonVi = dr["ma_dvi"].ToString();
duan.MaDuAn = dr["ma"].ToString();
duan.NamBatDau = Convert.ToInt32(dr["nambd"]);
duan.NamKetThuc = Convert.ToInt32(dr["namkt"]);
duan.NhomDuAn = (NhomDuAn)Enum.Parse(typeof(NhomDuAn), dr["nhom_da"].ToString());
duan.TenDuAn = dr["ten"].ToString();
duan.TongVonDauTu = Convert.ToInt64(dr["tienqd"]);
duan.TenLoaiNguonVon = EnumHelper.GetDescription(duan.LoaiNguonVon);
duan.TenLoaiPhanCap = EnumHelper.GetDescription(duan.LoaiPhanCap);
duan.TenNhomDuAn = EnumHelper.GetDescription(duan.NhomDuAn);
list.Add(duan);
}
listDuAn.DuAnModelsGridView = list;
}
}
return listDuAn;
}
catch (Exception)
{
return null;
}
}
