private void load_data_2_grid()
{
m_us_1.FillDataset(m_ds_1);
v_us_dm_tu_dien.FillDataset(v_ds_dm_tu_dien, "WHERE Id_loai_tu_dien = 5 AND ID <> 655");
//1.tạo danh sách cột chức vụ
m_fg.Cols.Count = m_ds_1.DM_CHUC_VU.Rows.Count + 2;
m_fg.Cols[0].Width = 150;
//m_fg.Cols[1].Caption = "Trạng thái/Chức vụ";
m_fg.Cols[1].Caption = "Tổng";
m_fg.Cols[1].UserData = 0;
//m_fg.Cols[1].Style.ForeColor = Color.Black;
for (int i = 2; i < m_fg.Cols.Count; i++)
{
m_fg.Cols[i].Caption = m_ds_1.DM_CHUC_VU.Rows[i - 2][1].ToString();
m_fg.Cols[i].UserData = m_ds_1.DM_CHUC_VU.Rows[i - 2][0];
}
//2. tạo danh sách dòng trạng thái
m_fg.Rows.Count = v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count + 1;
//m_fg.Rows[1][0] = "Tổng";
//m_fg.Rows[1].UserData = 0;
for (int j = 1; j < m_fg.Rows.Count; j++)
{
m_fg.Rows[j][0] = v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows[j - 1][3].ToString();
m_fg.Rows[j].UserData = v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows[j - 1][0];
}
//3.Đưa dữ liệu lên lưới
m_ds_rpt = new DS_RPT_CHUC_VU_TRANG_THAI();
m_us_rpt.FillDatasetByProc(m_ds_rpt, m_dat_thoidiem.Value, CAppContext_201.getCurrentIDPhapnhan());
for (int v_i_cur_col = m_fg.Cols.Fixed; v_i_cur_col < m_fg.Cols.Count; v_i_cur_col++)
{
//if((int.Parse(row[1].ToString())) == (int.Parse(m_fg.Cols[u].UserData.ToString())))
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
string v_str_id_chuc_vu = m_fg.Cols[v_i_cur_col].UserData.ToString();
string v_str_id_trang_thai = m_fg.Rows[v_i_cur_row].UserData.ToString();
DataRow[] v_arr_dr
= m_ds_rpt.RPT_CHUC_VU_TRANG_THAI.Select(
RPT_CHUC_VU_TRANG_THAI.ID_CV + "="
+ v_str_id_chuc_vu
+ " AND "
+ RPT_CHUC_VU_TRANG_THAI.ID_TRANG_THAI + "="
+ v_str_id_trang_thai);
if (v_arr_dr.Length == 0)
{
continue;
}
m_fg[v_i_cur_row, v_i_cur_col] = v_arr_dr[0][RPT_CHUC_VU_TRANG_THAI.SO_LUONG];
}
}
for (int v = 1; v < m_fg.Rows.Count; v++)
{
int sum = 0;
for (int t = 2; t < m_fg.Cols.Count; t++)
{
sum += Convert.ToInt32(m_fg.Rows[v][t]);
}
m_fg.Rows[v][1] = sum;
}
m_fg.SubtotalPosition = SubtotalPositionEnum.BelowData;
m_fg.Tree.Column = 0;
m_fg.Tree.Style = TreeStyleFlags.Simple;
m_fg.Subtotal(AggregateEnum.Clear);
for (int u = 1; u < m_fg.Cols.Count; u++)
{
m_fg.Subtotal(AggregateEnum.Sum, -1, -1, u, "Tổng");
}
m_fg.AutoSizeCols();
WinFormControls.load_data_to_CheckboxCombobox(m_fg, m_cbc_choose_columns, load_invisible);
}
