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