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_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; }