protected void btTimKiem_Click(object sender, EventArgs e)
{
if (Validate())
{
var pageSize = 200;
var sps = new SearchProjectSetting();
sps.MaDuAn = txtMaDuAn.Text;
sps.LoaiDuAn = ddlLoaiDuAn.SelectedValue;
sps.NhomDuAn = (NhomDuAn)Enum.Parse(typeof(NhomDuAn), ddlNhomDuAn.SelectedValue);
sps.LoaiNguonVon = (LoaiNguonVon)Enum.Parse(typeof(LoaiNguonVon), ddlLoaiNguonVon.SelectedValue);
sps.PhanCap = (LoaiPhanCap)Enum.Parse(typeof(LoaiPhanCap), ddlPhanCap.SelectedValue);
sps.MaDonViQuanLy = ddlDonViQuanLyDT.SelectedValue;
sps.MaDonViThucHien = ddlDonViChuDT.SelectedValue;
sps.TongVonDauTuToanTu = ddlTTTongVonDT.SelectedValue;
sps.TongVonDauTu = Int64.Parse(txtTongVonDT.Text == "" ? "0" : txtTongVonDT.Text);
sps.NamBatDauToanTu = ddlTTThoiGianPhatSinh.SelectedValue;
sps.NamBatDau = Int32.Parse(ddlThoiGianPhatSinh.SelectedValue);// Int32.Parse(txtThoiGianPhatSinh.Text == "" ? "0" : txtThoiGianPhatSinh.Text);
sps.NamKetThucToanTu = ddlTTThoiGianKetThuc.SelectedValue;
sps.NamKetThuc = Int32.Parse(ddlThoiGianKetThuc.SelectedValue);
ListDuAnModelGridView result = giamsatService.TimKiemDuAn("", "", "", sps, pageSize, 1);
//if (result.DuAnModelsGridView != null)
//{
// foreach (var item in result.DuAnModelsGridView)
// {
// string a = "";
// item.TongVonDauTu = Common.GetValueFormatNumber(a);
// }
//}
Grid1.DataSource = result.DuAnModelsGridView;
Grid1.DataBind();
}
}
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 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;
}
}
