Exemplo n.º 1
0
        public BindingList<PhanQuyenDTO> LayDanhSach()
        {
            BindingList<PhanQuyenDTO> danhSach = new BindingList<PhanQuyenDTO>();
            OleDbConnection cn;
            cn = DataProvider.KetNoi();
            string strSQL;
            strSQL = "Select * From SysDanhMucPhanQuyen";
            OleDbCommand cmd = new OleDbCommand(strSQL, cn);
            OleDbDataReader dr;
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                PhanQuyenDTO itemDTO = new PhanQuyenDTO();

                itemDTO.Id = (int)dr["Id"];
                itemDTO.IdNguoiDung = (int)dr["IdNguoiDung"];
                itemDTO.IdChucNang = (int)dr["IdChucNang"];
                itemDTO.IdPhanHe = (int)dr["IdPhanHe"];
                itemDTO.Doc = (bool)dr["Doc"];
                itemDTO.Them = (bool)dr["Them"];
                itemDTO.Sua = (bool)dr["Sua"];
                itemDTO.Xoa = (bool)dr["Xoa"];

                danhSach.Add(itemDTO);
            }
            return danhSach;
        }
Exemplo n.º 2
0
        public void Sua(PhanQuyenDTO itemDTO)
        {
            OleDbConnection cn;
            cn = DataProvider.KetNoi();

            string strSQL;
            strSQL = "Update SysDanhMucPhanQuyen Set Doc = ?, Them = ?, Sua = ?, Xoa = ? Where Id = ?";

            OleDbCommand cmd = new OleDbCommand(strSQL, cn);
            cmd.Parameters.Add("@Doc", OleDbType.Boolean).Value = itemDTO.Doc;
            cmd.Parameters.Add("@Them", OleDbType.Boolean).Value = itemDTO.Them;
            cmd.Parameters.Add("@Sua", OleDbType.Boolean).Value = itemDTO.Sua;
            cmd.Parameters.Add("@Xoa", OleDbType.Boolean).Value = itemDTO.Xoa;
            cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;

            cmd.ExecuteNonQuery();
            cn.Close();
        }
Exemplo n.º 3
0
        private void gvDanhSachPhanQuyen_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
        {
            if (gvDanhSachPhanQuyen.FocusedRowHandle > -1)
            {
                try
                {
                    PhanQuyenDTO itemDTO = new PhanQuyenDTO();
                    PhanQuyenBUS itemBUS = new PhanQuyenBUS();
                    itemDTO.Doc = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Doc").ToString());
                    itemDTO.Them = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Them").ToString());
                    itemDTO.Sua = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Sua").ToString());
                    itemDTO.Xoa = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Xoa").ToString());
                    itemDTO.Id = int.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Id").ToString());

                    itemBUS.Sua(itemDTO);

                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Exemplo n.º 4
0
        public void Them(PhanQuyenDTO itemDTO)
        {
            OleDbConnection cn;
            cn = DataProvider.KetNoi();
            string strSQL;

            strSQL = "Insert into SysDanhMucPhanQuyen (IdNguoiDung, IdChucNang, IdPhanHe, Doc, Them, Sua, Xoa) values (?, ?, ?, ?, ?, ?, ?)";
            OleDbCommand cmd = new OleDbCommand(strSQL, cn);

            cmd.Parameters.Add("@IdNguoiDung", OleDbType.Numeric).Value = itemDTO.IdNguoiDung;
            cmd.Parameters.Add("@IdChucNang", OleDbType.Numeric).Value = itemDTO.IdChucNang;
            cmd.Parameters.Add("@IdPhanHe", OleDbType.Numeric).Value = itemDTO.IdPhanHe;
            cmd.Parameters.Add("@Doc", OleDbType.Boolean).Value = itemDTO.Doc;
            cmd.Parameters.Add("@Them", OleDbType.Boolean).Value = itemDTO.Them;
            cmd.Parameters.Add("@Sua", OleDbType.Boolean).Value = itemDTO.Sua;
            cmd.Parameters.Add("@Xoa", OleDbType.Boolean).Value = itemDTO.Xoa;

            cmd.ExecuteNonQuery();

            cn.Close();
        }
Exemplo n.º 5
0
 public void Them(PhanQuyenDTO itemDTO)
 {
     PhanQuyenDAO itemDAO = new PhanQuyenDAO();
     itemDAO.Them(itemDTO);
 }
Exemplo n.º 6
0
 public void Sua(PhanQuyenDTO itemDTO)
 {
     PhanQuyenDAO itemDAO = new PhanQuyenDAO();
     itemDAO.Sua(itemDTO);
 }