private void load_data_2_grid() { m_ds = new DS_V_GD_BAO_CAO_DU_AN_2(); var v_str_search = m_txt_tim_kiem.Text.Trim(); if (v_str_search == m_str_suggest) { v_str_search = ""; } if (m_cbo_tim_kiem_theo_ngay.SelectedIndex == -1) { m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; m_lbl_total_record_grid1.Text = string.Format("Có {0} dự án", m_ds.Tables[0].Rows.Count); return; } m_us.FillDatasetSearch(m_ds, v_str_search, m_dat_tu_ngay.Value, m_dat_den_ngay.Value, decimal.Parse(m_cbo_trang_thai.SelectedValue.ToString()), decimal.Parse(m_cbo_loai_du_an.SelectedValue.ToString()), decimal.Parse(m_cbo_co_che.SelectedValue.ToString()), m_cbo_tim_kiem_theo_ngay.SelectedIndex, CAppContext_201.getCurrentIDPhapnhan()); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; m_lbl_total_record_grid1.Text = string.Format("Có {0} dự án", m_ds.Tables[0].Rows.Count); }
public US_V_GD_BAO_CAO_DU_AN_2(decimal i_dbID) { pm_objDS = new DS_V_GD_BAO_CAO_DU_AN_2(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
public void FillDatasetSearch( DS_V_GD_BAO_CAO_DU_AN_2 op_ds_bc_da, string i_str_search, DateTime v_dat_tu_ngay, DateTime v_dat_den_ngay, decimal v_dc_trang_thai, decimal v_dc_loai_du_an, decimal v_dc_co_che, decimal v_dc_tim_kiem_theo_ngay, decimal ip_dc_id_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_V_GD_BAO_CAO_DU_AN_2_search"); v_sp.addNVarcharInputParam("@str_search", i_str_search); v_sp.addDatetimeInputParam("@tu_ngay", v_dat_tu_ngay); v_sp.addDatetimeInputParam("@den_ngay", v_dat_den_ngay); v_sp.addDecimalInputParam("@id_trang_thai_du_an", v_dc_trang_thai); v_sp.addDecimalInputParam("@id_loai_du_an", v_dc_loai_du_an); v_sp.addDecimalInputParam("@id_co_che", v_dc_co_che); v_sp.addDecimalInputParam("@tim_kiem_theo_ngay", v_dc_tim_kiem_theo_ngay); v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds_bc_da); }
public US_V_GD_BAO_CAO_DU_AN_2() { pm_objDS = new DS_V_GD_BAO_CAO_DU_AN_2(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }