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