Example #1
0
        private void load_data_2_grid()
        {
            US_V_DM_DON_VI v_us_dm_don_vi = new US_V_DM_DON_VI();

            m_v_ds = new DS_V_DM_DON_VI();
            var v_str_search = m_txt_search.Text.Trim();

            //var v_str_search = "TEG";
            if (m_txt_search.Text.Trim() != m_str_goi_y_tim_kiem)
            {
                v_us_dm_don_vi.FillDatasetByKeyWord(m_v_ds, v_str_search, CIPConvert.ToDecimal(m_cbo_loaidv.SelectedValue), CIPConvert.ToDecimal(m_cbo_capdv.SelectedValue), m_cbo_trangthai.SelectedValue.ToString(), CAppContext_201.getCurrentIDPhapnhan());
            }
            else
            {
                v_us_dm_don_vi.FillDatasetByKeyWord(m_v_ds, "", CIPConvert.ToDecimal(m_cbo_loaidv.SelectedValue), CIPConvert.ToDecimal(m_cbo_capdv.SelectedValue), m_cbo_trangthai.SelectedValue.ToString(), CAppContext_201.getCurrentIDPhapnhan());
            }
            m_fg.Redraw = false;
            int minID_LEVEL = int.Parse(m_v_ds.V_DM_DON_VI.Compute("Min(ID_LEVEL)", "").ToString());

            DataRow[] v_arr_dr = m_v_ds.V_DM_DON_VI.Select(V_DM_DON_VI.ID_LEVEL + "=" + minID_LEVEL.ToString());
            if (v_arr_dr.Length == 0)
            {
                return;
            }
            CGridUtils.ClearDataInGrid(m_fg);
            v_us_dm_don_vi.DataRow2Me(v_arr_dr[0]);
            m_fg.Rows.Count += 1;
            int v_i_root_row = m_fg.Rows.Count - 1;

            us_object_2_grid(v_us_dm_don_vi, m_v_ds, v_i_root_row);
            m_fg.Rows[v_i_root_row].IsNode     = true;
            m_fg.Rows[v_i_root_row].Node.Level = int.Parse(v_us_dm_don_vi.dcID_LEVEL.ToString());
            switch (m_fg.Rows[v_i_root_row].Node.Level)
            {
            case 0:
                m_fg.Rows[v_i_root_row].Style = m_fg.Styles[CellStyleEnum.Subtotal0];
                break;

            case 1:
                m_fg.Rows[v_i_root_row].Style = m_fg.Styles[CellStyleEnum.Subtotal1];
                break;

            case 2:
                m_fg.Rows[v_i_root_row].Style = m_fg.Styles[CellStyleEnum.Subtotal2];
                break;

            case 3:
                m_fg.Rows[v_i_root_row].Style = m_fg.Styles[CellStyleEnum.Subtotal3];
                break;
            }
            insert_all_child_of_node(v_i_root_row, m_v_ds);
            load_custom_source_2_m_txt_search();
            m_fg.Redraw = true;
            set_search_format_before();
            /*Đếm số dòng dữ liệu trên Grid*/
            m_lbl_so_luong_ban_ghi.Text = m_v_ds.V_DM_DON_VI.Count.ToString();
        }
Example #2
0
        private bool trung_ma_don_vi(string ip_str_ma_don_vi)
        {
            var v_ds = new DS_V_DM_DON_VI();
            var v_us = new US_V_DM_DON_VI();

            v_us.FillDatasetByKeyWord(v_ds, ip_str_ma_don_vi, -1, -1, "", CAppContext_201.getCurrentIDPhapnhan());
            decimal v_count = v_ds.V_DM_DON_VI.Count;

            if (v_count > 0)
            {
                return(true);
            }
            return(false);
        }
        private void tao_dong_don_vi_grid_don_vi()
        {
            DS_V_DM_DON_VI v_ds_v_dm_don_vi = new DS_V_DM_DON_VI();
            US_V_DM_DON_VI v_us_v_dm_don_vi = new US_V_DM_DON_VI();

            v_us_v_dm_don_vi.FillDatasetByKeyWord(v_ds_v_dm_don_vi, "Y", CAppContext_201.getCurrentIDPhapnhan());
            int v_minID_LEVEL = int.Parse(v_ds_v_dm_don_vi.V_DM_DON_VI.Compute("Min(ID_LEVEL)", "").ToString());

            DataRow[] v_dr = v_ds_v_dm_don_vi.V_DM_DON_VI.Select(V_DM_DON_VI.ID_LEVEL + "=" + v_minID_LEVEL.ToString());
            if (v_dr.Length == 0)
            {
                return;
            }
            CGridUtils.ClearDataInGrid(m_fg_donvi);
            v_us_v_dm_don_vi.DataRow2Me(v_dr[0]);
            m_fg_donvi.Rows.Count += 1;
            int v_i_root_row = m_fg_donvi.Rows.Count - 1;

            //m_fg.Rows.Count = m_ds_1.V_DM_DON_VI.Rows.Count + 1;
            //int v_i_root_row = 1;
            m_fg_donvi.Rows[v_i_root_row].IsNode     = true;
            m_fg_donvi.Rows[v_i_root_row].Node.Level = int.Parse(v_us_v_dm_don_vi.dcID_LEVEL.ToString());
            switch (m_fg_donvi.Rows[v_i_root_row].Node.Level)
            {
            case 0:
                m_fg_donvi.Rows[v_i_root_row].Style = m_fg_donvi.Styles[CellStyleEnum.Subtotal0];
                break;

            case 1:
                m_fg_donvi.Rows[v_i_root_row].Style = m_fg_donvi.Styles[CellStyleEnum.Subtotal1];
                break;

            case 2:
                m_fg_donvi.Rows[v_i_root_row].Style = m_fg_donvi.Styles[CellStyleEnum.Subtotal2];
                break;

            case 3:
                m_fg_donvi.Rows[v_i_root_row].Style = m_fg_donvi.Styles[CellStyleEnum.Subtotal3];
                break;
            }
            m_fg_donvi.Rows[1][1]       = v_us_v_dm_don_vi.strMA_DON_VI_CAP_TREN;
            m_fg_donvi.Rows[1][2]       = v_us_v_dm_don_vi.strMA_DON_VI;
            m_fg_donvi.Rows[1].UserData = v_us_v_dm_don_vi.dcID;
            insert_all_child_of_node(v_i_root_row, v_ds_v_dm_don_vi);
        }