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;
}
}
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);
Grid1.DataSource = result.DuAnModelsGridView;
Grid1.DataBind();
}
}
public object[] TimKiemDuAn(string mdv, string nsd, string pas, SearchProjectSetting searchProjectSetting,
int pageSize, int pageIndex = 1)
{
try
{
ConnectDB.CloseConnection(_connectGs);
_connectGs = new OracleConnection();
_connectGs = ConnectDB.GetOracleConnection(_connectGs);
var cm = _connectGs.CreateCommand();
cm.CommandText = "usp_TimKiem_DuAn";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add(new OracleParameter("ma_donvi", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("nsd", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("pas", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("ma_duan", OracleDbType.Varchar2)).Value =
searchProjectSetting.MaDuAn;
cm.Parameters.Add(new OracleParameter("loai_duan", OracleDbType.Varchar2)).Value =
searchProjectSetting.LoaiDuAn;
cm.Parameters.Add(new OracleParameter("nhom_duan", OracleDbType.Varchar2)).Value =
searchProjectSetting.NhomDuAn==NhomDuAn.KhongXacDinh?"":searchProjectSetting.NhomDuAn.ToString();
cm.Parameters.Add(new OracleParameter("loai_nguonvon", OracleDbType.Int32)).Value =
searchProjectSetting.LoaiNguonVon == LoaiNguonVon.KhongXacDinh ? -1 : (int)searchProjectSetting.LoaiNguonVon;
cm.Parameters.Add(new OracleParameter("phancap", OracleDbType.Varchar2)).Value =
searchProjectSetting.PhanCap == LoaiPhanCap.KhongXacDinh ? "" : searchProjectSetting.PhanCap.ToString();
cm.Parameters.Add(new OracleParameter("ma_donvi_quanly", OracleDbType.Varchar2)).Value =
searchProjectSetting.MaDonViQuanLy;
cm.Parameters.Add(new OracleParameter("ma_donvi_thuchien", OracleDbType.Varchar2)).Value =
searchProjectSetting.MaDonViThucHien;
cm.Parameters.Add(new OracleParameter("toantu_tongvon", OracleDbType.Varchar2)).Value =
searchProjectSetting.TongVonDauTuToanTu;
cm.Parameters.Add(new OracleParameter("tongvon", OracleDbType.Long)).Value =
searchProjectSetting.TongVonDauTu;
cm.Parameters.Add(new OracleParameter("toantu_nam_bd", OracleDbType.Varchar2)).Value =
searchProjectSetting.NamBatDauToanTu;
cm.Parameters.Add(new OracleParameter("nam_bd", OracleDbType.Int32)).Value =
searchProjectSetting.NamBatDau;
cm.Parameters.Add(new OracleParameter("toantu_nam_kt", OracleDbType.Varchar2)).Value =
searchProjectSetting.NamKetThucToanTu;
cm.Parameters.Add(new OracleParameter("nam_kt", OracleDbType.Int32)).Value =
searchProjectSetting.NamKetThuc;
cm.Parameters.Add(new OracleParameter("page_index", OracleDbType.Int32)).Value = pageIndex;
cm.Parameters.Add(new OracleParameter("page_size", OracleDbType.Int32)).Value = pageSize;
var op = new OracleParameter("total_record", OracleDbType.Long, 15)
{Direction = ParameterDirection.Output};
cm.Parameters.Add(op);
cm.Parameters.Add(new OracleParameter("cs_lke", OracleDbType.RefCursor)).Direction =
ParameterDirection.Output;
var tableGs = new DataTable();
_oracleAdapter = new OracleDataAdapter(cm);
_oracleAdapter.Fill(tableGs);
var totalRecord = cm.Parameters["total_record"].Value.ToString();
var arrObject = new object[2];
arrObject[0] = tableGs;
arrObject[1] = totalRecord;
return arrObject;
}
catch (Exception ex)
{
return null;
}
finally
{
ConnectDB.CloseConnection(_connectGs);
}
}
