private void load_data_2_grid()
{
US_HT_PHAN_QUYEN_HE_THONG v_us_phan_quyen = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds_phan_quyen = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us_phan_quyen.FillDataset(v_ds_phan_quyen);
CGridUtils.Dataset2C1Grid(v_ds_phan_quyen, m_fg, m_obj_trans);
US_HT_PHAN_QUYEN_CHO_NHOM v_us_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
DS_HT_PHAN_QUYEN_CHO_NHOM v_ds_phan_quyen_cho_nhom = new DS_HT_PHAN_QUYEN_CHO_NHOM();
v_us_phan_quyen_cho_nhom.FillDatasetByGroupUserID(m_us_group.dcID, v_ds_phan_quyen_cho_nhom);
//set not null quyen user
for (int v_i_cur = m_fg.Rows.Fixed; v_i_cur < m_fg.Rows.Count; v_i_cur++)
{
m_fg[v_i_cur, (int)e_col_number.LA_QUYEN_USER] = false;
}
//set quyen
foreach (DataRow v_dr in v_ds_phan_quyen_cho_nhom.HT_PHAN_QUYEN_CHO_NHOM.Rows)
{
for (int v_i_cur = m_fg.Rows.Fixed; v_i_cur < m_fg.Rows.Count; v_i_cur++)
{
if ((decimal)m_fg[v_i_cur, (int)e_col_number.ID_QUYEN]
== (decimal)v_dr[HT_PHAN_QUYEN_CHO_NHOM.ID_PHAN_QUYEN_HE_THONG])
{
m_fg[v_i_cur, (int)e_col_number.LA_QUYEN_USER] = true;
}
}
}
}
public void FillDatasetByMaPhanQuyen(DS_HT_PHAN_QUYEN_HE_THONG op_ds, string ip_str)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_select_by_ma_pq");
v_stored_proc.addNVarcharInputParam("@MA_PHAN_QUYEN", ip_str);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetQuyenDaCapByIdUserGroup(DS_HT_PHAN_QUYEN_HE_THONG op_ds, decimal ip_dc_id)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_quyen_da_cap_select_by_id_nhom_quyen");
v_stored_proc.addDecimalInputParam("@ID_USER_GROUP", ip_dc_id);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
m_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
private void load_data_2_cbo_nhom_quyen()
{
US_HT_PHAN_QUYEN_HE_THONG v_us = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us.FillDataset(v_ds);
m_cbo_nhom_quyen.DataSource = v_ds.Tables[0];
m_cbo_nhom_quyen.ValueMember = HT_PHAN_QUYEN_HE_THONG.ID;
m_cbo_nhom_quyen.DisplayMember = HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN;
}
private void load_data_2_cbo_nhom_quyen()
{
US_HT_PHAN_QUYEN_HE_THONG v_us = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us.FillDataset(v_ds);
m_cbo_nhom_quyen.DataSource = v_ds.Tables[0];
m_cbo_nhom_quyen.ValueMember = HT_PHAN_QUYEN_HE_THONG.ID;
m_cbo_nhom_quyen.DisplayMember = HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN;
}
public US_HT_PHAN_QUYEN_HE_THONG(decimal i_dbID)
{
pm_objDS = new DS_HT_PHAN_QUYEN_HE_THONG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private ITransferDataRow get_trans_object(C1.Win.C1FlexGrid.C1FlexGrid i_fg)
{
Hashtable v_htb = new Hashtable();
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.ID, e_col_number.ID_QUYEN);
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.GHI_CHU, e_col_number.TEN_QUYEN);
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN, e_col_number.MA_QUYEN);
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
ITransferDataRow v_obj_trans = new CC1TransferDataRow(i_fg, v_htb, v_ds.HT_PHAN_QUYEN_HE_THONG.NewRow());
return(v_obj_trans);
}
private void m_cmd_save_Click(object sender, EventArgs e)
{
try
{
US_HT_PHAN_QUYEN_CHO_NHOM v_us_ht_phan_quyen_cho_nhom;
DS_HT_PHAN_QUYEN_CHO_NHOM v_ds_ht_phan_quyen_cho_nhom = new DS_HT_PHAN_QUYEN_CHO_NHOM();
collection v_coll_new = new collection(m_lbox_quyen_da_cap.Items.Count);
for (int i = 0; i < m_lbox_quyen_da_cap.Items.Count; i++)
{
v_coll_new.insert(m_lbox_quyen_da_cap.Items[i].ToString());
}
US_HT_PHAN_QUYEN_HE_THONG v_us_pqht = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds_pqht = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us_pqht.FillDatasetQuyenDaCapByIdUserGroup(v_ds_pqht, m_dc_id_user_group);
collection v_coll_old = new collection(v_ds_pqht.Tables[0].Rows.Count);
for (int i = 0; i < v_ds_pqht.Tables[0].Rows.Count; i++)
{
DataRow v_dr = v_ds_pqht.Tables[0].Rows[i];
v_coll_old.insert(v_dr[HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN].ToString());
}
collection v_coll_quyen_insert = new collection(v_coll_new.countInANotInB(v_coll_old));
v_coll_quyen_insert = v_coll_new.InANotInB(v_coll_old);
for (int i = 0; i < v_coll_quyen_insert.getIndex(); i++)
{
v_us_ht_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
v_us_ht_phan_quyen_cho_nhom.dcID_USER_GROUP = m_dc_id_user_group;
v_ds_pqht.Clear();
v_us_pqht.FillDatasetByMaPhanQuyen(v_ds_pqht, v_coll_quyen_insert.s[i]);
v_us_ht_phan_quyen_cho_nhom.dcID_PHAN_QUYEN_HE_THONG = CIPConvert.ToDecimal(v_ds_pqht.Tables[0].Rows[0][HT_PHAN_QUYEN_HE_THONG.ID]);
v_us_ht_phan_quyen_cho_nhom.Insert();
}
collection v_coll_quyen_delete = new collection(v_coll_new.countNotInAInB(v_coll_old));
v_coll_quyen_delete = v_coll_new.NotInAInB(v_coll_old);
for (int i = 0; i < v_coll_quyen_delete.getIndex(); i++)
{
v_ds_ht_phan_quyen_cho_nhom.Clear();
v_us_ht_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
v_us_ht_phan_quyen_cho_nhom.FillDatasetByIdUserGroupAndMaPhanQuyen(v_ds_ht_phan_quyen_cho_nhom, m_dc_id_user_group, v_coll_quyen_delete.s[i]);
v_us_ht_phan_quyen_cho_nhom.dcID = CIPConvert.ToDecimal(v_ds_ht_phan_quyen_cho_nhom.Tables[0].Rows[0][HT_PHAN_QUYEN_CHO_NHOM.ID]);
v_us_ht_phan_quyen_cho_nhom.Delete();
}
BaseMessages.MsgBox_Infor("Dữ liệu đã được cập nhật");
this.Close();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
public US_HT_PHAN_QUYEN_HE_THONG(decimal i_dbID)
{
pm_objDS = new DS_HT_PHAN_QUYEN_HE_THONG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_data_2_rtxt_quyen_chua_cap(decimal ip_dc_id)
{
US_HT_PHAN_QUYEN_HE_THONG v_us = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us.FillDatasetQuyenChuaCapByIdUserGroup(v_ds, ip_dc_id);
int v_row_count = v_ds.Tables[0].Rows.Count;
m_lbox_quyen_chua_cap.Items.Clear();
for (int i = 0; i < v_row_count; i++)
{
DataRow v_dr = v_ds.Tables[0].Rows[i];
m_lbox_quyen_chua_cap.Items.Add(v_dr[HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN]);
}
}
private void load_data_2_rtxt_quyen_da_cap(decimal ip_dc_id)
{
US_HT_PHAN_QUYEN_HE_THONG v_us = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us.FillDatasetQuyenDaCapByIdUserGroup(v_ds, ip_dc_id);
int v_row_count = v_ds.Tables[0].Rows.Count;
m_lbox_quyen_da_cap.Items.Clear();
for (int i = 0; i < v_row_count; i++)
{
DataRow v_dr = v_ds.Tables[0].Rows[i];
m_lbox_quyen_da_cap.Items.Add(v_dr[HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN]);
}
}
public void FillDatasetByMaPhanQuyen(DS_HT_PHAN_QUYEN_HE_THONG op_ds, string ip_str)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_select_by_ma_pq");
v_stored_proc.addNVarcharInputParam("@MA_PHAN_QUYEN", ip_str);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
private void m_cmd_save_Click(object sender, EventArgs e)
{
try
{
US_HT_PHAN_QUYEN_CHO_NHOM v_us_ht_phan_quyen_cho_nhom;
DS_HT_PHAN_QUYEN_CHO_NHOM v_ds_ht_phan_quyen_cho_nhom = new DS_HT_PHAN_QUYEN_CHO_NHOM();
CCollection v_coll_new = new CCollection(m_lbox_quyen_da_cap.Items.Count);
for (int i = 0; i < m_lbox_quyen_da_cap.Items.Count; i++)
{
v_coll_new.insert(m_lbox_quyen_da_cap.Items[i].ToString());
}
US_HT_PHAN_QUYEN_HE_THONG v_us_pqht = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds_pqht = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us_pqht.FillDatasetQuyenDaCapByIdUserGroup(v_ds_pqht, m_dc_id_user_group);
CCollection v_coll_old = new CCollection(v_ds_pqht.Tables[0].Rows.Count);
for (int i = 0; i < v_ds_pqht.Tables[0].Rows.Count; i++)
{
DataRow v_dr = v_ds_pqht.Tables[0].Rows[i];
v_coll_old.insert(v_dr[HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN].ToString());
}
CCollection v_coll_quyen_insert = new CCollection(v_coll_new.countInANotInB(v_coll_old));
v_coll_quyen_insert = v_coll_new.InANotInB(v_coll_old);
for (int i = 0; i < v_coll_quyen_insert.getIndex(); i++)
{
v_us_ht_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
//v_us_ht_phan_quyen_cho_nhom.dcID_USER_GROUP = 1;
v_us_ht_phan_quyen_cho_nhom.dcID_USER_GROUP = m_dc_id_user_group;
v_ds_pqht.Clear();
v_us_pqht.FillDatasetByMaPhanQuyen(v_ds_pqht, v_coll_quyen_insert.s[i]);
v_us_ht_phan_quyen_cho_nhom.dcID_PHAN_QUYEN_HE_THONG = CIPConvert.ToDecimal(v_ds_pqht.Tables[0].Rows[0][HT_PHAN_QUYEN_HE_THONG.ID]);
v_us_ht_phan_quyen_cho_nhom.Insert();
}
CCollection v_coll_quyen_delete = new CCollection(v_coll_new.countNotInAInB(v_coll_old));
v_coll_quyen_delete = v_coll_new.NotInAInB(v_coll_old);
for (int i = 0; i < v_coll_quyen_delete.getIndex(); i++)
{
v_ds_ht_phan_quyen_cho_nhom.Clear();
v_us_ht_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
v_us_ht_phan_quyen_cho_nhom.FillDatasetByIdUserGroupAndMaPhanQuyen(v_ds_ht_phan_quyen_cho_nhom, m_dc_id_user_group, v_coll_quyen_delete.s[i]);
v_us_ht_phan_quyen_cho_nhom.dcID = CIPConvert.ToDecimal(v_ds_ht_phan_quyen_cho_nhom.Tables[0].Rows[0][HT_PHAN_QUYEN_CHO_NHOM.ID]);
v_us_ht_phan_quyen_cho_nhom.Delete();
}
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
//this.Close();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void load_data_2_grid()
{
m_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
private ITransferDataRow get_trans_object(C1.Win.C1FlexGrid.C1FlexGrid i_fg)
{
Hashtable v_htb = new Hashtable();
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.ID, e_col_number.ID_QUYEN);
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.GHI_CHU, e_col_number.TEN_QUYEN);
v_htb.Add(HT_PHAN_QUYEN_HE_THONG.MA_PHAN_QUYEN, e_col_number.MA_QUYEN);
DS_HT_PHAN_QUYEN_HE_THONG v_ds = new DS_HT_PHAN_QUYEN_HE_THONG();
ITransferDataRow v_obj_trans = new CC1TransferDataRow(i_fg, v_htb, v_ds.HT_PHAN_QUYEN_HE_THONG.NewRow());
return v_obj_trans;
}
private void load_data_2_grid()
{
US_HT_PHAN_QUYEN_HE_THONG v_us_phan_quyen = new US_HT_PHAN_QUYEN_HE_THONG();
DS_HT_PHAN_QUYEN_HE_THONG v_ds_phan_quyen = new DS_HT_PHAN_QUYEN_HE_THONG();
v_us_phan_quyen.FillDataset(v_ds_phan_quyen);
CGridUtils.Dataset2C1Grid(v_ds_phan_quyen, m_fg, m_obj_trans);
US_HT_PHAN_QUYEN_CHO_NHOM v_us_phan_quyen_cho_nhom = new US_HT_PHAN_QUYEN_CHO_NHOM();
DS_HT_PHAN_QUYEN_CHO_NHOM v_ds_phan_quyen_cho_nhom = new DS_HT_PHAN_QUYEN_CHO_NHOM();
v_us_phan_quyen_cho_nhom.FillDatasetByGroupUserID(m_us_group.dcID, v_ds_phan_quyen_cho_nhom);
//set not null quyen user
for (int v_i_cur = m_fg.Rows.Fixed; v_i_cur < m_fg.Rows.Count; v_i_cur++)
{
m_fg[v_i_cur, (int)e_col_number.LA_QUYEN_USER] = false;
}
//set quyen
foreach (DataRow v_dr in v_ds_phan_quyen_cho_nhom.HT_PHAN_QUYEN_CHO_NHOM.Rows)
{
for (int v_i_cur = m_fg.Rows.Fixed; v_i_cur < m_fg.Rows.Count; v_i_cur++)
{
if ((decimal)m_fg[v_i_cur, (int)e_col_number.ID_QUYEN]
== (decimal)v_dr[HT_PHAN_QUYEN_CHO_NHOM.ID_PHAN_QUYEN_HE_THONG])
{
m_fg[v_i_cur, (int)e_col_number.LA_QUYEN_USER] = true;
}
}
}
}
public US_HT_PHAN_QUYEN_HE_THONG()
{
pm_objDS = new DS_HT_PHAN_QUYEN_HE_THONG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public US_HT_PHAN_QUYEN_HE_THONG()
{
pm_objDS = new DS_HT_PHAN_QUYEN_HE_THONG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetQuyenDaCapByIdUserGroup(DS_HT_PHAN_QUYEN_HE_THONG op_ds, decimal ip_dc_id)
{
CStoredProc v_stored_proc = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_quyen_da_cap_select_by_id_nhom_quyen");
v_stored_proc.addDecimalInputParam("@ID_USER_GROUP", ip_dc_id);
v_stored_proc.fillDataSetByCommand(this, op_ds);
}
