private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DON_HANG_SO_DIEU_PHOI_LAI");
pivotGridControl1.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_GD_CUOC_GOI_YEU_CAU");
m_grc_cuoc_goi.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_GD_DIEU_PHOI_LAI");
m_grc_ds_dieu_phoi_lai.DataSource = v_ds.Tables[0];
}
private void load_data_griv()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_HT_NGUOI_SU_DUNG");
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DON_HANG_NGUOI_XU_LY_DICH_VU_TRANG_THAI_DON_HANG");
pivotGridControl1.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_GD_DA_NHAN_XU_LY");
m_grc_xac_nhan_don_hang.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_TINH_HINH_DANH_GIA");
pivotGridControl1.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new System.Data.DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_KHOA");
m_grc_dm_khoa.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_GD_CAN_XU_LY");
m_grc_ds_don_hang_can_tiep_nhan.DataSource = v_ds.Tables[0];
m_grv_ds_don_hang_can_tiep_nhan.ActiveFilterString = "[ID_NGUOI_NHAN_THAO_TAC]= 69761";
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_GD_CUOC_GOI_YEU_CAU");
m_grc_cuoc_goi.DataSource = v_ds.Tables[0];
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_GIANG_VIEN");
m_grc_dm_giang_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DON_HANG_SO_DIEU_PHOI_LAI");
pivotGridControl1.DataSource = v_ds.Tables[0];
}
private void load_data_griv()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_HT_NGUOI_SU_DUNG");
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOAI_NGAY_CONG");
m_grc_dm_loai_ngay_cong.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
m_ds = new DataSet();
m_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(m_ds, "V_TONG_QUAN");
m_grc.DataSource = m_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();//Khai báo US
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithTableName(v_ds, "V_GD_CHUNG_CHI");
m_grc.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOP_SINH_VIEN");
m_grc_dm_lop_sinh_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_GIANG_VIEN");
m_grc_dm_giang_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_ds.EnforceConstraints = false;
v_us.FillDatasetWithTableName(v_ds, "V_GD_HOC_VIEN_LOP_HOC where id_lop_mon = " + m_dc_id_lop_mon.ToString() + " or " + m_dc_id_lop_mon.ToString() + " = -1");
m_grc.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new System.Data.DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_KHOA");
m_grc_dm_khoa.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOP_SINH_VIEN");
m_grc_dm_lop_sinh_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_CAN_PM_DANH_GIA");
// v_us.FillDatasetWithQuery(v_ds, " select * from V_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH WHERE ID_NHOM = 2");
m_grc_danh_sach_can_phe_duyet_PM.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_USER_NAME");
v_ds.Tables[0].Rows[0].Delete();
m_grc_user_name.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[1]);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_CAN_PM_DANH_GIA");
// v_us.FillDatasetWithQuery(v_ds, " select * from V_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH WHERE ID_NHOM = 2");
m_grc_danh_sach_can_phe_duyet_PM.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();//Khai báo US
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithTableName(v_ds, "V_DM_CAU_HOI");
m_grc.DataSource = v_ds.Tables[0];
m_grv.ExpandAllGroups();
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); //Khai báo US
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithTableName(v_ds, "V_GD_DAT_HANG");
m_grc.DataSource = v_ds.Tables[0];
m_grv.ExpandAllGroups();
}
private void f128_danh_sach_dich_vu_Load(object sender, EventArgs e)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
if ((us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(11, us_user.dcID) != 0) || (us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(11, us_user.dcID) != 0))
{
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOAI_YEU_CAU");
}
else
{
v_us.FillDatasetWithQuery(v_ds, "SELECT dmyc.* FROM HT_BO_DICH_VU,V_DM_LOAI_YEU_CAU AS dmyc WHERE dmyc.ID =HT_BO_DICH_VU.ID_DICH_VU AND HT_BO_DICH_VU.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString());
}
m_grc_dich_vu.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
try
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_HOC_PHAN");
m_grc_dm_hoc_phan.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
catch
{
MessageBox.Show("Đã xảy ra lỗi trong hệ thống!");
}
}
private void load_data_2_grid()
{
try
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_HOC_PHAN");
m_grc_dm_hoc_phan.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[0]);
}
catch
{
MessageBox.Show("Đã xảy ra lỗi trong hệ thống!");
}
}
private void load_data_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_CAU_HOI");
m_grc_dm_cau_hoi.DataSource = v_ds.Tables[0];
if (us_user.dcIDNhom == 1)
{
m_pan_xoa.Visible = false;
}
else
{
m_pan_xoa.Visible = true;
m_grv_dm_cau_hoi.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
}
}
private void load_data_griv()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOAI_YEU_CAU");
m_grc_dm_loai_yeu_cau.DataSource = v_ds.Tables[0];
if(us_user.dcIDNhom == 5)
{
}
else
{
m_pan_button.Visible = false;
m_grv_dm_loai_yeu_cau.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
}
}
private void load_data_griv()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_LOAI_YEU_CAU");
m_grc_dm_loai_yeu_cau.DataSource = v_ds.Tables[0];
if (us_user.dcIDNhom == 5)
{
}
else
{
m_pan_button.Visible = false;
m_grv_dm_loai_yeu_cau.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
}
}
private void load_data_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_CAU_HOI");
m_grc_dm_cau_hoi.DataSource = v_ds.Tables[0];
if (us_user.dcIDNhom == 1)
{
m_pan_xoa.Visible = false;
}
else
{
m_pan_xoa.Visible = true;
m_grv_dm_cau_hoi.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
}
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DON_HANG_NGUOI_XU_LY_DICH_VU_TRANG_THAI_DON_HANG");
pivotGridControl1.DataSource = v_ds.Tables[0];
Series series1 = new Series("Series 1", ViewType.SideBySideStackedBar);
Series series2 = new Series("Series 2", ViewType.SideBySideStackedBar);
Series series3 = new Series("Series 3", ViewType.SideBySideStackedBar);
Series series4 = new Series("Series 4", ViewType.SideBySideStackedBar);
Series series5 = new Series("Series 4", ViewType.SideBySideStackedBar);
Series series6 = new Series("Series 4", ViewType.SideBySideStackedBar);
Series series7 = new Series("Series 4", ViewType.SideBySideStackedBar);
Series series8 = new Series("Series 4", ViewType.SideBySideStackedBar);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_USER_NAME");
v_ds.Tables[0].Rows[0].Delete();
m_grc_user_name.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[1]);
}
public void load_data_2_grid()
{
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_BAO_CAO_TONG");
pivotGridControl1.DataSource = v_ds.Tables[0];
}
private void fill_data_2_grid_thue_thang()
{
US_DUNG_CHUNG v_us_dung_chung = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
v_us_dung_chung.FillDatasetWithTableName(v_ds, "V_DM_NHAN_VIEN_2");
v_ds.Tables[0].Columns.Add("TRUY_LINH");
v_ds.Tables[0].Columns.Add("TRUY_THU");
v_ds.Tables[0].Columns.Add("THUC_LINH_CUOI_CUNG");
//v_ds.Tables[0].Columns.Add("PHAN_TRAM_THUE");
//foreach(DataRow v_dr in v_ds.Tables[0].Rows)
//{
// v_dr["PHAN_TRAM_THUE"] = 10;
//}
m_grc_main.DataSource = v_ds.Tables[0];
CHRMCommon.make_stt_indicator(m_grv_main);
}