private void load_data_2_grid() { m_ds = new DS_V_GD_QUYET_DINH(); if (m_txt_tim_kiem.Text.Trim() == m_str_tim_kiem || m_txt_tim_kiem.Text.Trim() == "") { m_us.FillDatasetSearch(m_ds, "", CIPConvert.ToDecimal(m_cbo_loai_quyet_dinh.SelectedValue.ToString()), CIPConvert.ToDecimal(m_cbo_tim_kiem_theo.SelectedValue.ToString()), m_dat_tu_ngay.Value, m_dat_den_ngay.Value, CAppContext_201.getCurrentIDPhapnhan()); } else { m_us.FillDatasetSearch(m_ds, m_txt_tim_kiem.Text.Trim(), CIPConvert.ToDecimal(m_cbo_loai_quyet_dinh.SelectedValue.ToString()), CIPConvert.ToDecimal(m_cbo_tim_kiem_theo.SelectedValue.ToString()), m_dat_tu_ngay.Value, m_dat_den_ngay.Value, CAppContext_201.getCurrentIDPhapnhan()); } // m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế , 0 , (int)e_col_Number.LOAI_QUYET_DINH // chỗ này là tên trường mà mình nhóm , (int)e_col_Number.MA_QUYET_DINH // chỗ này là tên trường mà mình Count , "{0}" ); m_fg.Redraw = true; m_lbl_total_record.Text = string.Format("Có {0} bản ghi", m_ds.V_GD_QUYET_DINH.Rows.Count); load_custom_source_2_m_txt_tim_kiem(); }
public US_V_GD_QUYET_DINH(decimal i_dbID) { pm_objDS = new DS_V_GD_QUYET_DINH(); 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_QUYET_DINH op_ds, string i_str_search, decimal ip_dc_loai_qd, decimal ip_dc_loai_ngay, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_dc_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_V_GD_QUYET_DINH_search"); v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search); v_sp.addDecimalInputParam("@LOAI_QUYET_DINH", ip_dc_loai_qd); v_sp.addDecimalInputParam("@LOAI_NGAY", ip_dc_loai_ngay); v_sp.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay); v_sp.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay); v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds); }
private void load_custom_source_2_m_txt_tim_kiem() { // DEBUG DucVT //m_us.FillDataset(m_ds); DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); m_us.FillDataset(v_ds); int count = m_ds.Tables["V_GD_QUYET_DINH"].Rows.Count; AutoCompleteStringCollection v_acsc_search = new AutoCompleteStringCollection(); foreach (DataRow dr in v_ds.V_GD_QUYET_DINH) { v_acsc_search.Add(dr[V_GD_QUYET_DINH.MA_NV].ToString()); v_acsc_search.Add(dr[V_GD_QUYET_DINH.TEN].ToString()); v_acsc_search.Add(dr[V_GD_QUYET_DINH.HO_DEM] + " " + dr[V_GD_QUYET_DINH.TEN]); v_acsc_search.Add(dr[V_GD_QUYET_DINH.MA_QUYET_DINH].ToString()); /* v_acsc_search.Add(dr[V_GD_QUYET_DINH.NOI_DUNG].ToString());*/ } m_txt_tim_kiem.AutoCompleteCustomSource = v_acsc_search; }
private DS_V_GD_QUYET_DINH load_data_2_ds_v_gd_quyet_dinh() { US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(); DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); v_us.FillDataset(v_ds); return v_ds; }
private DataTable load_danh_sach_quyet_dinh() { US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(); DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); v_us.FillDataset(v_ds); return v_ds.Tables[0]; }
private DataSet load_data_2_ds_v_gd_quyet_dinh() { US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(); DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); v_us.FillDataset(v_ds); //v_us.FillDatasetWithTableName(v_ds, "V_GD_QUYET_DINH"); return v_ds; }
//clear data in form private void clear_data_inform() { m_sle_loai_quyet_dinh.EditValue = null; m_txt_ma_qd.Text = ""; m_lbl_kiem_tra_ma_qd.Visible = false; m_dat_ngay_co_hieu_luc.Value = DateTime.Now.Date; m_dat_ngay_het_hieu_luc.Value = DateTime.Now.Date; m_dat_ngay_ky.Value = DateTime.Now.Date; m_txt_nguoi_ky.Text = ""; m_txt_noi_dung.Text = ""; m_txt_link.Text = ""; DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); m_grc_quyet_dinh.DataSource = v_ds.Tables[0]; }
private void load_data_2_grid() { CHRMCommon.make_stt(m_grv_quyet_dinh); US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(); DS_V_GD_QUYET_DINH v_ds = new DS_V_GD_QUYET_DINH(); v_us.FillDataset(v_ds); m_grc_quyet_dinh.DataSource = v_ds.Tables[0]; }
public void FillDataset(DS_V_GD_QUYET_DINH op_ds) { CStoredProc v_sp = new CStoredProc("pr_V_GD_QUYET_DINH_FillDataset"); v_sp.fillDataSetByCommand(this, op_ds); }
public US_V_GD_QUYET_DINH() { pm_objDS = new DS_V_GD_QUYET_DINH(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }