private void load_danh_sach_don_vi()
{
US_DM_DON_VI v_us = new US_DM_DON_VI();
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
v_us.FillDataset(v_ds, "order by SO_THU_TU");
m_sle_chon_don_vi.Properties.DataSource = v_ds.Tables[0];
}
//check validate data
private bool check_ma_don_vi_is_exist()
{
US_DM_DON_VI v_us = new US_DM_DON_VI();
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
v_us.FillDataset(v_ds, "where ma_don_vi = N'" + m_txt_ma_dv.Text + "'");
if (m_txt_ma_dv.Text != m_us_dm_dv.strMA_DON_VI && v_ds.Tables[0].Rows.Count !=0)
{
return true;
}
return false;
}
private void load_data_2_tree()
{
US_DM_DON_VI v_us_dv = new US_DM_DON_VI();
DS_DM_DON_VI v_ds_dv = new DS_DM_DON_VI();
v_us_dv.FillDataset(v_ds_dv);
m_tree_don_vi.ParentFieldName = DM_DON_VI.ID_DON_VI_CAP_TREN;
m_tree_don_vi.DataSource = v_ds_dv.Tables[0];
m_tree_don_vi.RefreshDataSource();
m_tree_don_vi.ExpandAll();
}
private void load_data_to_sle_don_vi()
{
US_DM_DON_VI v_us = new US_DM_DON_VI();
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
v_us.FillDataset(v_ds);
m_sle_don_vi.Properties.DataSource = v_ds.Tables[0];
m_sle_don_vi.Properties.DisplayMember = DM_DON_VI.TEN_DON_VI;
m_sle_don_vi.Properties.ValueMember = DM_DON_VI.ID;
//m_sle_don_vi.Properties.NullText = "---Chọn đơn vị---";
}
private DataTable load_data_to_don_vi()
{
US_DM_DON_VI v_us = new US_DM_DON_VI();
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
v_us.FillDataset(v_ds);
return v_ds.Tables[0];
}
private DataSet load_data_2_ds_v_dm_don_vi()
{
US_DM_DON_VI v_us = new US_DM_DON_VI();
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
v_us.FillDataset(v_ds);
return v_ds;
}
private DS_DM_DON_VI load_data_2_dm_loai_don_vi()
{
DS_DM_DON_VI v_ds = new DS_DM_DON_VI();
US_DM_DON_VI v_us = new US_DM_DON_VI();
v_us.FillDataset(v_ds);
return v_ds;
}
