public void FillDatasetSearch(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds, string i_str_search) { CStoredProc v_sp = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_search"); v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search); v_sp.fillDataSetByCommand(this, op_ds); }
public void FillDatasetByID_TRANG_THAI_PARENT(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds) { CStoredProc cstored = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_Select_by_ID_Parent"); //cstored.addDecimalInputParam("@ID_NS", i_str_search); cstored.fillDataSetByCommand(this, op_ds); }
private void load_data_2_grid() { m_ds = new DS_V_DM_TRANG_THAI_UNG_VIEN(); if (m_txt_tim_kiem.Text.Trim() == m_str_tim_kiem || m_txt_tim_kiem.Text.Trim() == "") { m_us.FillDatasetSearch(m_ds, ""); } else { m_us.FillDatasetSearch(m_ds, m_txt_tim_kiem.Text.Trim()); } //m_us.FillDataset(m_ds); var v_str_search = m_txt_tim_kiem.Text.Trim(); if (v_str_search.Equals(m_str_tim_kiem)) { v_str_search = ""; } 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.MA_TRANG_THAI_CAP_TREN // chỗ này là tên trường mà mình nhóm , (int)e_col_Number.MA_TRANG_THAI // chỗ này là tên trường mà mình Count , "{0}" ); m_fg.Redraw = true; set_search_format_before(); }
public US_V_DM_TRANG_THAI_UNG_VIEN(decimal i_dbID) { pm_objDS = new DS_V_DM_TRANG_THAI_UNG_VIEN(); 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]); }
private void load_data_2_cbo_ma_trang_thai_cap_tren() { var v_ds = new DS_V_DM_TRANG_THAI_UNG_VIEN(); var v_us = new US_V_DM_TRANG_THAI_UNG_VIEN(); v_us.FillDatasetByID_TRANG_THAI_PARENT(v_ds); //v_us.FillDatasetSearch(v_ds, ""); m_cbo_ma_trang_thai_cap_tren.DisplayMember = V_DM_TRANG_THAI_UNG_VIEN.MA_TRANG_THAI_CAP_TREN; m_cbo_ma_trang_thai_cap_tren.ValueMember = V_DM_TRANG_THAI_UNG_VIEN.ID_TRANG_THAI_CAP_TREN; m_cbo_ma_trang_thai_cap_tren.DataSource = v_ds.V_DM_TRANG_THAI_UNG_VIEN; var v_row = v_ds.V_DM_TRANG_THAI_UNG_VIEN.NewRow(); v_row[V_DM_TRANG_THAI_UNG_VIEN.ID] = -1; v_row[V_DM_TRANG_THAI_UNG_VIEN.MA_TRANG_THAI] = "NULL"; v_row[V_DM_TRANG_THAI_UNG_VIEN.ID_TRANG_THAI_CAP_TREN] = -1; v_row[V_DM_TRANG_THAI_UNG_VIEN.DINH_NGHIA] = ""; v_row[V_DM_TRANG_THAI_UNG_VIEN.DAU_HIEU] = ""; v_row[V_DM_TRANG_THAI_UNG_VIEN.VIEC_CAN_LAM] = ""; v_ds.V_DM_TRANG_THAI_UNG_VIEN.Rows.InsertAt(v_row, 0); }
public US_V_DM_TRANG_THAI_UNG_VIEN() { pm_objDS = new DS_V_DM_TRANG_THAI_UNG_VIEN(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }