private void load_data_2_grid(decimal m_id_dich_vu)
{
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");
v_us.FillDatasetWithQuery(v_ds, " select distinct ID_BO, BO from V_DICH_VU_BO_PM_TD where ID_DICH_VU=" + m_id_dich_vu);
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
Color.AliceBlue.ToArgb();
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, m_id_dich_vu);
v_us.FillResourcesByDichVu(v_ds_resource, m_id_dich_vu);
SetUpMapping();
schedulerStorage1.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage1.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Timeline;
m_sch.GroupType = SchedulerGroupType.Resource;
m_sch.Start = System.DateTime.Now;
}
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());
m_lst_BO_da_duoc_dieu_phoi = new List <decimal>();
lay_ds_BO_da_dc_dieu_phoi(m_lst_BO_da_duoc_dieu_phoi);
string m_str_query = " select distinct ID_BO,BO from V_DICH_VU_BO_PM_TD where ID_DICH_VU = " + m_us.dcID_NHOM_DV_YEU_CAU.ToString() + " And ID_BO not in ( ";
if (m_lst_BO_da_duoc_dieu_phoi.Count == 0)
{
m_str_query += "0 )";
}
for (int i = 0; i < m_lst_BO_da_duoc_dieu_phoi.Count; i++)
{
if (i < m_lst_BO_da_duoc_dieu_phoi.Count - 1)
{
m_str_query += m_lst_BO_da_duoc_dieu_phoi[i].ToString() + ",";
}
else
{
m_str_query += m_lst_BO_da_duoc_dieu_phoi[i].ToString() + ")";
}
}
v_us.FillDatasetWithQuery(v_ds, m_str_query);
m_grc_ds_BO.DataSource = v_ds.Tables[0];
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, m_us.dcID_NHOM_DV_YEU_CAU);
v_us.FillResourcesByDichVu(v_ds_resource, m_us.dcID_NHOM_DV_YEU_CAU);
SetUpMapping();
schedulerStorage1.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage1.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Day;
m_sch.GroupType = SchedulerGroupType.Resource;
}
private void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, id_dich_vu);
v_us.FillResourcesByDichVu(v_ds_resource, id_dich_vu);
schedulerStorage.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Day;
m_sch.GroupType = SchedulerGroupType.Resource;
}
private void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, id_dich_vu);
v_us.FillResourcesByDichVu(v_ds_resource, id_dich_vu);
schedulerStorage.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Day;
m_sch.GroupType = SchedulerGroupType.Resource;
}
private void load_data_2_grid(decimal m_id_dich_vu)
{
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");
v_us.FillDatasetWithQuery(v_ds, " select distinct ID_BO, BO from V_DICH_VU_BO_PM_TD where ID_DICH_VU=" + m_id_dich_vu);
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
Color.AliceBlue.ToArgb();
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, m_id_dich_vu);
v_us.FillResourcesByDichVu(v_ds_resource, m_id_dich_vu);
SetUpMapping();
schedulerStorage1.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage1.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Day;
m_sch.GroupType = SchedulerGroupType.Resource;
}
