private bool check_trung_tam(decimal ip_id_trung_tam, decimal ip_id_phap_nhan)
{
US_V_DM_PHONG_BAN_PHAP_NHAN v_us = new US_V_DM_PHONG_BAN_PHAP_NHAN();
DS_V_DM_PHONG_BAN_PHAP_NHAN v_ds = new DS_V_DM_PHONG_BAN_PHAP_NHAN();
v_us.FillDataset(v_ds, "where id_phong_ban=" + ip_id_trung_tam + "and id_phap_nhan =" + ip_id_phap_nhan);
if (v_ds.Tables[0].Rows.Count != 0)
return false;
else
return true;
}
private void load_cbo_trung_tam()
{
US_V_DM_PHONG_BAN_PHAP_NHAN v_us = new US_V_DM_PHONG_BAN_PHAP_NHAN();
DS_V_DM_PHONG_BAN_PHAP_NHAN v_ds = new DS_V_DM_PHONG_BAN_PHAP_NHAN();
decimal v_id_phap_nhan = CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue);
if (v_id_phap_nhan == -1)
{
v_us.FillDataset(v_ds);
}
else
{
v_us.FillDataset(v_ds, "where id_phap_nhan=" + v_id_phap_nhan);
}
m_cbo_trung_tam.DataSource = v_ds.v_DM_PHONG_BAN_PHAP_NHAN;
m_cbo_trung_tam.ValueMember = V_DM_PHONG_BAN_PHAP_NHAN.ID_PHONG_BAN;
m_cbo_trung_tam.DisplayMember = V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHONG_BAN;
DataRow v_dr = v_ds.v_DM_PHONG_BAN_PHAP_NHAN.NewRow();
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID_PHAP_NHAN] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID_PHONG_BAN] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.MA_PHAP_NHAN] = "";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHAP_NHAN] = "Tất cả";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHONG_BAN] = "Tất cả";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.MA_PHONG_BAN] = "";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TY_TRONG] = 100;
v_ds.v_DM_PHONG_BAN_PHAP_NHAN.Rows.InsertAt(v_dr, 0);
m_cbo_trung_tam.SelectedIndex = 0;
}
private void load_data_nguoi_nhan_ban_luu()
{
try
{
US_V_DM_PHONG_BAN_PHAP_NHAN v_us_dm_phong_ban = new US_V_DM_PHONG_BAN_PHAP_NHAN();
DS_V_DM_PHONG_BAN_PHAP_NHAN v_ds_dm_phong_ban = new DS_V_DM_PHONG_BAN_PHAP_NHAN();
m_cbx_ban_luu.DisplayMember = V_DM_PHONG_BAN_PHAP_NHAN.MA_PHONG_BAN;
m_cbx_ban_luu.ValueMember = V_DM_PHONG_BAN_PHAP_NHAN.ID_PHONG_BAN;
US_DM_PHAP_NHAN v_us_dm_phap_nhan = new US_DM_PHAP_NHAN(CIPConvert.ToDecimal(m_cbx_phap_nhan.SelectedValue));
if (v_us_dm_phap_nhan.strMA_PHAP_NHAN == "TPE" )
{
v_us_dm_phong_ban.FillDataset(v_ds_dm_phong_ban, "where id_phap_nhan=" +m_cbx_phap_nhan.SelectedValue + " order by ma_phong_ban");//5 la id EDT
m_cbx_ban_luu.DataSource = v_ds_dm_phong_ban.v_DM_PHONG_BAN_PHAP_NHAN;
}
else
{
v_us_dm_phong_ban.FillDataset(v_ds_dm_phong_ban, "where id_phap_nhan=5 order by ma_phong_ban");//5 la id EDT
m_cbx_ban_luu.DataSource = v_ds_dm_phong_ban.v_DM_PHONG_BAN_PHAP_NHAN;
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}