public US_V_HT_LOG_TRUY_CAP(decimal i_dbID) { pm_objDS = new DS_V_HT_LOG_TRUY_CAP(); 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_grid() { m_ds = new DS_V_HT_LOG_TRUY_CAP(); m_us.fill_data_bo_loc(m_ds , m_txt_username.Text.Trim() , m_dat_from_date.Value , m_dat_to_date.Value , CIPConvert.ToDecimal(m_cbo_loai_hanh_dong.SelectedValue)); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); CGridUtils.MakeSoTT((int)e_col_Number.STT, m_fg); m_fg.Redraw = true; }
public void fill_data_bo_loc(DS_V_HT_LOG_TRUY_CAP op_ds_ht_log_truy_cap , string ip_str_username , DateTime ip_dat_tu_ngay , DateTime ip_dat_den_ngay , decimal ip_dc_id_hanh_dong) { CStoredProc v_cstore = new CStoredProc("pr_V_HT_LOG_TRUY_CAP_filter"); v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username); v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay); v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay); v_cstore.addDecimalInputParam("@ID_LOAI_HANH_DONG", ip_dc_id_hanh_dong); v_cstore.fillDataSetByCommand(this, op_ds_ht_log_truy_cap); }
public US_V_HT_LOG_TRUY_CAP() { pm_objDS = new DS_V_HT_LOG_TRUY_CAP(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }