예제 #1
0
 /// <summary>
 /// 删除一条数据
 /// </summary>
 public int DeleteT(string ID)
 {
     string userHostAddress = HttpContext.Current.Request.UserHostAddress;
     int count = 0;
     using (MWDatabaseEntities MWDB = new MWDatabaseEntities())
     {
         try
         {
             System.Guid gu = new Guid(ID);
             tblRole objRole = MWDB.tblRole.First(r => r.RoleID == gu);
             if (objRole != null)
             {
                 List<tblMenu_Permission_Role> list = MWDB.tblMenu_Permission_Role.Where<tblMenu_Permission_Role>(m => m.RoleID == gu).ToList();
                 if (list.Count > 0)
                 {
                     foreach (var lists in list)
                     {
                         tblMenu_Permission_Role tblMenu_Permission_RoleObj;
                         tblMenu_Permission_RoleObj = MWDB.tblMenu_Permission_Role.First(m => m.RoleID == lists.RoleID);
                         MWDB.DeleteObject(tblMenu_Permission_RoleObj);
                         count = MWDB.SaveChanges();
                         if (count>0)
                         {
                             DbLoggerBLL.SysLogger.Info("Delete menu and the role relationship successfully! ID: '"
                                 + tblMenu_Permission_RoleObj.ID + "'. User host address: '" + userHostAddress + "'");
                         }
                     }
                 }
             }
         }
         catch (Exception ex)
         {
             DbLoggerBLL.SysLogger.Error("Delete menu and the role relationship failed! ID: '"
                     + ID + "'. User host address: '" + userHostAddress + "' . Exception info"
                     + ex.Message);
         }
     }
     return count;
 }
예제 #2
0
        /// <summary>
        /// 逻辑删除
        /// </summary>
        /// <param name="KeyId">需要删除对象的ID</param>
        /// <returns>返回受影响的行数</returns>
        public bool Delete(string strKeyId)
        {
            //影响行数标记
            int counts = 0;

            //转换成Guid类型
            System.Guid KeyIdGuid = new Guid(strKeyId);

            //需要跟新的对象
            tblRole_User tblRole_Users;

            try
            {
                using (MWDatabaseEntities MWDB = new MWDatabaseEntities())
                {
                    tblRole_Users = MWDB.tblRole_User.FirstOrDefault(t => t.UserID == KeyIdGuid);
                    if (tblRole_Users != null)
                    {
                        MWDB.DeleteObject(tblRole_Users);
                        counts = MWDB.SaveChanges();
                    }
                    if (counts > 0)
                    {
                        string userHostAddress = HttpContext.Current.Request.UserHostAddress;
                        DbLoggerBLL.SysLogger.Info("Delete user and role relationship successfully! User and role relationship ID: '"
                            + strKeyId + "'. User host address: '" + userHostAddress + "' . ");
                        return true;
                    }
                }
            }
            catch (Exception ex)
            {
                string userHostAddress = HttpContext.Current.Request.UserHostAddress;
                DbLoggerBLL.SysLogger.Error("Increase user and role relationship failed! User and role relationship ID: '"
                    + strKeyId + "'. User host address: '" + userHostAddress + "' . Exception info:" + ex.Message);
                return false;
            }
            return false;
        }