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