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; }
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); } }
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]); } }
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 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; }
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(); }